public static void AddNewStudent(int Stu_id, string Stu_Name, string Class, string Major)
{
OracleDatabase db =(OracleDatabase)DatabaseFactory.CreateDatabase("PHTS");
using (System.Data.Common.DbCommand cmd = db.GetStoredProcCommand("AddNewStudent"))
{
db.AddInParameter(cmd, "I_Stu_id", DbType.Int32, Stu_id);
db.AddInParameter(cmd, "I_Stu_Name", DbType.String, Stu_Name);
db.AddInParameter(cmd, "I_Class", DbType.String, Class);
db.AddInParameter(cmd, "I_Major", DbType.String, Major);
db.ExecuteNonQuery(cmd);
}
}
public static void UpdateStudent(int Stu_id, string Stu_Name, string Class, string Major)
{
OracleDatabase db =(OracleDatabase)DatabaseFactory.CreateDatabase("PHTS");
using (System.Data.Common.DbCommand cmd = db.GetStoredProcCommand("UpdateStudent"))
{
db.AddInParameter(cmd, "I_Stu_id", DbType.Int32, Stu_id);
db.AddInParameter(cmd, "I_Stu_Name", DbType.String, Stu_Name);
db.AddInParameter(cmd, "I_Class", DbType.String, Class);
db.AddInParameter(cmd, "I_Major", DbType.String, Major);
db.ExecuteNonQuery(cmd);
}
}
User Interface
private void Savebutton_Click(object sender, EventArgs e)
{
int student_id = Convert.ToInt32(this.SIDtextBox.Text);
string stu_name = this.textBox1.Text;
string class = this.textBox2.Text;
string major= this.textBox3.Text;;
if(stu_id ==0)
{
PHTS.DataServices.cslMaterial.AddNewStudent(stu_id, stu_name, class, major);
MessageBox.Show("Record Saved");
}
else
{
PHTS.DataServices.cslMaterial.UpdateStudent(stu_id, stu_name, class, major);
MessageBox.Show("Record Saved");
}
}
I changed the code and insterted a if statement but still not working. Can anyone help me how can a user save and update data using the same button.
Thanks