public PartialViewResult _ViewPartial(int id)
{
try
{
SalesInvoiceViewModels model = new SalesInvoiceViewModels();
model.SalesInvoices = salesinvoiceRepository.FindOneInvoiceById(id);
model.SalesInvoiceItemsList = salesinvoiceRepository.FindOneInvoiceItemById(id);
//Bind Branch
var BranchList = salesinvoiceRepository.GetBranchList().ToList();
model.BranchList = BranchList;
//Bind VAT
var VATList = salesinvoiceRepository.GetVAT().ToList();
model.VATList = VATList;
//Bind Product
var ProductList = salesinvoiceRepository.GetProductList().ToList();
model.ProductList = ProductList;
//Bind Businesspartner
var BusinessParterList = salesinvoiceRepository.GetBusinessPartnerList().ToList();
model.BusinessPartnerList = BusinessParterList;
return(PartialView(model));
}
catch (Exception ex)
{
ExceptionHandler.LogException(ex);
ViewBag.AppErrorMessage = ex.Message;
return(PartialView("Error"));
}
}
// GET: SalesInvoices
public ActionResult Index()
{
try
{
LogHandler.WriteLog("Sales Invoice Index page requested by #UserId");
var qList = salesinvoiceRepository.GetAllSalesInvoice().ToList();
SalesInvoiceViewModels model = new SalesInvoiceViewModels();
model.SalesInvoiceList = qList;
//Bind Branch
var BranchList = salesinvoiceRepository.GetBranchList().ToList();
model.BranchList = BranchList;
//Bind VAT
var VATList = salesinvoiceRepository.GetVAT().ToList();
model.VATList = VATList;
//Bind Product
var ProductList = salesinvoiceRepository.GetProductList().ToList();
model.ProductList = ProductList;
//Bind Businesspartner
var BusinessParterList = salesinvoiceRepository.GetBusinessPartnerList().ToList();
model.BusinessPartnerList = BusinessParterList;
//Bind GoodsReceipt
var qList1 = salesinvoiceRepository.GetSalesDelivery().ToList();
model.SalesDeliveryList = qList1;
return(View(model));
}
catch (Exception ex)
{
ExceptionHandler.LogException(ex);
ViewBag.AppErrorMessage = ex.Message;
return(View("Error"));
}
}
public ActionResult Index(string submitButton, SalesInvoiceViewModels model, HttpPostedFileBase file)
{
try
{
//ApplicationUser currentUser = ApplicationUserManager.GetApplicationUser(User.Identity.Name, HttpContext.GetOwinContext());
if (submitButton == "Save")
{
model.SalesInvoices.Doc_Status = "Open";
model.SalesInvoices.Invoice_Payment = "N";
model.SalesInvoices.Created_Branc_Id = CurrentBranchId; //currentUser.Created_Branch_Id;
model.SalesInvoices.Created_Date = DateTime.Now;
model.SalesInvoices.Created_User_Id = CurrentUser.Id; //currentUser.Created_User_Id; //GetUserId()
//model.PurchaseInvoice.Modified_User_Id = CurrentUser.Created_User_Id;//currentUser.Modified_User_Id;
//model.PurchaseInvoice.Modified_Date = DateTime.Now;
//model.PurchaseInvoice.Modified_Branch_Id =CurrentBranchId;//currentUser.Modified_Branch_Id;
model.SalesInvoices.TargetDocId = "0";
var InvoiceList = model.SalesInvoiceItemsList.Where(x => x.IsDummy == 0);
model.SalesInvoiceItemsList = InvoiceList.ToList();
if (salesinvoiceRepository.AddNewSalesInvoice(model.SalesInvoices, model.SalesInvoiceItemsList, ref ErrorMessage))
{
//XMLGenerate_SAPInsert(model);
//for (int i = 0; i < model.PurchaseQuotationItemList.Count; i++)
//{
// XMLGenerate_Quotation_SAPInsert(model.PurchaseQuotationItemList[i]);
//}
return(RedirectToAction("Index", "SalesInvoices"));
}
else
{
ViewBag.AppErrorMessage = ErrorMessage;
return(View("Error"));
}
}
else if (submitButton == "Update")
{
model.SalesInvoices.Doc_Status = "Open";
model.SalesInvoices.Invoice_Payment = "N";
//model.PurchaseInvoice.Created_Branc_Id = CurrentBranchId;//currentUser.Created_Branch_Id;
//model.PurchaseInvoice.Created_Date = DateTime.Now;
//model.PurchaseInvoice.Created_User_Id = CurrentUser.Created_User_Id;//currentUser.Created_User_Id; //GetUserId()
model.SalesInvoices.Modified_User_Id = CurrentUser.Id; //currentUser.Modified_User_Id;
model.SalesInvoices.Modified_Date = DateTime.Now;
model.SalesInvoices.Modified_Branch_Id = CurrentBranchId; //currentUser.Modified_Branch_Id;
model.SalesInvoices.TargetDocId = "0";
var QuotationList = model.SalesInvoiceItemsList.Where(x => x.IsDummy == 0);
model.SalesInvoiceItemsList = QuotationList.ToList();
if (salesinvoiceRepository.UpdateSalesInvoice(model.SalesInvoices, model.SalesInvoiceItemsList, ref ErrorMessage))
{
return(RedirectToAction("Index", "SalesInvoices"));
}
else
{
ViewBag.AppErrorMessage = ErrorMessage;
return(View("Error"));
}
}
else if (submitButton == " Save")
{
SalesInvoiceViewModels model1 = new SalesInvoiceViewModels();
model1.SalesDelivery = salesinvoiceRepository.FindOneSalesDeliveryById(model.SalesDelivery.Sales_Delivery_Id);
model1.SalesDeliveryItemList = salesinvoiceRepository.FindOneSalesDeliveryItemById(model.SalesDelivery.Sales_Delivery_Id);
if (model1.SalesDelivery.Customer == model.SalesDelivery.Customer)
{
//for BaseDocId
for (int j = 0; j < model.SalesDeliveryItemList.Count; j++)
{
if (model1.SalesDeliveryItemList[j].Product_Id == model.SalesDeliveryItemList[j].Product_Id)
{
model.SalesInvoices.BaseDocId = model.SalesDelivery.Sales_Delivery_Id;
}
}
//for BaseDocLink
for (int j = 0; j < model.SalesDeliveryItemList.Count; j++)
{
if (model1.SalesDeliveryItemList[j].Product_Id == model.SalesDeliveryItemList[j].Product_Id)
{
model.SalesInvoiceItemsList[j].BaseDocLink = "Y";
}
else
{
model.SalesInvoiceItemsList[j].BaseDocLink = "N";
}
model.SalesInvoices.Sales_Invoice_Id = model.SalesDelivery.Sales_Delivery_Id;
model.SalesInvoices.Reference_Number = model.SalesDelivery.Reference_Number;
model.SalesInvoices.Customer = model.SalesDelivery.Customer;
model.SalesInvoices.Doc_Status = "Open";
model.SalesInvoices.Posting_Date = DateTime.Now; // model.PurchaseQuotation.Posting_Date;
model.SalesInvoices.Due_Date = model.SalesDelivery.Delivery_Date;; // model.PurchaseQuotation.Valid_Date;
model.SalesInvoices.Document_Date = DateTime.Now; //model.PurchaseQuotation.Posting_Date;
model.SalesInvoices.Branch = model.SalesDelivery.Branch;
model.SalesInvoices.TotalBefDocDisc = model.SalesDelivery.TotalBefDocDisc;
model.SalesInvoices.DocDiscAmt = model.SalesDelivery.DocDiscAmt;
model.SalesInvoices.TotalBefDocDisc = model.SalesDelivery.TotalBefDocDisc;
model.SalesInvoices.TaxAmt = model.SalesDelivery.TaxAmt;
model.SalesInvoices.Remarks = model.SalesDelivery.Remarks;
model.SalesInvoices.TargetDocId = "0";
model.SalesInvoices.Invoice_Payment = "N";
model.SalesInvoices.Created_Branc_Id = CurrentBranchId; //currentUser.Created_Branch_Id;
model.SalesInvoices.Created_Date = DateTime.Now;
model.SalesInvoices.Created_User_Id = CurrentUser.Id; //currentUser.Created_User_Id; //GetUserId()
//model.PurchaseInvoice.Modified_User_Id = CurrentUser.Created_User_Id;//currentUser.Modified_User_Id;
//model.PurchaseInvoice.Modified_Date = DateTime.Now;
//model.PurchaseInvoice.Modified_Branch_Id = CurrentBranchId;//currentUser.Modified_Branch_Id;
var QuotationList = model.SalesDeliveryItemList.Where(x => x.IsDummy == 0);
model.SalesDeliveryItemList = QuotationList.ToList();
model.SalesInvoiceItemsList[j].Product_id = model.SalesDeliveryItemList[j].Product_Id;
model.SalesInvoiceItemsList[j].Quantity = Convert.ToInt32(model.SalesDeliveryItemList[j].Quantity);
model.SalesInvoiceItemsList[j].Unit_price = model.SalesDeliveryItemList[j].Unit_Price;
model.SalesInvoiceItemsList[j].Discount_percent = model.SalesDeliveryItemList[j].Discount_Precent;
model.SalesInvoiceItemsList[j].Vat_Code = model.SalesDeliveryItemList[j].Vat_Code;
model.SalesInvoiceItemsList[j].LineTotal = model.SalesDeliveryItemList[j].LineTotal;
}
if (salesinvoiceRepository.AddNewSalesInvoice(model.SalesInvoices, model.SalesInvoiceItemsList, ref ErrorMessage))
{
//for Purchase Quotation/Purchase Quotation item table update
for (int j = 0; j < model.SalesDeliveryItemList.Count; j++)
{
if (model1.SalesDeliveryItemList[j].Product_Id == model.SalesDeliveryItemList[j].Product_Id && model.SalesDeliveryItemList[j].Quantity >= model1.SalesDeliveryItemList[j].Quantity)
{
model1.SalesDelivery.Doc_Status = "Closed";
model1.SalesDelivery.TargetDocId = model1.SalesDelivery.TargetDocId + "," + Convert.ToString(model.SalesInvoices.Sales_Invoice_Id);
model1.SalesDeliveryItemList[j].sales_Item_Id = model1.SalesDeliveryItemList[j].sales_Item_Id;
model1.SalesDeliveryItemList[j].Sales_Delivery_Id = model1.SalesDeliveryItemList[j].Sales_Delivery_Id;
model1.SalesDeliveryItemList[j].Invoiced_Qty = model1.SalesDeliveryItemList[j].Invoiced_Qty + Convert.ToInt32(model.SalesDeliveryItemList[j].Quantity);
model1.SalesDeliveryItemList[j].Product_Id = model.SalesDeliveryItemList[j].Product_Id;
model1.SalesDeliveryItemList[j].Unit_Price = model.SalesDeliveryItemList[j].Unit_Price;
model1.SalesDeliveryItemList[j].Discount_Precent = model.SalesDeliveryItemList[j].Discount_Precent;
model1.SalesDeliveryItemList[j].Vat_Code = model.SalesDeliveryItemList[j].Vat_Code;
}
else if (model1.SalesDeliveryItemList[j].Product_Id == model.SalesDeliveryItemList[j].Product_Id && model.SalesDeliveryItemList[j].Quantity < model1.SalesDeliveryItemList[j].Quantity)
{
model1.SalesDelivery.Doc_Status = "Open";
model1.SalesDelivery.TargetDocId = model1.SalesDelivery.TargetDocId + "," + Convert.ToString(model.SalesInvoices.Sales_Invoice_Id);
model1.SalesDeliveryItemList[j].sales_Item_Id = model1.SalesDeliveryItemList[j].sales_Item_Id;
model1.SalesDeliveryItemList[j].Sales_Delivery_Id = model1.SalesDeliveryItemList[j].Sales_Delivery_Id;
model1.SalesDeliveryItemList[j].Invoiced_Qty = model1.SalesDeliveryItemList[j].Invoiced_Qty + Convert.ToInt32(model.SalesDeliveryItemList[j].Quantity);
model1.SalesDeliveryItemList[j].Product_Id = model.SalesDeliveryItemList[j].Product_Id;
model1.SalesDeliveryItemList[j].Unit_Price = model.SalesDeliveryItemList[j].Unit_Price;
model1.SalesDeliveryItemList[j].Discount_Precent = model.SalesDeliveryItemList[j].Discount_Precent;
model1.SalesDeliveryItemList[j].Vat_Code = model.SalesDeliveryItemList[j].Vat_Code;
}
}
model1.SalesDelivery.Created_Branc_Id = CurrentBranchId; //currentUser.Created_Branch_Id;
model1.SalesDelivery.Created_Date = DateTime.Now;
model1.SalesDelivery.Created_User_Id = CurrentUser.Id; //currentUser.Created_User_Id; //GetUserId()
//model1.GoodsReceipt.Modified_User_Id = CurrentUser.Created_User_Id;//currentUser.Modified_User_Id;
//model1.GoodsReceipt.Modified_Dte = DateTime.Now;
//model1.GoodsReceipt.Modified_Branch_Id = CurrentBranchId;//currentUser.Modified_Branch_Id;
salesinvoiceRepository.UpdateSalesDelivery(model1.SalesDelivery, model1.SalesDeliveryItemList, ref ErrorMessage);
return(RedirectToAction("Index", "SalesInvoices"));
}
else
{
ViewBag.AppErrorMessage = ErrorMessage;
return(View("Error"));
}
}
}
return(RedirectToAction("Index", "SalesInvoices"));
}
catch (Exception ex)
{
ExceptionHandler.LogException(ex);
ViewBag.AppErrorMessage = ex.Message;
return(View("Error"));
}
}
