private void initial(Models.students entity)
{
itnumericupdownid1.Text = entity.id;
ittextboxname2.Text = entity.name;
ittextboxschool3.Text = entity.school;
database = new MSSQLDatabase(new System.Data.SqlClient.SqlConnection(connstring));
}
public students(Models.students entity)
{
InitializeComponent();
regisEvents();
initial(entity);
isUpdate = true;
this.Text = "UpdateForm";
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (grvData.CurrentRow == null)
{
return;
}
Models.students selectedRow = (Models.students)grvData.CurrentRow.DataBoundItem;
Views.students updateForm = new Views.students(selectedRow);
updateForm.Show();
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
Models.students selectedRow = (Models.students)grvData.CurrentRow.DataBoundItem;
database.Table(typeof(Models.students)).Delete(selectedRow);
MessageBox.Show("Delete successfully. Refresh...");
loadData();
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
string id = itnumericupdownid1.Text;
string name = ittextboxname2.Text;
string school = ittextboxschool3.Text;
// add
if (!isUpdate)
{
Models.students tmp = new Models.students();
tmp.id = id;
tmp.name = name;
tmp.school = school;
database.Table(typeof(Models.students)).Insert(tmp);
}
// update
else
{
Models.students tmp = new Models.students();
tmp.id = id;
tmp.name = name;
tmp.school = school;
database.Table(typeof(Models.students)).Update(tmp);
}
}
catch (InvalidCastException ex)
{
Debug.WriteLine(ex.Message);
MessageBox.Show("Invalid value for type Number! Please try again.");
this.Close();
}
}
