public bool UpdateRequestInfor(tbl_Request_Infor request)
{
try
{
var requestOld = db.tbl_Request_Infor.FirstOrDefault(x => x.Id == request.Id);
if (requestOld != null)
{
requestOld.IncommingDate = request.IncommingDate;
requestOld.OutgoingDate = request.OutgoingDate;
requestOld.PurposeVisit = request.PurposeVisit;
requestOld.Remark = request.Remark;
requestOld.Type = request.Type;
requestOld.CreatedDate = request.CreatedDate;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
public bool CheckExistsRequest(tbl_Request_Infor request)
{
try
{
var result = db.tbl_Request_Infor.FirstOrDefault(x => x.EmployeeId == request.EmployeeId &&
x.PurposeVisit.Trim().ToLower() == request.PurposeVisit.Trim().ToLower() &&
x.IncommingDate == request.IncommingDate && x.OutgoingDate == request.OutgoingDate);
if (result == null)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
WriteLogError.Write("CheckExistsRequest", ex.ToString());
return(false);
}
}
public bool InsertRequestInfor(tbl_Request_Infor request)
{
try
{
if (CheckExistsRequest(request))
{
db.tbl_Request_Infor.Add(request);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
WriteLogError.Write("InsertRequestInfor", ex.ToString());
return(false);
}
}
