public FrayteResult DeleteCountryPublicHoliday(int countrypublcHolidayId) { FrayteResult result = new FrayteResult(); try { var countryPublicHoliday = new CountryPublicHoliday { CountryPublicHolidayId = countrypublcHolidayId }; dbContext.CountryPublicHolidays.Attach(countryPublicHoliday); dbContext.CountryPublicHolidays.Remove(countryPublicHoliday); dbContext.SaveChanges(); result.Status = true; } catch (Exception ex) { result.Status = false; result.Errors = new List <string>(); result.Errors.Add(ex.Message); } return(result); }
public FrayteResult SaveParcelHubKey(ParcelHubKeyModel ParcelHubKey) { FrayteResult result = new FrayteResult(); result = new ParcelHubKeyRepository().SaveParcelHubKey(ParcelHubKey); return(result); }
public FrayteResult DeleteTradelane(int tradelaneId) { FrayteResult result = new FrayteResult(); result = new TradelaneRepository().DeleteTradelane(tradelaneId); return(result); }
public IHttpActionResult GetQuotationValidity(int QuotationShipmentId) { FrayteResult result = new FrayteResult(); result = new QuotationRepository().QuotationValidity(QuotationShipmentId); return(Ok(result)); }
public IHttpActionResult RemoveQuotation(int QuotationShipmentId) { FrayteResult result = new FrayteResult(); result = new QuotationRepository().DeleteQuotation(QuotationShipmentId); return(Ok(result)); }
public FrayteResult DeleteParcelHubKey(int APIId) { FrayteResult result = new FrayteResult(); result = new ParcelHubKeyRepository().DeleteParcelHubKey(APIId); return(result); }
public FrayteResult DeleteWorkingWeekDay(int weekDayId) { FrayteResult result = new FrayteResult(); //Step 1: Remove Working Week Details var workingWeekDetails = dbContext.WorkingWeekDayDetails.Where(p => p.WorkingWeekDayId == weekDayId).ToList(); if (workingWeekDetails != null && workingWeekDetails.Count > 0) { foreach (WorkingWeekDayDetail weekDayDetail in workingWeekDetails) { //dbContext.WorkingWeekDayDetails.Add(weekDayDetail); dbContext.WorkingWeekDayDetails.Remove(weekDayDetail); dbContext.SaveChanges(); } } //Step 2: Remove Working Week var workingWeek = dbContext.WorkingWeekDays.Find(weekDayId); if (workingWeek != null) { dbContext.WorkingWeekDays.Remove(workingWeek); dbContext.SaveChanges(); } result.Status = true; return(result); }
public FrayteResult DeleteSystemAlert(int systemAlertId) { FrayteResult result = new FrayteResult(); try { var systemAlert = dbContext.SystemAlerts.Find(systemAlertId); if (systemAlert != null) { systemAlert.IsActive = false; dbContext.Entry(systemAlert).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); result.Status = true; } else { result.Status = false; } } catch (Exception ex) { result.Status = false; } return(result); }
public IHttpActionResult DeleteSystemAlert(int systemAlertId) { FrayteResult result = new FrayteResult(); result = new SystemAlertRepository().DeleteSystemAlert(systemAlertId); return(Ok(result)); }
public FrayteResult generateeCommerceBagLabelReport(eCommerceReportBagLabel eCommerceBagLabelReport) { FrayteResult result = new FrayteResult(); eCommerceBagLabelReport.Date = eCommerceBagLabelReport.CreatedOn.ToString("dd") + " / " + eCommerceBagLabelReport.CreatedOn.ToString("MM"); List <eCommerceReportBagLabel> source = new List <eCommerceReportBagLabel>(); source.Add(eCommerceBagLabelReport); ReportTemplate.Other.eCommerceBagLabel re = new ReportTemplate.Other.eCommerceBagLabel(); re.DataSource = source; re.Parameters["LogoPath"].Value = eCommerceBagLabelReport.BarCodePath; string filePathToSave = AppSettings.eCommerceBag; filePathToSave = HttpContext.Current.Server.MapPath(filePathToSave) + eCommerceBagLabelReport.ShipmentBagId.ToString(); if (!System.IO.Directory.Exists(filePathToSave)) { System.IO.Directory.CreateDirectory(filePathToSave); } re.ExportToImage(HttpContext.Current.Server.MapPath(AppSettings.eCommerceBag) + eCommerceBagLabelReport.ShipmentBagId.ToString() + "/" + eCommerceBagLabelReport.BagName + ".Jpeg", System.Drawing.Imaging.ImageFormat.Jpeg); result.Status = true; return(result); }
public FrayteResult AddEditHSCodeSetting(eCommerceSettingModel HSCodeDetail) { FrayteResult FR = new FrayteResult(); HSCode HSC = new HSCode(); var Result = dbContext.HSCodes.Where(a => a.HSCodeId == HSCodeDetail.HsCodeId).FirstOrDefault(); if (Result == null) { Mapper.CreateMap <eCommerceSettingModel, HSCode>(); AutoMapper.Mapper.Map(HSCodeDetail, HSC); dbContext.HSCodes.Add(HSC); dbContext.SaveChanges(); FR.Status = true; } else { Mapper.CreateMap <eCommerceSettingModel, HSCode>(); AutoMapper.Mapper.Map(HSCodeDetail, Result); dbContext.Entry(Result).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); FR.Status = true; } return(FR); }
public FrayteResult AssignJobToOperator(OpeartorJob job) { FrayteResult result = new FrayteResult(); try { if (job != null && job.OperatorId > 0 && job.jobs != null && job.jobs.Count > 0) { foreach (var data in job.jobs) { var ship = dbContext.eCommerceShipments.Find(data.ShipmentId); if (ship != null) { ship.AssignedTo = job.OperatorId; //dbContext.Entry<ship> dbContext.SaveChanges(); result.Status = true; } } } else { result.Status = false; } return(result); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); result.Status = false; return(result); } }
public FrayteResult UpdateHAWBNumber(int shipmentId, int hawbNumber) { FrayteResult result = new FrayteResult(); result = new TradelaneBookingRepository().UpdateHAWBNumber(shipmentId, hawbNumber); return(result); }
public FrayteResult DeleteParcelHubKey(int APIId) { FrayteResult result = new FrayteResult(); APIKeyDetail parcelHubKey; try { parcelHubKey = dbContext.APIKeyDetails.Find(APIId); if (parcelHubKey != null) { dbContext.APIKeyDetails.Remove(parcelHubKey); dbContext.SaveChanges(); result.Status = true; } else { result.Status = false; } } catch (Exception e) { result.Status = false; } return(result); }
public FrayteResult RemoveOtherDocument(int tradelaneShipmentDocumentId) { FrayteResult result = new FrayteResult(); try { var shipmentDoc = dbContext.TradelaneShipmentDocuments.Find(tradelaneShipmentDocumentId); if (shipmentDoc != null) { string filePhysicalPath = HttpContext.Current.Server.MapPath("~/UploadFiles/Tradelane/" + shipmentDoc.TradelaneShipmentId + "/" + shipmentDoc.DocumentName); if (File.Exists(filePhysicalPath)) { File.Delete(filePhysicalPath); } dbContext.TradelaneShipmentDocuments.Remove(shipmentDoc); dbContext.SaveChanges(); result.Status = true; } } catch (Exception ex) { result.Status = false; } return(result); }
public FrayteResult UploadBaseRate() { FrayteResult result = new FrayteResult(); var httpRequest = HttpContext.Current.Request; if (httpRequest.Files.Count > 0) { HttpFileCollection files = httpRequest.Files; HttpPostedFile file = files[0]; if (!string.IsNullOrEmpty(file.FileName)) { string connString = ""; string filename = DateTime.Now.ToString("MM_dd_yyyy_hh_mm_ss_") + file.FileName; string filepath = HttpContext.Current.Server.MapPath("~/UploadFiles/Shipments/" + filename); file.SaveAs(filepath); connString = new BaseRateCardUpdateRepository().getExcelConnectionString(filename, filepath); string fileExtension = ""; fileExtension = new BaseRateCardUpdateRepository().getFileExtensionString(filename); try { if (!string.IsNullOrEmpty(fileExtension)) { var ds = new DataSet(); using (var conn = new OleDbConnection(connString)) { conn.Open(); DataTable dbSchema = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); //for (int j = 0; j < dbSchema.Rows.Count; j++) //{ string firstSheetName = dbSchema.Rows[0]["TABLE_NAME"].ToString(); var query = "SELECT * FROM " + "[" + firstSheetName + "]"; using (var adapter = new OleDbDataAdapter(query, conn)) { adapter.Fill(ds, "Rates"); } var exceldata = ds.Tables[0]; if (exceldata.Rows.Count > 0) { result = new BaseRateCardUpdateRepository().UpdateRates(exceldata); } //} } if ((System.IO.File.Exists(filepath))) { System.IO.File.Delete(filepath); } } } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); } } } return(result); }
public FrayteResult SaveParcelHubKey(ParcelHubKeyModel ParcelHubKey) { FrayteResult result = new FrayteResult(); APIKeyDetail parcelHubKey; if (ParcelHubKey.APIId == 0) { parcelHubKey = new APIKeyDetail(); parcelHubKey.APIKey = ParcelHubKey.APIKey; parcelHubKey.APIName = ParcelHubKey.APIName; dbContext.APIKeyDetails.Add(parcelHubKey); dbContext.SaveChanges(); result.Status = true; } else { parcelHubKey = dbContext.APIKeyDetails.Find(ParcelHubKey.APIId); if (parcelHubKey != null) { parcelHubKey.APIKey = ParcelHubKey.APIKey; parcelHubKey.APIName = ParcelHubKey.APIName; dbContext.SaveChanges(); result.Status = true; } else { result.Status = false; } } return(result); }
public IHttpActionResult CreatePayment() { FrayteResult result = new FrayteResult(); //FrayteResult result = new PaymentRepository().CreatePayment(); return(Ok(result)); }
public FrayteResult SaveShipper(FrayteShipperReceiver frayteUser) { FrayteResult result = new FrayteResult(); FrayteUserRepository userRepository = new FrayteUserRepository(); //Step 1: Save User Detail userRepository.SaveUserDetail(frayteUser); //Step 2: Save user role userRepository.SaveUserRole(frayteUser.UserId, (int)FrayteUserRole.Shipper); //Step 3: Save User Address information frayteUser.UserAddress.AddressTypeId = (int)FrayteAddressType.MainAddress; frayteUser.UserAddress.UserId = frayteUser.UserId; userRepository.SaveUserAddress(frayteUser.UserAddress); //Step 4: Save Shipper Pickup address information if (frayteUser.PickupAddresses != null && frayteUser.PickupAddresses.Count > 0) { foreach (FrayteAddress address in frayteUser.PickupAddresses) { address.AddressTypeId = (int)FrayteAddressType.OtherAddress; address.UserId = frayteUser.UserId; userRepository.SaveUserAddress(address); } } result.Status = true; return(result); }
public IHttpActionResult SaveFuelSurCharge(FrayteFuelSurChargeSaveModel FrayteSurCharge) { FuelSurChargeRepository fscr = new FuelSurChargeRepository(); FrayteResult result = fscr.SaveFuelSurCharge(FrayteSurCharge); return(Ok(result)); }
public IHttpActionResult SetPrintPackageStatus(int eCommercePackageTrackingDetailId, string Type) { FrayteResult result = new FrayteResult(); result = new eCommerceShipmentRepository().SetPrintPackageStatus(eCommercePackageTrackingDetailId, Type); return(Ok(result)); }
public IHttpActionResult SaveCustomerCharge(FrayteCustomerSpecificAdminCharges charge) { FrayteResult result = new FrayteResult(); result = new AdminChargesRepository().SaveCustomerCharge(charge); return(Ok(result)); }
public FrayteResult SaveTradelaneTracking(TradelaneUpdateTrackingModel TM) { var Shipment = dbContext.TradelaneShipments.Where(a => a.TradelaneShipmentId == TM.TradelaneShipmentId).FirstOrDefault(); var user = dbContext.Users.Where(a => a.UserId == Shipment.CustomerId).FirstOrDefault(); FrayteResult FR = new FrayteResult(); FR.Status = false; var Result = dbContext.TradelaneFlightDetails.Where(a => a.TradelaneFlightDetailId == TM.TradelaneFlightId).FirstOrDefault(); if (Result != null) { Result.TradelaneShipmentId = TM.TradelaneShipmentId; Result.FlightNumber = TM.FlightNo; Result.ArrivalAirportCode = TM.DestinationAirportCode; Result.DepartureAirportCode = TM.DepartureAirportCode; var Timezone = dbContext.Timezones.Where(a => a.TimezoneId == user.TimezoneId).FirstOrDefault(); TimeZoneModal TZM = new TimeZoneModal(); if (Timezone != null) { TZM.TimezoneId = Timezone.TimezoneId; TZM.Name = Timezone.Name; } Result.ArrivalDate = UtilityRepository.ConvertToUniversalTimeWitDate(TM.ArrivalTime, TM.ArrivalDate.Value, TZM); Result.DepartureDate = UtilityRepository.ConvertToUniversalTimeWitDate(TM.DepartureTime, TM.DepartureDate.Value, TZM); Result.BookingStatus = TM.BookingStatus; Result.Pieces = TM.TotalPeices; Result.TotalVolume = TM.Volume; Result.TotalWeight = TM.TotalWeight; dbContext.Entry(Result).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); FR.Status = true; } else { TradelaneFlightDetail TlST = new TradelaneFlightDetail(); TlST.TradelaneShipmentId = TM.TradelaneShipmentId; TlST.FlightNumber = TM.FlightNo; TlST.ArrivalAirportCode = TM.DestinationAirportCode; TlST.DepartureAirportCode = TM.DepartureAirportCode; var Timezone = dbContext.Timezones.Where(a => a.TimezoneId == user.TimezoneId).FirstOrDefault(); TimeZoneModal TZM = new TimeZoneModal(); if (Timezone != null) { TZM.TimezoneId = Timezone.TimezoneId; TZM.Name = Timezone.Name; } TlST.ArrivalDate = UtilityRepository.ConvertToUniversalTimeWitDate(TM.ArrivalTime, TM.ArrivalDate.Value, TZM); TlST.DepartureDate = UtilityRepository.ConvertToUniversalTimeWitDate(TM.DepartureTime, TM.DepartureDate.Value, TZM); TlST.BookingStatus = TM.BookingStatus; TlST.Pieces = TM.TotalPeices; TlST.TotalVolume = TM.Volume; TlST.TotalWeight = TM.TotalWeight; dbContext.TradelaneFlightDetails.Add(TlST); dbContext.SaveChanges(); FR.Status = true; } return(FR); }
public FrayteResult DeleteTimeZone(int timezoneId) { FrayteResult result = new FrayteResult(); result = new TimeZoneRepository().DeleteTimeZone(timezoneId); return(result); }
public FrayteResult AssigneedHAWB(List <TrackTradelanePackage> packages) { FrayteResult result = new FrayteResult(); result = new TradelaneBookingRepository().AssigneedHAWB(packages); return(result); }
public FrayteResult DeleteWarehouse(int warehouseId) { FrayteResult result = new FrayteResult(); result = new WarehouseRepository().DeleteWarehouse(warehouseId); return(result); }
public FrayteResult DeleteCourier(int courierId) { FrayteResult result = new FrayteResult(); result = new CourierRepository().DeleteCourier(courierId); return(result); }
public FrayteResult DeleteCountryHoliday(int countryHolydayId) { FrayteResult result = new FrayteResult(); result = new CountryRepository().DeleteCountryHoliday(countryHolydayId); return(result); }
public FrayteResult DeleteCountryDocument(int countryDocumentId) { FrayteResult result = new FrayteResult(); result = new CountryRepository().DeleteCountryDocument(countryDocumentId); return(result); }
public FrayteResult UpdateRates(System.Data.DataTable exceldata) { FrayteResult result = new FrayteResult(); try { int k = 0; foreach (DataRow shipmentdetail in exceldata.Rows) { if (k > 0) { for (int i = 0; i < exceldata.Columns.Count; i++) { var id = exceldata.Columns[i].ColumnName; var weightid = int.Parse(shipmentdetail.ItemArray[0].ToString()); if (i > 2) { var zoneid = int.Parse(id.ToString()); var dbRate = dbContext.LogisticServiceBaseRateCards.Where(p => p.LogisticServiceZoneId == zoneid && p.LogisticServiceWeightId == weightid).FirstOrDefault(); if (dbRate != null) { dbRate.LogisticRate = decimal.Parse(shipmentdetail.ItemArray[i].ToString()); dbContext.Entry(dbRate).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } else { LogisticServiceBaseRateCard rate = new LogisticServiceBaseRateCard(); rate.OperationZoneId = 2; rate.LogisticServiceZoneId = zoneid; rate.LogisticServiceWeightId = weightid; rate.LogisticServiceShipmentTypeId = 48; rate.LogisticServiceDimensionId = 0; rate.LogisticServiceCourierAccountId = 95; rate.LogisticRate = decimal.Parse(shipmentdetail.ItemArray[i].ToString()); rate.LogisticCurrency = "GBP"; rate.ModuleType = "DirectBooking"; dbContext.LogisticServiceBaseRateCards.Add(rate); if (rate != null) { dbContext.SaveChanges(); } } } } } k++; } result.Status = true; return(result); } catch (Exception ex) { result.Status = false; return(result); } }