示例#1
0
        public ActionResult Edit(PODStatusVM v)
        {
            AWBStatu obj = new AWBStatu();

            obj.AWBStatusID         = v.AWBStatusID;
            obj.StatusDescriptionID = v.CourierStatusID;



            POD ob = new POD();

            ob.PODID        = v.PODID;
            ob.ReceiverName = v.RecevierName;
            ob.Remarks      = v.Remarks;

            db.Entry(obj).State = EntityState.Modified;
            db.SaveChanges();

            db.Entry(ob).State = EntityState.Modified;
            db.SaveChanges();

            ////var insacn = db.AWBStatus.Where(itm => itm.AWBStatusID == v.AWBStatusID).FirstOrDefault();
            ////insacn.AWBStatusID = v.AWBStatusID;
            ////insacn.StatusDescriptionID = v.CourierStatusID;
            ////db.SaveChanges();


            //var insacn1 = db.PODs.Where(itm => itm.PODID == v.PODID).FirstOrDefault();
            //insacn1.PODID = v.PODID;
            //insacn1.ReceiverName = v.RecevierName;
            //insacn1.Remarks = v.Remarks;
            //db.SaveChanges();

            return(RedirectToAction("Index"));
        }
示例#2
0
        public ActionResult Create(PODStatusVM v)
        {
            AWBStatu obj = new AWBStatu();

            int max = (from c in db.AWBStatus orderby c.AWBStatusID descending select c.AWBStatusID).FirstOrDefault();


            //List<PODStatusVM> lst = (from c in db.CourierStatus join t in db.AWBStatus on c.CourierStatusID equals t.StatusDescriptionID select new PODStatusVM { CourierStatusID = c.CourierStatusID }).ToList();

            if (max == null)
            {
                obj.AWBStatusID         = 1;
                obj.StatusDescriptionID = v.CourierStatusID;
            }
            else
            {
                obj.AWBStatusID         = max + 1;
                obj.StatusDescriptionID = v.CourierStatusID;
            }

            POD ob   = new POD();
            int data = (from c in db.PODs orderby c.PODID descending select c.PODID).FirstOrDefault();

            if (data == null)
            {
                ob.PODID        = 1;
                ob.ReceiverName = v.RecevierName;
                ob.Remarks      = v.Remarks;
            }
            else
            {
                ob.PODID        = data + 1;
                ob.ReceiverName = v.RecevierName;
                ob.Remarks      = v.Remarks;
            }


            db.AWBStatus.Add(obj);
            db.SaveChanges();


            db.PODs.Add(ob);
            db.SaveChanges();


            return(RedirectToAction("Index"));
        }
