Ejemplo n.º 1
0
        public ActionResult Index(string submitButton, PurchaseReturnViewModels model)
        {
            try
            {
                //ApplicationUser currentUser = ApplicationUserManager.GetApplicationUser(User.Identity.Name, HttpContext.GetOwinContext());


                if (submitButton == "Save")
                {
                    PurchaseReturnViewModels model1 = new PurchaseReturnViewModels();
                    model1.PurchaseInvoice          = purchasereturnrepository.FindOneInvoiceById(model.PurchaseInvoice.Purchase_Invoice_Id);
                    model1.PurchaseInvoiceItemsList = purchasereturnrepository.FindOneInvoiceItemById(model.PurchaseInvoice.Purchase_Invoice_Id);


                    if (model1.PurchaseInvoice.Vendor == model.PurchaseInvoice.Vendor)
                    {
                        //for BaseDocId
                        for (int j = 0; j < model.PurchaseInvoiceItemsList.Count; j++)
                        {
                            if (model1.PurchaseInvoiceItemsList[j].Product_id == model.PurchaseInvoiceItemsList[j].Product_id)
                            {
                                model.PurchaseReturn.BaseDocId = model.PurchaseInvoice.Purchase_Invoice_Id;
                            }
                        }
                        model.PurchaseReturn.Doc_Status          = "OPEN";
                        model.PurchaseReturn.Created_Branc_Id    = CurrentBranchId; //CurrentBranchId;
                        model.PurchaseReturn.Created_Date        = DateTime.Now;
                        model.PurchaseReturn.Created_User_Id     = CurrentUser.Id;  //CurrentUser.Id;
                        model.PurchaseReturn.Purchase_Invoice_Id = model.PurchaseInvoice.Purchase_Invoice_Id;
                        model.PurchaseReturn.Vendor = model.PurchaseInvoice.Vendor;
                        // model.PurchaseReturn.Doc_Status = model.PurchaseInvoice.Doc_Status;
                        model.PurchaseReturn.Posting_Date     = model.PurchaseInvoice.Posting_Date;
                        model.PurchaseReturn.Due_Date         = model.PurchaseInvoice.Due_Date;
                        model.PurchaseReturn.Document_Date    = model.PurchaseInvoice.Document_Date;
                        model.PurchaseReturn.Ship_To          = model.PurchaseInvoice.Ship_To;
                        model.PurchaseReturn.Freight          = model.PurchaseInvoice.Freight;
                        model.PurchaseReturn.Loading          = model.PurchaseInvoice.Loading;
                        model.PurchaseReturn.TotalBefDocDisc  = model.PurchaseInvoice.TotalBefDocDisc;
                        model.PurchaseReturn.DocDiscAmt       = model.PurchaseInvoice.DocDiscAmt;
                        model.PurchaseReturn.TaxAmt           = model.PurchaseInvoice.TaxAmt;
                        model.PurchaseReturn.TotalPurRtnAmt   = model.PurchaseInvoice.TotalPurInvAmt;
                        model.PurchaseReturn.Reference_Number = model.PurchaseInvoice.Reference_Number;



                        var RetrnList = model.PurchaseReturnitemsList.Where(x => x.IsDummy == 0);
                        model.PurchaseReturnitemsList = RetrnList.ToList();

                        for (int i = 0; i < model.PurchaseReturnitemsList.Count; i++)
                        {
                            if (model1.PurchaseInvoiceItemsList[i].Product_id == model.PurchaseInvoiceItemsList[i].Product_id)
                            {
                                model.PurchaseReturnitemsList[i].BaseDocLink = "Y";
                            }
                            else
                            {
                                model.PurchaseReturnitemsList[i].BaseDocLink = "N";
                            }
                            model.PurchaseReturnitemsList[i].Product_id       = model.PurchaseInvoiceItemsList[i].Product_id;
                            model.PurchaseReturnitemsList[i].Quantity         = model.PurchaseInvoiceItemsList[i].Quantity;
                            model.PurchaseReturnitemsList[i].Unit_price       = model.PurchaseInvoiceItemsList[i].Unit_price;
                            model.PurchaseReturnitemsList[i].Discount_percent = model.PurchaseInvoiceItemsList[i].Discount_percent;
                            model.PurchaseReturnitemsList[i].Vat_Code         = model.PurchaseInvoiceItemsList[i].Vat_Code;
                            model.PurchaseReturnitemsList[i].Freight_Loading  = model.PurchaseInvoiceItemsList[i].Freight_Loading;
                            model.PurchaseReturnitemsList[i].LineTotal        = model.PurchaseInvoiceItemsList[i].LineTotal;
                        }

                        if (purchasereturnrepository.AddNewReturn(model.PurchaseReturn, model.PurchaseReturnitemsList, ref ErrorMessage))
                        {
                            //return RedirectToAction("Index", "PurchaseOrders");

                            //for Purchase Quotation/Purchase Quotation item table update
                            for (int j = 0; j < model.PurchaseInvoiceItemsList.Count; j++)
                            {
                                if (model1.PurchaseInvoiceItemsList[j].Product_id == model.PurchaseInvoiceItemsList[j].Product_id && model.PurchaseInvoiceItemsList[j].Quantity >= model1.PurchaseInvoiceItemsList[j].Quantity)
                                {
                                    model1.PurchaseInvoice.Doc_Status = "Closed";
                                    if (model1.PurchaseInvoice.TargetDocId == "")
                                    {
                                        model1.PurchaseInvoice.TargetDocId = Convert.ToString(model.PurchaseReturn.Purchase_Return_Id);
                                    }
                                    else
                                    {
                                        model1.PurchaseInvoice.TargetDocId = model1.PurchaseInvoice.TargetDocId + "," + Convert.ToString(model.PurchaseReturn.Purchase_Return_Id);
                                    }


                                    model1.PurchaseInvoiceItemsList[j].Purchase_InvoiceItem_Id = model1.PurchaseInvoiceItemsList[j].Purchase_InvoiceItem_Id;
                                    model1.PurchaseInvoiceItemsList[j].Purchase_Invoice_Id     = model1.PurchaseInvoiceItemsList[j].Purchase_Invoice_Id;
                                    //model1.PurchaseInvoiceItemsList[j].Quoted_date = model1.PurchaseInvoiceItemsList[j].Quoted_date;
                                    model1.PurchaseInvoiceItemsList[j].Inv_Return_Qty   = model1.PurchaseInvoiceItemsList[j].Inv_Return_Qty + Convert.ToInt32(model.PurchaseInvoiceItemsList[j].Quantity);
                                    model1.PurchaseInvoiceItemsList[j].Product_id       = model.PurchaseInvoiceItemsList[j].Product_id;
                                    model1.PurchaseInvoiceItemsList[j].Unit_price       = model.PurchaseInvoiceItemsList[j].Unit_price;
                                    model1.PurchaseInvoiceItemsList[j].Discount_percent = model.PurchaseInvoiceItemsList[j].Discount_percent;
                                    model1.PurchaseInvoiceItemsList[j].Vat_Code         = model.PurchaseInvoiceItemsList[j].Vat_Code;
                                    model1.PurchaseInvoiceItemsList[j].LineTotal        = model.PurchaseInvoiceItemsList[j].LineTotal;
                                }
                                else if (model1.PurchaseInvoiceItemsList[j].Product_id == model.PurchaseInvoiceItemsList[j].Product_id && model.PurchaseInvoiceItemsList[j].Quantity < model1.PurchaseInvoiceItemsList[j].Quantity)
                                {
                                    model1.PurchaseInvoice.Doc_Status = "Open";
                                    if (model1.PurchaseInvoice.TargetDocId == "")
                                    {
                                        model1.PurchaseInvoice.TargetDocId = Convert.ToString(model.PurchaseReturn.Purchase_Return_Id);
                                    }
                                    else
                                    {
                                        model1.PurchaseInvoice.TargetDocId = model1.PurchaseInvoice.TargetDocId + "," + Convert.ToString(model.PurchaseReturn.Purchase_Return_Id);
                                    }

                                    model1.PurchaseInvoiceItemsList[j].Purchase_InvoiceItem_Id = model1.PurchaseInvoiceItemsList[j].Purchase_InvoiceItem_Id;
                                    model1.PurchaseInvoiceItemsList[j].Purchase_Invoice_Id     = model1.PurchaseInvoiceItemsList[j].Purchase_Invoice_Id;
                                    //model1.PurchaseInvoiceItemsList[j].Quoted_date = model1.PurchaseInvoiceItemsList[j].Quoted_date;
                                    model1.PurchaseInvoiceItemsList[j].Inv_Return_Qty   = model1.PurchaseInvoiceItemsList[j].Inv_Return_Qty + Convert.ToInt32(model.PurchaseInvoiceItemsList[j].Quantity);
                                    model1.PurchaseInvoiceItemsList[j].Product_id       = model.PurchaseInvoiceItemsList[j].Product_id;
                                    model1.PurchaseInvoiceItemsList[j].Unit_price       = model.PurchaseInvoiceItemsList[j].Unit_price;
                                    model1.PurchaseInvoiceItemsList[j].Discount_percent = model.PurchaseInvoiceItemsList[j].Discount_percent;
                                    model1.PurchaseInvoiceItemsList[j].Vat_Code         = model.PurchaseInvoiceItemsList[j].Vat_Code;
                                    model1.PurchaseInvoiceItemsList[j].LineTotal        = model.PurchaseInvoiceItemsList[j].LineTotal;
                                }
                            }

                            // model1.PurchaseInvoice.Creating_Branch = CurrentBranchId;
                            model1.PurchaseInvoice.Created_Branc_Id   = CurrentBranchId; //currentUser.Created_Branch_Id;
                            model1.PurchaseInvoice.Created_Date       = DateTime.Now;
                            model1.PurchaseInvoice.Created_User_Id    = CurrentUser.Id;  //currentUser.Created_User_Id;  //GetUserId()
                            model1.PurchaseInvoice.Modified_User_Id   = CurrentUser.Id;  //currentUser.Modified_User_Id;
                            model1.PurchaseInvoice.Modified_Date      = DateTime.Now;
                            model1.PurchaseInvoice.Modified_Branch_Id = CurrentBranchId; //currentUser.Modified_Branch_Id;

                            purchasereturnrepository.UpdateInvoice(model1.PurchaseInvoice, model1.PurchaseInvoiceItemsList, ref ErrorMessage);
                            return(RedirectToAction("Index", "PurchaseReturns"));
                        }
                        else
                        {
                            ViewBag.AppErrorMessage = ErrorMessage;
                            return(View("Error"));
                        }



                        return(RedirectToAction("Index", "PurchaseReturns"));
                    }
                }


                else if (submitButton == "Update")
                {
                    model.PurchaseReturn.Doc_Status         = "open";
                    model.PurchaseReturn.Modified_Branch_Id = CurrentBranchId; //CurrentBranchId;
                    model.PurchaseReturn.Modified_Date      = DateTime.Now;
                    model.PurchaseReturn.Modified_User_Id   = CurrentUser.Id;  //CurrentUser.Id;

                    var QuotationList = model.PurchaseReturnitemsList.Where(x => x.IsDummy == 0);
                    model.PurchaseReturnitemsList = QuotationList.ToList();

                    for (int i = 0; i < model.PurchaseReturnitemsList.Count; i++)
                    {
                        model.PurchaseReturnitemsList[i].BaseDocLink = "N";
                    }
                    if (purchasereturnrepository.UpdateReturn(model.PurchaseReturn, model.PurchaseReturnitemsList, ref ErrorMessage))
                    {
                        return(RedirectToAction("Index", "PurchaseReturns"));
                    }
                    else
                    {
                        ViewBag.AppErrorMessage = ErrorMessage;
                        return(View("Error"));
                    }
                }

                return(RedirectToAction("Index", "PurchaseReturns"));
            }
            catch (OptimisticConcurrencyException ex)
            {
                ObjectStateEntry entry = ex.StateEntries[0];
                PurchaseReturn   post  = entry.Entity as PurchaseReturn; //Post is the entity name he is using. Rename it with yours
                Console.WriteLine("Failed to save {0} because it was changed in the database", post.Purchase_Return_Id);
                return(View("Error"));

                //catch (Exception ex)
                //{
                //    ExceptionHandler.LogException(ex);
                //    ViewBag.AppErrorMessage = ex.Message;
                //    return View("Error");
                //}
            }
        }