public ActionResult ReturnPurchase(int?id)
{
if (Session["LOGGEDIN"] != null)
{
objPInvoiceVM = new LP_PI_ViewModel();
objPIProperty = new LP_P_Invoice_Property();
objPIProperty.idx = Convert.ToInt32(id);
objPIBLL = new LP_PInvoice_BLL(objPIProperty);
objPInvoiceVM.TaxesList = Helper.ConvertDataTable <Taxes_Property>(GetAllTaxes());
objPInvoiceVM.ProductList = Helper.ConvertDataTable <Product_Property>(ViewAllProducts());
objPInvoiceVM.BankList = Helper.ConvertDataTable <Company_Bank_Property>(GetAllCompanyBanks());
DataSet DS = objPIBLL.SelectPIWithDetailData(objPIProperty.idx);
if (DS.Tables.Count > 0)
{
ViewBag.isReturn = 1;
objPInvoiceVM.idx = Convert.ToInt32(id);
objPInvoiceVM.InvoiceDetails = Helper.ConvertDataTable <LP_P_Invoice_Details>(DS.Tables[0]);
if (DS.Tables[1].Rows.Count > 0)
{
var data = objPIBLL.SelectByID();
var masterData = data.Tables[0];
var purchaseTaxData = DS.Tables[1];
decimal netAmount, totalAmount, taxAmount, paidAmount, balanceAmount;
decimal.TryParse(masterData.Rows[0]["NetAmount"].ToString(), out netAmount);
decimal.TryParse(masterData.Rows[0]["TotalAmount"].ToString(), out totalAmount);
decimal.TryParse(masterData.Rows[0]["PaidAmount"].ToString(), out paidAmount);
decimal.TryParse(masterData.Rows[0]["BalanceAmount"].ToString(), out balanceAmount);
if (masterData.Rows[0]["Taxable"].ToString() == "True")
{
decimal.TryParse(purchaseTaxData.Compute("Sum(taxPercent)", "").ToString(), out taxAmount);
objPInvoiceVM.TaxAmount = (((netAmount) / 100) * taxAmount);
}
objPInvoiceVM.NetAmount = netAmount;
objPInvoiceVM.TotalAmount = totalAmount;
objPInvoiceVM.PaidAmount = paidAmount;
objPInvoiceVM.BalanceAmount = balanceAmount;
objPInvoiceVM.PITAXLIST = Helper.ConvertDataTable <LP_PI_Taxes_Property>(DS.Tables[1]);
}
}
return(View("_AddNewPI", objPInvoiceVM));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public LP_PInvoice_BLL(LP_P_Invoice_Property objpinvoice)
{
_objpinvoice = objpinvoice;
}
public ActionResult AddNewPI(int?id)
{
if (Session["LOGGEDIN"] != null)
{
objPInvoiceVM = new LP_PI_ViewModel();
objPIBLL = new LP_PInvoice_BLL();
objPurchaseBLL = new LP_Purchase_BLL();
objPInvoiceVM.POLIST = Helper.ConvertDataTable <LP_Purchase_Master_Property>(objPurchaseBLL.SelectAll());
objPInvoiceVM.TaxesList = Helper.ConvertDataTable <Taxes_Property>(GetAllTaxes());
objPInvoiceVM.VendorList = Helper.ConvertDataTable <Vendors_Property>(GetAllVendors());
objPInvoiceVM.ProductList = Helper.ConvertDataTable <Product_Property>(ViewAllProducts());
objPInvoiceVM.BankList = Helper.ConvertDataTable <Company_Bank_Property>(GetAllCompanyBanks());
//objGRNVM_Property.Doc_No = "GRN-001";
if (id > 0)
{
//update
objPIProperty = new LP_P_Invoice_Property();
objPIProperty.idx = Convert.ToInt16(id);
objPIBLL = new LP_PInvoice_BLL(objPIProperty);
DataSet DS = objPIBLL.SelectByID();
objPInvoiceVM.InvoiceProperty = Helper.ConvertDataTable <LP_P_Invoice_Property>(DS.Tables[0]);
objPInvoiceVM.InvoiceDetails = Helper.ConvertDataTable <LP_P_Invoice_Details>(DS.Tables[1]);
objPInvoiceVM.PITAXLIST = Helper.ConvertDataTable <LP_PI_Taxes_Property>(DS.Tables[2]);
//
objPInvoiceVM.ParentDocID = objPInvoiceVM.InvoiceProperty[0].ParentDocID;
objPInvoiceVM.InvoiceNo = objPInvoiceVM.InvoiceProperty[0].InvoiceNo;
objPInvoiceVM.VendorID = objPInvoiceVM.InvoiceProperty[0].VendorID;
objPInvoiceVM.CreatedDate = objPInvoiceVM.InvoiceProperty[0].CreatedDate;
objPInvoiceVM.Reference = objPInvoiceVM.InvoiceProperty[0].Reference;
objPInvoiceVM.Description = objPInvoiceVM.InvoiceProperty[0].Description;
objPInvoiceVM.NetAmount = objPInvoiceVM.InvoiceProperty[0].NetAmount;
objPInvoiceVM.TotalAmount = objPInvoiceVM.InvoiceProperty[0].TotalAmount;
objPInvoiceVM.TaxAmount = objPInvoiceVM.InvoiceProperty[0].TaxAmount;
objPInvoiceVM.BalanceAmount = objPInvoiceVM.InvoiceProperty[0].BalanceAmount;
objPInvoiceVM.PaidAmount = objPInvoiceVM.InvoiceProperty[0].PaidAmount;
objPInvoiceVM.PaymentType = objPInvoiceVM.InvoiceProperty[0].PaymentType;
objPInvoiceVM.bankIdx = objPInvoiceVM.InvoiceProperty[0].BankId;
objPInvoiceVM.accorChequeNumber = objPInvoiceVM.InvoiceProperty[0].AccountChequeNo;
ViewBag.update = true;
return(PartialView("_AddNewPI", objPInvoiceVM));
}
else
{
objPInvoiceVM.InvoiceProperty = Helper.ConvertDataTable <LP_P_Invoice_Property>(new DataTable());
objPInvoiceVM.InvoiceDetails = Helper.ConvertDataTable <LP_P_Invoice_Details>(new DataTable());
objPInvoiceVM.PITAXLIST = Helper.ConvertDataTable <LP_PI_Taxes_Property>(new DataTable());
LP_GenerateTransNumber_Property objtrans = new LP_GenerateTransNumber_Property();
objtrans.TableName = "P_Invoice";
objtrans.Identityfieldname = "idx";
objtrans.userid = Session["UID"].ToString();
objPInvoiceVM.InvoiceNo = objPIBLL.GeneratePINo(objtrans);
//objPInvoiceVM.CreatedDate =DateTime.Parse(DateTime.Now.ToString("MM/dd/yyyy"));
return(PartialView("_AddNewPI", objPInvoiceVM));
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public JsonResult SalesReturnEntry(LP_PI_ViewModel objPI)
{
try
{
bool flag = false;
decimal previousTotalAmount, previousNetAmount, previousPaidAmount, previousBalanceAmount, totaltaxPercent, netAmountAfterReturn, taxAmountAfterReturn, totalReturnAmountInclusiveTax, taxAmountOnReturn = 0.00m;
if (objPI.idx > 0)
{
// var BankList = Helper.ConvertDataTable<Company_Bank_Property>(GetCompanyBankById(objPI.bankIdx));
objPIProperty = new LP_P_Invoice_Property();
objPIProperty.idx = Convert.ToInt32(objPI.idx);
objPIBLL = new LP_PInvoice_BLL(objPIProperty);
var data = objPIBLL.SelectByID();
var vendorIdx = int.Parse(data.Tables[0].Rows[0]["VendorID"].ToString());
var VendorsData = Helper.ConvertDataTable <Vendors_Property>(GetVendorById(vendorIdx));
var list = objPI.InvoiceDetails;
previousNetAmount = decimal.Parse(data.Tables[0].Rows[0]["NetAmount"].ToString());
previousTotalAmount = decimal.Parse(data.Tables[0].Rows[0]["TotalAmount"].ToString());
previousPaidAmount = decimal.Parse(data.Tables[0].Rows[0]["PaidAmount"].ToString());
previousBalanceAmount = decimal.Parse(data.Tables[0].Rows[0]["BalanceAmount"].ToString());
decimal totalReturnAmount = decimal.Parse(list.Sum(x => x.ReturnAmount).ToString());
netAmountAfterReturn = previousNetAmount - totalReturnAmount;
totalReturnAmountInclusiveTax = totalReturnAmount;//if No tax
if (totalReturnAmount > 0)
{
LP_PIReturn_Property objReturn = new LP_PIReturn_Property();
LP_PIReturn_BLL objReturnBLL = new LP_PIReturn_BLL(objReturn);
objReturn.piIdx = objPI.idx;
objReturn.invoiceNo = data.Tables[0].Rows[0]["InvoiceNo"].ToString();
objReturn.returnAmount = totalReturnAmount;
objReturn.createdBy = Convert.ToInt16(Session["UID"].ToString());
objReturn.VendorID = int.Parse(data.Tables[0].Rows[0]["VendorID"].ToString());
objReturn.DetailData = Helper.ToDataTable <LP_P_Invoice_Details>(objPI.InvoiceDetails.Where(x => x.Qty > 0 && x.ReturnQty > 0).ToList());
objReturn.UpdatedDetailData = Helper.ToDataTable <LP_P_Invoice_Details>(objPI.UpdatedInvoiceDetails.ToList());
objReturn.coaVendorIdx = VendorsData[0].coaIdx;
objReturn.PaidAmount = previousPaidAmount;
objReturn.BalancAmount = previousBalanceAmount;
objReturn.NetAmount = previousNetAmount;
objReturn.TotalAmount = previousTotalAmount;
//Account and Tax Updation After Return
var taxData = data.Tables[2];
if (taxData.Rows.Count > 0)
{
object sumObject;
sumObject = taxData.Compute("Sum(taxPercent)", string.Empty);
totaltaxPercent = decimal.Parse(sumObject.ToString());
taxAmountAfterReturn = ((netAmountAfterReturn) / 100) * totaltaxPercent;
taxAmountOnReturn = ((totalReturnAmount) / 100) * totaltaxPercent;//Return Ka Tax Amount Hai
objReturn.UpdatedTaxAmount = taxAmountAfterReturn;
totalReturnAmountInclusiveTax = totalReturnAmount + taxAmountOnReturn;
objReturn.taxData = taxData;
}
else
{
objReturn.UpdatedTaxAmount = 0.00m;
}
objReturn.returnAmountInclusiveTax = totalReturnAmountInclusiveTax;
if (totalReturnAmountInclusiveTax <= previousBalanceAmount)
{
objReturn.UpdatedTotalAmount = netAmountAfterReturn + objReturn.UpdatedTaxAmount;
objReturn.UpdatedNetAmount = netAmountAfterReturn;
//objReturn.UpdatedBalanceAmount = previousBalanceAmount - totalReturnAmount;
objReturn.UpdatedBalanceAmount = previousBalanceAmount - totalReturnAmountInclusiveTax;
objReturn.UpdatedPaidAmount = previousPaidAmount;
objReturn.amountTobeReceived = 0.00m;
if (totalReturnAmount < previousBalanceAmount)
{
//only balance Amount will be updated means only payable will decrease only
//isPaid Check will remain zero
objReturn.isPaid = 0;
}
else
{
//only balance Amount will be updated means only payable will decrease only
//isPaid Check will remain one
objReturn.isPaid = 1;
}
}
else if (totalReturnAmountInclusiveTax > previousBalanceAmount)
{
if (totalReturnAmountInclusiveTax == previousTotalAmount)
{
objReturn.UpdatedTotalAmount = 0;
objReturn.UpdatedNetAmount = 0;
objReturn.UpdatedBalanceAmount = 0;
objReturn.UpdatedPaidAmount = 0;
decimal Amount = previousBalanceAmount - totalReturnAmountInclusiveTax;
objReturn.UpdatedPaidAmount = previousPaidAmount + Amount;
objReturn.amountTobeReceived = -(Amount);
objReturn.isPaid = 1;
}
else
{
objReturn.UpdatedTotalAmount = netAmountAfterReturn + objReturn.UpdatedTaxAmount;
objReturn.UpdatedNetAmount = netAmountAfterReturn;
objReturn.UpdatedBalanceAmount = 0;
decimal Amount = previousBalanceAmount - totalReturnAmountInclusiveTax;
objReturn.UpdatedPaidAmount = previousPaidAmount + Amount;
objReturn.amountTobeReceived = -(Amount);
objReturn.isPaid = 1;
}
}
objReturnBLL.Insert();
}
}
else
{
//add
objPIProperty = new LP_P_Invoice_Property();
objPIProperty.InvoiceNo = objPI.InvoiceNo;
objPIProperty.InvoiceType = objPI.InvoiceType;
objPIProperty.IsPaid = objPI.IsPaid;
objPIProperty.NetAmount = objPI.NetAmount;
objPIProperty.PaidAmount = objPI.PaidAmount;
objPIProperty.BalanceAmount = objPI.BalanceAmount;
objPIProperty.PaymentType = objPI.PaymentType;
objPIProperty.Status = objPI.Status;
objPIProperty.Taxable = objPI.Taxable;
objPIProperty.TotalAmount = objPI.TotalAmount;
objPIProperty.Description = objPI.Description;
objPIProperty.CreatedBy = Convert.ToInt16(Session["UID"].ToString());
objPIProperty.Description = objPI.Description;
objPIProperty.Reference = objPI.Reference;
objPIProperty.BankId = objPI.bankIdx;
objPIProperty.AccountChequeNo = objPI.accorChequeNumber;
objPIProperty.CreatedDate = DateTime.Now;
objPIProperty.Status = 0;
if (objPI.Description == null)
{
objPIProperty.Description = "";
}
else
{
objPIProperty.Description = objPI.Description;
}
if (objPI.PITAXLIST.Count() > 0)
{
objPIProperty.Taxable = true;
}
else
{
objPIProperty.Taxable = false;
}
//objPIProperty.Taxable= ((objPI.TaxesList.Count()>0)==true?true:false);
objPIProperty.VendorID = objPI.VendorID;
objPIProperty.ParentDocID = objPI.ParentDocID;
//tax
objPIProperty.TaxData = Helper.ToDataTable <LP_PI_Taxes_Property>(objPI.PITAXLIST);
objPIProperty.InvoiceDetails = Helper.ToDataTable <LP_P_Invoice_Details>(objPI.InvoiceDetails);
objPIBLL = new LP_PInvoice_BLL(objPIProperty);
flag = objPIBLL.Insert();
}
return(Json(new { data = "", success = flag, msg = flag == true ? "Successfull" : "Failed", statuscode = flag == true ? 200 : 401 }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { data = ex.InnerException, success = false, statuscode = 400, count = 0 }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult AddUpdate(LP_PI_ViewModel objPI)
{
try
{
bool flag = false;
if (objPI.idx > 0)
{
//update
}
else
{
//add
objPInvoiceVM = new LP_PI_ViewModel();
var BankList = Helper.ConvertDataTable <Company_Bank_Property>(GetCompanyBankById(objPI.bankIdx));
var VendorsData = Helper.ConvertDataTable <Vendors_Property>(GetVendorById(objPI.VendorID));
objPIProperty = new LP_P_Invoice_Property();
objPIProperty.InvoiceNo = objPI.InvoiceNo;
objPIProperty.InvoiceType = objPI.InvoiceType;
objPIProperty.IsPaid = objPI.IsPaid;
objPIProperty.NetAmount = objPI.NetAmount;
objPIProperty.PaidAmount = objPI.PaidAmount;
objPIProperty.BalanceAmount = objPI.BalanceAmount;
objPIProperty.PaymentType = objPI.PaymentType;
objPIProperty.Status = objPI.Status;
objPIProperty.Taxable = objPI.Taxable;
objPIProperty.TotalAmount = objPI.TotalAmount;
objPIProperty.Description = objPI.Description;
objPIProperty.CreatedBy = Convert.ToInt16(Session["UID"].ToString());
objPIProperty.Description = objPI.Description;
objPIProperty.Reference = objPI.Reference;
objPIProperty.BankId = objPI.bankIdx;
objPIProperty.AccountChequeNo = objPI.accorChequeNumber;
objPIProperty.CreatedDate = DateTime.Now;
objPIProperty.Status = 0;
if (objPI.Description == null)
{
objPIProperty.Description = "";
}
else
{
objPIProperty.Description = objPI.Description;
}
if (objPI.PITAXLIST.Count() > 0)
{
objPIProperty.Taxable = true;
}
else
{
objPIProperty.Taxable = false;
}
//objPIProperty.Taxable= ((objPI.TaxesList.Count()>0)==true?true:false);
objPIProperty.VendorID = objPI.VendorID;
objPIProperty.ParentDocID = objPI.ParentDocID;
//tax
objPIProperty.TaxData = Helper.ToDataTable <LP_PI_Taxes_Property>(objPI.PITAXLIST);
if (BankList.Count > 0)
{
objPIProperty.CoaIDx = Convert.ToInt32(BankList[0].coaidx);
}
objPIProperty.VendorCoaidx = Convert.ToInt32(VendorsData[0].coaIdx);
objPIProperty.InvoiceDetails = Helper.ToDataTable <LP_P_Invoice_Details>(objPI.InvoiceDetails);
objPIBLL = new LP_PInvoice_BLL(objPIProperty);
flag = objPIBLL.Insert();
}
return(Json(new { data = "", success = flag, msg = flag == true ? "Successfull" : "Failed", statuscode = flag == true ? 200 : 401 }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { data = ex.InnerException, success = false, statuscode = 400, count = 0 }, JsonRequestBehavior.AllowGet));
}
}
public LP_Purchase_Invoice_DAL(LP_P_Invoice_Property objpinvoiceproperty)
{
_objpinvoiceproperty = objpinvoiceproperty;
}
public JsonResult AddUpdate(LP_PI_ViewModel objPI)
{
try
{
bool flag = false;
//objGRNProperty = new LP_GRN_Master_Property();
//objGRNProperty.Doc_No = objGRN.Doc_No;
//objGRNProperty.Parent_DocID = objGRN.Parent_DocID;
//objGRNProperty.Date_Created = objGRN.Date_Created;
//objGRNProperty.Narration = objGRN.Narration;
//objGRNProperty.Total_Amount = objGRN.Total_Amount;
//objGRNProperty.User_ID = Convert.ToInt16(Session["UID"].ToString());
//// objGRNProperty.paidDate = ;// objGRN.paidDate;
//objGRNProperty.DetailData = Helper.ToDataTable<LP_GRN_Detail_Property>(objGRN.GRNDeatilList);
if (objPI.idx > 0)
{
//update
}
else
{
//add
objPIProperty = new LP_P_Invoice_Property();
objPIProperty.InvoiceNo = objPI.InvoiceNo;
objPIProperty.InvoiceType = objPI.InvoiceType;
objPIProperty.IsPaid = objPI.IsPaid;
objPIProperty.NetAmount = objPI.NetAmount;
objPIProperty.PaidAmount = objPI.PaidAmount;
objPIProperty.BalanceAmount = objPI.BalanceAmount;
objPIProperty.PaymentType = objPI.PaymentType;
objPIProperty.Status = objPI.Status;
objPIProperty.Taxable = objPI.Taxable;
objPIProperty.TotalAmount = objPI.TotalAmount;
objPIProperty.Description = objPI.Description;
objPIProperty.CreatedBy = Convert.ToInt16(Session["UID"].ToString());
objPIProperty.Description = objPI.Description;
objPIProperty.Reference = objPI.Reference;
objPIProperty.BankId = objPI.bankIdx;
objPIProperty.AccountChequeNo = objPI.accorChequeNumber;
objPIProperty.CreatedDate = DateTime.Now;
objPIProperty.Status = 0;
if (objPI.Description == null)
{
objPIProperty.Description = "";
}
else
{
objPIProperty.Description = objPI.Description;
}
if (objPI.PITAXLIST.Count() > 0)
{
objPIProperty.Taxable = true;
}
else
{
objPIProperty.Taxable = false;
}
//objPIProperty.Taxable= ((objPI.TaxesList.Count()>0)==true?true:false);
objPIProperty.VendorID = objPI.VendorID;
objPIProperty.ParentDocID = objPI.ParentDocID;
//tax
objPIProperty.TaxData = Helper.ToDataTable <LP_PI_Taxes_Property>(objPI.PITAXLIST);
objPIProperty.InvoiceDetails = Helper.ToDataTable <LP_P_Invoice_Details>(objPI.InvoiceDetails);
objPIBLL = new LP_PInvoice_BLL(objPIProperty);
flag = objPIBLL.Insert();
}
return(Json(new { data = "", success = flag, msg = flag == true ? "Successfull" : "Failed", statuscode = flag == true ? 200 : 401 }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { data = ex.InnerException, success = false, statuscode = 400, count = 0 }, JsonRequestBehavior.AllowGet));
}
}
