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);
}
}
