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 : { }
}