示例#3
0
        public ActionResult DeleteConfirmed(int id = 0)
        {
            AWBStatu a = db.AWBStatus.Find(id);

            if (a == null)
            {
                return(HttpNotFound());
            }
            else
            {
                db.AWBStatus.Remove(a);
                db.SaveChanges();

                List <POD> lst = (from c in db.PODs where c.PODID == id select c).ToList();

                foreach (var item in lst)
                {
                    db.PODs.Remove(item);
                    db.SaveChanges();
                }

                return(RedirectToAction("Index"));
            }
        }
        public ActionResult Create(AWBillVM v)
        {
            try
            {
                string AWBNo = string.Empty;


                if (v.AWBNO != string.Empty)
                {
                    AWBNo = v.AWBNO;
                }
                else
                {
                    string aw = (from c in db.InScans orderby c.AWBNo descending select c.AWBNo).FirstOrDefault();

                    int a = Convert.ToInt32(aw) + 1;
                    AWBNo = a.ToString();
                }
                int CurrentBranchID = Convert.ToInt32(Session["CurrentBranchID"].ToString());
                var ahead           = db.AcHeadAssigns.FirstOrDefault(); // commented on sep 21 2020 Where(x => x.BranchID == CurrentBranchID).FirstOrDefault();
                try
                {
                    var ajm = new AcJournalMaster()
                    {
                        AcJournalID       = GetMaxAcJournalID() + 1,
                        VoucherNo         = "C.Note" + AWBNo,
                        TransDate         = DateTime.UtcNow,
                        AcFinancialYearID = Convert.ToInt32(Session["CurrentYear"].ToString()),
                        VoucherType       = "DX",
                        TransType         = 1,
                        StatusDelete      = false,
                        Remarks           = "",
                        UserID            = Convert.ToInt32(Session["UserID"].ToString()),
                        AcCompanyID       = Convert.ToInt32(Session["CurrenctCompanyID"].ToString()),
                        //BranchID = this.CurrentBranchID,
                        Reference = "",
                        ShiftID   = 0,
                    };
                    db.AcJournalMasters.Add(ajm);
                    db.SaveChanges();
                    if (v.paymentmode != "CSR" && v.TotalCharges > 0)
                    {
                        if (ahead != null)
                        {
                            int aheadassign = 0;

                            switch (v.paymentmode)
                            {
                            case "COD": aheadassign = ahead.CODControlID.Value; break;             //CODControlID

                            case "FOC": aheadassign = ahead.FOCControlID.Value; break;             //FOCControlID

                            case "PKP": aheadassign = ahead.ProvisionCostControlAcID.Value; break; //UnPostedSalesAcHeadID

                            default:
                                break;
                            }

                            if (aheadassign != 0 && Convert.ToDecimal(v.TotalCharges) != 0)
                            {
                                AcJournalDetail ajd = new AcJournalDetail()
                                {
                                    AcJournalDetailID = GetMaxAcJournalDetailID() + 1,
                                    AcJournalID       = ajm.AcJournalID,
                                    AcHeadID          = aheadassign,
                                    Amount            = Convert.ToDecimal(v.TotalCharges),
                                    Remarks           = "",
                                };
                                db.AcJournalDetails.Add(ajd);
                                db.SaveChanges();

                                ajd = new AcJournalDetail()
                                {
                                    AcJournalDetailID = GetMaxAcJournalDetailID() + 1,
                                    AcJournalID       = ajm.AcJournalID,
                                    AcHeadID          = aheadassign,
                                    Amount            = -Convert.ToDecimal(v.TotalCharges),
                                    Remarks           = "",
                                };
                                db.AcJournalDetails.Add(ajd);
                                db.SaveChanges();
                            }
                        }
                    }
                    else if (v.paymentmode == "CSR" && v.TotalCharges > 0)
                    {
                        AcJournalDetail ajd = new AcJournalDetail()
                        {
                            AcJournalDetailID = GetMaxAcJournalDetailID() + 1,
                            AcJournalID       = ajm.AcJournalID,
                            AcHeadID          = ahead.MaterialCostControlReceivableAcHeadID,
                            Amount            = Convert.ToDecimal(v.TotalCharges),
                            Remarks           = "",
                        };

                        db.AcJournalDetails.Add(ajd);
                        db.SaveChanges();

                        ajd = new AcJournalDetail()
                        {
                            AcJournalDetailID = GetMaxAcJournalDetailID() + 1,
                            AcJournalID       = ajm.AcJournalID,
                            AcHeadID          = ahead.MaterialCostControlReceivableAcHeadID,
                            Amount            = -Convert.ToDecimal(v.TotalCharges),
                            Remarks           = "",
                        };
                        db.AcJournalDetails.Add(ajd);
                        db.SaveChanges();
                    }

                    InScan inscan = new InScan();

                    inscan.InScanID = GetMaxInscanID();
                    //inscan.AWBNumberMode = IsAWBAutoManual;
                    inscan.BranchID         = Convert.ToInt32(Session["CurrentBranchID"].ToString());
                    inscan.AWBNo            = AWBNo;
                    inscan.Remarks          = v.Remarks;
                    inscan.UserID           = Convert.ToInt32(Session["UserID"].ToString());
                    inscan.EnquiryID        = 0;
                    inscan.StatusClose      = false;
                    inscan.MovementID       = v.movementID;
                    inscan.AcJournalID      = ajm.AcJournalID;
                    inscan.AcCompanyID      = Convert.ToInt32(Session["CurrenctCompanyID"].ToString());
                    inscan.StatusReconciled = false;
                    if (v.Date != null)
                    {
                        inscan.InScanDate = v.Date.Value;
                        //inscan.InScanDate = DateTime.Parse(deDate.SelectedDate.Value.Date.ToString("dd/MM/yyyy") + " " + deDate.SelectedDate.Value.ToString("HH:mm:ss")); //DateTime.Parse(deDate.SelectedDate.Value.Date.ToString("dd/MM/yyyy") + " " + this.rtpTime.SelectedDate.Value.ToString("HH:mm:ss")),
                    }

                    inscan.StatusInScan       = "CN";
                    inscan.CustomerRateTypeID = 0;
                    if (v.CustomerRateTypeID != null)
                    {
                        inscan.CustomerRateTypeID = v.CustomerRateTypeID;
                    }
                    inscan.Tax = 0;
                    if (v.Tax != null)
                    {
                        inscan.Tax = v.Tax;
                    }
                    if (v.Pieces != null)
                    {
                        inscan.Pieces = v.Pieces;
                    }
                    inscan.StatedWeight = 0;
                    if (v.Weight != null)
                    {
                        inscan.StatedWeight = v.Weight;
                    }
                    inscan.CourierDescriptionID = 0;
                    if (v.CourierType != null)
                    {
                        inscan.CourierDescriptionID = v.CourierType;
                    }

                    inscan.CourierServiceID = 0;
                    if (v.ProductType != null)
                    {
                        inscan.CourierServiceID = v.ProductType;
                    }


                    if (v.Agent != null)
                    {
                        inscan.IAgentID        = 0;
                        inscan.PickupCharges   = 0;
                        inscan.CollectedAmount = 0;
                        inscan.PickupCharges   = 0;
                        inscan.CollectedBy     = 0;
                        inscan.ReceivedBy      = 0;
                        if (v.Agent != null)
                        {
                            inscan.IAgentID = Convert.ToInt32(v.Agent);
                            if (v.collectedamt != null)
                            {
                                inscan.CollectedAmount = Convert.ToDecimal(v.collectedamt);
                            }
                            if (v.pickupcharge != null)
                            {
                                inscan.PickupCharges = Convert.ToDecimal(v.pickupcharge);
                            }
                        }
                    }
                    else
                    {
                        if (v.CollectedByDetails != null)
                        {
                            inscan.CollectedBy = v.CollectedByDetails;
                        }
                    }

                    inscan.ReceivedBy = 0;
                    if (v.ReceivedBy != null)
                    {
                        inscan.ReceivedBy = v.ReceivedBy;
                    }
                    inscan.CourierCharge = 0;
                    if (v.CourierCharges != null)
                    {
                        inscan.CourierCharge = v.CourierCharges;
                    }
                    inscan.OtherCharge = 0;
                    if (v.OtherCharges != null)
                    {
                        inscan.OtherCharge = v.OtherCharges;
                    }
                    inscan.ServiceCharge = 0;
                    if (v.ServiceCharges != null)
                    {
                        inscan.ServiceCharge = v.ServiceCharges;
                    }
                    inscan.PackingCharge = 0;
                    if (v.PackingCharges != null)
                    {
                        inscan.PackingCharge = v.PackingCharges;
                    }

                    if (v.paymentmode != null)
                    {
                        inscan.StatusPaymentMode = v.paymentmode;
                    }

                    inscan.OriginID = 0;
                    if (v.origincountry != null)
                    {
                        inscan.OriginID = v.origincountry;
                    }
                    if (v.destinationCountry != null)
                    {
                        inscan.DestinationID = v.destinationCountry.ToString();
                    }
                    inscan.ConsignorCityID = 0;
                    if (v.origincity != null)
                    {
                        inscan.ConsignorCityID = v.origincity;
                    }
                    inscan.ConsigneeCityID = 0;
                    if (v.destinationCity != null)
                    {
                        inscan.ConsigneeCityID = v.destinationCity;
                    }
                    if (v.CourierMode != null && v.CourierType != null)
                    {
                        inscan.TaxconfigurationID = (from tc1 in db.TaxConfigurations
                                                     where tc1.EffectFromDate <= DateTime.UtcNow && tc1.CourierMoveMentID == Convert.ToInt32(v.CourierMode) && tc1.ParcelTypeId == v.CourierType
                                                     select tc1.TaxConfigurationID).FirstOrDefault();
                    }
                    inscan.CustomerID = 0;
                    if (v.CustomerID != null)
                    {
                        inscan.CustomerID = v.CustomerID;
                    }

                    inscan.Consignee        = v.consignee;
                    inscan.Consignor        = v.shipper;
                    inscan.ConsigneeAddress = v.Consigneeaddress;
                    inscan.ConsignorAddress = v.shipperaddress;
                    if (v.ConsigneePhone != null)
                    {
                        inscan.ConsigneePhone = v.ConsigneePhone;
                    }
                    if (v.shipperphone != null)
                    {
                        inscan.ConsignorPhone = v.shipperphone;
                    }

                    inscan.ConsigneeCountryID = 0;
                    if (v.destinationCountry != null)
                    {
                        inscan.ConsigneeCountryID = v.destinationCountry;
                    }
                    inscan.ConsignorCountryID = 0;
                    if (v.origincountry != null)
                    {
                        inscan.ConsignorCountryID = v.origincountry;
                    }
                    if (v.originlocation != null)
                    {
                        inscan.ConsignorLocation = v.originlocation;
                    }
                    if (v.destinationLocation != null)
                    {
                        inscan.ConsigneeLocation = v.destinationLocation;
                    }

                    inscan.AcTaxJournalID = 0;
                    inscan.BalanceAmt     = 0;
                    if (v.TotalCharges != null)
                    {
                        inscan.BalanceAmt = v.TotalCharges;
                    }

                    inscan.TypeOfGoodID = 0;
                    if (v.InvoiceValue != null)
                    {
                        inscan.InvoiceValue = v.InvoiceValue;
                    }

                    inscan.MaterialCost = 0;
                    if (v.MaterialCost != null)
                    {
                        inscan.MaterialCost = v.MaterialCost;
                    }

                    inscan.ReferenceAWBNo      = v.ReferenceNumber;
                    inscan.MaterialDescription = v.MaterialDescription;
                    if (v.RevisedRate != null)
                    {
                        inscan.RevisedRate = v.RevisedRate;
                    }
                    if (v.SpecialInstructions != null)
                    {
                        inscan.SpecialInstructions = v.SpecialInstructions;
                    }
                    inscan.ConsigneeAddress1   = "";
                    inscan.ConsigneeAddress2   = "";
                    inscan.ConsignorAddress1   = "";
                    inscan.ConsignorAddress2   = "";
                    inscan.ConsigneeContact    = v.consigneecontact;
                    inscan.ConsignorContact    = v.consigneecontact;
                    inscan.CargoDescription    = v.CargoDescription;
                    inscan.HandlingInstruction = v.HandlingInstructions;

                    inscan.CustomsCollectedBy = 0;
                    if (v.ReceivedBy != null)
                    {
                        inscan.CustomsCollectedBy = v.ReceivedBy;
                    }
                    db.InScans.Add(inscan);
                    db.SaveChanges();


                    InScanInternationalDeatil isid = new InScanInternationalDeatil();


                    isid.InScanID = 0;
                    ////InScanInternationalDeatilID = Common.GetMaxNumber("InScanInternationalDeatilID", "InScanInternationalDeatils"),
                    isid.InScanID = inscan.InScanID;
                    ////InscanInternationalID = isi.InScanInternationalID,

                    isid.VerifiedWeight = 0;
                    if (v.VerifiedWeight != null)
                    {
                        isid.VerifiedWeight = Convert.ToDecimal(v.VerifiedWeight);
                    }
                    //if (txtForwardingCharge.Text != string.Empty)
                    //{
                    //    isid.ForwardingCharge = Convert.ToDecimal(txtForwardingCharge.Value);
                    //}

                    ////context.InScanInternationalDeatils.InsertOnSubmit(isid);


                    InScanInternational isi = new InScanInternational();

                    ////InScanInternationalID = Common.GetMaxNumber("InScanInternationalID", "InScanInternational"),
                    ////FAgentID = -1,

                    isi.FAgentID = 0;
                    if (v.ForwardingAgentID != null)
                    {
                        isi.FAgentID = v.ForwardingAgentID;
                    }
                    else
                    {
                        isi.FAgentID = 0;
                    }

                    if (v.ForwardingDate != null)
                    {
                        isi.ForwardingDate = v.ForwardingDate.Value;
                    }

                    isi.VerifiedWeight = 0;
                    if (v.VerifiedWeight != null)
                    {
                        isi.VerifiedWeight = v.VerifiedWeight;
                    }
                    //if (txtForwardingCharge.Text != string.Empty)
                    //{
                    //    isi.ForwardingCharge = Convert.ToDecimal(txtForwardingCharge.Value);
                    //}
                    isi.StatusAssignment       = false;
                    isi.ForwardingAWBNo        = v.ForwardingAWB;
                    isid.InscanInternationalID = isi.InScanInternationalID;
                    isi.InScanID = inscan.InScanID;
                    if (v.ForwardingAgentID != null)
                    {
                        isi.FAgentID = v.ForwardingAgentID;
                    }
                    if (v.ForwardingDate != null)
                    {
                        isi.ForwardingDate = v.ForwardingDate.Value;
                    }
                    db.InScanInternationals.Add(isi);
                    db.SaveChanges();

                    db.InScanInternationalDeatils.Add(isid);
                    db.SaveChanges();


                    int max = (from c in db.AWBStatus orderby c.AWBStatusID descending select c.AWBStatusID).FirstOrDefault();
                    if (max == null)
                    {
                        max = 1;
                    }
                    else
                    {
                        max = max + 1;
                    }

                    AWBStatu astat = new AWBStatu()
                    {
                        AWBStatusID         = max,
                        StatusDescriptionID = inscan.InScanID,
                        AWBNO  = AWBNo,
                        Date   = inscan.InScanDate,
                        Status = "DetailsUpdated",
                        FormID = "IN",
                    };

                    db.AWBStatus.Add(astat);
                    db.SaveChanges();
                }
                catch (Exception e)
                {
                }
            }
            catch (Exception ex)
            {
            }

            return(RedirectToAction("Index"));
        }