public List<InvoiceListDTO> getInvoiceList(int MeterTypeID, DateTime InvoiceStartDate, DateTime InvoiceFinishDate, long? CustomerID, long? CustomerGroupID) { sqlprm.Clear(); sqlprm.Add("MeterTypeID", MeterTypeID); sqlprm.Add("InvoiceStartDate", InvoiceStartDate); sqlprm.Add("InvoiceFinishDate", InvoiceFinishDate); sqlprm.Add("CustomerID", CustomerID); sqlprm.Add("CustomerGroupID", CustomerGroupID); DataTable dtInvList = this.sqlOp.executeSPInstantly("OSYS..sp_GetInvoiceList", sqlprm); InvoiceListDTO inv; List<InvoiceListDTO> invoiceList = new List<InvoiceListDTO>(); /* Invoices.ID ,Customer.Name ,CustomerGroup.Name as GroupName ,MeterTypes.Name MeterTypeName ,Invoices.InvoiceDate ,Meters.SerialNo ,ReportDate ,KDV ,TotalCost ,KDVTotalCost */ foreach (DataRow row in dtInvList.Rows) { inv = new InvoiceListDTO(); inv.Id = Convert.ToInt64(row["ID"]); inv.CustomerID = Convert.ToInt32(row["CustomerID"]); inv.Name = row["Name"] == null ? null : row["Name"].ToString(); inv.GroupName = row["GroupName"] == null ? null : row["GroupName"].ToString(); inv.InvoiceDate = Convert.ToDateTime(row["InvoiceDate"]); inv.SerialNo = row["SerialNo"] == null ? null : row["SerialNo"].ToString(); inv.MeterTypeName = row["MeterTypeName"] == null ? null : row["MeterTypeName"].ToString(); inv.KDV = Convert.ToDecimal(row["Kdv"]); inv.KDVTotalCost = Convert.ToDecimal(row["KdvTotalCost"]); inv.TotalCost = Convert.ToDecimal(row["TotalCost"]); invoiceList.Add(inv); } dtInvList.Clear(); return invoiceList; }
public List<InvoiceListDTO> getInvoiceByCustomerID(long customerID, bool isPaid) { sqlprm = new Dictionary<string, object>(); sqlprm.Add("customerID", customerID); sqlprm.Add("isPaid", isPaid); DataTable dtInvList = this.sqlOp.executeSPInstantly("OSYS..sp_GetInvoiceByCustomerID", sqlprm); InvoiceListDTO inv; List<InvoiceListDTO> invoiceList = new List<InvoiceListDTO>(); foreach (DataRow row in dtInvList.Rows) { inv = new InvoiceListDTO(); inv.CustomerID = Convert.ToInt32(row["CustomerID"]); inv.InvoiceDate = Convert.ToDateTime(row["InvoiceDate"]); inv.FinalPaymentDate = Convert.ToDateTime(row["FinalPaymentDate"]); inv.PaymentDate = Convert.ToDateTime(row["PaymentDate"]); inv.IsPaid = Convert.ToBoolean(row["IsPaid"]); inv.MeterNo = row["MeterNo"] == null ? null : row["MeterNo"].ToString(); inv.MeterTypeName = row["MeterTypeName"] == null ? null : row["MeterTypeName"].ToString(); inv.KDV = Convert.ToDecimal(row["KDV"]); inv.KDVTotalCost = Convert.ToDecimal(row["KDVTotalCost"]); inv.TotalCost = Convert.ToDecimal(row["TotalCost"]); invoiceList.Add(inv); } dtInvList.Clear(); return invoiceList; }