public static ClsReturnValues setRegister(ClsRegister obj)
{
ClsReturnValues lst = new ClsReturnValues();
using (var db = new tdoEntities())
{
lst = db.uspAddEditRegister(obj.tdoRegisterID,obj.jobNumber,obj.dateReceived,obj.expiryDate,obj.status,obj.cargoTypeID,obj.fileRef,obj.destinationID,
obj.terminalID,obj.containerNo,obj.returnTerminal,obj.truckID,obj.tdoReceiptDate,obj.schDelDate,obj.loadingTime,obj.dispatchTime,
obj.remarks,obj.createdByID,obj.sessionID).FirstOrDefault();
}
return lst;
}
public JsonResult setRegister(string tdoRegisterID, string jobNumber,string dateReceived,string expiryDate,string status,string cargoTypeID,string fileRef,
string destinationID,string terminalID,string containerNo, string returnTerminal,string truckID,string tdoReceiptDate,string schDelDate,
string remarks,string createdByID,string sessionID)
{
List<ClsUserDisplay> userDisplay = new List<ClsUserDisplay>();
using (tdoEntities db = new tdoEntities())
{
userDisplay = db.uspGetUserDisplay(GetID()).ToList<ClsUserDisplay>();
}
List<string> editableForms = Restriction.GetEditableForms(userDisplay);
List<string> addableForms = Restriction.GetAddableForms(userDisplay);
if (int.Parse(tdoRegisterID) == 0 && !addableForms.Contains("Register"))
{
return Json(new { id = 0, isSuccess = false, msg = "You are not allowed to add new records." });
}
else if (int.Parse(tdoRegisterID) != 0 && !editableForms.Contains("Register"))
{
return Json(new { id = 0, isSuccess = false, msg = "You are not allowed to edit records." });
}
if (tdoRegisterID == "") { tdoRegisterID = "0"; }
Guid Session = new Guid(GetSession()); //do not hard code session ID and createdbyID
int _id = 0;
try { _id = int.Parse(tdoRegisterID.Trim()); }
catch { }
ClsRegister obj = new ClsRegister()
{
tdoRegisterID = _id,
jobNumber = jobNumber,
dateReceived = StringToArray.ConvertToDate(dateReceived),
expiryDate = StringToArray.ConvertToDate(expiryDate),
status = status,
cargoTypeID = int.Parse(cargoTypeID),
fileRef = fileRef,
destinationID = int.Parse(destinationID),
terminalID = int.Parse(terminalID),
containerNo = containerNo,
returnTerminal = int.Parse(returnTerminal),
truckID = int.Parse(truckID),
tdoReceiptDate = StringToArray.ConvertToDate(tdoReceiptDate),
schDelDate = StringToArray.ConvertToDate(schDelDate),
remarks = remarks,
createdByID = GetID(),
sessionID = Session
};
ClsReturnValues k = Modules.setRegister(obj);
return Json(new { id = k.ID, isSuccess = k.IsSuccess ?? false ? 1 : 0, msg = k.Response });
}
public JsonResult setDispatch(string tdoRegisterID,string status,string loadingDate,string loadingTime,string dispatchDate, string dispatchTime,string remarks, string createdByID, string sessionID)
{
List<ClsUserDisplay> userDisplay = new List<ClsUserDisplay>();
using (tdoEntities db = new tdoEntities())
{
userDisplay = db.uspGetUserDisplay(GetID()).ToList<ClsUserDisplay>();
}
List<string> editableForms = Restriction.GetEditableForms(userDisplay);
List<string> addableForms = Restriction.GetAddableForms(userDisplay);
if (int.Parse(tdoRegisterID) == 0 && !addableForms.Contains("Dispatch"))
{
return Json(new { id = 0, isSuccess = false, msg = "You are not allowed to add new records." });
}
else if (int.Parse(tdoRegisterID) != 0 && !editableForms.Contains("Dispatch"))
{
return Json(new { id = 0, isSuccess = false, msg = "You are not allowed to edit records." });
}
if (tdoRegisterID == "") { tdoRegisterID = "0"; }
Guid Session = new Guid(GetSession()); //do not hard code session ID and createdbyID
int _id = 0;
try { _id = int.Parse(tdoRegisterID.Trim()); }
catch { }
ClsRegister rg = Modules.getRegister(_id).FirstOrDefault();
//var ldTime = StringToArray.ConvertToDate(loadingDate);
//var dpTime = StringToArray.ConvertToDate(dispatchDate);
if (dispatchDate == "") { dispatchDate = "1900-01-01"; }
if (dispatchTime == "") { dispatchTime = "00:00"; }
if (loadingDate == "") { loadingDate = "1900-01-01";}
if (loadingTime == "") { loadingTime = "00:00"; }
//var ldTime = Convert.ToDateTime(loadingDate+" "+loadingTime);
//var dpTime = Convert.ToDateTime(dispatchDate+" "+dispatchTime);
//DateTime dt1 = DateTime.ParseExact(one + " " + two, "dd/MM/yy h:mm:ss tt", CultureInfo.InvariantCulture);
var ldTime = DateTime.Parse(loadingDate + " " + loadingTime);
var dpTime = DateTime.Parse(dispatchDate + " " + dispatchTime);
ClsRegister obj = new ClsRegister()
{
tdoRegisterID = _id,
jobNumber = rg.jobNumber,
dateReceived = rg.dateReceived,
expiryDate = rg.expiryDate,
status = status,
cargoTypeID = rg.cargoTypeID,
fileRef = rg.fileRef,
destinationID = rg.destinationID,
terminalID = rg.terminalID,
containerNo = rg.containerNo,
returnTerminal = rg.returnTerminal,
truckID = rg.truckID,
tdoReceiptDate = rg.tdoReceiptDate,
schDelDate = rg.schDelDate,
loadingTime = ldTime,
dispatchTime = dpTime,
remarks = remarks,
createdByID = GetID(),
sessionID = Session
};
ClsReturnValues k = Modules.setRegister(obj);
return Json(new { id = k.ID, isSuccess = k.IsSuccess ?? false ? 1 : 0, msg = k.Response });
}
