public ResponseBase InsertOrUpdate(Q_Evaluate obj)
{
var rs = new ResponseBase();
try
{
if (obj.Id == 0)
{
db.Q_Evaluate.Add(obj);
rs.IsSuccess = false;
}
else
{
var oldObj = Get(obj.Id);
if (oldObj != null)
{
oldObj.Index = obj.Index;
oldObj.Name = obj.Name;
oldObj.Note = obj.Note;
}
}
db.SaveChanges();
rs.IsSuccess = true;
}
catch { }
return(rs);
}
public ResponseBase InsertOrUpdate(string connectString, Q_Evaluate obj)
{
using (db = new QMSSystemEntities(connectString))
{
var rs = new ResponseBase();
try
{
if (obj.Id == 0)
{
db.Q_Evaluate.Add(obj);
rs.IsSuccess = false;
}
else
{
var oldObj = db.Q_Evaluate.FirstOrDefault(x => x.Id == obj.Id);;
if (oldObj != null)
{
oldObj.Index = obj.Index;
oldObj.Name = obj.Name;
oldObj.Note = obj.Note;
}
}
db.SaveChanges();
rs.IsSuccess = true;
}
catch { }
return(rs);
}
}
private bool CheckExists(Q_Evaluate model)
{
Q_Evaluate obj = null;
if (!string.IsNullOrEmpty(model.Name))
{
obj = db.Q_Evaluate.FirstOrDefault(x => x.Id != model.Id && x.Name.Trim().ToUpper().Equals(model.Name.Trim().ToUpper()));
}
return(obj != null ? true : false);
}
public int Insert(string connectString, Q_Evaluate obj)
{
using (db = new QMSSystemEntities(connectString))
{
if (!CheckExists(obj))
{
db.Q_Evaluate.Add(obj);
db.SaveChanges();
}
return(obj.Id);
}
}
public int Update(string connectString, Q_Evaluate model)
{
using (db = new QMSSystemEntities(connectString))
{
var obj = db.Q_Evaluate.FirstOrDefault(x => x.Id == model.Id);
if (obj != null)
{
if (!CheckExists(model))
{
obj.Index = model.Index;
obj.Name = model.Name;
obj.Note = model.Note;
db.SaveChanges();
return(obj.Id);
}
else
{
return(0);
}
}
return(0);
}
}
public JsonResult Save(Q_Evaluate obj)
{
int result = 0;
try
{
if (obj.Id == 0)
{
result = BLLEvaluate.Instance.Insert(AppGlobal.Connectionstring, obj);
}
else
{
result = BLLEvaluate.Instance.Update(AppGlobal.Connectionstring, obj);
}
if (result == 0)
{
JsonDataResult.Result = "ERROR";
JsonDataResult.ErrorMessages.Add(new Error()
{
Message = "Lỗi SQL"
});
}
else
{
JsonDataResult.Result = "OK";
}
}
catch (Exception ex)
{
JsonDataResult.Result = "ERROR";
JsonDataResult.ErrorMessages.Add(new Error()
{
MemberName = "Add-Update", Message = "Lỗi: " + ex.Message
});
}
return(Json(JsonDataResult));
}
