public ActionResult Edit(ProformaInvoice model) { ViewBag.Title = "Edit"; model.OrganizationId = OrganizationId; model.CreatedDate = System.DateTime.Now; model.CreatedBy = UserID.ToString(); { try { var result2 = new ProformaInvoiceRepository().DeleteProformaInvoiceDT(model.ProformaInvoiceId); string id = new ProformaInvoiceRepository().UpdateProformaInvoiceHD(model); string id1 = new ProformaInvoiceRepository().InsertProformaInvoiceDT(model); TempData["success"] = "Updated successfully. Proforma Invoice Reference No. is " + id; TempData["error"] = ""; return(RedirectToAction("Index", new { type = model.isProjectBased })); } catch (SqlException sx) { TempData["error"] = "Some error occured while connecting to database. Please check your network connection and try again.|" + sx.Message; } catch (NullReferenceException nx) { TempData["error"] = "Some required data was missing. Please try again.|" + nx.Message; } catch (Exception ex) { TempData["error"] = "Some error occured. Please try again.|" + ex.Message; } return(View("Edit", model)); } }
public ActionResult PendingProforma(int?ProjectBased) { var repo = new ProformaInvoiceRepository(); ViewBag.ProjectBased = ProjectBased; IEnumerable <PendingSO> pendingSO = repo.GetSaleOrdersForPerforma(ProjectBased ?? 0); return(View(pendingSO)); }
public ActionResult Edit(int type, int id = 0) { if (id == 0) { return(RedirectToAction("Index", "Home", new { type = type })); } ProformaInvoice model = new ProformaInvoiceRepository().GetProformaInvoiceHdDetails(id); //model.SymbolName = new CurrencyRepository().GetCurrencyFrmOrganization(OrganizationId).SymbolName; model.Items = new ProformaInvoiceRepository().GetProformaInvoiceItemDetails(id); model.PrintDescriptions = new ProformaInvoiceRepository().GetPrintDescription(id); return(View(model)); }
public ActionResult Create(int?SaleOrderId) { ProformaInvoiceRepository repo = new ProformaInvoiceRepository(); CurrencyRepository repo1 = new CurrencyRepository(); ProformaInvoice model = repo.GetSaleOrderForPorforma(SaleOrderId ?? 0); //model.SymbolName = repo1.GetCurrencyFrmOrganization(OrganizationId).SymbolName; var PIList = repo.GetPorformaInvoiceData(model.SaleOrderId); model.Items = new List <ProformaInvoiceItem>(); foreach (var item in PIList) { model.Items.Add(new ProformaInvoiceItem { WorkDescription = item.WorkDescription, VehicleModelName = item.VehicleModelName, Quantity = item.Quantity, UnitName = item.UnitName, Rate = item.Rate, Amount = item.Amount, Discount = item.Discount, SaleOrderItemId = item.SaleOrderItemId }); } string internalId = ""; try { internalId = DatabaseCommonRepository.GetNextDocNo(6, OrganizationId); } catch (NullReferenceException nx) { TempData["success"] = ""; TempData["error"] = "Some required data was missing. Please try again.|" + nx.Message; } catch (Exception ex) { TempData["success"] = ""; TempData["error"] = "Some error occurred. Please try again.|" + ex.Message; } model.ProformaInvoiceRefNo = internalId; model.ProformaInvoiceDate = DateTime.Now; model.PrintDescriptions = new ProformaInvoiceRepository().GetPrintDescriptions(SaleOrderId); if (model.PrintDescriptions == null || model.PrintDescriptions.Count == 0) { model.PrintDescriptions.Add(new PrintDescription()); } return(View(model)); }
public ActionResult Create(ProformaInvoice model) { try { model.OrganizationId = OrganizationId; model.CreatedDate = System.DateTime.Now; model.CreatedBy = UserID.ToString(); string id = new ProformaInvoiceRepository().InsertProformaInvoice(model); if (id.Split('|')[0] != "0") { TempData["success"] = "Saved successfully. Proforma Invoice No. is " + id.Split('|')[1]; //TempData["error"] = ""; return(RedirectToAction("PendingProforma", new { ProjectBased = model.isProjectBased })); } else { throw new Exception(); } } catch (SqlException sx) { TempData["error"] = "Some error occured while connecting to database. Please check your network connection and try again.|" + sx.Message; } catch (NullReferenceException nx) { TempData["error"] = "Some required data was missing. Please try again.|" + nx.Message; } catch (Exception ex) { TempData["error"] = "Some error occured. Please try again.|" + ex.Message; } TempData["success"] = ""; return(View(model)); }
public ActionResult ProformaInvoice(int Id) { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "ProformaInvoiceee.rpt")); DataSet ds = new DataSet(); ds.Tables.Add("Head"); ds.Tables.Add("Items"); //-------HEAD ds.Tables["Head"].Columns.Add("ProformaInvoiceRefNo"); ds.Tables["Head"].Columns.Add("ProformaInvoiceDate"); ds.Tables["Head"].Columns.Add("CustomerName"); ds.Tables["Head"].Columns.Add("Address"); ds.Tables["Head"].Columns.Add("CustomerAddress"); ds.Tables["Head"].Columns.Add("CustomerOrderRef"); ds.Tables["Head"].Columns.Add("SaleOrderRefNo"); ds.Tables["Head"].Columns.Add("PaymentTerms"); ds.Tables["Head"].Columns.Add("Image1"); ds.Tables["Head"].Columns.Add("OrganizationName"); ds.Tables["Head"].Columns.Add("OrganizationRefNo"); ds.Tables["Head"].Columns.Add("DoorNo"); ds.Tables["Head"].Columns.Add("Street"); ds.Tables["Head"].Columns.Add("State"); ds.Tables["Head"].Columns.Add("Country"); ds.Tables["Head"].Columns.Add("Currency"); ds.Tables["Head"].Columns.Add("Phone"); ds.Tables["Head"].Columns.Add("Fax"); ds.Tables["Head"].Columns.Add("Email"); ds.Tables["Head"].Columns.Add("ContactPerson"); ds.Tables["Head"].Columns.Add("Zip"); ds.Tables["Head"].Columns.Add("CreateUser"); ds.Tables["Head"].Columns.Add("CreateSig"); ds.Tables["Head"].Columns.Add("CreatedDes"); //-------DT ds.Tables["Items"].Columns.Add("PrintDescription"); ds.Tables["Items"].Columns.Add("Quantity"); ds.Tables["Items"].Columns.Add("UoM"); ds.Tables["Items"].Columns.Add("PriceEach"); ds.Tables["Items"].Columns.Add("Amount"); ProformaInvoiceRepository repo = new ProformaInvoiceRepository(); var Head = repo.GetProformaInvoiceHD(Id); DataRow dr = ds.Tables["Head"].NewRow(); dr["ProformaInvoiceRefNo"] = Head.ProformaInvoiceRefNo; dr["ProformaInvoiceDate"] = Head.ProformaInvoiceDate.ToString("dd-MMM-yyyy"); dr["CustomerName"] = Head.CustomerName; dr["Address"] = Head.CustomerAddress; dr["CustomerAddress"] = Head.CustomerAddress; dr["CustomerOrderRef"] = Head.CustomerOrderRef; dr["SaleOrderRefNo"] = Head.SaleOrderRefNo; dr["PaymentTerms"] = Head.PaymentTerms; dr["OrganizationName"] = Head.OrganizationName; dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1; dr["OrganizationRefNo"] = Head.OrganizationRefNo; dr["DoorNo"] = Head.DoorNo; dr["Street"] = Head.Street; dr["State"] = Head.State; dr["Country"] = Head.CountryName; dr["Currency"] = Head.CurrencyName; dr["Phone"] = Head.Phone; dr["Fax"] = Head.Fax; dr["Email"] = Head.Email; dr["ContactPerson"] = Head.ContactPerson; dr["Zip"] = Head.Zip; dr["CreateUser"] = Head.CreateUser; dr["CreateSig"] = Server.MapPath("~/App_images/") + Head.CreateSig; dr["CreatedDes"] = Head.CreatedDes; ds.Tables["Head"].Rows.Add(dr); ProformaInvoiceItemRepository repo1 = new ProformaInvoiceItemRepository(); var Items = repo1.GetProformaInvoiceItemDT(Id); foreach (var item in Items) { DataRow dri = ds.Tables["Items"].NewRow(); dri["PrintDescription"] = item.Description; dri["Quantity"] = item.Quantity; dri["PriceEach"] = item.PriceEach; dri["Amount"] = item.Amount; dri["UoM"] = item.UoM; ds.Tables["Items"].Rows.Add(dri); } ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "ProformaInvoiceee.xml"), XmlWriteMode.WriteSchema); rd.SetDataSource(ds); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf")); } catch (Exception ex) { throw; } }