private void Save()
{
try
{
int Id = 0;
int.TryParse(gridViewVideo.GetRowCellValue(gridViewVideo.FocusedRowHandle, "Id").ToString(), out Id);
if (string.IsNullOrEmpty(gridViewVideo.GetRowCellValue(gridViewVideo.FocusedRowHandle, "TemplateName").ToString()))
{
MessageBox.Show("Vui lòng nhập tên mẫu.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
var obj = new Q_VideoTemplate();
obj.Id = Id;
obj.TemplateName = gridViewVideo.GetRowCellValue(gridViewVideo.FocusedRowHandle, "TemplateName").ToString();
obj.IsActive = Convert.ToBoolean(gridViewVideo.GetRowCellValue(gridViewVideo.FocusedRowHandle, "IsActive").ToString());
obj.Note = gridViewVideo.GetRowCellValue(gridViewVideo.FocusedRowHandle, "Note") != null?gridViewVideo.GetRowCellValue(gridViewVideo.FocusedRowHandle, "Note").ToString() : "";
var rs = BLLVideoTemplate.Instance.InsertOrUpdate(connect, obj);
if (rs.IsSuccess)
{
LoadGridVideoTemplate();
}
else
{
MessageBox.Show(rs.Errors[0].Message, rs.Errors[0].MemberName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch (Exception ex)
{
}
}
public ResponseBase InsertOrUpdate(Q_VideoTemplate model)
{
var rs = new ResponseBase();
using (var db = new QMSSystemEntities())
{
try
{
if (CheckName(model, db) == null)
{
if (model.Id == 0)
{
db.Q_VideoTemplate.Add(model);
}
else
{
var obj = db.Q_VideoTemplate.FirstOrDefault(x => !x.IsDeleted && x.Id == model.Id);
if (obj != null)
{
obj.TemplateName = model.TemplateName;
obj.Note = model.Note;
obj.IsActive = model.IsActive;
}
}
db.SaveChanges();
rs.IsSuccess = true;
}
else
{
rs.IsSuccess = false;
rs.Errors.Add(new Error()
{
MemberName = "Lỗi nhập liệu", Message = "Tên mẫu video này đã tồn tại. Vui lòng nhập tên khác."
});
}
}
catch (Exception)
{
rs.IsSuccess = false;
rs.Errors.Add(new Error()
{
MemberName = "Lỗi nhập liệu", Message = "Lỗi CSDL."
});
}
return(rs);
}
}
public JsonResult Save(Q_VideoTemplate model)
{
ResponseBase res = new ResponseBase();
try
{
res = BLLVideoTemplate.Instance.InsertOrUpdate(AppGlobal.Connectionstring, model);
if (!res.IsSuccess)
{
JsonDataResult.Result = "ERROR";
JsonDataResult.ErrorMessages.AddRange(res.Errors);
}
else
{
JsonDataResult.Result = "OK";
}
}
catch (Exception ex)
{
throw (ex);
}
return(Json(JsonDataResult));
}
private Q_VideoTemplate CheckName(Q_VideoTemplate model, QMSSystemEntities db)
{
return(db.Q_VideoTemplate.FirstOrDefault(x => !x.IsDeleted && x.Id != model.Id && x.TemplateName.Equals(model.TemplateName)));
}