public int Insert(string connectString, Q_ReadTemplate obj) { using (db = new QMSSystemEntities(connectString)) { db.Q_ReadTemplate.Add(obj); db.SaveChanges(); return(obj.Id); } }
public bool Update(string connectString, Q_ReadTemplate model) { using (db = new QMSSystemEntities(connectString)) { var obj = db.Q_ReadTemplate.FirstOrDefault(x => !x.IsDeleted && x.Id == model.Id); if (obj != null) { obj.Name = model.Name; obj.LanguageId = model.LanguageId; obj.Note = model.Note; db.SaveChanges(); return(true); } return(false); } }
private void gridViewReadTemplate_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { int Id = 0; int.TryParse(gridViewReadTemplate.GetRowCellValue(gridViewReadTemplate.FocusedRowHandle, "Id").ToString(), out Id); if (Id == 0 && string.IsNullOrEmpty(gridViewReadTemplate.GetRowCellValue(gridViewReadTemplate.FocusedRowHandle, "Name").ToString())) { goto End; } if (Id == 0 && int.Parse(gridViewReadTemplate.GetRowCellValue(gridViewReadTemplate.FocusedRowHandle, "LanguageId").ToString()) == 0) { goto End; } if (Id != 0 && string.IsNullOrEmpty(gridViewReadTemplate.GetRowCellValue(gridViewReadTemplate.FocusedRowHandle, "Name").ToString())) { MessageBox.Show("Vui lòng nhập tên mẫu.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (Id != 0 && int.Parse(gridViewReadTemplate.GetRowCellValue(gridViewReadTemplate.FocusedRowHandle, "LanguageId").ToString()) == 0) { MessageBox.Show("Vui lòng chọn ngôn ngữ.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var obj = new Q_ReadTemplate(); obj.Id = Id; obj.Name = gridViewReadTemplate.GetRowCellValue(gridViewReadTemplate.FocusedRowHandle, "Name").ToString(); obj.LanguageId = int.Parse(gridViewReadTemplate.GetRowCellValue(gridViewReadTemplate.FocusedRowHandle, "LanguageId").ToString()); obj.Note = gridViewReadTemplate.GetRowCellValue(gridViewReadTemplate.FocusedRowHandle, "Note") != null?gridViewReadTemplate.GetRowCellValue(gridViewReadTemplate.FocusedRowHandle, "Note").ToString() : ""; if (obj.Id == 0) { BLLReadTemplate.Instance.Insert(connect, obj); } else { BLLReadTemplate.Instance.Update(connect, obj); } GetGridView(); frmMain.lib_ReadTemplates = BLLReadTemplate.Instance.GetsForMain(connect); } } catch (Exception ex) { } End : { } }