public CustomersStatementEntity GetAllUnPaidInvoice(int customerID, string statementDate) { CustomersStatementEntity entity = new CustomersStatementEntity(); List <CustomersBalanceEntity> lstbalances = new List <CustomersBalanceEntity>(); List <CustomersInvoiceDetailsEntity> lstInvoices = new List <CustomersInvoiceDetailsEntity>(); try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { lstInvoices = entities.Database.SqlQuery <CustomersInvoiceDetailsEntity>("USP_CustomersStatementUnPaidInvoice @ID,@SDate", new SqlParameter("ID", customerID), new SqlParameter("SDate", statementDate)).ToList(); lstbalances = entities.Database.SqlQuery <CustomersBalanceEntity>("USP_GetStatementUnpaidInvoice_Summary @ID,@SDate,@Type", new SqlParameter("ID", customerID), new SqlParameter("SDate", statementDate), new SqlParameter("Type", "C")).ToList(); entity.LstBalances = lstbalances; entity.LstInvoices = lstInvoices; } } catch (Exception ex) { throw ex; } return(entity); }
public CustomersStatementEntity GetPrintUnpaidSalesInvoice(int customerID, string statementDate) { CustomersStatementEntity entity = new CustomersStatementEntity(); List <CustomersBalanceEntity> lstbalances = new List <CustomersBalanceEntity>(); List <CustomersInvoiceDetailsEntity> lstInvoices = new List <CustomersInvoiceDetailsEntity>(); //CustomersEntity data = new CustomersEntity(); try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { lstInvoices = entities.Database.SqlQuery <CustomersInvoiceDetailsEntity>("USP_CustomersStatementUnPaidInvoice @ID,@SDate", new SqlParameter("ID", customerID), new SqlParameter("SDate", statementDate)).ToList(); lstbalances = entities.Database.SqlQuery <CustomersBalanceEntity>("USP_GetStatementUnpaidInvoice_Summary @ID,@SDate,@Type", new SqlParameter("ID", customerID), new SqlParameter("SDate", statementDate), new SqlParameter("Type", "C")).ToList(); entity.LstBalances = lstbalances; entity.LstInvoices = lstInvoices; var Customer = (from cus in entities.Customers where cus.ID == customerID && (cus.IsDeleted == false || cus.IsDeleted == null) select new CustomersUnpaidInvoicesEntity { CustomerName = cus.Cus_Name, CustomerBillAddress1 = cus.Cus_Bill_to_line1, CustomerBillAddress2 = cus.Cus_Bill_to_line2, CustomerBillAddressCity = cus.Cus_Bill_to_city, CustomerBillAddressState = cus.Cus_Bill_to_state, CustomerBillAddressCountary = cus.Cus_Bill_to_country, CustomerBillPostCode = cus.Cus_Bill_to_post_code }).SingleOrDefault(); if (Customer != null) { entity.InvoiceData = Customer; } var optiondata = (from option in entities.Options select new CustomersUnpaidInvoicesEntity { CurrencyCode = option.Currency_Code }).SingleOrDefault(); if (optiondata != null) { entity.InvoiceData.CurrencyCode = optiondata.CurrencyCode; } var company = (from com in entities.CompanyDetails where (com.IsDeleted == false || com.IsDeleted == null) select new CustomersUnpaidInvoicesEntity { CompanyName = com.Comp_Name, CompanyLogo = com.Comp_Logo, CompanyRegNumber = com.Comp_Reg_No, CompanyGstNumber = com.Comp_GST_Reg_No, CompanyBillToAddressLine1 = com.Comp_Bill_to_line1, CompanyBillToAddressLine2 = com.Comp_Bill_to_line2, CompanyBillToCity = com.Comp_Bill_to_city, CompanyBillToState = com.Comp_Bill_to_state, CompanyBillToCountary = com.Comp_Bill_to_country, CompanyBillToPostCode = com.Comp_Bill_to_post_code, CompanyEmail = com.Comp_Email, CompanyFax = com.Comp_Fax }).SingleOrDefault(); if (company != null) { entity.InvoiceData.CompanyName = company.CompanyName; entity.InvoiceData.CompanyLogo = company.CompanyLogo; entity.InvoiceData.CompanyRegNumber = company.CompanyRegNumber; entity.InvoiceData.CompanyGstNumber = company.CompanyGstNumber; entity.InvoiceData.CompanyBillToAddressLine1 = company.CompanyBillToAddressLine1; entity.InvoiceData.CompanyBillToAddressLine2 = company.CompanyBillToAddressLine2; entity.InvoiceData.CompanyBillToCity = company.CompanyBillToCity; entity.InvoiceData.CompanyBillToState = company.CompanyBillToState; entity.InvoiceData.CompanyBillToCountary = company.CompanyBillToCountary; entity.InvoiceData.CompanyBillToPostCode = company.CompanyBillToPostCode; } } } catch (Exception ex) { throw ex; } return(entity); }