public int Insert(string connectString, Q_ActionParameter obj) { using (db = new QMSSystemEntities(connectString)){ db.Q_ActionParameter.Add(obj); db.SaveChanges(); return(obj.Id); } }
public bool Update(string connectString, Q_ActionParameter model) { using (db = new QMSSystemEntities(connectString)){ var obj = db.Q_ActionParameter.FirstOrDefault(x => !x.IsDeleted && x.Id == model.Id); if (obj != null) { obj.ParameterCode = model.ParameterCode; obj.ActionId = model.ActionId; obj.Note = model.Note; db.SaveChanges(); return(true); } return(false); } }
private void gridViewActionParameter_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { int Id = 0; int.TryParse(gridViewActionParameter.GetRowCellValue(gridViewActionParameter.FocusedRowHandle, "Id").ToString(), out Id); if (Id == 0 && string.IsNullOrEmpty(gridViewActionParameter.GetRowCellValue(gridViewActionParameter.FocusedRowHandle, "ParameterCode").ToString())) { goto End; } if (Id != 0 && string.IsNullOrEmpty(gridViewActionParameter.GetRowCellValue(gridViewActionParameter.FocusedRowHandle, "ParameterCode").ToString())) { MessageBox.Show("Vui lòng nhập tham số.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var obj = new Q_ActionParameter(); obj.Id = Id; obj.ParameterCode = gridViewActionParameter.GetRowCellValue(gridViewActionParameter.FocusedRowHandle, "ParameterCode").ToString(); obj.ActionId = actionId; obj.Note = gridViewActionParameter.GetRowCellValue(gridViewActionParameter.FocusedRowHandle, "Note") != null?gridViewActionParameter.GetRowCellValue(gridViewActionParameter.FocusedRowHandle, "Note").ToString() : ""; if (obj.Id == 0) { BLLActionParameter.Instance.Insert(obj); } else { BLLActionParameter.Instance.Update(obj); } GetGridActionParameter(); } } catch (Exception ex) { } End: { } }