public static int AddShipperQuick(string code, string name) { Shipper shipperObj = new Shipper(); shipperObj.ShipperCode = code; shipperObj.ShipperNameEn = name; EasyFreightEntities db = new EasyFreightEntities(); string isSaved = "true"; db.Shippers.Add(shipperObj); try { db.SaveChanges(); } catch (DbEntityValidationException e) { isSaved = "false " + e.Message; } catch (Exception e) { isSaved = "false " + e.InnerException.InnerException; } return(shipperObj.ShipperId); }
public static int AddConsigneeQuick(string code, string name) { Consignee consigneeObj = new Consignee(); consigneeObj.ConsigneeCode = code; consigneeObj.ConsigneeNameEn = name; EasyFreightEntities db = new EasyFreightEntities(); string isSaved = "true"; db.Consignees.Add(consigneeObj); try { db.SaveChanges(); } catch (DbEntityValidationException e) { isSaved = "false " + e.Message; } catch (Exception e) { isSaved = "false " + e.InnerException.InnerException; } return(consigneeObj.ConsigneeId); }
internal static string DeleteTruckingCost(int id) { EasyFreightEntities db = new EasyFreightEntities(); string isDeleted = "true"; var costObj = db.TruckingCostLibs.Where(x => x.TruckingCostId == id).FirstOrDefault(); db.TruckingCostLibs.Remove(costObj); try { db.SaveChanges(); } catch (Exception ex) { if ((ex.InnerException).InnerException.Message.Contains("DELETE statement conflicted")) { isDeleted = "false. Can't delete this row as it is linked with some operation orders"; } else { isDeleted = "false" + ex.Message; } } return(isDeleted); }
public static string AddEditArea(Area areaDb) { string isSaved = "true"; EasyFreightEntities db = new EasyFreightEntities(); if (areaDb.AreaId == 0) { db.Areas.Add(areaDb); } else { db.Areas.Attach(areaDb); db.Entry(areaDb).State = System.Data.Entity.EntityState.Modified; } try { db.SaveChanges(); } catch (Exception ex) { isSaved = "false" + ex.Message; } return(isSaved); }
public static string ChangeStatus(int truckingOrderId, byte statusId) { string isSaved = "true"; EasyFreightEntities db = new EasyFreightEntities(); TruckingOrder orderDb; orderDb = db.TruckingOrders.Where(x => x.TruckingOrderId == truckingOrderId).FirstOrDefault(); if (statusId == 4) //cancel from HB will delete the record { db.TruckingOrders.Remove(orderDb); } else { orderDb.StatusId = statusId; } try { db.SaveChanges(); } catch (DbEntityValidationException e) { isSaved = "false " + e.Message; } catch (Exception e) { isSaved = "false " + e.Message; } return(isSaved); }
internal static object DeleteVessel(int vesselId) { EasyFreightEntities db = new EasyFreightEntities(); string isDeleted = "true"; Vessel vesselDb = db.Vessels.Where(x => x.VesselId == vesselId).FirstOrDefault(); db.Vessels.Remove(vesselDb); try { db.SaveChanges(); } catch (Exception ex) { if ((ex.InnerException).InnerException.Message.Contains("DELETE statement conflicted")) { isDeleted = "false. Can't delete this row as it is linked with some operation orders"; } else { isDeleted = "false" + ex.Message; } } return(isDeleted); }
internal static string AddEditTruckCost(int costlId, string costNameEn, string costNameAr) { string isSaved = "true"; EasyFreightEntities db = new EasyFreightEntities(); TruckingCostLib costDb; if (costlId == 0) { costDb = new TruckingCostLib(); } else { costDb = db.TruckingCostLibs.Where(x => x.TruckingCostId == costlId).FirstOrDefault(); } costDb.TruckingCostName = costNameEn; costDb.TruckingCostNameAr = costNameAr; if (costlId == 0) { db.TruckingCostLibs.Add(costDb); } try { db.SaveChanges(); } catch (Exception ex) { isSaved = "false" + ex.Message; } return(isSaved); }
internal static string AddEditVessel(int vesselId, string vesselName) { string isSaved = "true"; EasyFreightEntities db = new EasyFreightEntities(); Vessel vesselDb; if (vesselId == 0) { vesselDb = new Vessel(); } else { vesselDb = db.Vessels.Where(x => x.VesselId == vesselId).FirstOrDefault(); } vesselDb.VesselName = vesselName; if (vesselId == 0) { db.Vessels.Add(vesselDb); } try { db.SaveChanges(); } catch (Exception ex) { isSaved = "false" + ex.Message; } return(isSaved); }
//public static OperationStatisticVm GetOperationStatistics(System.Web.Mvc.FormCollection form) //{ //OperationsEntities db5 = new OperationsEntities(); //var operationList = db5.OperationViews.Where(f => f.OrderFrom == orderFrom && // (f.OperationDate >= fromDate && f.OperationDate <= toDate)) // .Select(x => new // { // x.OperationId, // x.CarrierType, // x.QuoteId, // x.CreateDate, // x.OperationCode, // x.ShipperNameEn, // x.ConsigneeNameEn, // x.CarrierNameEn, // x.FromPort, // x.ToPort, // x.DateOfDeparture, // x.StatusName, // x.StatusId, // x.IsConsolidation, // x.OrderFrom, // x.AgentNameEn // }) // .ToList(); // OperationsEntities db = new OperationsEntities(); // OperationStatisticVm operationStatistic = new OperationStatisticVm() ; // int orderfrom = string.IsNullOrEmpty(form["OrderFrom"])? 1:int.Parse(form["OrderFrom"]); // DateTime fromDate = string.IsNullOrEmpty(form["FromDate"]) ? DateTime.Now.AddDays(-7) : DateTime.Parse(form["FromDate"]); // DateTime toDate = string.IsNullOrEmpty(form["ToDate"]) ? DateTime.Now.AddDays(-7) : DateTime.Parse(form["ToDate"]); // operationStatistic = GetOperationStatistics(fromDate, toDate, orderfrom); // return operationStatistic; //} internal static string DeleteOperation(int operationId) { string isClosed = "true"; OperationsEntities db = new OperationsEntities(); int statusId = db.Operations.Where(d => d.OperationId == operationId).FirstOrDefault().StatusId; if (statusId > 2) { isClosed = "false Cannot delete this operation it may be Closed or Invoice Issued "; return(isClosed); } // delete all HB under this operation var hbList = db.HouseBills.Where(x => x.OperationId == operationId);// && (x.StatusId == 1 || x.StatusId == 2)); foreach (var item in hbList) { item.StatusId = 4; //canceled } // delete all Custom Clearance under this operation var ccList = db.CustomClearanceOrders.Where(x => x.OperationId == operationId);// && (x.StatusId == 1 || x.StatusId == 2)); foreach (var item in ccList) { item.StatusId = 4; //canceled } // Delete all Trucking orders EasyFreightEntities dbE = new EasyFreightEntities(); var truckList = dbE.TruckingOrders.Where(x => x.OperationId == operationId);// && (x.StatusId == 1 || x.StatusId == 2)); foreach (var item in truckList) { item.StatusId = 4; //canceled } var operation = db.Operations.Where(x => x.OperationId == operationId).FirstOrDefault(); operation.StatusId = 4; try { db.SaveChanges(); dbE.SaveChanges(); } catch (DbEntityValidationException e) { isClosed = "false " + e.Message; } catch (Exception e) { isClosed = "false " + e.InnerException; } return(isClosed); }
public static string DeleteTruckingOrder(int truckingOrderId) { string isSaved = "true"; EasyFreightEntities db = new EasyFreightEntities(); OperationsEntities db1 = new OperationsEntities(); TruckingOrder orderDb; List <TruckingOrderDetail> orderDetailsDb; List <TruckingOrderCost> orderCostDb; orderDb = db.TruckingOrders.Where(x => x.TruckingOrderId == truckingOrderId).FirstOrDefault(); int houseBillStatusID = db1.HouseBills.Where(c => c.HouseBillId == orderDb.HouseBillId).FirstOrDefault().StatusId; if (houseBillStatusID == 3 || houseBillStatusID == 6) { return("false " + "Cannot delete this trucking. The house bill is closed"); } //cancel from HB will delete the record db.TruckingOrders.Remove(orderDb); orderDetailsDb = db.TruckingOrderDetails.Where(x => x.TruckingOrderId == truckingOrderId).ToList(); foreach (var item in orderDetailsDb) { db.TruckingOrderDetails.Remove(item); } orderCostDb = db.TruckingOrderCosts.Where(x => x.TruckingOrderId == truckingOrderId).ToList(); foreach (var item in orderCostDb) { db.TruckingOrderCosts.Remove(item); } try { db.SaveChanges(); } catch (DbEntityValidationException e) { isSaved = "false " + e.Message; } catch (Exception e) { isSaved = "false " + e.Message; } return(isSaved); }
public static string AddEditContractorRate(ContractorRateVm contractRateVm) { string isSaved = "true"; EasyFreightEntities db = new EasyFreightEntities(); ContractorRate contractRateDb; bool isSameActive = CheckIfActiveRate(contractRateVm); if (isSameActive) { return("false. Another rate is active with same data"); } int contractRateVmId = contractRateVm.ContractorRateId; if (contractRateVmId == 0) { contractRateDb = new ContractorRate(); } else { contractRateDb = db.ContractorRates.Where(x => x.ContractorRateId == contractRateVmId).FirstOrDefault(); } Mapper.CreateMap <ContractorRateVm, ContractorRate>() .ForMember(x => x.Contractor, y => y.Ignore()); Mapper.Map(contractRateVm, contractRateDb); if (contractRateVmId == 0) { db.ContractorRates.Add(contractRateDb); } try { db.SaveChanges(); } catch (DbEntityValidationException e) { isSaved = "false " + e.Message; } catch (Exception e) { isSaved = "false " + e.Message; } return(isSaved); }
/// <summary> /// Will set isValid to false .. will not be deleted /// </summary> /// <param name="carrRateId"></param> /// <returns></returns> public static string Delete(int carrRateId) { string isDeleted = "true"; EasyFreightEntities db = new EasyFreightEntities(); CarrierRate carrRateDb = db.CarrierRates.Where(x => x.CarrierRateId == carrRateId).FirstOrDefault(); carrRateDb.IsValid = false; try { db.SaveChanges(); } catch (Exception ex) { isDeleted = "false" + ex.Message; } return(isDeleted); }
public static string DeleteArea(int areaId) { EasyFreightEntities db = new EasyFreightEntities(); string isDeleted = "true"; Area areaToDel = db.Areas.Where(x => x.AreaId == areaId).FirstOrDefault(); db.Areas.Remove(areaToDel); try { db.SaveChanges(); } catch (Exception ex) { isDeleted = "false" + ex.Message; } return(isDeleted); }
public static string DeletePort(int portId) { EasyFreightEntities db = new EasyFreightEntities(); string isDeleted = "true"; Port portToDel = db.Ports.Where(x => x.PortId == portId).FirstOrDefault(); db.Ports.Remove(portToDel); try { db.SaveChanges(); } catch (Exception ex) { isDeleted = "false" + ex.Message; } return(isDeleted); }
public static string DeleteIncoterm(int incotermId) { EasyFreightEntities db = new EasyFreightEntities(); string isDeleted = "true"; IncotermLib countryToDel = db.IncotermLibs.Where(x => x.IncotermId == incotermId).FirstOrDefault(); db.IncotermLibs.Remove(countryToDel); try { db.SaveChanges(); } catch (Exception ex) { isDeleted = "false" + ex.Message; } return(isDeleted); }
public static string DeleteContainerType(int containerTypeId) { EasyFreightEntities db = new EasyFreightEntities(); string isDeleted = "true"; ContainerType countryToDel = db.ContainerTypes.Where(x => x.ContainerTypeId == containerTypeId).FirstOrDefault(); db.ContainerTypes.Remove(countryToDel); try { db.SaveChanges(); } catch (Exception ex) { isDeleted = "false" + ex.Message; } return(isDeleted); }
public static string Delete(int id) { string isDeleted = "true"; EasyFreightEntities db = new EasyFreightEntities(); Agent carrObj = db.Agents.Where(x => x.AgentId == id).FirstOrDefault(); db.Agents.Remove(carrObj); try { db.SaveChanges(); } catch (Exception ex) { isDeleted = "false " + ex.Message; } return(isDeleted); }
public static string AddTruckingOrder(TruckingOrderVm truckingOrderVm) { string isSaved = "true"; EasyFreightEntities db = new EasyFreightEntities(); TruckingOrder truckingOrderDb = new TruckingOrder(); Mapper.CreateMap <TruckingOrderVm, TruckingOrder>().IgnoreAllNonExisting(); Mapper.Map(truckingOrderVm, truckingOrderDb); //Get carrier Id from operation OperationsEntities db1 = new OperationsEntities(); int operationId = truckingOrderDb.OperationId; truckingOrderDb.CarrierId = db1.Operations.Where(x => x.OperationId == operationId).FirstOrDefault().CarrierId; var op_DeliveryNeeded = db1.Operations.Where(x => x.OperationId == operationId).FirstOrDefault(); op_DeliveryNeeded.DeliveryNeeded = true; if (truckingOrderVm.TruckingOrderId == 0) { db.TruckingOrders.Add(truckingOrderDb); } try { db.SaveChanges(); db1.SaveChanges(); } catch (DbEntityValidationException e) { isSaved = "false " + e.Message; } catch (Exception e) { isSaved = "false " + e.InnerException.InnerException; } return(isSaved); }
public static string AddEditIncoterm(int incotermId, string incotermCode, string incotermName) { string isSaved = "true"; EasyFreightEntities db = new EasyFreightEntities(); IncotermLib incotermLibDb = new IncotermLib(); incotermLibDb.IncotermId = incotermId; incotermLibDb.IncotermCode = incotermCode; incotermLibDb.IncotermName = incotermName; if (string.IsNullOrEmpty(incotermName)) { return("false"); } if (incotermId == 0) { db.IncotermLibs.Add(incotermLibDb); } else { db.IncotermLibs.Attach(incotermLibDb); db.Entry(incotermLibDb).State = System.Data.Entity.EntityState.Modified; } try { db.SaveChanges(); } catch (Exception ex) { isSaved = "false" + ex.Message; } return(isSaved); }
public static string AddEditContainerType(int containerTypeId, string containerTypeName, string maxCBM, string maxWeight) { string isSaved = "true"; EasyFreightEntities db = new EasyFreightEntities(); ContainerType containerTypeDb = new ContainerType(); containerTypeDb.ContainerTypeId = containerTypeId; containerTypeDb.ContainerTypeName = containerTypeName; containerTypeDb.MaxCBM = decimal.Parse(maxCBM); containerTypeDb.MaxWeight = decimal.Parse(maxWeight); if (string.IsNullOrEmpty(containerTypeName)) { return("false"); } if (containerTypeId == 0) { db.ContainerTypes.Add(containerTypeDb); } else { db.ContainerTypes.Attach(containerTypeDb); db.Entry(containerTypeDb).State = System.Data.Entity.EntityState.Modified; } try { db.SaveChanges(); } catch (Exception ex) { isSaved = "false" + ex.Message; } return(isSaved); }
public static string AddEditCountry(int countryId, string countyNameEn, string countryNameAr) { string isSaved = "true"; EasyFreightEntities db = new EasyFreightEntities(); Country countryDb = new Country(); countryDb.CountryId = countryId; countryDb.CountryNameAr = countryNameAr; countryDb.CountryNameEn = countyNameEn; if (string.IsNullOrEmpty(countyNameEn)) { return("false"); } if (countryId == 0) { db.Countries.Add(countryDb); } else { db.Countries.Attach(countryDb); db.Entry(countryDb).State = System.Data.Entity.EntityState.Modified; } try { db.SaveChanges(); } catch (Exception ex) { isSaved = "false" + ex.Message; } return(isSaved); }
public static string AddEditPackageType(int packageTypeId, string packageTypeNameEn, string packageTypeNameAr) { string isSaved = "true"; EasyFreightEntities db = new EasyFreightEntities(); PackageType packageTypeDb = new PackageType(); packageTypeDb.PackageTypeId = packageTypeId; packageTypeDb.PackageTypeNameEn = packageTypeNameEn; packageTypeDb.PackageTypeNameAr = packageTypeNameAr; if (string.IsNullOrEmpty(packageTypeNameEn)) { return("false"); } if (packageTypeId == 0) { db.PackageTypes.Add(packageTypeDb); } else { db.PackageTypes.Attach(packageTypeDb); db.Entry(packageTypeDb).State = System.Data.Entity.EntityState.Modified; } try { db.SaveChanges(); } catch (Exception ex) { isSaved = "false" + ex.Message; } return(isSaved); }
public static string AddEditAgent(AgentVm carrVm) { int carrId = carrVm.AgentId; string isSaved = "true"; EasyFreightEntities db = new EasyFreightEntities(); Agent carrDb; List <AgentContact> dbContactList = new List <AgentContact>(); if (carrId == 0) //Add new case { carrDb = new Agent(); } else { carrDb = db.Agents.Include("AgentContacts").Where(x => x.AgentId == carrId).FirstOrDefault(); //delete any removed contact on the screen dbContactList = carrDb.AgentContacts.ToList(); try { //Get contact Ids sent from the screen List <int> contactVmIds = carrVm.ContactPersons.Select(x => x.ContactId).ToList(); var contactDel = dbContactList.Where(x => !contactVmIds.Contains(x.ContactId)).ToList(); foreach (var item in contactDel) { db.AgentContacts.Remove(item); } } catch { } } Mapper.CreateMap <AgentVm, Agent>().IgnoreAllNonExisting(); Mapper.Map(carrVm, carrDb); if (carrId == 0) { Random rand = new Random(); carrDb.AgentCode = rand.Next(10000).ToString(); db.Agents.Add(carrDb); } Mapper.CreateMap <ContactPersonVm, AgentContact>().IgnoreAllNonExisting() .ForMember(x => x.AgentId, opts => opts.MapFrom(scr => scr.FkValue)); AgentContact carrContactDb; if (carrVm.ContactPersons != null && carrVm.ContactPersons.Count > 0) { foreach (var item in carrVm.ContactPersons.Where(x => !string.IsNullOrEmpty(x.ContactName))) { if (item.ContactId == 0) { carrContactDb = new AgentContact(); } else { int contVmId = item.ContactId; carrContactDb = dbContactList.Where(x => x.ContactId == contVmId).FirstOrDefault(); } Mapper.Map(item, carrContactDb); if (item.ContactId == 0) { carrDb.AgentContacts.Add(carrContactDb); } } } try { db.SaveChanges(); } catch (DbEntityValidationException e) { isSaved = "false " + e.Message; } catch (Exception e) { isSaved = "false " + e.Message; } return(isSaved); }
public static string AddEditCompSetup(CompanySetupVm compSetVm) { string isSaved = "true"; EasyFreightEntities db = new EasyFreightEntities(); if (compSetVm.TabIndex == 1) // First tab .. CompanySetup table { int rowsCount = db.CompanySetups.Count(); CompanySetup compSetupDb; if (rowsCount == 0) { compSetupDb = new CompanySetup(); } else { compSetupDb = db.CompanySetups.FirstOrDefault(); } Mapper.CreateMap <CompanySetupVm, CompanySetup>(); Mapper.Map(compSetVm, compSetupDb); compSetupDb.CompanyId = 1; //Add new if (rowsCount == 0) { db.CompanySetups.Add(compSetupDb); } db.SaveChanges(); } else if (compSetVm.TabIndex == 2) // Second tab .. CompanySetupContact table { int rowsCount = db.CompanySetupContacts.Count(); CompanySetupContact compSetupDb; if (rowsCount == 0) { compSetupDb = new CompanySetupContact(); } else { compSetupDb = db.CompanySetupContacts.FirstOrDefault(); } Mapper.CreateMap <CompanySetupVm, CompanySetupContact>(); Mapper.Map(compSetVm, compSetupDb); compSetupDb.CompanyId = 1; //Add new if (rowsCount == 0) { db.CompanySetupContacts.Add(compSetupDb); } db.SaveChanges(); } else if (compSetVm.TabIndex == 3) // last tab .. SystemSetup table { int rowsCount = db.SystemSetups.Count(); SystemSetup compSetupDb; if (rowsCount == 0) { compSetupDb = new SystemSetup(); } else { compSetupDb = db.SystemSetups.FirstOrDefault(); } Mapper.CreateMap <CompanySetupVm, SystemSetup>(); Mapper.Map(compSetVm, compSetupDb); compSetupDb.CompanyId = 1; //Add new if (rowsCount == 0) { db.SystemSetups.Add(compSetupDb); } db.SaveChanges(); } return(isSaved); }
public static string AddEditTruckingOrderDetails(TruckingOrderDetailVm truckingOrderVm) { int truckingOrderId = truckingOrderVm.TruckingOrderId; string isSaved = "true"; EasyFreightEntities db = new EasyFreightEntities(); TruckingOrderDetail orderDetailDb; //check if detauils is inserted before int detailCount = db.TruckingOrderDetails.Where(x => x.TruckingOrderId == truckingOrderId).Count(); TruckingOrder orderDb; orderDb = db.TruckingOrders.Where(x => x.TruckingOrderId == truckingOrderId).FirstOrDefault(); // change the status if (truckingOrderVm.StatusId == 3) { orderDb.StatusId = 3; //closed } List <TruckingOrderCost> dbOrderCostList = new List <TruckingOrderCost>(); if (detailCount == 0) //Add new case { orderDetailDb = new TruckingOrderDetail(); } else { orderDetailDb = db.TruckingOrderDetails.Include("TruckingOrderCosts").Where(x => x.TruckingOrderId == truckingOrderId).FirstOrDefault(); //delete any removed costs on the screen dbOrderCostList = orderDetailDb.TruckingOrderCosts.ToList(); //Get cost Ids sent from the screen List <int> truckingOrderCostVmIds = truckingOrderVm.TruckingOrderCosts.Select(x => x.TruckingOrderCostId).ToList(); var orderCostDel = dbOrderCostList.Where(x => !truckingOrderCostVmIds.Contains(x.TruckingOrderCostId)).ToList(); foreach (var item in orderCostDel) { db.TruckingOrderCosts.Remove(item); } } Mapper.CreateMap <TruckingOrderDetailVm, TruckingOrderDetail>().IgnoreAllNonExisting(); Mapper.CreateMap <TruckingCostVm, TruckingOrderCost>().IgnoreAllNonExisting(); Mapper.Map(truckingOrderVm, orderDetailDb); if (detailCount == 0) { orderDetailDb.TruckingOrderCode = AdminHelper.GeneratePrefixCode(PrefixForEnum.TruckingOrder, true); db.TruckingOrderDetails.Add(orderDetailDb); if (truckingOrderVm.StatusId != 3) { orderDb.StatusId = 2; // open } } List <OperationContainer> dbOperationContainerList = new List <OperationContainer>(); OperationsEntities opdb = new OperationsEntities(); dbOperationContainerList = opdb.OperationContainers.Where(x => x.OperationId == truckingOrderVm.OperationId).ToList(); foreach (var item in truckingOrderVm.OperationContainers) { long operConIdvmId = item.OperConId; OperationContainer operationContainerDb = dbOperationContainerList .Where(x => x.OperConId == operConIdvmId).FirstOrDefault(); operationContainerDb.ContainerNumber = item.ContainerNumber; operationContainerDb.SealNumber = item.SealNumber; //Mapper.Map(item, operationContainerDb); } try { db.SaveChanges(); opdb.SaveChanges(); } catch (DbEntityValidationException e) { isSaved = "false " + e.Message; } catch (Exception e) { isSaved = "false " + e.InnerException.InnerException.Message; } return(isSaved); }
public static string AddEditCarrierRate(CarrierRateVm carrRateVm) { string isSaved = "true"; bool isSameActive = CheckIfActiveRate(carrRateVm); if (isSameActive) { return("false. Another rate is active with same data"); } EasyFreightEntities db = new EasyFreightEntities(); CarrierRate carrRateDb; int carrRateVmId = carrRateVm.CarrierRateId; if (carrRateVmId == 0) { carrRateDb = new CarrierRate(); } else { carrRateDb = db.CarrierRates.Include("CarrierRateTransits").Where(x => x.CarrierRateId == carrRateVmId).FirstOrDefault(); } Mapper.CreateMap <CarrierRateVm, CarrierRate>().IgnoreAllNonExisting(); Mapper.Map(carrRateVm, carrRateDb); var transitList = carrRateDb.CarrierRateTransits.ToList(); //Delete all transit and insert it again if (carrRateDb.CarrierRateTransits.Count > 0) { foreach (var item in transitList) { carrRateDb.CarrierRateTransits.Remove(item); } } if (carrRateVm.TransitPortId != null) { CarrierRateTransit carrTransit; foreach (var item in carrRateVm.TransitPortId) { carrTransit = new CarrierRateTransit(); carrTransit.CarrierRateId = carrRateVm.CarrierRateId; carrTransit.TransitPortId = item; carrRateDb.CarrierRateTransits.Add(carrTransit); } } if (carrRateVmId == 0) { db.CarrierRates.Add(carrRateDb); } try { db.SaveChanges(); } catch (DbEntityValidationException e) { isSaved = "false " + e.Message; } catch (Exception e) { isSaved = "false " + e.Message; } return(isSaved); }