public bool UpdateScheduledPickup(string emailId)
{
ScheduledPickUp tempobj = new ScheduledPickUp();
bool status = false;
//long num;
try
{
tempobj = Context.ScheduledPickUp
.Where(x => x.EmailId == emailId)
.FirstOrDefault();
if (tempobj != null)
{
//Console.WriteLine("Not null");
tempobj.AwbNumber = (from db in Context.ReceivePackage where db.CustomerName == tempobj.Name select db.AwbNumber).FirstOrDefault();
//tempobj.AwbNumber = 100007;
Context.ScheduledPickUp.Update(tempobj);
status = true;
Context.SaveChanges();
}
else
{
status = false;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
status = false;
}
return(status);
}
public bool SchedulePickUp(WebService.Models.SchedulePickUpCardDetails spcdobj)
{
bool status = false;
try
{
ScheduledPickUp spobj = new ScheduledPickUp();
CardDetails cdobj = new CardDetails();
spobj.EmailId = spcdobj.EmailId;
spobj.PickupPinCode = spcdobj.PickupPinCode;
spobj.DeliveryPinCode = spcdobj.DeliveryPinCode;
spobj.ShipmentType = spcdobj.ShipmentType;
spobj.PackageLen = spcdobj.PackageLen;
spobj.PackageBreadth = spcdobj.PackageBreadth;
spobj.PackageHeight = spcdobj.PackageHeight;
spobj.PackageWeight = spcdobj.PackageWeight;
spobj.PackingReq = spcdobj.PackingReq;
spobj.DeliveryOpt = spcdobj.DeliveryOpt;
spobj.TimeSlot = spcdobj.TimeSlot;
spobj.PickupAddress = spcdobj.PickupAddress;
spobj.DeliveryAddress = spcdobj.DeliveryAddress;
//spobj.Insurance = spcdobj.Insurance;
//spobj.Amount = spcdobj.Amount;
spobj.Payment = spcdobj.Payment;
if (spcdobj.CardNumber != 0)
{
cdobj.CardNumber = spcdobj.CardNumber;
cdobj.NameOnCard = spcdobj.NameOnCard;
cdobj.CardType = spcdobj.CardType;
cdobj.Cvvnumber = spcdobj.Cvvnumber;
cdobj.ExpiryDate = spcdobj.ExpiryDate;
cdobj.Balance = spcdobj.Balance;
}
status = rep.ScheduleAPick_Up(spobj, cdobj);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
status = false;
}
return(status);
}
public bool ScheduleAPick_Up(ScheduledPickUp obj, CardDetails cdobj)
{
ScheduledPickUp temp = new ScheduledPickUp();
Orders orderobj = new Orders();
bool status = false;
try
{
Console.WriteLine("hi");
if (ServiceAvailability(Convert.ToInt32(obj.DeliveryPinCode)) && ServiceAvailability(Convert.ToInt32(obj.PickupPinCode)))
{
Console.WriteLine("Hello");
int dist = 5;
int deloptchrge = 0;
int insurancechrg = 0;
int packingServicesCharge = 0;
int perKmPrice = 7;
int pickUpChrg = 200;
int weightCharges = 0;
int volumeCharges = 0;
decimal amount;
decimal volume = (obj.PackageLen * obj.PackageBreadth * obj.PackageHeight);
int insuranceCol;
decimal finalamount;
if (obj.Payment.ToLower() == "card" && cdobj != null)
{
addCardDetails(cdobj);
addSavedCards(obj.EmailId, cdobj.CardNumber);
}
if (obj.PackingReq == 1)
{
packingServicesCharge = 500;
}
if (obj.DeliveryOpt == "Overnight")
{
deloptchrge = 500;
}
if (obj.DeliveryOpt == "Express")
{
deloptchrge = 100;
}
if (obj.DeliveryOpt == "Standard")
{
deloptchrge = 0;
}
if (obj.PackageWeight > 5)
{
weightCharges = 500;
}
if (volume > 100)
{
volumeCharges = 50;
}
amount = pickUpChrg + deloptchrge + (dist * perKmPrice) + packingServicesCharge + (obj.PackageWeight * weightCharges) + (volume * volumeCharges);
if (amount > 1000)
{
insuranceCol = 1;
insurancechrg = 1000;
}
else
{
insuranceCol = 1;
insurancechrg = 1000;
}
finalamount = amount + insurancechrg;
temp.EmailId = obj.EmailId;
temp.PickupPinCode = Convert.ToDecimal(obj.PickupPinCode);
temp.DeliveryPinCode = Convert.ToDecimal(obj.DeliveryPinCode);
temp.ShipmentType = obj.ShipmentType;
temp.PackageLen = Convert.ToDecimal(obj.PackageLen);
temp.PackageBreadth = Convert.ToDecimal(obj.PackageBreadth);
temp.PackageHeight = Convert.ToDecimal(obj.PackageHeight);
temp.PackageWeight = Convert.ToDecimal(obj.PackageWeight);
temp.PackingReq = Convert.ToByte(obj.PackingReq);
temp.DeliveryOpt = obj.DeliveryOpt;
temp.TimeSlot = Convert.ToDateTime(obj.TimeSlot);
temp.PickupAddress = obj.PickupAddress;
temp.DeliveryAddress = obj.DeliveryAddress;
temp.Insurance = Convert.ToByte(insuranceCol);
temp.Amount = Convert.ToDecimal(finalamount);
temp.Payment = obj.Payment;
orderobj.DeliveryAddress = temp.DeliveryAddress;
orderobj.EmailId = temp.EmailId;
Console.WriteLine(finalamount);
//int retval = (int)Context.Database.ExecuteSqlCommand($"exec [dbo].[schedule_pickup] {obj.EmailId},{Convert.ToInt32(obj.PickupPinCode)},{Convert.ToInt32(obj.DeliveryPinCode)}," +
// $"{obj.ShipmentType},{Convert.ToDecimal(obj.PackageLen)},{Convert.ToDecimal(obj.PackageBreadth)},{Convert.ToDecimal(obj.PackageHeight)},{Convert.ToDecimal(obj.PackageWeight)}," +
// $"{obj.PackingReq},{obj.DeliveryOpt},{obj.TimeSlot},{obj.PickupAddress},{obj.DeliveryAddress},{dist},{obj.Payment}");
Context.ScheduledPickUp.Add(temp);
Context.Orders.Add(orderobj);
//Console.WriteLine("xyz");
Context.SaveChanges();
status = true;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
status = false;
}
return(status);
}
