public ActionResult SystemReturn(FormCollection fCollection)
{
objLoginHelper = (LoginHelper)Session["LogInInformation"];
Sal_SystemReturn objSystemReturn;
Sal_SystemReturnItems objSystemReturnItems;
Sal_SystemReturnItemsWithSerialNo objSystemReturnItemsWithSerialNo;
List <Sal_SystemReturnItems> lstSystemReturnItems = new List <Sal_SystemReturnItems>();
List <Sal_SystemReturnItemsWithSerialNo> lstSystemReturnItemsWithSerialNo = new List <Sal_SystemReturnItemsWithSerialNo>();
int customerOrRsf = Convert.ToInt32(fCollection["hfCustomerOrRSF"]), serialCounter = 1;
string serialTempTableRows = string.Empty;
try
{
objSystemReturn = new Sal_SystemReturn();
objSystemReturn.CustomerCode = fCollection["txtCustomerCode"].Trim();
objSystemReturn.ReturnDate = Convert.ToDateTime(Helper.DateFormatMMDDYYYY(fCollection["dtpSystemReturn"].Trim()));
objSystemReturn.MonthUsage = Convert.ToByte(fCollection["txtUsagesMonth"]);
objSystemReturn.UsageChargeReceivable = Convert.ToDecimal(fCollection["txtUsageCharge"]);
objSystemReturn.ServiceChargeReceivable = Convert.ToDecimal(fCollection["txtReceivableServiceCharge"]);
objSystemReturn.NonReturnedItemValue = Convert.ToDecimal(fCollection["txtNonReturnItemsValue"]);
objSystemReturn.TotalReceivable = Convert.ToDecimal(fCollection["txtTotalReceivable"]);
objSystemReturn.TotalRecovered_DPPlusInstallment = Convert.ToDecimal(fCollection["txtTotalRecoveredDPAndInstallment"]);
if (customerOrRsf == -1)
{
objSystemReturn.ReceivableOrPayableAmount = Convert.ToDecimal(fCollection["txtReceaviblePaybleAmount"]) * -1;
objSystemReturn.ActualReceivedOrPaidAmount = Convert.ToDecimal(fCollection["txtActualPaidRSFORCustomer"]) * -1;
}
else
{
if (fCollection["hfIsPaidToCustomerOnApprovalByManagementWhenReceivable"] == "1")
{
// objSystemReturn.ReceivableOrPayableAmount = Convert.ToDecimal(fCollection["txtReceaviblePaybleAmount"]) * -1; -------Recommandatiion Md.Raiz vai to Chanage By Md.Sultan Mahmud
objSystemReturn.ReceivableOrPayableAmount = Convert.ToDecimal(fCollection["txtReceaviblePaybleAmount"]) * 1; //Newly added By Md.Sultan Mahmud
objSystemReturn.ActualReceivedOrPaidAmount = Convert.ToDecimal(fCollection["txtApprovedAmount"]) * -1;
objSystemReturn.IsPaidToCustomerOnApprovalByManagementWhenReceivable = true;
}
else
{
objSystemReturn.ReceivableOrPayableAmount = Convert.ToDecimal(fCollection["txtReceaviblePaybleAmount"]);
objSystemReturn.ActualReceivedOrPaidAmount = Convert.ToDecimal(fCollection["txtActualPaidRSFORCustomer"]);
objSystemReturn.IsPaidToCustomerOnApprovalByManagementWhenReceivable = false;
}
}
objSystemReturn.CreatedBy = objLoginHelper.LogInID;
objSystemReturn.CreatedOn = DateTime.Now;
//itemCode + "," + soldQuantity + "," + unitCost + "," + returnQuantity + "," + returnItemsValue + "," + nonReturnItemsValue + "," + componentSequenceNumber + "," + stockLocation + "," + serialNumber;
string[] systemReturnItemsCollection = fCollection["hfSystemReturnsItems"].Trim().Split('#');
int sytemReturnItemsCollectionLength = systemReturnItemsCollection.Length;
if (sytemReturnItemsCollectionLength > 0)
{
for (int i = 0; i < sytemReturnItemsCollectionLength; i++)
{
string[] systemReturnItems = systemReturnItemsCollection[i].Trim().Split(',');
objSystemReturnItems = new Sal_SystemReturnItems();
objSystemReturnItems.CustomerCode = fCollection["txtCustomerCode"].Trim();
objSystemReturnItems.CompSeqNo = Convert.ToByte(systemReturnItems[6].Trim()); // Component Sequence Number
objSystemReturnItems.ItemCode = systemReturnItems[0].Trim(); // Item Code
objSystemReturnItems.SoldQuantity = Convert.ToDouble(systemReturnItems[1].Trim()); // Purchase Quantity/ Sold Quantity
objSystemReturnItems.ReturnQuantity = Convert.ToDouble(systemReturnItems[3].Trim()); // Return Item Quantity
objSystemReturnItems.ReturnInToStoreLocation = Convert.ToByte(systemReturnItems[7].Trim()); // Store Location
objSystemReturnItems.UnitCost = Convert.ToDecimal(systemReturnItems[4].Trim()); // Sold Item Depriciated Unit Cost
objSystemReturnItems.NonReturnItemsValue = Convert.ToDecimal(systemReturnItems[5].Trim()); // Non Return Items Cost
lstSystemReturnItems.Add(objSystemReturnItems);
if (!string.IsNullOrEmpty(systemReturnItems[8].Trim()))
{
objSystemReturnItemsWithSerialNo = new Sal_SystemReturnItemsWithSerialNo();
objSystemReturnItemsWithSerialNo.CustomerCode = fCollection["txtCustomerCode"].Trim();
objSystemReturnItemsWithSerialNo.CompSeqNo = Convert.ToByte(serialCounter);
objSystemReturnItemsWithSerialNo.ItemCode = systemReturnItems[0].Trim(); // Item Code
objSystemReturnItemsWithSerialNo.ItemSerialNo = systemReturnItems[8].Trim(); // Item Serial Number
objSystemReturnItemsWithSerialNo.Status = Helper.Active;
lstSystemReturnItemsWithSerialNo.Add(objSystemReturnItemsWithSerialNo);
if (!string.IsNullOrEmpty(serialTempTableRows))
{
serialTempTableRows += "," + "(" + objSystemReturnItems.ItemCode + ",'" + objSystemReturnItemsWithSerialNo.ItemSerialNo + "','" + systemReturnItems[9].Trim() + "'," + Convert.ToByte(systemReturnItems[7].Trim()) + ",'" + objLoginHelper.LocationCode + "','" + fCollection["txtCustomerCode"].Trim() + "')";
}
else
{
serialTempTableRows = "(" + objSystemReturnItems.ItemCode + ",'" + objSystemReturnItemsWithSerialNo.ItemSerialNo + "','" + systemReturnItems[9].Trim() + "'," + Convert.ToByte(systemReturnItems[7].Trim()) + ",'" + objLoginHelper.LocationCode + "','" + fCollection["txtCustomerCode"].Trim() + "')";
}
serialCounter++;
}
}
}
salesDal.SaveSystemReturn(objSystemReturn, lstSystemReturnItems, lstSystemReturnItemsWithSerialNo, objLoginHelper.LocationCode, serialTempTableRows);
erpDal.CreateUserLog(Helper.ClientIPAddress(), string.Empty, objLoginHelper.LocationCode, objLoginHelper.LogInID, "System Return, Customer Code: " + fCollection["txtCustomerCode"].Trim());
return(new JsonResult {
Data = ExceptionHelper.ExceptionMessage("System Return" + Helper.SuccessMessage)
});
}
catch (Exception ex)
{
return(new JsonResult {
Data = ExceptionHelper.ExceptionMessage(ex)
});
}
}
public JsonResult Login(FormCollection fCollection)
{
try
{
ArrayList logInMessage = new ArrayList();
UserInformation userInfo = new UserInformation();
userInfo = securityDal.ReadUserInformation(fCollection["txtUserName"], fCollection["txtPassword"], Helper.Active);
if (userInfo != null)
{
objLoginHelper = securityDal.LoginInformation(fCollection, userInfo);
String ipAddress = string.Empty, sMacAddress = string.Empty;
ipAddress = IPNetworking.GetIP4Address();
// ipAddress = System.Web.HttpContext.Current.Request.UserHostAddress; // Use it Or the below one for get Visitors IP address
if (String.IsNullOrEmpty(ipAddress))
{
ipAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (ipAddress == null)
{
ipAddress = Request.ServerVariables["REMOTE_ADDR"];
}
}
//sMacAddress = NetworkUtility.GetMacAddress(NetworkUtility.GetMacAddress(ipAddress));
erpDal.CreateUserLog(ipAddress, sMacAddress, objLoginHelper.LocationCode, objLoginHelper.LogInID, "Login");
Session["LogInInformation"] = objLoginHelper;
return(new JsonResult {
Data = ExceptionHelper.ExceptionMessage(string.Empty, "Valid", Helper.URL(objLoginHelper))
});
}
else
{
return(new JsonResult {
Data = ExceptionHelper.ExceptionMessage("Sorry, UserId/Password Is Not Valid.", "error", string.Empty)
});
}
//RASolarERPDAL objModuleDal = new RASolarERPDAL();
//ViewBag.RSFModule = objModuleDal.RSFERPModuleDataForCombo();
//ViewBag.UserValidation = false;
//return View();
//aa = fCollection["ddlZone"];
//aa = fCollection["ddlRegion"];
//aa = fCollection["ddlUnit"];
//aa = fCollection["txtUserName"];
//aa = fCollection["txtPassword"];
}
catch (Exception ex)
{
return(new JsonResult {
Data = ExceptionHelper.ExceptionMessage(ex)
});
}
}
