public bool UpdateBaseInformation(tbl_Visitor_Infor visitor, string nationalIdOld, string employee)
{
try
{
var visitorUpdate = db.tbl_Visitor_Infor.FirstOrDefault(x => x.Request_Infor_Id == visitor.Request_Infor_Id && x.NationalId == visitor.NationalId);
if (visitorUpdate == null)
{
var visitorOld = db.tbl_Visitor_Infor.FirstOrDefault(x => x.Request_Infor_Id == visitor.Request_Infor_Id && x.NationalId == nationalIdOld);
db.tbl_Visitor_Infor.Remove(visitorOld);
db.tbl_Visitor_Infor.Add(visitor);
}
else
{
visitorUpdate.VisitorName = visitor.VisitorName;
visitorUpdate.CompanyName = visitor.CompanyName;
visitorUpdate.NationalId = visitor.NationalId;
visitorUpdate.Remark = visitor.Remark;
visitorUpdate.UpdateDate = DateTime.Now;
visitorUpdate.UpdateBy = employee;
}
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
WriteLogError.Write("UpdateBaseInformation", ex.ToString());
return(false);
}
}
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 InsertOrUpdateRequest(tbl_Taxi_Request_Infor request)
{
try
{
var checkRequest = db.tbl_Taxi_Request_Infor.FirstOrDefault(x => x.Id == request.Id);
if (checkRequest != null)
{
checkRequest.ScheduleTime = request.ScheduleTime;
checkRequest.Purpose = request.Purpose;
checkRequest.Pickup = request.Pickup;
checkRequest.DropOff1 = request.DropOff1;
checkRequest.DropOff2 = request.DropOff2;
checkRequest.Remark = request.Remark;
}
else
{
db.tbl_Taxi_Request_Infor.Add(request);
}
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
WriteLogError.Write("CreateRequest", ex.ToString());
return(false);
}
}
public bool InsertOrUpdateApproval(tbl_Taxi_Approval_Infor approval)
{
try
{
var approveCheck = db.tbl_Taxi_Approval_Infor.FirstOrDefault(x => x.Request_Id == approval.Request_Id && x.Process == approval.Process);
if (approveCheck == null)
{
db.tbl_Taxi_Approval_Infor.Add(approval);
}
else
{
approveCheck.ApproverId = approval.ApproverId;
approveCheck.Process = approval.Process;
approveCheck.State = approval.State;
approveCheck.UpdateDate = approval.UpdateDate;
approveCheck.Remark = approval.Remark;
}
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
WriteLogError.Write("InsertOrUpdateApproval", ex.ToString());
return(false);
}
}
//Insert or update
public string InsertOrUpdateUser(tbl_User user)
{
try
{
var userFind = db.tbl_User.FirstOrDefault(x => x.EmployeeId == user.EmployeeId);
if (userFind == null)
{
db.tbl_User.Add(user);
db.SaveChanges();
return(user.EmployeeId);
}
else
{
userFind.EmployeeId = user.EmployeeId;
userFind.FushanAd = user.FushanAd;
userFind.FullName = user.FullName;
userFind.Email = user.Email;
userFind.JobTitle = user.JobTitle;
userFind.DeparmentName = user.DeparmentName;
db.SaveChanges();
return(userFind.EmployeeId);
}
}
catch (Exception ex)
{
WriteLogError.Write("InsertOrUpdateUser", ex.ToString());
return("false");
}
}
public bool InsertOrUpdateUser(tbl_Taxi_User_Infor user)
{
try
{
var userCheck = db.tbl_Taxi_User_Infor.FirstOrDefault(x => x.Taxi_Request_Infor_Id == user.Taxi_Request_Infor_Id &&
x.EmployeeId == user.EmployeeId && x.Process == user.Process
);
if (userCheck == null)
{
db.tbl_Taxi_User_Infor.Add(user);
}
else
{
// Update item
if (user.Cost == null && user.CarNumber == null)
{
if (user.CardNumber != null && userCheck.CreateBy == null)
{
userCheck.CreateDate = user.CreateDate;
userCheck.CreateBy = user.CreateBy;
}
}
userCheck.CarNumber = user.CarNumber;
userCheck.SwipeTime = user.SwipeTime;
userCheck.CardNumber = user.CardNumber;
userCheck.Cost = user.Cost;
userCheck.RefNumber = user.RefNumber;
userCheck.UpdateDate = user.UpdateDate;
userCheck.UpdateBy = user.UpdateBy;
}
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
WriteLogError.Write("InsertOrUpdateUser", ex.ToString());
return(false);
}
}
public bool InsertOrUpdateDepartment(tbl_Taxi_Department_Infor department)
{
try
{
var departmentFind = db.tbl_Taxi_Department_Infor.FirstOrDefault(x => x.DepartmentName == department.DepartmentName);
if (departmentFind == null)
{
db.tbl_Taxi_Department_Infor.Add(department);
}
else
{
departmentFind.Head_id = department.Head_id;
departmentFind.UpdateDate = department.UpdateDate;
}
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
