private tblConsignmentNoteDTO FillDropDown(tblConsignmentNoteDTO tblConsignmentNoteDTO) { var partyList = ConsignorBusinessLogic.GetAll(); foreach (var item in partyList) { item.PartyNameWithCode = item.Code + "-" + item.ConsignorName; } tblConsignmentNoteDTO.ConsigneeList = partyList.Where(type => type.Type == 1).ToList(); tblConsignmentNoteDTO.ConsignorList = partyList.Where(type => type.Type == 2).ToList(); //------------------- tblConsignmentNoteDTO.ServiceTaxisPayableByList = new List <SelectListItem>(); tblConsignmentNoteDTO.ServiceTaxisPayableByList.Add(new SelectListItem { Value = "CONSIGNOR", Text = "CONSIGNOR" }); tblConsignmentNoteDTO.ServiceTaxisPayableByList.Add(new SelectListItem { Value = "CONSIGNEE", Text = "CONSIGNEE" }); tblConsignmentNoteDTO.ServiceTaxisPayableByList.Add(new SelectListItem { Value = "Transport", Text = "Transport" }); return(tblConsignmentNoteDTO); }
public ActionResult Save(int id) { tblConsignmentNoteDTO tblConsignmentNoteDTO; if (id == 0) { tblConsignmentNoteDTO = new tblConsignmentNoteDTO(); } else { tblConsignmentNoteDTO = ConsignmentNoteBusinessLogic.Get(id); } tblConsignmentNoteDTO = FillDropDown(tblConsignmentNoteDTO); return(View(tblConsignmentNoteDTO)); }
public ActionResult Save(tblConsignmentNoteDTO tblConsignmentNoteDTO) { if (ModelState.IsValid) { var resultCheckDuplicateConsignmentNoteNo = ConsignmentNoteBusinessLogic.CheckDuplicateConsignmentNoteNo(tblConsignmentNoteDTO.ConsignmentId, tblConsignmentNoteDTO.ConsignmentNoteNo ?? 0); if (resultCheckDuplicateConsignmentNoteNo) { ModelState.AddModelError("ConsignmentNoteNo", "Consignment Note No already exists."); } else { tblConsignmentNoteDTO.FinalAmount = (tblConsignmentNoteDTO.Amount1 + tblConsignmentNoteDTO.Amount2 + tblConsignmentNoteDTO.Amount3 + tblConsignmentNoteDTO.Amount4 + tblConsignmentNoteDTO.Amount5); var result = ConsignmentNoteBusinessLogic.Save(tblConsignmentNoteDTO); return(RedirectToAction("Index")); } } tblConsignmentNoteDTO = FillDropDown(tblConsignmentNoteDTO); return(View(tblConsignmentNoteDTO)); }
public static int Save(tblConsignmentNoteDTO tblConsignmentNoteDTO) { return(ConsignmentNoteRepository.Save(tblConsignmentNoteDTO)); }
private void btnSave_Click(object sender, EventArgs e) { if (ValidateData()) { if (txtAmount1.Text.Trim() == "") { txtAmount1.Text = "0"; } if (txtAmount2.Text.Trim() == "") { txtAmount2.Text = "0"; } if (txtAmount3.Text.Trim() == "") { txtAmount3.Text = "0"; } if (txtAmount4.Text.Trim() == "") { txtAmount4.Text = "0"; } if (txtAmount5.Text.Trim() == "") { txtAmount5.Text = "0"; } tblConsignmentNoteDTO consignNoteDTO = new tblConsignmentNoteDTO(); consignNoteDTO.CompanyName = txtCompanyName.Text; consignNoteDTO.PolicyNo = txtPolicyNo.Text; consignNoteDTO.CompanyDate = Convert.ToDateTime(dpCompanyDate.Value); consignNoteDTO.CompanyAmount = txtCompanyAmount.Text.Trim() == "" ? 0 : Convert.ToDouble(txtCompanyAmount.Text); consignNoteDTO.ConsigneeId = Convert.ToInt32(cmbConsineeName.SelectedValue); consignNoteDTO.ConsigneeInvoiceNo = txtInvoiceNo.Text; consignNoteDTO.ConsigneeServiceTaxRegNo = txtConsigneeServiceTaxRegNo.Text; consignNoteDTO.ConsignorId = Convert.ToInt32(cmbConsignorName.SelectedValue); consignNoteDTO.ConsignorPurchaseOrderNo = txtPurchaseOrderNo.Text; consignNoteDTO.ConsignorServiceTaxRegNo = txtConsignorServiceTaxRegNo.Text; consignNoteDTO.PanNo = txtPanNo.Text; consignNoteDTO.CentralisedServiceTaxRegnNo = txtCentralisedServiceTaxRegNo.Text; consignNoteDTO.FromCode = txtFromCodeName.Text; consignNoteDTO.ConsignmentNoteNo = txtConsignmentNoteNo.Text.Trim() == "" ? 0 : Convert.ToInt32(txtConsignmentNoteNo.Text); consignNoteDTO.ConsignmentDate = Convert.ToDateTime(dpConsignmentDate.Value); consignNoteDTO.AddressofIssuing = txtAddressOfIssueOffice.Text; consignNoteDTO.ToCode = txtToCodeName.Text; consignNoteDTO.CompanyPhone = txtCompanyPhoneNo.Text; consignNoteDTO.NoofPackages = txtNoOfPackages.Text; consignNoteDTO.MethodOfPacking = txtMethodOfPacking.Text; consignNoteDTO.ActualWtInKGS = txtActualWeightInKg.Text; consignNoteDTO.CategoryOfLoad = txtChargeWeightInKg.Text; consignNoteDTO.Rate = txtRate.Text; consignNoteDTO.Charges1 = txtCharges1.Text; consignNoteDTO.Amount1 = double.Parse(txtAmount1.Text); consignNoteDTO.LoadType = txtLoadType.Text; consignNoteDTO.Distance = txtDistance.Text; consignNoteDTO.KMS = txtKms.Text; consignNoteDTO.Charges1 = txtCharges1.Text; consignNoteDTO.Charges2 = txtCharges2.Text; consignNoteDTO.Amount2 = double.Parse(txtAmount2.Text); consignNoteDTO.Charges3 = txtCharges3.Text; consignNoteDTO.Charges4 = txtCharges4.Text; consignNoteDTO.AdvancedPaymentDate = Convert.ToDateTime(dpAdvancePaymentDate.Value); consignNoteDTO.Charges5 = txtCharges5.Text; consignNoteDTO.Amount3 = txtAmount3.Text.Trim() == "" ? 0 : Convert.ToDouble(txtAmount3.Text); consignNoteDTO.Amount4 = txtAmount4.Text.Trim() == "" ? 0 : Convert.ToDouble(txtAmount4.Text); consignNoteDTO.Amount5 = txtAmount5.Text.Trim() == "" ? 0 : Convert.ToDouble(txtAmount5.Text); txtFinalAmount.Text = (Convert.ToDouble(txtAmount1.Text) + Convert.ToDouble(txtAmount2.Text) + Convert.ToDouble(txtAmount3.Text) + Convert.ToDouble(txtAmount4.Text) + Convert.ToDouble(txtAmount5.Text)).ToString(); consignNoteDTO.FinalAmount = Convert.ToDouble(txtFinalAmount.Text); consignNoteDTO.PrivateMarketOtherIdentificaion = txtPrivateMarks.Text; consignNoteDTO.AdvancedPaymentAmount = txtAdvancePaymentAmount.Text; consignNoteDTO.BusinessType = txtBusinessType.Text; consignNoteDTO.DeclarationNo = txtDeclaredValueGoods.Text; consignNoteDTO.DimensionLength = txtLength.Text; consignNoteDTO.DimensionWidth = txtWidth.Text; consignNoteDTO.DimensionHeight = txtHeight.Text; consignNoteDTO.DimensionNoOfPKGS = txtDiamentionNoOfPkgs.Text; consignNoteDTO.DimensionTotalCFTCMT = txtTotalCFT.Text; consignNoteDTO.DimensionSinglePieceWeight = txtSinglePiece.Text; consignNoteDTO.ValidType = txtValidType.Text; consignNoteDTO.DeclaredValueOfGoods = txtDeclaredValueGoods.Text; consignNoteDTO.ServicetaxThrough = txtServiceTaxThrough.Text; consignNoteDTO.BasicOfBooking = txtBasicOfBooking.Text; consignNoteDTO.BilledWithMs = txtBilledWith.Text; consignNoteDTO.BranchCode = txtBranchCode.Text; consignNoteDTO.PartyCode = txtPartyCode.Text; consignNoteDTO.ToPay = txtToPay.Text; consignNoteDTO.Rebooking = txtRebooking.Text; consignNoteDTO.MainConsignmentNo = txtMainConsignment.Text; consignNoteDTO.ServiceTaxisPayableBy = (cmbServiceTaxisPaybleBy.SelectedItem).ToString(); consignNoteDTO.ConsignmentId = Consignmentid; var resultCheckDuplicateConsignmentNoteNo = ConsignmentNoteBusinessLogic.CheckDuplicateConsignmentNoteNo(Consignmentid, Convert.ToInt32(txtConsignmentNoteNo.Text)); if (resultCheckDuplicateConsignmentNoteNo) { MessageBox.Show("Consignment Number already exists."); txtConsignmentNoteNo.Focus(); } else { var result = ConsignmentNoteBusinessLogic.Save(consignNoteDTO); if (result > 0) { MessageBox.Show("LR Note Successfully Generate"); if (Consignmentid > 0) { this.Close(); } else { clearData(); } } } } }
public static int Save(tblConsignmentNoteDTO tblConsignmentNoteDTO) { using (var dbObject = new BRCTransportDBEntities()) { var tblConsignmentNoteObject = tblConsignmentNoteDTO.ToEntity(); if (tblConsignmentNoteDTO.ConsignmentId == 0) { dbObject.tblConsignmentNotes.Add(tblConsignmentNoteObject); } else { tblConsignmentNoteObject = dbObject.tblConsignmentNotes.Find(tblConsignmentNoteDTO.ConsignmentId); tblConsignmentNoteObject.ConsignmentNoteNo = tblConsignmentNoteDTO.ConsignmentNoteNo; tblConsignmentNoteObject.CompanyName = tblConsignmentNoteDTO.CompanyName; tblConsignmentNoteObject.PolicyNo = tblConsignmentNoteDTO.PolicyNo; tblConsignmentNoteObject.CompanyDate = tblConsignmentNoteDTO.CompanyDate; tblConsignmentNoteObject.CompanyAmount = tblConsignmentNoteDTO.CompanyAmount; tblConsignmentNoteObject.CompanyPhone = tblConsignmentNoteDTO.CompanyPhone; tblConsignmentNoteObject.ConsigneeId = tblConsignmentNoteDTO.ConsigneeId; tblConsignmentNoteObject.ConsignorId = tblConsignmentNoteDTO.ConsignorId; tblConsignmentNoteObject.ConsigneeInvoiceNo = tblConsignmentNoteDTO.ConsigneeInvoiceNo; tblConsignmentNoteObject.ConsigneeServiceTaxRegNo = tblConsignmentNoteDTO.ConsigneeServiceTaxRegNo; tblConsignmentNoteObject.ConsignorPurchaseOrderNo = tblConsignmentNoteDTO.ConsignorPurchaseOrderNo; tblConsignmentNoteObject.ConsignorServiceTaxRegNo = tblConsignmentNoteDTO.ConsignorServiceTaxRegNo; tblConsignmentNoteObject.FromCode = tblConsignmentNoteDTO.FromCode; tblConsignmentNoteObject.ToCode = tblConsignmentNoteDTO.ToCode; tblConsignmentNoteObject.NoofPackages = tblConsignmentNoteDTO.NoofPackages; tblConsignmentNoteObject.MethodOfPacking = tblConsignmentNoteDTO.MethodOfPacking; tblConsignmentNoteObject.ActualWtInKGS = tblConsignmentNoteDTO.ActualWtInKGS; tblConsignmentNoteObject.CategoryOfLoad = tblConsignmentNoteDTO.CategoryOfLoad; tblConsignmentNoteObject.Rate = tblConsignmentNoteDTO.Rate; tblConsignmentNoteObject.LoadType = tblConsignmentNoteDTO.LoadType; tblConsignmentNoteObject.Distance = tblConsignmentNoteDTO.Distance; tblConsignmentNoteObject.KMS = tblConsignmentNoteDTO.KMS; tblConsignmentNoteObject.DescriptionSaidToContain = tblConsignmentNoteDTO.DescriptionSaidToContain; tblConsignmentNoteObject.PrivateMarketOtherIdentificaion = tblConsignmentNoteDTO.PrivateMarketOtherIdentificaion; tblConsignmentNoteObject.BusinessType = tblConsignmentNoteDTO.BusinessType; tblConsignmentNoteObject.AdvancedPaymentMRNo = tblConsignmentNoteDTO.AdvancedPaymentMRNo; tblConsignmentNoteObject.AdvancedPaymentDate = tblConsignmentNoteDTO.AdvancedPaymentDate; tblConsignmentNoteObject.AdvancedPaymentAmount = tblConsignmentNoteDTO.AdvancedPaymentAmount; tblConsignmentNoteObject.DimensionLength = tblConsignmentNoteDTO.DimensionLength; tblConsignmentNoteObject.DimensionWidth = tblConsignmentNoteDTO.DimensionWidth; tblConsignmentNoteObject.DimensionHeight = tblConsignmentNoteDTO.DimensionHeight; tblConsignmentNoteObject.DimensionNoOfPKGS = tblConsignmentNoteDTO.DimensionNoOfPKGS; tblConsignmentNoteObject.DimensionTotalCFTCMT = tblConsignmentNoteDTO.DimensionTotalCFTCMT; tblConsignmentNoteObject.DimensionSinglePieceWeight = tblConsignmentNoteDTO.DimensionSinglePieceWeight; tblConsignmentNoteObject.DeclarationNo = tblConsignmentNoteDTO.DeclarationNo; tblConsignmentNoteObject.ValidUpto = tblConsignmentNoteDTO.ValidUpto; tblConsignmentNoteObject.DeclaredValueOfGoods = tblConsignmentNoteDTO.DeclaredValueOfGoods; tblConsignmentNoteObject.BasicOfBooking = tblConsignmentNoteDTO.BasicOfBooking; tblConsignmentNoteObject.BilledWithMs = tblConsignmentNoteDTO.BilledWithMs; tblConsignmentNoteObject.BranchCode = tblConsignmentNoteDTO.BranchCode; tblConsignmentNoteObject.ToPay = tblConsignmentNoteDTO.ToPay; tblConsignmentNoteObject.Rebooking = tblConsignmentNoteDTO.Rebooking; tblConsignmentNoteObject.MainConsignmentNo = tblConsignmentNoteDTO.MainConsignmentNo; tblConsignmentNoteObject.GoodRecievedDetails = tblConsignmentNoteDTO.GoodRecievedDetails; tblConsignmentNoteObject.Charges1 = tblConsignmentNoteDTO.Charges1; tblConsignmentNoteObject.Amount1 = tblConsignmentNoteDTO.Amount1; tblConsignmentNoteObject.Charges2 = tblConsignmentNoteDTO.Charges2; tblConsignmentNoteObject.Amount2 = tblConsignmentNoteDTO.Amount2; tblConsignmentNoteObject.Charges3 = tblConsignmentNoteDTO.Charges3; tblConsignmentNoteObject.Amount3 = tblConsignmentNoteDTO.Amount3; tblConsignmentNoteObject.Charges4 = tblConsignmentNoteDTO.Charges4; tblConsignmentNoteObject.Amount4 = tblConsignmentNoteDTO.Amount4; tblConsignmentNoteObject.Charges5 = tblConsignmentNoteDTO.Charges5; tblConsignmentNoteObject.Amount5 = tblConsignmentNoteDTO.Amount5; tblConsignmentNoteObject.FinalAmount = tblConsignmentNoteDTO.FinalAmount; tblConsignmentNoteObject.ServiceTaxisPayableBy = tblConsignmentNoteDTO.ServiceTaxisPayableBy; tblConsignmentNoteObject.FinalAmount = tblConsignmentNoteDTO.FinalAmount; tblConsignmentNoteObject.PanNo = tblConsignmentNoteDTO.PanNo; tblConsignmentNoteObject.PartyCode = tblConsignmentNoteDTO.PartyCode; tblConsignmentNoteObject.ServicetaxThrough = tblConsignmentNoteDTO.ServicetaxThrough; tblConsignmentNoteObject.ValidType = tblConsignmentNoteDTO.ValidType; tblConsignmentNoteObject.PhoneNo = tblConsignmentNoteDTO.PhoneNo; tblConsignmentNoteObject.AddressofIssuing = tblConsignmentNoteDTO.AddressofIssuing; tblConsignmentNoteObject.ConsignmentDate = tblConsignmentNoteDTO.ConsignmentDate; tblConsignmentNoteObject.CentralisedServiceTaxRegnNo = tblConsignmentNoteDTO.CentralisedServiceTaxRegnNo; } dbObject.SaveChanges(); return(tblConsignmentNoteObject.ConsignmentId); } }