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