public ActionResult Create(FormCollection collection) { var SelectedIds = collection.GetValues("selectedAddressesIds"); List <int> PolicyIds = new List <int>(); if (SelectedIds != null) { foreach (var item in SelectedIds) { if (item.ToString() != "false") { PolicyIds.Add(Convert.ToInt32(item.ToString())); } } } CustomerInvoice Model = new CustomerInvoiceRepository().GetPolicyDetailsForInvoice(PolicyIds); Model.Items = new CustomerInvoiceRepository().GetPolicyDetailsForInvoiceDetails(PolicyIds); var internalid = CustomerInvoiceRepository.GetNextDocNo(); Model.CusInvoiceRefNo = "CIB/INV/" + internalid; Model.CusInvoiceDate = DateTime.Now; return(View(Model)); }
public ActionResult PreviousInvoicePartial(DateTime?FromDate, DateTime?ToDate, string ClientName = "") { FromDate = FromDate ?? FYStartdate; ToDate = ToDate ?? DateTime.Now; List <Invoice> obj = new List <Invoice>(); obj = new CustomerInvoiceRepository().InvoiceList(FromDate, ToDate, ClientName); return(PartialView("_PreviousInvoiceList", obj)); }
public ActionResult Invoice(int Paymentid) { Invoice objInvoice = new CustomerInvoiceRepository().GetInvoice(Paymentid); var internalid = CustomerInvoiceRepository.GetNextRefNo(); objInvoice.CustInvoiceRefNo = internalid; objInvoice.CustInvoiceDate = DateTime.Now; objInvoice.BillDueDate = DateTime.Now; objInvoice.CustomerInvoiceItem = new CustomerInvoiceRepository().GetInvoiceItem(Paymentid); return(View("Invoice", objInvoice)); //return View(); }
public ActionResult DeleteInvoice(int id = 0) { try { if (id == 0) { return(RedirectToAction("Index", "Home")); } string result = new CustomerInvoiceRepository().DeleteInvoice(id); TempData["Success"] = "Deleted Successfully!"; return(RedirectToAction("PreviousInvoice")); } catch (Exception) { TempData["error"] = "Some error occured while deleting. Please try again."; return(RedirectToAction("Invoice", new { id = id })); } }
public ActionResult Invoice(Invoice model) { model.CreatedBy = UserID.ToString(); model.CreatedDate = System.DateTime.Now; if (!ModelState.IsValid) { var allErrors = ModelState.Values.SelectMany(v => v.Errors); return(View(model)); } Result res = new CustomerInvoiceRepository().Insert(model); if (res.Value) { TempData["Success"] = "Saved Successfully!"; } else { } return(RedirectToAction("paymentFollowup", "Payment")); }
public ActionResult Update(Invoice model) { try { model.CreatedBy = UserID.ToString(); model.CreatedDate = System.DateTime.Now; var success = new CustomerInvoiceRepository().UpdateInvoice(model); if (success <= 0) { throw new Exception(); } TempData["success"] = "Updated successfully (" + model.CustInvoiceRefNo + ")"; return(RedirectToAction("PreviousInvoice")); } catch (Exception) { TempData["error"] = "Some error occured while saving. Please try again."; return(View("Invoice", model)); } }
public ActionResult Update(int id) { try { if (id == 0) { TempData["error"] = "That was an invalid/unknown request. Please try again."; return(RedirectToAction("Index", "Home")); } var model = new CustomerInvoiceRepository().GetInvoiceView(id); if (model == null) { TempData["error"] = "Could not find the requested Purchase Indent. Please try again."; return(RedirectToAction("Index", "Home")); } return(View("Invoice", model)); } catch (Exception) { TempData["error"] = "Some error occured. Please try again."; return(RedirectToAction("PreviousInvoice")); } }
public ActionResult InvoiceReport(int Id) { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "CustomerInvoice.rpt")); DataSet ds = new DataSet(); ds.Tables.Add("Head"); ds.Tables.Add("Items"); #region creating Head table ds.Tables["Head"].Columns.Add("CustInvoiceRefNo"); ds.Tables["Head"].Columns.Add("CustInvoiceDate"); ds.Tables["Head"].Columns.Add("ClientName"); ds.Tables["Head"].Columns.Add("ProjectOrderRefNo"); ds.Tables["Head"].Columns.Add("Address1"); ds.Tables["Head"].Columns.Add("Address2"); ds.Tables["Head"].Columns.Add("Address3"); ds.Tables["Head"].Columns.Add("SpecialRemarks"); ds.Tables["Head"].Columns.Add("PaymentTerms"); ds.Tables["Head"].Columns.Add("AdditionalRemarks"); ds.Tables["Head"].Columns.Add("AddAmount"); ds.Tables["Head"].Columns.Add("DeductionRemarks"); ds.Tables["Head"].Columns.Add("DedAmount"); ds.Tables["Head"].Columns.Add("BillDueDate"); #endregion #region creating Item Table ds.Tables["Items"].Columns.Add("ProjectRefNo"); ds.Tables["Items"].Columns.Add("ProjectDate"); ds.Tables["Items"].Columns.Add("ProjectEnquiry"); ds.Tables["Items"].Columns.Add("Description"); ds.Tables["Items"].Columns.Add("Amount"); ds.Tables["Items"].Columns.Add("InvoiceAmount"); #endregion #region store data to Head table CustomerInvoiceRepository repo = new CustomerInvoiceRepository(); var Head = repo.CustomerInvoiceHdforPrint(Id); DataRow dr = ds.Tables["Head"].NewRow(); dr["CustInvoiceRefNo"] = Head.CustInvoiceRefNo; dr["CustInvoiceDate"] = Head.CustInvoiceDate.ToString("dd-MMM-yyyy"); dr["ClientName"] = Head.ClientName; dr["ProjectOrderRefNo"] = Head.ProjectOrderRefNo; dr["Address1"] = Head.Address1; dr["Address2"] = Head.Address2; dr["Address3"] = Head.Address3; dr["SpecialRemarks"] = Head.SpecialRemarks; dr["PaymentTerms"] = Head.PaymentTerms; dr["AdditionalRemarks"] = Head.AdditionalRemarks; dr["AddAmount"] = Head.AddAmount; dr["DeductionRemarks"] = Head.DeductionRemarks; dr["DedAmount"] = Head.DedAmount; dr["BillDueDate"] = Head.BillDueDate.ToString("dd-MMM-yyyy"); ds.Tables["Head"].Rows.Add(dr); #endregion #region store data to Items Table CustomerInvoiceRepository repo1 = new CustomerInvoiceRepository(); var Items = repo1.customerInvoiceItemforPrint(Id); foreach (var item in Items) { DataRow dri = ds.Tables["Items"].NewRow(); dri["ProjectRefNo"] = item.ProjectRefNo; dri["ProjectDate"] = item.ProjectDate.ToString("dd-MMM-yyyy"); dri["ProjectEnquiry"] = item.ProjectEnquiry; dri["Description"] = item.Description; dri["Amount"] = item.Amount; dri["InvoiceAmount"] = item.InvoiceAmount; ds.Tables["Items"].Rows.Add(dri); } #endregion ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "CustomerInvoice.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"));//, String.Format("SalesInvoice{0}.pdf", Id.ToString())); } catch (Exception ex) { throw; } }
public IEnumerable <CustomerInvoices> GetCustomerInvoicesByCustomerNo(string customerNo) { var ci = CustomerInvoiceRepository.ListByCustom("CustomerNo", customerNo); return(ci); }
public RepositoryFactory() { Repository bankRepository = new Repository(new Bank()); CurrencyRepository ccyRepository = new CurrencyRepository(); Repository divRepository = new Repository(new Division()); Repository empRepository = new EmployeeRepository(new Employee()); Repository topRepository = new Repository(new TermOfPayment()); Repository unitRepository = new Repository(new Unit()); Repository cuscatRepository = new Repository(new CustomerCategory()); Repository supcatRepository = new Repository(new SupplierCategory()); Repository pricecatRepository = new Repository(new PriceCategory()); Repository taxRepository = new Repository(new Tax()); Repository prtGroupRepository = new Repository(new PartGroup()); Repository warehouseRepository = new Repository(new Warehouse()); Repository prtCategoryRepository = new Repository(new PartCategory()); Repository docTypeRepository = new Repository(new DocumentType()); Repository excRateRepository = new Repository(new ExchangeRate()); CustomerRepository customerRepository = new CustomerRepository(); SupplierRepository supplierRepository = new SupplierRepository(); Repository yearRepository = new YearRepository(); Repository partRepository = new PartRepository(new Part()); StockTakingRepository stocktakingRepository = new StockTakingRepository(); UserRepository userRepository = new UserRepository(new User()); GeneralSetupRepository generalsetupRepository = new GeneralSetupRepository(); PurchaseOrderRepository poRepository = new PurchaseOrderRepository(); PeriodRepository periodRepository = new PeriodRepository(); UserSettingsRepository usRepository = new UserSettingsRepository(); GoodReceiveNoteRepository grnRepository = new GoodReceiveNoteRepository(); PurchaseReturnRepository prRepository = new PurchaseReturnRepository(); SupplierInvoiceRepository siRepository = new SupplierInvoiceRepository(); SupplierOutStandingInvoiceRepository soiRepository = new SupplierOutStandingInvoiceRepository(); SupplierInvoiceJournalRepository sijRepository = new SupplierInvoiceJournalRepository(); PaymentRepository payRepository = new PaymentRepository(); APDebitNoteRepository apdnRepository = new APDebitNoteRepository(); ProcessTransactionRepository prtrRepository = new ProcessTransactionRepository(); SalesOrderRepository slsorderRepository = new SalesOrderRepository(); DeliveryOrderRepository doRepository = new DeliveryOrderRepository(); SalesReturnRepository srRepository = new SalesReturnRepository(); CustomerOutStandingInvoiceRepository coirRepository = new CustomerOutStandingInvoiceRepository(); CustomerInvoiceRepository cirRepository = new CustomerInvoiceRepository(); ReceiptRepository rcptRepository = new ReceiptRepository(); ARCreditNoteRepository arcrRepository = new ARCreditNoteRepository(); CustomerInvoiceJournalRepository cijRepository = new CustomerInvoiceJournalRepository(); OpeningStockRepository opstRepository = new OpeningStockRepository(); POSRepository posRepository = new POSRepository(); m_listService.Add(BANK_REPOSITORY, bankRepository); m_listService.Add(CURRENCY_REPOSITORY, ccyRepository); m_listService.Add(DIVISION_REPOSITORY, divRepository); m_listService.Add(EMPLOYEE_REPOSITORY, empRepository); m_listService.Add(TOP_REPOSITORY, topRepository); m_listService.Add(UNIT_REPOSITORY, unitRepository); m_listService.Add(CUSTOMER_CATEGORY_REPOSITORY, cuscatRepository); m_listService.Add(SUPPLIER_CATEGORY_REPOSITORY, supcatRepository); m_listService.Add(PRICE_CATEGORY_REPOSITORY, pricecatRepository); m_listService.Add(TAX_REPOSITORY, taxRepository); m_listService.Add(PART_GROUP_REPOSITORY, prtGroupRepository); m_listService.Add(WAREHOUSE_REPOSITORY, warehouseRepository); m_listService.Add(PART_CATEGORY_REPOSITORY, prtCategoryRepository); m_listService.Add(DOC_TYPE_REPOSITORY, docTypeRepository); m_listService.Add(EXCHANGE_RATE_REPOSITORY, excRateRepository); m_listService.Add(CUSTOMER_REPOSITORY, customerRepository); m_listService.Add(SUPPLIER_REPOSITORY, supplierRepository); m_listService.Add(YEAR_REPOSITORY, yearRepository); m_listService.Add(PART_REPOSITORY, partRepository); m_listService.Add(STOCKTAKING_REPOSITORY, stocktakingRepository); m_listService.Add(USER_REPOSITORY, userRepository); m_listService.Add(GENERAL_SETUP_REPOSITORY, generalsetupRepository); m_listService.Add(PURCHASEORDER_REPOSITORY, poRepository); m_listService.Add(PERIOD_REPOSITORY, periodRepository); m_listService.Add(USER_SETTING_REPOSITORY, usRepository); m_listService.Add(GOODRECEIVENOTE_REPOSITORY, grnRepository); m_listService.Add(PURCHASE_RETURN_REPOSITORY, prRepository); m_listService.Add(SUPPLIERINVOICE_REPOSITORY, siRepository); m_listService.Add(SUPPLIERINVOICE_JOURNAL_REPOSITORY, sijRepository); m_listService.Add(SUPPLIER_OUTSTANDING_INVOICE_REPOSITORY, soiRepository); m_listService.Add(PAYMENT_REPOSITORY, payRepository); m_listService.Add(APDEBITNOTE_REPOSITORY, apdnRepository); m_listService.Add(PROCESS_TRANSACTION_REPOSITORY, prtrRepository); m_listService.Add(SALES_ORDER_REPOSITORY, slsorderRepository); m_listService.Add(DELIVERY_ORDER_REPOSITORY, doRepository); m_listService.Add(SALES_RETURN_REPOSITORY, srRepository); m_listService.Add(CUSTOMER_OUTSTANDING_INVOICE_REPOSITORY, coirRepository); m_listService.Add(CUSTOMERINVOICE_REPOSITORY, cirRepository); m_listService.Add(RECEIPT_REPOSITORY, rcptRepository); m_listService.Add(ARCREDITNOTE_REPOSITORY, arcrRepository); m_listService.Add(CUSTOMERINVOICE_JOURNAL_REPOSITORY, cijRepository); m_listService.Add(OPENING_STOCK_REPOSITORY, opstRepository); m_listService.Add(POS_REPOSITORY, posRepository); }
public ActionResult Print(int Id) { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "CustomerInvoice.rpt")); DataSet ds = new DataSet(); ds.Tables.Add("Head"); ds.Tables.Add("Items"); // //-------HEAD ds.Tables["Head"].Columns.Add("DocumentNo"); ds.Tables["Head"].Columns.Add("DocumentDate"); ds.Tables["Head"].Columns.Add("Location"); ds.Tables["Head"].Columns.Add("InsuredName"); ds.Tables["Head"].Columns.Add("SpecialRemarks"); //-------DT ds.Tables["Items"].Columns.Add("EffectiveDate"); ds.Tables["Items"].Columns.Add("InsuranceType"); ds.Tables["Items"].Columns.Add("PolicyOrEndorseNo"); ds.Tables["Items"].Columns.Add("Company"); ds.Tables["Items"].Columns.Add("Premium"); ds.Tables["Items"].Columns.Add("Remarks"); CustomerInvoiceRepository repo = new CustomerInvoiceRepository(); var Head = repo.GetCustomerInvoiceHdDetails(Id); DataRow dr = ds.Tables["Head"].NewRow(); dr["DocumentNo"] = Head.CusInvoiceRefNo; dr["DocumentDate"] = Head.CusInvoiceDate.Value.ToString("dd-MMM-yyyy"); dr["InsuredName"] = Head.CusName; dr["SpecialRemarks"] = Head.SpecialRemarks; ds.Tables["Head"].Rows.Add(dr); var Items = repo.GetCustomerInvoicePrint(Id); foreach (var item in Items) { var CustomerInvoiceItem = new CustomerInvoiceItem { EffectiveDate = item.EffectiveDate, TranType = item.TranType, PolicyNo = item.PolicyNo, InsCmpName = item.InsCmpName, TotalPremium = item.TotalPremium, Remarks = item.Remarks }; DataRow dri = ds.Tables["Items"].NewRow(); dri["EffectiveDate"] = CustomerInvoiceItem.EffectiveDate.Value.ToString("dd-MMM-yyyy"); dri["InsuranceType"] = CustomerInvoiceItem.TranType; dri["PolicyOrEndorseNo"] = CustomerInvoiceItem.PolicyNo; dri["Company"] = CustomerInvoiceItem.InsCmpName; dri["Premium"] = CustomerInvoiceItem.TotalPremium; dri["Remarks"] = CustomerInvoiceItem.Remarks; ds.Tables["Items"].Rows.Add(dri); } ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "CustomerInvoice.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; } }