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