public async Task <IActionResult> PutTblTransportation(long id, TblTransportation tblTransportation)
{
if (id != tblTransportation.Id)
{
return(BadRequest());
}
_context.Entry(tblTransportation).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TblTransportationExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ApiResponse> updateCountry(TblCountryMaster tblCountryMaster)
{
if (tblCountryMaster.Id == 0)
{
var ApiResponse = await response.ApiResult("FAILED", "", "Error in Update");
return(ApiResponse);
}
_context.Entry(tblCountryMaster).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
var ApiResponse = await response.ApiResult("OK", "", "update Record ");
return(ApiResponse);
}
catch (DbUpdateConcurrencyException)
{
var ApiResponse = await response.ApiResult("FAILED", "", "Error in UPdate");
return(ApiResponse);
}
}
public async Task <ApiResponse> AddAgent(TblAgentMaster objAgent)
{
_context.TblAgentMaster.Add(objAgent);
await _context.SaveChangesAsync();
var ApiResponse = await response.ApiResult("OK", objAgent.Id, "Add Agent");
return(ApiResponse);
}
public async Task <ApiResponse> addProduct(TblProduct tblProduct)
{
_context.TblProduct.Add(tblProduct);
await _context.SaveChangesAsync();
var ApiResponse = await response.ApiResult("OK", new { id = tblProduct.Id }, "Add Product Successfull");
return(ApiResponse);
}
public async Task <ActionResult <ApiResponse> > AddCategory(TblCategoryMaster tblCategoryMaster)
{
_context.TblCategoryMaster.Add(tblCategoryMaster);
await _context.SaveChangesAsync();
var ApiResponse = await response.ApiResult("OK", tblCategoryMaster.Id, " Add Record");
return(ApiResponse);
}
public async Task <ApiResponse> AddCompany(TblCompany tblcompany)
{
var headd = Request.Headers["Auth"];
_context.TblCompany.Add(tblcompany);
await _context.SaveChangesAsync();
var ApiResponse = await response.ApiResult("OK", tblcompany.Id, "Record Add");
return(ApiResponse);
// return CreatedAtAction("GetTblStock", new { id = tblStock.Id }, tblStock);
}
public async Task <ApiResponse> updatePort(TblPortMaster tblPortMaster)
{
_context.Entry(tblPortMaster).State = EntityState.Modified;
_context.Entry(tblPortMaster).Property(i => i.RecordDate).IsModified = false;
try
{
await _context.SaveChangesAsync();
var listPortAgent = await _context.TblPortAgent.Where(i => i.PortId == tblPortMaster.Id).ToListAsync();
_context.TblPortAgent.RemoveRange(listPortAgent);
await _context.SaveChangesAsync();
for (int i = 0; i < tblPortMaster.AgentArray.Length; i++)
{
TblPortAgent obj = new TblPortAgent();
obj.AgentId = tblPortMaster.AgentArray[i];
obj.PortId = tblPortMaster.Id;
_context.TblPortAgent.Add(obj);
await _context.SaveChangesAsync();
}
var ApiResponse = await response.ApiResult("OK", "", "Port Update");
return(ApiResponse);
}
catch (DbUpdateConcurrencyException)
{
var ApiResponseError = await response.ApiResult("OK", "", "Port Update");
return(ApiResponseError);
}
}
public async Task <ApiResponse> UpdateVesselName(long id, TblVesselName tblVesselName)
{
_context.Entry(tblVesselName).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
var ApiResponse = await response.ApiResult("OK", "", "Record Add");
return(ApiResponse);
}
catch (DbUpdateConcurrencyException ex)
{
var ApiResponseError = await response.ApiResult("OK", ex, "Record Add");
return(ApiResponseError);
}
}
public async Task <ApiResponse> updateColor(TblColor tblColor)
{
_context.Entry(tblColor).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
var ApiResponse = await response.ApiResult("OK", new { id = tblColor.Id }, "Update Record");
return(ApiResponse);
}
catch (DbUpdateConcurrencyException ex)
{
var ApiResponse = await response.ApiResult("FAILED", new { error = ex }, "Error");
return(ApiResponse);
}
}
public async Task <ApiResponse> UpdateYard(TblYard tblYard)
{
_context.Entry(tblYard).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
var tblYardlocation = await _context.TblYardLocation.Where(i => i.YardId == tblYard.Id).ToListAsync();
_context.TblYardLocation.RemoveRange(tblYardlocation);
await _context.SaveChangesAsync();
TblYardLocation objYardLocation = new TblYardLocation();
objYardLocation.YardId = tblYard.Id;
objYardLocation.CountryId = tblYard.CountryId;
objYardLocation.LocationDiscription = tblYard.LocationDescription;
_context.TblYardLocation.Add(objYardLocation);
await _context.SaveChangesAsync();
var ApiResponse = await response.ApiResult("OK", tblYard, "Data Found");
return(ApiResponse);
}
catch (DbUpdateConcurrencyException ex)
{
var ApiResponse = await response.ApiResult("FAILED", ex, "Error in update");
return(ApiResponse);
}
}
public async Task <ApiResponse> InstallmentPay(TblInstallmentDetail objInsDetail)
{
_context.Entry(objInsDetail).Property(x => x.InstallmentGivenDate).IsModified = true;
_context.Entry(objInsDetail).Property(x => x.PaymentBy).IsModified = true;
_context.Entry(objInsDetail).Property(x => x.ReffNo).IsModified = true;
_context.Entry(objInsDetail).Property(x => x.PaidAmount).IsModified = true;
_context.Entry(objInsDetail).Property(x => x.PaymentStatus).IsModified = true;
try
{
var response = await _context.SaveChangesAsync();
var ApiResponse = await InstallmentDetailById(objInsDetail);
return(ApiResponse);
}
catch (DbUpdateConcurrencyException ex)
{
var ApiResponseCatch = await response.ApiResult("FALIED", ex, "Erro In Update ");
return(ApiResponseCatch);
}
}
public async Task <ApiResponse> updateVesselMaster(TblVesselMaster tblVesselMaster)
{
_context.Entry(tblVesselMaster).State = EntityState.Modified;
_context.Entry(tblVesselMaster).Property(i => i.RecordDate).IsModified = false;
try
{
await _context.SaveChangesAsync();
//remove vessel Route
var listVesselRoute = await _context.TblVesselRoute.Where(i => i.VesselMasterId == tblVesselMaster.Id).ToListAsync();
_context.TblVesselRoute.RemoveRange(listVesselRoute);
await _context.SaveChangesAsync();
List <TblVesselRoute> vesselRouteDetail = JsonConvert.DeserializeObject <List <TblVesselRoute> >(tblVesselMaster.VesselRouteDetail.ToString());
for (int i = 0; i < vesselRouteDetail.Count; i++)
{
TblVesselRoute objVesselRoute = new TblVesselRoute();
objVesselRoute.PortId = vesselRouteDetail[i].PortId;
objVesselRoute.VesselMasterId = tblVesselMaster.Id;
objVesselRoute.Type = vesselRouteDetail[i].Type;
objVesselRoute.LastPuttingdate = vesselRouteDetail[i].LastPuttingdate;
_context.TblVesselRoute.Add(objVesselRoute);
await _context.SaveChangesAsync();
}
var ApiResponse = await response.ApiResult("OK", "", "Record Update");
return(ApiResponse);
}
catch (DbUpdateConcurrencyException ex)
{
var ApiResponseEX = await response.ApiResult("OK", ex, "Record Found");
return(ApiResponseEX);
}
}