public ActionResult SalesAuditAdjustment(string customerCode) { ViewBag.CustomerType = salesDal.ReadCustomerTypes(); //ViewBag.PackageCapacity = salesDal.ReadCapacityByProjectCode("100200", Helper.IsCapacityOnlyForPackagesAndItems); //ViewBag.PackageLight = salesDal.ReadLightByCapacityId("0020WP"); //ViewBag.Package = salesDal.ReadPackages("0020WP", "02LIGHT", Helper.NewSalesAgreement); //ViewBag.ModeOfPayment = salesDal.ReadModeOfPayment("SHS001", "SHS010", "HOUHLD"); changes for salesresalesagreement page for ddlPackage change ViewBag.ModeOfPayment = salesDal.ReadModeOfPayment("", "SHS001", "SHS010", "HOUHLD", ""); //ViewBag.PanelModel = salesDal.ReadItemModelByCategoryId("PANEL1"); //ViewBag.PanelStructureModel = salesDal.ReadItemModelByCategoryId("PNLSR1"); //ViewBag.BatteryModel = salesDal.ReadItemModelByCategoryId("BAT001"); //ViewBag.HolderModel = salesDal.ReadItemModelByCategoryId("HOL001"); CustomerNAgreementNItemDetails objCustomerNAgreementNItemDetails = new CustomerNAgreementNItemDetails(); objCustomerNAgreementNItemDetails = salesDal.ReadCustomerNAgreementItemDetails(customerCode, "100200"); Session["SalesAdjustmentPreviousData"] = objCustomerNAgreementNItemDetails; return(PartialView("AuditAdjustmentForSalesAgreement", objCustomerNAgreementNItemDetails)); }
public JsonResult SalesAgreementAuditAdjustmentSave(Aud_AuditAdjustmentObservationOnSalesAgreement objAuditAdjustmentObservationOnSalesAgreement) { string auditSequenceNumber = string.Empty, saveMessage = string.Empty; try { objLoginHelper = (LoginHelper)Session["LogInInformation"]; auditSequenceNumber = hraDal.ReadAuditSeqNumberAfterCheckFinishedDate(objLoginHelper.LocationCode); objAuditAdjustmentObservationOnSalesAgreement.LocationCode = objLoginHelper.LocationCode; objAuditAdjustmentObservationOnSalesAgreement.YearMonth = Helper.ConvertDateToYearMonth(objLoginHelper.MonthOpenForSales); objAuditAdjustmentObservationOnSalesAgreement.DataStatusFlag = "1RC"; objAuditAdjustmentObservationOnSalesAgreement.AuditSeqNo = auditSequenceNumber; if (!string.IsNullOrEmpty(objAuditAdjustmentObservationOnSalesAgreement.RefMemoNo)) { objAuditAdjustmentObservationOnSalesAgreement.RefMemoNo = objAuditAdjustmentObservationOnSalesAgreement.RefMemoNo; string firstCharacterOfCashMemo = objAuditAdjustmentObservationOnSalesAgreement.RefMemoNo.Trim().Substring(0, 1); if (firstCharacterOfCashMemo.ToUpper() == "A") { objAuditAdjustmentObservationOnSalesAgreement.CashMemoNo = objAuditAdjustmentObservationOnSalesAgreement.RefMemoNo; objAuditAdjustmentObservationOnSalesAgreement.CashMemoUsesID = Helper.CashMemuUsesIdFirst; objAuditAdjustmentObservationOnSalesAgreement.RefMemoNo = null; } } Aud_AuditAdjustmentObservationOnSalesAgreement objPreviousDataAuditAdjustmentObservationOnSalesAgreement = new Aud_AuditAdjustmentObservationOnSalesAgreement(); CustomerNAgreementNItemDetails objCustomerNAgreementNItemDetails = new CustomerNAgreementNItemDetails(); objCustomerNAgreementNItemDetails = (CustomerNAgreementNItemDetails)Session["SalesAdjustmentPreviousData"]; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.LocationCode = objLoginHelper.LocationCode; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.YearMonth = Helper.ConvertDateToYearMonth(objLoginHelper.MonthOpenForSales); objPreviousDataAuditAdjustmentObservationOnSalesAgreement.CustomerCode = objCustomerNAgreementNItemDetails.CustomerCode; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.DataStatusFlag = "0BC"; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.AuditSeqNo = auditSequenceNumber; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.CustomerName = objCustomerNAgreementNItemDetails.CustomerName; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.IsReSales = objCustomerNAgreementNItemDetails.IsResales; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.AgreementDate = Convert.ToDateTime(objCustomerNAgreementNItemDetails.AgreementDate); objPreviousDataAuditAdjustmentObservationOnSalesAgreement.CustomerType = objCustomerNAgreementNItemDetails.CustomerType; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.PackageCapacity = objCustomerNAgreementNItemDetails.Capacity; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.PackageLight = objCustomerNAgreementNItemDetails.Light; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.PackageCode = objCustomerNAgreementNItemDetails.PackageCode; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.StoreLocationForPanel = objCustomerNAgreementNItemDetails.StoreLocationForPanel; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.PanelItemCode = objCustomerNAgreementNItemDetails.PanelItemCode; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.PanelSerialNo = objCustomerNAgreementNItemDetails.PanelSerialNo; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.StoreLocationForBattery = objCustomerNAgreementNItemDetails.StoreLocationForBattery; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.BatteryItemCode = objCustomerNAgreementNItemDetails.BatteryItemCode; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.BatterySerialNo = objCustomerNAgreementNItemDetails.BatterySerialNo; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.ModeOfPaymentID = objCustomerNAgreementNItemDetails.ModeOfPaymentID; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.DownPaymentID = objCustomerNAgreementNItemDetails.DownPaymentID; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.DownPaymentAmount = Convert.ToDecimal(objCustomerNAgreementNItemDetails.DownPaymentAmount); objPreviousDataAuditAdjustmentObservationOnSalesAgreement.ServiceChargeID = objCustomerNAgreementNItemDetails.ServiceChargeID; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.STDServiceChargePercentage = objCustomerNAgreementNItemDetails.STDServiceChargePercentage; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.RefMemoNo = objCustomerNAgreementNItemDetails.RefMemoNo; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.CashMemoNo = objCustomerNAgreementNItemDetails.CashMemoNo; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.CashMemoUsesID = objCustomerNAgreementNItemDetails.CashMemoUsesID; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.PackagePrice = Convert.ToDecimal(objCustomerNAgreementNItemDetails.PackagePrice); objPreviousDataAuditAdjustmentObservationOnSalesAgreement.PanelStructureItemCode = objCustomerNAgreementNItemDetails.PanelStructureItemCode; objPreviousDataAuditAdjustmentObservationOnSalesAgreement.HolderItemCode = objCustomerNAgreementNItemDetails.HolderItemCode; if (salesDal.IsAuditAdjustmentObservationOnSalesAgreementExistOrNot(objAuditAdjustmentObservationOnSalesAgreement.LocationCode, objAuditAdjustmentObservationOnSalesAgreement.CustomerCode) == false) { salesDal.Create(objAuditAdjustmentObservationOnSalesAgreement, objPreviousDataAuditAdjustmentObservationOnSalesAgreement); } else { // salesDal.Update(objAuditAdjustmentObservationOnSalesAgreement); saveMessage = "Multiple edit for a customer is not allowed."; } Session.Remove("SalesAdjustmentPreviousData"); return(new JsonResult { Data = ExceptionHelper.ExceptionMessage(saveMessage) }); } catch (Exception ex) { return(new JsonResult { Data = ExceptionHelper.ExceptionMessage(ex) }); } }