public int Update(Q_Counter model) { using (db = new QMSSystemEntities()) { var obj = db.Q_Counter.FirstOrDefault(x => !x.IsDeleted && x.Id == model.Id); if (obj != null) { if (!CheckExists(model)) { obj.ShortName = model.ShortName; obj.Name = model.Name; obj.Index = model.Index; obj.Position = model.Position; obj.Acreage = model.Acreage; db.SaveChanges(); return(model.Id); } else { return(0); } } return(0); } }
private bool CheckExists(Q_Counter model) { Q_Counter obj = null; if (!string.IsNullOrEmpty(model.Name)) { obj = db.Q_Counter.FirstOrDefault(x => !x.IsDeleted && x.Id != model.Id && x.Name.Trim().ToUpper().Equals(model.Name.Trim().ToUpper())); } return(obj != null ? true : false); }
public int Insert(Q_Counter obj) { using (db = new QMSSystemEntities()) { if (!CheckExists(obj)) { db.Q_Counter.Add(obj); db.SaveChanges(); } return(obj.Id); } }
private void gridViewCounter_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { int Id = 0; int.TryParse(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Id").ToString(), out Id); if (Id == 0 && string.IsNullOrEmpty(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Name").ToString())) { goto End; } else if (Id == 0 && string.IsNullOrEmpty(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "ShortName").ToString())) { goto End; } else if (Id == 0 && string.IsNullOrEmpty(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Index").ToString())) { goto End; } if (Id != 0 && string.IsNullOrEmpty(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Name").ToString())) { MessageBox.Show("Vui lòng nhập tên quầy.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && string.IsNullOrEmpty(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "ShortName").ToString())) { MessageBox.Show("Vui lòng nhập tên rút gọn.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && string.IsNullOrEmpty(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Index").ToString())) { MessageBox.Show("Vui lòng nhập số thứ tự.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var obj = new Q_Counter(); obj.Id = Id; obj.ShortName = gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "ShortName").ToString(); obj.Name = gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Name").ToString(); obj.Index = int.Parse(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Index").ToString()); obj.Position = gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Position") != null?gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Position").ToString() : ""; obj.Acreage = gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Acreage") != null?gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Acreage").ToString() : ""; int kq = 0; if (obj.Id == 0) { kq = BLLCounter.Instance.Insert(obj); } else { kq = BLLCounter.Instance.Update(obj); } if (kq == 0) { MessageBox.Show("Tên quầy đã tồn tại. Xin nhập tên khác", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); goto End; } else { GetGridCounter(); } } } catch (Exception ex) { } End : { } }