//Insert VGM data
public int InsertVGMDetails(EVGMDetailsModel model)
{
var ConsignmentID = new SqlParameter("@ConsignmentID", SqlDbType.NVarChar, 400).Value = model.ConsignmentID;
var JobModeID = new SqlParameter("@JobModeID", SqlDbType.Int).Value = model.JobModeID;
var JobID = new SqlParameter("@JobID", SqlDbType.Int).Value = model.JobID;
var VGMDeclarationFor = new SqlParameter("@VGMDeclarationFor", SqlDbType.NVarChar, 400).Value = model.VGMDeclarationFor;
var BookingNo = new SqlParameter("@BookingNo", SqlDbType.NVarChar, 400).Value = model.BookingNo;
var CountryCode = new SqlParameter("@CountryCode", SqlDbType.NVarChar, 100).Value = model.CountryCode;
var Country = new SqlParameter("@Country", SqlDbType.NVarChar, 200).Value = model.Country;
var UOM = new SqlParameter("@UOM", SqlDbType.NVarChar, 50).Value = model.UOM;
var TotalContainers = new SqlParameter("@TotalContainers", SqlDbType.Int).Value = model.TotalContainers;
var Name = new SqlParameter("@Name", SqlDbType.NVarChar, 200).Value = model.Name.ToUpper();
var CompanyEmail = new SqlParameter("@CompanyEmail", SqlDbType.NVarChar, 200).Value = model.CompanyEmail;
var Telephone = new SqlParameter("@Telephone", SqlDbType.NVarChar, 50).Value = model.Telephone;
var ShippersCompanyName = new SqlParameter("@ShippersCompanyName", SqlDbType.NVarChar, 400).Value = model.ShippersCompanyName;
var ShippersAddress = new SqlParameter("@ShippersAddress", SqlDbType.NVarChar, 800).Value = model.ShippersAddress;
var Signature = new SqlParameter("@Signature", SqlDbType.Image).Value = convertstringToByte(model.Signature);
var Chk1 = new SqlParameter("@Chk1", SqlDbType.Bit).Value = model.Chk1;
var XmlVal = new SqlParameter("@XmlVal", SqlDbType.Xml, 10000).Value = ""; //convertListToXML(model.VGMContainerDetails);
var VGMID = new SqlParameter("@VGMID", SqlDbType.Int).Direction = ParameterDirection.Output;
var RVGMID = _datacontext.Database.ExecuteSqlCommand("WEB_VGMDetails_Insert @p0, @p1,@p2," +
"@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,@p11,@p12," +
"@p13,@p14,@p15,@p16,@p17", ConsignmentID, JobModeID, JobID,
VGMDeclarationFor, BookingNo, CountryCode, Country, UOM, TotalContainers, Name, CompanyEmail, Telephone,
ShippersCompanyName, ShippersAddress, Signature, Chk1, XmlVal, VGMID);
_datacontext.SaveChanges();
if (RVGMID > 0)
{
SendEmail(model.ShipmentPdf, model.EmailTo);
}
return(RVGMID);
}
public IActionResult Post([FromBody] EVGMDetailsModel value)
{
var status = _trackingRepository.InsertVGMDetails(value);
if (status > 0)
{
return(StatusCode(Microsoft.AspNetCore.Http.StatusCodes.Status200OK));
}
else
{
return(StatusCode(Microsoft.AspNetCore.Http.StatusCodes.Status500InternalServerError));
}
}
