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 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 FrayteTimeZone SaveTimeZone(FrayteTimeZone timezone)
{
Timezone newTimeZone;
if (timezone.TimezoneId > 0)
{
newTimeZone = dbContext.Timezones.Where(p => p.TimezoneId == timezone.TimezoneId).FirstOrDefault();
newTimeZone.Name = timezone.Name;
newTimeZone.Offset = timezone.Offset;
newTimeZone.OffsetShort = timezone.OffsetShort;
}
else
{
newTimeZone = new Timezone();
newTimeZone.Name = timezone.Name;
newTimeZone.Offset = timezone.Offset;
newTimeZone.OffsetShort = timezone.OffsetShort;
dbContext.Timezones.Add(newTimeZone);
}
dbContext.SaveChanges();
timezone.TimezoneId = newTimeZone.TimezoneId;
return(timezone);
}
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 int SaveMileStone(TrackingMileStoneModel TMSM)
{
var result = dbContext.TrackingMileStones.Where(a => a.TrackingMileStoneId == TMSM.TrackingMileStoneId).FirstOrDefault();
var ShipHandelCount = dbContext.TrackingMileStones.Where(a => a.ShipmentHandlerMethodId == TMSM.ShipmentHandlerMethodId).ToList();
if (result == null)
{
TrackingMileStone TMS = new TrackingMileStone();
TMS.MileStoneKey = TMSM.MileStoneKey;
TMS.Description = TMSM.Description;
TMS.OrderNumber = TMSM.OrderNumber;
TMS.ShipmentHandlerMethodId = TMSM.ShipmentHandlerMethodId;
TMS.CreatedBy = TMSM.CreatedBy;
TMS.CreatedOnUtc = DateTime.UtcNow;
TMS.UpdatedBy = TMSM.UpdatedBy;
TMS.UpdatedOnUtc = DateTime.UtcNow;
dbContext.TrackingMileStones.Add(TMS);
dbContext.SaveChanges();
SetOrderAddEdit(TMS);
return(TMS.TrackingMileStoneId);
}
else
{
result.MileStoneKey = TMSM.MileStoneKey;
result.Description = TMSM.Description;
result.OrderNumber = TMSM.OrderNumber;
result.ShipmentHandlerMethodId = TMSM.ShipmentHandlerMethodId;
result.UpdatedBy = TMSM.UpdatedBy;
result.UpdatedOnUtc = DateTime.UtcNow;
dbContext.Entry(result).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
SetOrderAddEdit(result);
return(result.TrackingMileStoneId);
}
}
public FrayteCarrier SaveCarrier(FrayteCarrier carrier)
{
Carrier newCarrier;
if (carrier.CarrierId > 0)
{
newCarrier = dbContext.Carriers.Where(p => p.CarrierId == carrier.CarrierId).FirstOrDefault();
newCarrier.CarrierName = carrier.CarrierName;
newCarrier.Code = carrier.Code;
newCarrier.Prefix = carrier.Prefix;
newCarrier.CarrierType = carrier.CarrierType;
}
else
{
newCarrier = new Carrier();
newCarrier.CarrierId = carrier.CarrierId;
newCarrier.CarrierName = carrier.CarrierName;
newCarrier.Code = carrier.Code;
newCarrier.Prefix = carrier.Prefix;
newCarrier.CarrierType = carrier.CarrierType;
dbContext.Carriers.Add(newCarrier);
}
dbContext.SaveChanges();
carrier.CarrierId = newCarrier.CarrierId;
return(carrier);
}
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 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);
}
}
public void SaveEasyPostReceiverAddressId(int userAddressId, string easyPostAddressId)
{
try
{
var UserAddress = dbContext.UserAddresses.Find(userAddressId);
UserAddress.EasyPostAddressId = easyPostAddressId;
dbContext.SaveChanges();
}
catch (Exception e)
{
}
}
public FrayteResult SetShipmentHSCode(int eCommerceShipmentDetailid, string HSCode)
{
FrayteResult result = new FrayteResult();
try
{
if (eCommerceShipmentDetailid > 0)
{
var data = dbContext.eCommerceShipmentDetails.Find(eCommerceShipmentDetailid);
if (data != null)
{
data.HSCode = HSCode;
dbContext.Entry(data).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
result.Status = true;
}
else
{
result.Status = false;
}
try
{
var shipDetail = dbContext.eCommerceShipmentDetails
.Where(p => p.eCommerceShipmentId == data.eCommerceShipmentId &&
!string.IsNullOrEmpty(p.HSCode)).ToList();
if (shipDetail == null || (shipDetail != null || shipDetail.Count == 0))
{
var ship = dbContext.eCommerceShipments.Find(data.eCommerceShipmentId);
if (ship != null)
{
ship.MappedOn = DateTime.UtcNow;
dbContext.Entry(ship).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
}
}
}
catch (Exception ex)
{
}
}
}
catch (Exception ex)
{
result.Status = false;
}
return(result);
}
public TermAndCondition SaveTermAndCondition(TermAndCondition termAndCondition)
{
//For Term And Condition, we always have to create new term and condition in database.
string shortCode = string.Empty;
var customerCompanyDetail = dbContext.CustomerCompanyDetails.Where(p => p.UserId == termAndCondition.CreatedBy).FirstOrDefault();
if (customerCompanyDetail != null)
{
shortCode = customerCompanyDetail.CompanyName.ToLower().Contains("mex") ? "MEX" : "";
}
var OperationZone = UtilityRepository.GetOperationZone();
TermAndCondition newTermAndCondition = new TermAndCondition();
newTermAndCondition.TermAndConditionId = 0;
newTermAndCondition.Detail = termAndCondition.Detail;
newTermAndCondition.CreatedOn = DateTime.UtcNow;
newTermAndCondition.OperationZoneId = termAndCondition.OperationZoneId;
newTermAndCondition.TermAndConditionType = termAndCondition.TermAndConditionType;
newTermAndCondition.CreatedBy = termAndCondition.CreatedBy;
newTermAndCondition.ConpanyCode = shortCode;
dbContext.TermAndConditions.Add(newTermAndCondition);
dbContext.SaveChanges();
return(newTermAndCondition);
}
public void EditThirPartyMatrix(List <FrayteThirdPartyMatrix> _party)
{
try
{
LogisticServiceThirdPartyMatrix tpm;
if (_party != null && _party.Count > 0)
{
foreach (var pr in _party)
{
tpm = dbContext.LogisticServiceThirdPartyMatrices.Where(x => x.LogisticServiceThirdPartyMatrixId == pr.ThirdPartyMatrixId).FirstOrDefault();
if (tpm != null)
{
tpm.FromLogisticServiceZoneId = pr.FromZone.ZoneId;
tpm.ToLogisticServiceZoneId = pr.ToZone.ZoneId;
tpm.ApplyLogisticServiceZoneId = pr.ApplyZone.ZoneId;
tpm.OperationZoneId = pr.OperationZone.OperationZoneId;
dbContext.Entry(tpm).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
}
}
}
}
catch (Exception ex)
{
}
}
public void UpdateReportSettingDate(int CustomerPODSettingId, DateTime lastrun)
{
try
{
var rs = dbContext.CustomerSettings.Where(p => p.CustomerSettingId == CustomerPODSettingId).FirstOrDefault();
if (rs != null && rs.CustomerSettingId > 0)
{
rs.UpdatedOn = lastrun;
dbContext.Entry(rs).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
}
}
public FrayteManifestName SaveLogisticServiceBaseRateHistory(int LogisticServiceId, int Year, string FileName)
{
FrayteManifestName name = new FrayteManifestName();
try
{
LogisticServiceBaseRateCardHistory history = new LogisticServiceBaseRateCardHistory();
history.LogisticServiceId = LogisticServiceId;
history.ReportYear = Year;
history.ReportFileName = FileName;
dbContext.LogisticServiceBaseRateCardHistories.Add(history);
dbContext.SaveChanges();
//Retun Filename and Path
name.FileName = FileName;
name.FilePath = AppSettings.WebApiPath + "ReportFiles/BaseRateCard/" + FileName;
}
catch (DbEntityValidationException dbEx)
{
string validationErrorMsg = "";
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
validationErrorMsg = validationErrorMsg + string.Format("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return(name);
}
public FrayteResult SaveManifestTracking(List <ManifestTrackingModel> MTM)
{
FrayteResult FR = new FrayteResult();
try
{
foreach (var MT in MTM)
{
var EMT = dbContext.eCommerceTrackings.Where(a => a.eCommerceShipmentId == MT.eCommerceShipmentId).FirstOrDefault();
if (EMT == null)
{
eCommerceTracking EMTNew = new eCommerceTracking();
EMTNew.eCommerceShipmentId = MT.eCommerceShipmentId;
EMTNew.FrayteNumber = MT.FrayteNo;
EMTNew.TrackingDescription = MT.TrackingDescription;
EMTNew.TrackingMode = MT.TrackingMode;
EMTNew.TrackingNumber = MT.TrackingNo;
EMTNew.TrackingDescriptionCode = MT.TrackingDescriptionCode;
EMTNew.CreatedBy = MT.CreatedBy;
EMTNew.CreatedOnUtc = MT.CreatedOnUtc;
EMTNew.CreatedBy = MT.UserId;
dbContext.eCommerceTrackings.Add(EMTNew);
dbContext.SaveChanges();
}
else
{
EMT.eCommerceShipmentId = MT.eCommerceShipmentId;
EMT.FrayteNumber = MT.FrayteNo;
EMT.TrackingDescription = MT.TrackingDescription;
EMT.TrackingMode = MT.TrackingDescription;
EMT.TrackingNumber = MT.TrackingNo;
EMT.TrackingDescriptionCode = MT.TrackingDescriptionCode;
EMT.CreatedBy = MT.CreatedBy;
EMT.CreatedBy = MT.UserId;
EMT.CreatedOnUtc = MT.CreatedOnUtc;
dbContext.Entry(EMT).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
}
}
FR.Status = true;
}
catch (Exception e)
{
FR.Status = false;
}
return(FR);
}
public void SaveConsignmentBag(FrayteConsignment cc)
{
try
{
ConsignmentBag cb;
if (cc != null && cc.BagId == 0)
{
cb = new ConsignmentBag();
cb.Description = cc.Description;
dbContext.ConsignmentBags.Add(cb);
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
}
}
public FrayteResult SaveShipperOtherAddress(FrayteAddress shipperOtherAddress)
{
FrayteResult result = new FrayteResult();
UserAddress otherAddress = new UserAddress();
if (shipperOtherAddress.UserAddressId > 0)
{
otherAddress = dbContext.UserAddresses.Find(shipperOtherAddress.UserAddressId);
if (otherAddress != null)
{
otherAddress.UserId = shipperOtherAddress.UserId;
otherAddress.Address = shipperOtherAddress.Address;
otherAddress.Address2 = shipperOtherAddress.Address2;
otherAddress.Address3 = shipperOtherAddress.Address3;
otherAddress.City = shipperOtherAddress.City;
otherAddress.Suburb = shipperOtherAddress.Suburb;
otherAddress.State = shipperOtherAddress.State;
otherAddress.Zip = shipperOtherAddress.Zip;
otherAddress.CountryId = shipperOtherAddress.Country.CountryId;
dbContext.SaveChanges();
result.Status = true;
}
}
else
{
otherAddress.AddressTypeId = (int)FrayteAddressType.OtherAddress;
otherAddress.UserId = shipperOtherAddress.UserId;
otherAddress.Address = shipperOtherAddress.Address;
otherAddress.Address2 = shipperOtherAddress.Address2;
otherAddress.Address3 = shipperOtherAddress.Address3;
otherAddress.City = shipperOtherAddress.City;
otherAddress.Suburb = shipperOtherAddress.Suburb;
otherAddress.State = shipperOtherAddress.State;
otherAddress.Zip = shipperOtherAddress.Zip;
otherAddress.CountryId = shipperOtherAddress.Country.CountryId;
dbContext.UserAddresses.Add(otherAddress);
dbContext.SaveChanges();
result.Status = true;
}
return(result);
}
private void WorkingWeekDayDetails(int workingId, List <FrayteWorkingWeekDayDetail> frayteWorkingWeekDetail)
{
foreach (FrayteWorkingWeekDayDetail frayWeekDetail in frayteWorkingWeekDetail)
{
WorkingWeekDayDetail weekDetail = new WorkingWeekDayDetail();
if (frayWeekDetail.WorkingWeekDayDetailId == 0)
{
weekDetail.WorkingWeekDayId = workingId;
weekDetail.DayId = frayWeekDetail.DayId;
weekDetail.DayName = frayWeekDetail.DayName;
weekDetail.DayHalfTime = frayWeekDetail.DayHalfTime;
dbContext.WorkingWeekDayDetails.Add(weekDetail);
}
else
{
weekDetail = dbContext.WorkingWeekDayDetails.Where(p => p.WorkingWeekDayDetailId == frayWeekDetail.WorkingWeekDayDetailId).FirstOrDefault();
if (weekDetail != null)
{
weekDetail.WorkingWeekDayId = workingId;
weekDetail.DayId = frayWeekDetail.DayId;
weekDetail.DayName = frayWeekDetail.DayName;
weekDetail.DayHalfTime = frayWeekDetail.DayHalfTime;
}
}
if (weekDetail != null)
{
dbContext.SaveChanges();
}
frayWeekDetail.WorkingWeekDayDetailId = frayWeekDetail.WorkingWeekDayDetailId;
}
}
public FrayteResult SaveFuelSurCharge(FrayteFuelSurChargeSaveModel FrayteSurCharge)
{
FrayteResult result = new FrayteResult();
try
{
FrayteSurCharge.Year = new DateTime(FrayteSurCharge.Year.Year, 1, FrayteSurCharge.Year.Day);
FuelSurCharge fuelsurcharge;
var service = dbcontext.LogisticServices.Where(p => p.OperationZoneId == FrayteSurCharge.OperationZoneId && p.IsActive == true).ToList();
if (service.Count > 0)
{
foreach (var ss in service)
{
fuelsurcharge = new FuelSurCharge();
for (int i = 1; i <= 12; i++)
{
fuelsurcharge.OperationZoneId = FrayteSurCharge.OperationZoneId;
fuelsurcharge.LogisticServiceId = ss.LogisticServiceId;
fuelsurcharge.FrayteFuelPercent = 0;
fuelsurcharge.ExpryesFuelPercent = 0;
fuelsurcharge.DomesticFuelPercent = 0;
fuelsurcharge.RoadFuelSurcharge = 0;
fuelsurcharge.FuelMonthYear = FrayteSurCharge.Year;
fuelsurcharge.CreatedOn = DateTime.UtcNow;
fuelsurcharge.UpdatedOn = null;
fuelsurcharge.UpdatedBy = 1;
fuelsurcharge.IsUpdated = true;
dbcontext.FuelSurCharges.Add(fuelsurcharge);
dbcontext.SaveChanges();
FrayteSurCharge.Year = FrayteSurCharge.Year.AddMonths(1);
}
}
}
result.Status = true;
}
catch (Exception ex)
{
result.Status = false;
}
return(result);
}
public FrayteResult SavePermissionToRole(AccessRoleModule accessRoleModule)
{
FrayteResult result = new FrayteResult();
try
{
if (accessRoleModule != null && accessRoleModule.ModuleLeveLId > 0)
{
List <RoleModule> list = new List <RoleModule>();
if (accessRoleModule.UpdateCase == ModuleLevelUpdateCase.RoleModuleLevel)
{
list = dbContext.RoleModules.Where(p => p.ModuleLevelId == accessRoleModule.ModuleLeveLId && p.RoleId == accessRoleModule.RoleId).ToList();
}
else if (accessRoleModule.UpdateCase == ModuleLevelUpdateCase.RoleModuleDetailLevel)
{
list = dbContext.RoleModules.Where(p => p.ModuleLevelId == accessRoleModule.ModuleLeveLId && p.ModuleLevelDetailId == accessRoleModule.ModuleLeveLDetailId && p.RoleId == accessRoleModule.RoleId).ToList();
}
if (list != null && list.Count > 0)
{
foreach (var data in list)
{
data.IsActive = accessRoleModule.IsActive;
dbContext.Entry(data).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
result.Status = true;
}
}
else
{
result.Status = false;
}
}
else
{
result.Status = false;
}
}
catch (Exception ex)
{
result.Status = false;
}
return(result);
}
public FrayteResult DeleteTradelaneShipment(int TradelaneShipmentId)
{
FrayteResult FE = new FrayteResult();
FE.Status = false;
var Result = dbContext.TradelaneShipments.Where(a => a.TradelaneShipmentId == TradelaneShipmentId).FirstOrDefault();
if (Result != null)
{
var FromAddress = dbContext.TradelaneShipmentAddresses.Where(a => a.TradelaneShipmentAddressId == Result.FromAddressId).FirstOrDefault();
var ToAddress = dbContext.TradelaneShipmentAddresses.Where(a => a.TradelaneShipmentAddressId == Result.ToAddressId).FirstOrDefault();
var TradelaneShipmentDetail = dbContext.TradelaneShipmentDetails.Where(a => a.TradelaneShipmentId == Result.TradelaneShipmentId).ToList();
var TradelaneShipmentDoc = dbContext.TradelaneShipmentDocuments.Where(a => a.TradelaneShipmentId == Result.TradelaneShipmentId).ToList();
if (FromAddress != null)
{
dbContext.TradelaneShipmentAddresses.Remove(FromAddress);
dbContext.SaveChanges();
}
if (ToAddress != null)
{
dbContext.TradelaneShipmentAddresses.Remove(ToAddress);
dbContext.SaveChanges();
}
if (TradelaneShipmentDetail != null && TradelaneShipmentDetail.Count > 0)
{
dbContext.TradelaneShipmentDetails.RemoveRange(TradelaneShipmentDetail);
dbContext.SaveChanges();
}
if (TradelaneShipmentDoc != null && TradelaneShipmentDoc.Count > 0)
{
dbContext.TradelaneShipmentDocuments.RemoveRange(TradelaneShipmentDoc);
dbContext.SaveChanges();
}
dbContext.TradelaneShipments.Remove(Result);
dbContext.SaveChanges();
FE.Status = true;
return(FE);
}
else
{
return(FE);
}
}
public FrayteTradelane SaveTradelane(FrayteTradelane frateTradelane)
{
try
{
Tradelane tradelane;
if (frateTradelane.TradelaneId > 0)
{
tradelane = dbContext.Tradelanes.Where(p => p.TradelaneId == frateTradelane.TradelaneId).FirstOrDefault();
tradelane.OriginatingAgentId = frateTradelane.OriginatingAgent.UserId;
tradelane.OriginCountryId = frateTradelane.OriginatingCountry.CountryId;
tradelane.DestinationAgentId = frateTradelane.DestinationAgent.UserId;
tradelane.DestinationCountryId = frateTradelane.DestinationCountry.CountryId;
tradelane.Direct = frateTradelane.Direct;
tradelane.Deffered = frateTradelane.Deffered;
tradelane.CarrierId = frateTradelane.Carrier.CarrierId;
tradelane.TransitTime = frateTradelane.TransitTime;
dbContext.SaveChanges();
frateTradelane.TradelaneId = tradelane.TradelaneId;
}
else
{
tradelane = new Tradelane();
tradelane.OriginatingAgentId = frateTradelane.OriginatingAgent.UserId;
tradelane.OriginCountryId = frateTradelane.OriginatingCountry.CountryId;
tradelane.DestinationAgentId = frateTradelane.DestinationAgent.UserId;
tradelane.DestinationCountryId = frateTradelane.DestinationCountry.CountryId;
tradelane.Direct = frateTradelane.Direct;
tradelane.Deffered = frateTradelane.Deffered;
tradelane.CarrierId = frateTradelane.Carrier.CarrierId;
tradelane.TransitTime = frateTradelane.TransitTime;
dbContext.Tradelanes.Add(tradelane);
dbContext.SaveChanges();
frateTradelane.TradelaneId = tradelane.TradelaneId;
}
return(frateTradelane);
}
catch (Exception ex)
{
return(null);
}
}
public FrayteResult RemoveAssociateCustomer(int CustomerStaffDetailId)
{
FrayteResult result = new FrayteResult();
try
{
var detail = dbContext.CustomerStaffs.Where(p => p.CustomerStaffDetailId == CustomerStaffDetailId).FirstOrDefault();
if (detail != null)
{
detail.IsActive = false;
dbContext.Entry(detail).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
result.Status = true;
}
return(result);
}
catch (Exception ex)
{
result.Status = false;
return(result);
}
}
public FrayteCourier SaveCourier(FrayteCourier courier)
{
Courier newCourier;
if (courier.CourierId > 0)
{
newCourier = dbContext.Couriers.Where(p => p.CourierId == courier.CourierId).FirstOrDefault();
newCourier.CourierName = courier.Name;
newCourier.DisplayName = CommonConversion.DisplayName(courier.Name);
newCourier.Website = courier.Website;
newCourier.ShipmentType = courier.CourierType;
newCourier.LatestBookingTime = UtilityRepository.GetTimeFromString(courier.LatestBookingTime).Value;
}
else
{
newCourier = new Courier();
newCourier.CourierId = courier.CourierId;
newCourier.CourierName = courier.Name;
newCourier.DisplayName = CommonConversion.DisplayName(courier.Name);
newCourier.Website = courier.Website;
newCourier.ShipmentType = courier.CourierType;
newCourier.LatestBookingTime = UtilityRepository.GetTimeFromString(courier.LatestBookingTime).Value;
dbContext.Couriers.Add(newCourier);
}
try
{
dbContext.SaveChanges();
}
catch (Exception ex)
{
}
courier.CourierId = newCourier.CourierId;
return(courier);
}
public void SaveTracingComment(FrayteTracingComment ftc)
{
try
{
TracingComment tc;
if (ftc != null && ftc.TracingCommentId == 0)
{
tc = new TracingComment();
tc.Description = ftc.Description;
dbContext.TracingComments.Add(tc);
dbContext.SaveChanges();
}
//else
//{
// tc = dbContext.TracingComments.Find(ftc.TracingCommentId);
// tc.Description = ftc.Description;
// dbContext.TracingComments.Add(tc);
// dbContext.SaveChanges();
//}
}
catch (Exception ex)
{
}
}
public void UpdateOfflineTracking(List <FrayteOfflineTracking> frayteOfflineTracking)
{
if (frayteOfflineTracking != null && frayteOfflineTracking.Count > 0)
{
DirectShipmentTracking tracking;
foreach (var item in frayteOfflineTracking)
{
tracking = new DirectShipmentTracking();
tracking.DirectShipmentId = item.ShipmentId;
tracking.CreatedOnUtc = DateTime.UtcNow;
tracking.Location = item.Location;
tracking.TrackingDescription = item.Message;
dbContext.DirectShipmentTrackings.Add(tracking);
dbContext.SaveChanges();
}
}
}
//public SkyPostalResponseModel CreateShipment(SkyPostalRequestModel skyPostalRequest, int DirectShipmentDraftId)
//{
// SkyPostalResponseModel respone = new SkyPostalResponseModel();
// var logisticIntegration = UtilityRepository.getLogisticIntegration(UtilityRepository.GetOperationZone().OperationZoneId, AppSettings.ApplicationMode, FrayteIntegration.SKYPOSTAL);
// string result = string.Empty;
// #region SKYPOSTaL API Login
// skyPostalRequest.Key = logisticIntegration.InetgrationKey;
// var skyPostalJson = Newtonsoft.Json.JsonConvert.SerializeObject(skyPostalRequest);
// result = SkyPostalWebApi(logisticIntegration, skyPostalJson);
// respone = Newtonsoft.Json.JsonConvert.DeserializeObject<SkyPostalResponseModel>(result);
// respone.Rawrequest = skyPostalJson;
// respone.Rawresponse = result;
// if (respone.success > 0)
// {
// return respone;
// }
// else
// {
// var j1 = JObject.Parse(result);
// var diff = j1["response"].ToList();
// respone.Error = new FratyteError();
// respone.Error.Service = new List<string>();
// string err = string.Empty;
// foreach (var error1 in diff)
// {
// err = error1.ToString();
// var err1 = err.Replace("{", "");
// var err2 = err1.Replace("}", "");
// respone.Error.Service.Add(err2);
// }
// respone.Error.Status = false;
// //Error Recorded
// SaveDirectShipmentObject(skyPostalJson, respone.Error.Service.ToString(), DirectShipmentDraftId);
// return respone;
// }
// #endregion
//}
private void SaveDirectShipmentObject(string ShipmetObject, string ShipmetErrorObject, int ShipmentDraftId)
{
try
{
var detail = dbContext.DirectShipmentDrafts.Find(ShipmentDraftId);
if (detail != null)
{
detail.EasyPostOrderObject = ShipmetObject;
detail.EasyPostErrorObject = ShipmetErrorObject;
detail.LastUpdated = DateTime.UtcNow;
dbContext.Entry(detail).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(new Exception(ShipmetObject));
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
}
public FrayteResult DeleteCountryHoliday(int countryHolydayId)
{
FrayteResult result = new FrayteResult();
try
{
var publicHoliday = dbContext.CountryPublicHolidays.Find(countryHolydayId);
if (publicHoliday != null)
{
dbContext.CountryPublicHolidays.Remove(publicHoliday);
dbContext.SaveChanges();
result.Status = true;
return(result);
}
}
catch (Exception ex)
{
result.Status = false;
}
return(result);
}
public FrayteResult SaveCustomerCharge(FrayteCustomerSpecificAdminCharges charge)
{
FrayteResult result = new FrayteResult();
try
{
AdminCharge adminCharge;
foreach (var item in charge.Charges)
{
if (item.AdminChargeId == 0)
{
adminCharge = new AdminCharge();
adminCharge.Value = item.Amount;
adminCharge.CustomerId = charge.CustomerId;
adminCharge.CreatedOnUtc = DateTime.UtcNow;
adminCharge.IsActive = true;
adminCharge.Name = item.Value;
adminCharge.ShortName = item.Key;
adminCharge.OperationZoneId = UtilityRepository.GetOperationZone().OperationZoneId;
adminCharge.ChargeType = item.ChargeType;
adminCharge.CreatedBy = item.CreatedBy;
adminCharge.CurrencyCode = "GBP";// item.CurrencyCode;
dbcontext.AdminCharges.Add(adminCharge);
dbcontext.SaveChanges();
}
else
{
adminCharge = dbcontext.AdminCharges.Find(item.AdminChargeId);
adminCharge.Value = item.Amount;
adminCharge.UpdatedOnUtc = DateTime.UtcNow;
adminCharge.UpdatedBy = item.CreatedBy;
dbcontext.SaveChanges();
}
}
result.Status = true;
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
result.Status = false;
}
return(result);
}
public FrayteRateResponse SaveInitializeApiError(string Error)
{
FrayteRateResponse apierror = new FrayteRateResponse();
if (Error != null && Error != "")
{
//Step 1.0 Get last record from apierrorcode table
ApiErrorCode errordetail = dbContext.ApiErrorCodes.ToList().Last();
if (errordetail != null)
{
int errorcode = errordetail.ErrorCode.HasValue ? errordetail.ErrorCode.Value : 0;
apierror.Status = false;
apierror.Description = null;
apierror.ShipmentId = null;
apierror.RateCard = null;
//Step 1.1 Checking same development error
List <ApiErrorCode> _error = dbContext.ApiErrorCodes.Where(p => p.DevelopmentErrorDetail == Error).ToList();
if (_error.Count > 0)
{
apierror.Errors = new List <FrayteApiError>();
{
foreach (ApiErrorCode ai in _error)
{
//Step 1.2 Make error response
FrayteApiError tt = new FrayteApiError()
{
ErrorCode = ai.ErrorCode.HasValue ? ai.ErrorCode.Value : 0,
Description = ai.Description
};
apierror.Errors.Add(tt);
}
}
}
else
{
//Step 1.3 Insert error into apierrorcode table
ApiErrorCode code = new ApiErrorCode();
code.ErrorCode = errorcode + 1;
code.Description = Error;
code.DevelopmentErrorDetail = Error;
code.Courier = null;
code.CourierErrorCode = null;
code.CourierErrorDescription = null;
code.ParentErrorCodeId = errordetail.ErrorCodeId + 1;
if (code != null)
{
dbContext.ApiErrorCodes.Add(code);
dbContext.SaveChanges();
}
//Step 1.4 Make error response
apierror.Errors = new List <FrayteApiError>();
{
FrayteApiError tt = new FrayteApiError()
{
ErrorCode = errorcode + 1,
Description = Error
};
apierror.Errors.Add(tt);
}
}
}
}
return(apierror);
}