private void thêmToolStripMenuItem_Click(object sender, EventArgs e)
{
try {
dm_vinabiz_LoaiDinhNghia model = new dm_vinabiz_LoaiDinhNghia();
model.name = "";
model.orderid = ConvertType.ToInt(SQLDatabase.ExcDataTable("select max(orderid) from dm_vinabiz_LoaiDinhNghia").Rows[0][0]) + 1;
model.isAct = false;
SQLDatabase.Adddm_vinabiz_LoaiDinhNghia(model);
BindDM_loaidinhnghia();
}
catch (Exception ex) {
MessageBox.Show(ex.Message, "thêmToolStripMenuItem2_Click");
}
}
private void GridviewLoaiDinhNghia_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
try {
if (e.RowIndex != -1)
{
string Id = GridviewLoaiDinhNghia.Rows[e.RowIndex].Cells["id_loaidinhnghia"].Value.ToString();
string name = GridviewLoaiDinhNghia.Rows[e.RowIndex].Cells["name_loaidinhnghia"].Value.ToString();
int orderid = ConvertType.ToInt(GridviewLoaiDinhNghia.Rows[e.RowIndex].Cells["orderid_loaidinhnghia"].Value);
bool isActive = (Boolean)GridviewLoaiDinhNghia.Rows[e.RowIndex].Cells["IsAct"].Value;
dm_vinabiz_LoaiDinhNghia madauso = SQLDatabase.Loaddm_LoaiDinhNghia(string.Format("select * from [dm_vinabiz_LoaiDinhNghia] where id='{0}'", Id)).FirstOrDefault();
madauso.name = name;
madauso.orderid = orderid;
madauso.isAct = isActive;
SQLDatabase.Updatedm_vinabiz_LoaiDinhNghia(madauso);
}
}
catch (Exception ex) {
MessageBox.Show("Unable to save the record. There might be a blank cell. ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
