public ActionResult SaveCustomerCollectionAdjustmentForUpdateNDelete(FormCollection fCollection) { try { objLoginHelper = (LoginHelper)Session["LogInInformation"]; byte entrySerialNo = Convert.ToByte(fCollection["hfCollectionSerialsForUpdateNDelete"]); string yearMonth = fCollection["hfCollectionYearMonthForUpdateNDelete"]; string yearMonth1 = fCollection["dtpCollectionDateForUpdateNDelete"].ToString(); Sal_CollectionFromCustomers objCollectionFromCustomers = new Sal_CollectionFromCustomers(); objCollectionFromCustomers = salesDal.ReadCollectionFromCustomers(fCollection["hfCustomerCodeForCollectionForUpdateNDelete"], yearMonth, Convert.ToByte(fCollection["hfCollectionSerialsForUpdateNDelete"])); objCollectionFromCustomers.CustomerCode = fCollection["hfCustomerCodeForCollectionForUpdateNDelete"]; objCollectionFromCustomers.YearMonth = yearMonth; //Helper.ConvertDateToYearMonth(Convert.ToDateTime(yearMonth1)); objCollectionFromCustomers.SerialNo = entrySerialNo; if (fCollection["hfCustomerCollectionTypeForUpdateNDelete"].Trim() == "Installment/Overdue Collection Amount") { objCollectionFromCustomers.CollectionType = Helper.CollectionTypeIOC; } else { objCollectionFromCustomers.CollectionType = Helper.CollectionTypeAAA; } objCollectionFromCustomers.CollectionAmount = Convert.ToDecimal(fCollection["txtCollectionAmountForUpdateNDelete"]); objCollectionFromCustomers.CollectionDate = Convert.ToDateTime(fCollection["dtpCollectionDateForUpdateNDelete"]); if (!string.IsNullOrEmpty(fCollection["txtMemoNumberForUpdateNDelete"])) { objCollectionFromCustomers.RefMemoNo = fCollection["txtMemoNumberForUpdateNDelete"]; string firstCharacterOfCashMemo = objCollectionFromCustomers.RefMemoNo.Trim().Substring(0, 1); if (firstCharacterOfCashMemo.ToUpper() == "A") { objCollectionFromCustomers.CashMemoNo = objCollectionFromCustomers.RefMemoNo; objCollectionFromCustomers.CashMemoUsesID = Helper.CashMemuUsesIdFirst; objCollectionFromCustomers.RefMemoNo = null; } } else { objCollectionFromCustomers.CashMemoNo = ""; objCollectionFromCustomers.CashMemoUsesID = Helper.CashMemuUsesIdFirst; objCollectionFromCustomers.RefMemoNo = null; } objCollectionFromCustomers.CollectedByEmployee = null; objCollectionFromCustomers.RefAELocationCode = objLoginHelper.LocationCode; objCollectionFromCustomers.UserID = objLoginHelper.LogInID; objCollectionFromCustomers.EntryTime = DateTime.Now; salesDal.CustomerCollectionSaveForUpdateOrDelete(fCollection["hfUpdateNDeleteOptions"], objCollectionFromCustomers); return(new JsonResult { Data = ExceptionHelper.ExceptionMessage(string.Empty) }); } catch (Exception ex) { return(new JsonResult { Data = ExceptionHelper.ExceptionMessage(ex) }); } }
//public ActionResult SalesAuditAdjsutment() //{ // objLoginHelper = (LoginHelper)Session["LogInInformation"]; // PageAccessRightHelper objPageAccessRightHelper = new PageAccessRightHelper(); // objPageAccessRightHelper = securityDal.ReadPageAccessRight(Helper.ForSales, "SalesAuditAdjsutment", objLoginHelper.UerRoleOrGroupID, Helper.Inactive); // if (objPageAccessRightHelper != null) // { // if (objPageAccessRightHelper.AccessStatus == Helper.Inactive) // { // Session["messageInformation"] = objPageAccessRightHelper.MessageToShow; // return RedirectToAction("ErrorMessage", "../ErrorHnadle"); // } // } // ViewBag.CustomerStatus = salesDal.CustomerStatus(); // TempData["selectValue"] = "0"; // Aud_AuditingMaster objAuditMaster = new Aud_AuditingMaster(); // objAuditMaster = salesDal.AuditingMasterByLocationCode(objLoginHelper.LogInForUnitCode); // if (objAuditMaster != null) // { // ViewBag.AuditStartDate = objAuditMaster.AuditStartDate != null ? Helper.DateFormat(Convert.ToDateTime(objAuditMaster.AuditStartDate)) : Helper.DateFormat(DateTime.Now); // ViewBag.AuditFinishedDate = objAuditMaster.AuditFinishDate != null ? Helper.DateFormat(Convert.ToDateTime(objAuditMaster.AuditFinishDate)) : ""; // ViewBag.AuditCode = objAuditMaster.AuditSeqNo; // } // else // { // ViewBag.AuditStartDate = ""; // ViewBag.AuditFinishedDate = ""; // ViewBag.AuditCode = ""; // } // if (string.IsNullOrEmpty(Request.Params["grvSalesAdjustment-page"])) // { // Session.Remove("CustomerType"); // } // if (Session["CustomerType"] != null) // { // string ctype = Session["CustomerType"].ToString(); // byte customerType = Convert.ToByte(ctype); // TempData["CStatus"] = salesDal.ReadCustomerListWithRecoveryStatus(objLoginHelper.LogInForUnitCode, Convert.ToByte(ctype), Helper.DateTo(objLoginHelper.AuditorYearMonth)); // List<Aud_AdjustmentReasonCodes> salesAuditReasons = new List<Aud_AdjustmentReasonCodes>(); // //salesAuditReasons = salesDal.SalesAuditResonCodes(); // TempData["SalesAuditReason"] = salesAuditReasons; // TempData["selectValue"] = ctype; // if (customerType == Helper.FullPaiedCustomer || customerType == Helper.CashSalesCustomer || customerType == Helper.SystemReturnCustomer) // { // TempData["DisplayOrNot"] = true; // } // else // { // TempData["DisplayOrNot"] = false; // } // string recoveredUpToWithoutDP = ""; // recoveredUpToWithoutDP = "Recovered Up to " + Helper.DateTo(objLoginHelper.AuditorYearMonth).ToString("dd-MMM-yy") + " Without DP"; // TempData["recoveredUpToWithoutDP"] = recoveredUpToWithoutDP; // } // ViewBag.LocationTitle = objLoginHelper.LocationTitle; // ViewBag.Location = objLoginHelper.Location; // ViewBag.ZoneTitle = objLoginHelper.ZoneTitle; // ViewBag.ZoneName = objLoginHelper.LogInForZoneName; // ViewBag.RegionTitle = objLoginHelper.RegionTitle; // ViewBag.RegionName = objLoginHelper.LogInForRegionName; // ViewBag.UnitTitle = objLoginHelper.UnitTitle; // ViewBag.UnitName = objLoginHelper.LogInForUnitName; // ViewBag.OpenMonthYear = "Month: " + objLoginHelper.MonthOpenForSales.ToString("MMMM-yy"); // ViewBag.ModuleName = objLoginHelper.ModluleTitle; // ViewBag.TopMenu = objLoginHelper.TopMenu; // if (objLoginHelper.UerRoleOrGroupID == UserGroup.RegionManager) // { // ViewBag.ShowHideMenu = true; // } // else // ViewBag.ShowHideMenu = false; // return View(); //} //[HttpPost] //public ActionResult SalesAuditAdjsutment(FormCollection fCollection) //{ // objLoginHelper = (LoginHelper)Session["LogInInformation"]; // ViewBag.CustomerStatus = salesDal.CustomerStatus(); // TempData["selectValue"] = fCollection["ddlCustomerStatus"].ToString(); // TempData["CStatus"] = salesDal.ReadCustomerListWithRecoveryStatus(objLoginHelper.LogInForUnitCode, Convert.ToByte(fCollection["ddlCustomerStatus"].ToString()), Helper.DateTo(objLoginHelper.AuditorYearMonth)); // List<Aud_AdjustmentReasonCodes> salesAuditReasons = new List<Aud_AdjustmentReasonCodes>(); // // salesAuditReasons = salesDal.SalesAuditResonCodes(); // TempData["SalesAuditReason"] = salesAuditReasons; // Aud_AuditingMaster objAuditMaster = new Aud_AuditingMaster(); // objAuditMaster = salesDal.AuditingMasterByLocationCode(objLoginHelper.LogInForUnitCode); // if (objAuditMaster != null) // { // ViewBag.AuditStartDate = objAuditMaster.AuditStartDate != null ? Helper.DateFormat(Convert.ToDateTime(objAuditMaster.AuditStartDate)) : Helper.DateFormat(DateTime.Now); // ViewBag.AuditFinishedDate = objAuditMaster.AuditFinishDate != null ? Helper.DateFormat(Convert.ToDateTime(objAuditMaster.AuditFinishDate)) : ""; // ViewBag.AuditCode = objAuditMaster.AuditSeqNo; // } // ViewBag.LocationTitle = objLoginHelper.LocationTitle; // ViewBag.Location = objLoginHelper.Location; // ViewBag.ZoneTitle = objLoginHelper.ZoneTitle; // ViewBag.ZoneName = objLoginHelper.LogInForZoneName; // ViewBag.RegionTitle = objLoginHelper.RegionTitle; // ViewBag.RegionName = objLoginHelper.LogInForRegionName; // ViewBag.UnitTitle = objLoginHelper.UnitTitle; // ViewBag.UnitName = objLoginHelper.LogInForUnitName; // ViewBag.ModuleName = objLoginHelper.ModluleTitle; // ViewBag.TopMenu = objLoginHelper.TopMenu; // Session["CustomerType"] = fCollection["ddlCustomerStatus"].ToString(); // byte customerType = Convert.ToByte(fCollection["ddlCustomerStatus"]); // if (customerType == Helper.FullPaiedCustomer || customerType == Helper.CashSalesCustomer || customerType == Helper.SystemReturnCustomer) // { // TempData["DisplayOrNot"] = true; // } // else // { // TempData["DisplayOrNot"] = false; // } // if (objLoginHelper.UerRoleOrGroupID == UserGroup.RegionManager) // { // ViewBag.ShowHideMenu = true; // } // else // ViewBag.ShowHideMenu = false; // string recoveredUpToWithoutDP = ""; // recoveredUpToWithoutDP = "Recovered Up to " + Helper.DateTo(objLoginHelper.AuditorYearMonth).ToString("dd-MMM-yy") + " Without DP"; // TempData["recoveredUpToWithoutDP"] = recoveredUpToWithoutDP; // return View(); //} //public JsonResult SalesAuditAdjsutmentSave(string customerCode, string salesAdjustmentValue, string auditReason, string remarks) //{ // short auditSequenceNumber = 0; // string saveMessage = string.Empty; // //tbl_UnitWiseCustomerStatus objCustomerStatus = new tbl_UnitWiseCustomerStatus(); // Aud_AuditingMaster objAuditMaster = new Aud_AuditingMaster(); // try // { // objLoginHelper = (LoginHelper)Session["LogInInformation"]; // // objCustomerStatus = salesDal.ReadUnitWiseCustomerStatus(customerCode); // objAuditMaster = salesDal.AuditingMasterByLocationCode(objLoginHelper.LogInForUnitCode); // if (objAuditMaster != null) // { // auditSequenceNumber = Convert.ToInt16(objAuditMaster.AuditSeqNo); // } // else // { // auditSequenceNumber += 1; // objAuditMaster = new Aud_AuditingMaster(); // objAuditMaster.LocationCode = objLoginHelper.LogInForUnitCode; // //objAuditMaster.AuditForSalInvAccHrm = Helper.ForSales; // objAuditMaster.AuditSeqNo = auditSequenceNumber.ToString(); // objAuditMaster.AuditStartDate = DateTime.Now; // objAuditMaster.CreatedBy = objLoginHelper.LogInID; // objAuditMaster.CreatedOn = DateTime.Now; // salesDal.SaveAuditingMaster(objAuditMaster); // } // //if (objCustomerStatus != null) // //{ // // objCustomerStatus.AuditAdjustmentInSep = Convert.ToDecimal(salesAdjustmentValue); // // objCustomerStatus.RefAuditSeqNo = auditSequenceNumber; // // objCustomerStatus.Remarks = remarks; // // if (auditReason == "0") // // { // // objCustomerStatus.RefReasonForAuditAdjustment = null; // // } // // else // // objCustomerStatus.RefReasonForAuditAdjustment = auditReason; // // objCustomerStatus = salesDal.UpdateUnitWiseCustomerStatus(objCustomerStatus); // // if (objCustomerStatus != null) // // { // // saveMessage = "Save is Succeed"; // // } // //} // //else // //{ saveMessage = "Entry Is Not Valid."; } // } // catch (Exception ex) // { // saveMessage = "Save is not Succeed."; // } // return new JsonResult { Data = saveMessage }; //} //public JsonResult FinishedAuditAdjustment() //{ // short auditSequenceNumber = 0; // string updateMessage = string.Empty; // Aud_AuditingMaster objAuditMaster = new Aud_AuditingMaster(); // objLoginHelper = (LoginHelper)Session["LogInInformation"]; // try // { // objAuditMaster = salesDal.AuditingMasterByLocationCode(objLoginHelper.LogInForUnitCode); // if (objAuditMaster != null && objAuditMaster.AuditFinishDate == null) // { // objAuditMaster.AuditFinishDate = DateTime.Now; // salesDal.UpdateAuditingMaster(objAuditMaster); // if (objAuditMaster != null) // updateMessage = "succeedSave"; // else // updateMessage = "failed"; // } // else if (objAuditMaster == null) // { // auditSequenceNumber += 1; // objAuditMaster = new Aud_AuditingMaster(); // objAuditMaster.LocationCode = objLoginHelper.LogInForUnitCode; // //objAuditMaster.AuditForSalInvAccHrm = Helper.ForInventory; // objAuditMaster.AuditSeqNo = auditSequenceNumber.ToString(); // objAuditMaster.AuditStartDate = DateTime.Now; // objAuditMaster.CreatedBy = objLoginHelper.LogInID; // objAuditMaster.CreatedOn = DateTime.Now; // salesDal.SaveAuditingMaster(objAuditMaster); // if (objAuditMaster != null) // updateMessage = "succeedSave"; // else // updateMessage = "failed"; // } // else // { // updateMessage = "alreadyFinished"; // } // } // catch (Exception ex) // { // updateMessage = "failed"; // } // return new JsonResult { Data = updateMessage }; //} public JsonResult SaveCustomerCollectionAdjustment(FormCollection fCollection) { objLoginHelper = (LoginHelper)Session["LogInInformation"]; int serial = 0; string auditSequenceNumber = string.Empty; Sal_CollectionFromCustomers objCustomerCollection = new Sal_CollectionFromCustomers(); Aud_AuditAdjustmentRelatedCollectionFromCustomers objCollectionAuditAdjustnment = new Aud_AuditAdjustmentRelatedCollectionFromCustomers(); try { if (fCollection["hfCollectionSerials"] == "0") { serial = salesDal.CustomerCollectionSerial(fCollection["hfCustomerCodeForCollection"], Helper.ConvertDateToYearMonth(objLoginHelper.MonthOpenForSales)); } else { serial = Convert.ToInt32(fCollection["hfCollectionSerials"]); } auditSequenceNumber = hraDal.ReadAuditSeqNumberAfterCheckFinishedDate(objLoginHelper.LocationCode); objCustomerCollection.CustomerCode = fCollection["hfCustomerCodeForCollection"]; objCustomerCollection.YearMonth = Helper.ConvertDateToYearMonth(objLoginHelper.MonthOpenForSales); objCustomerCollection.SerialNo = Convert.ToByte(serial); objCustomerCollection.CollectionType = Helper.CollectionTypeAAA; objCustomerCollection.CollectionAmount = Convert.ToDecimal(fCollection["txtCollectionAmount"]); objCustomerCollection.CollectionAmount_Principal = Convert.ToDecimal(fCollection["CollectionAmount_Principal"]); objCustomerCollection.CollectionAmount_ServiceCharge = Convert.ToDecimal(fCollection["CollectionAmount_ServiceCharge"]); objCustomerCollection.CollectionDate = Convert.ToDateTime(Helper.DateFormatMMDDYYYY(fCollection["dtpCollectionDate"])); if (!string.IsNullOrEmpty(fCollection["txtMemoNumber"]) || String.IsNullOrEmpty(fCollection["txtMemoNumber"])) { objCustomerCollection.RefMemoNo = fCollection["txtMemoNumber"]; //string firstCharacterOfCashMemo = fCollection["txtMemoNumber"].Trim().Substring(0, 1); //if (firstCharacterOfCashMemo.ToUpper() == "A" || !String.IsNullOrEmpty(firstCharacterOfCashMemo)) //{ string firstCharacterOfCashMemo = fCollection["txtMemoNumber"].Trim(); if (firstCharacterOfCashMemo.ToUpper() == "BLANK") { objCustomerCollection.CashMemoNo = fCollection["txtMemoNumber"]; objCustomerCollection.CashMemoUsesID = "NULL"; objCustomerCollection.RefMemoNo = null; } else { objCustomerCollection.CashMemoNo = fCollection["txtMemoNumber"]; objCustomerCollection.CashMemoUsesID = Helper.CashMemuUsesIdFirst; objCustomerCollection.RefMemoNo = null; } objCustomerCollection.RefAELocationCode = objLoginHelper.LocationCode; //} } objCustomerCollection.CollectedByEmployee = fCollection["hfCustomerFprPerson"].Trim(); objCustomerCollection.UserID = objLoginHelper.LogInID; objCustomerCollection.EntryTime = DateTime.Now; objCollectionAuditAdjustnment.CustomerCode = fCollection["hfCustomerCodeForCollection"]; objCollectionAuditAdjustnment.YearMonth = Helper.ConvertDateToYearMonth(objLoginHelper.MonthOpenForSales); objCollectionAuditAdjustnment.SerialNo = Convert.ToByte(serial); objCollectionAuditAdjustnment.AuditSeqNo = auditSequenceNumber; objCollectionAuditAdjustnment.CollectionInUnit = objLoginHelper.LocationCode; objCollectionAuditAdjustnment.ReasonCode = fCollection["ddlAuditReason"].Trim(); objCollectionAuditAdjustnment.ResponsibleEmployeeID = fCollection["hfResponsibeEmployee"].Trim(); objCollectionAuditAdjustnment.Remarks = fCollection["txtClaimRemarks"].Trim(); //if (fCollection["ddlAuditReason"].Trim() == "CASCOBDEPM" || fCollection["ddlAuditReason"].Trim() == "CASCONDEPM" || fCollection["ddlAuditReason"].Trim() == "CASCONDEPW") //{ } if (fCollection["hfCollectionSerials"] == "0") { objCollectionAuditAdjustnment = salesDal.SaveCustomerCollectionForAudit(objCustomerCollection, objCollectionAuditAdjustnment, Helper.CashMemuUsesIdFirst); } else { objCustomerCollection = salesDal.UpdateCustomerCollectionAuditAdjustment(objCustomerCollection, objCollectionAuditAdjustnment); } return(new JsonResult { Data = ExceptionHelper.ExceptionMessage(string.Empty) }); } catch (Exception ex) { return(new JsonResult { Data = ExceptionHelper.ExceptionMessage(ex) }); } }