public IActionResult PutTblTransportDataToDataBase(int key, [FromBody] TransportData2ViewModel uTransport)
{
if (uTransport != null)
{
//if (!string.IsNullOrEmpty(uTransport.StringTransDate))
//{
// DateTime dt = new DateTime();
// DateTime.TryParseExact(uTransport.StringTransDate,
// "dd/MM/yyyy",
// System.Globalization.CultureInfo.InvariantCulture,
// System.Globalization.DateTimeStyles.None,
// out dt);
// uTransport.TransDate = dt;
//}
if (uTransport.TransDate != null)
{
var tempDate = uTransport.TransDate.Value;
System.TimeSpan time = System.TimeSpan.Parse(uTransport.TransTime);
uTransport.TransDate = new System.DateTime(tempDate.Year, tempDate.Month, tempDate.Day, time.Hours, time.Minutes, 0);
}
if (uTransport.FinalDate != null)
{
var tempDate2 = uTransport.FinalDate.Value;
var time2 = System.TimeSpan.Parse(uTransport.FinalTime);
uTransport.FinalDate = new System.DateTime(tempDate2.Year, tempDate2.Month, tempDate2.Day, time2.Hours, time2.Minutes, 0);
}
// Update to company
int?CompanyId = null;
if (uTransport.CompanyID.HasValue)
{
CompanyId = uTransport.CompanyID.Value;
}
var hasData = this.repository.UpdateTblTransportDataToDataBase(key, uTransport);
if (hasData != null)
{
if (CompanyId.HasValue)
{
Expression <Func <TblTranHasCompany, bool> > condition = c => c.TransportId == hasData.TransportId;
var hasTranHasCompany = this.repositoryTranCompany.Find(condition);
if (hasTranHasCompany != null)
{
hasTranHasCompany.CompanyId = CompanyId;
hasTranHasCompany.Modifyer = hasData.Modifyer;
hasTranHasCompany.ModifyDate = hasData.ModifyDate;
// update to table car has company
this.repositoryTranCompany.Update(hasTranHasCompany, hasTranHasCompany.TranHasCompanyId);
}
else
{
this.repositoryTranCompany.Add(new TblTranHasCompany()
{
CompanyId = CompanyId,
CreateDate = DateTime.Now,
Creator = hasData.Creator,
TransportId = hasData.TransportId
});
}
}
return(new JsonResult(hasData, DefaultJsonSettings));
}
}
return(new StatusCodeResult(500));
}
public IActionResult PostTblTransportDataToDataBase(int TransportReqID, [FromBody] TransportData2ViewModel nTransport)
{
if (nTransport != null)
{
if ((nTransport?.RoutineTransport ?? false) && nTransport?.RoutineCount > 0 && nTransport?.RoutineDay > 0)
{
TblTransportData lastData = null;
var dateCheck = nTransport.TransDate.Value;
System.TimeSpan time = System.TimeSpan.Parse(nTransport.TransTime);
int Counter = 1;
while (dateCheck <= nTransport.TransDate.Value.AddDays((nTransport?.RoutineDay ?? 0) * (nTransport?.RoutineCount ?? 0)))
{
var routineData = this.mapper.Map <TransportData2ViewModel, TblTransportData>(nTransport);
routineData.TransDate = new System.DateTime(dateCheck.Year, dateCheck.Month, dateCheck.Day, time.Hours, time.Minutes, 0);
routineData.TransportNo = nTransport.TransportNo + "/R" + Counter.ToString("00");
lastData = this.repository.InsertTblTransportDataToDataBase(routineData, TransportReqID);
dateCheck = dateCheck.AddDays(nTransport?.RoutineDay ?? 0);
Counter++;
}
if (lastData != null)
{
return(new JsonResult(lastData, DefaultJsonSettings));
}
}
else
{
if (nTransport.TransDate != null)
{
var tempDate = nTransport.TransDate.Value;
System.TimeSpan time = System.TimeSpan.Parse(nTransport.TransTime);
nTransport.TransDate = new System.DateTime(tempDate.Year, tempDate.Month, tempDate.Day, time.Hours, time.Minutes, 0);
}
if (nTransport.FinalDate != null)
{
var tempDate2 = nTransport.FinalDate.Value;
var time2 = System.TimeSpan.Parse(nTransport.FinalTime);
nTransport.FinalDate = new System.DateTime(tempDate2.Year, tempDate2.Month, tempDate2.Day, time2.Hours, time2.Minutes, 0);
}
// Update to company
int?CompanyId = null;
if (nTransport.CompanyID.HasValue)
{
CompanyId = nTransport.CompanyID.Value;
}
var hasData = this.repository.InsertTblTransportDataToDataBase(
this.mapper.Map <TransportData2ViewModel, TblTransportData>(nTransport), TransportReqID);
if (hasData != null)
{
if (CompanyId.HasValue)
{
this.repositoryTranCompany.Add(new TblTranHasCompany()
{
CompanyId = CompanyId,
CreateDate = DateTime.Now,
Creator = hasData.Creator,
TransportId = hasData.TransportId
});
}
return(new JsonResult(hasData, DefaultJsonSettings));
}
}
}
return(new StatusCodeResult(500));
}
