public List <OtherInvoiceList> GetFilteredOtherInvoiceList(DateTime FromDate, DateTime ToDate, int?AgentId, string UsersId, int?TypesId)
{
List <OtherInvoiceList> otherInvList = new List <OtherInvoiceList>();
try
{
using (SqlConnection connection = DataAccess.CreateConnection())
{
SqlCommand command = DataAccess.CreateCommand(connection);
DataAccess.CreateStoredprocedure(command, "GetFilteredOtherInvoiceList_SP");
DataAccess.AddInParameter(command, "@FromDate", SqlDbType.VarChar, FromDate.ToString("MM/dd/yyyy"));
DataAccess.AddInParameter(command, "@ToDate", SqlDbType.VarChar, ToDate.ToString("MM/dd/yyyy"));
DataAccess.AddInParameter(command, "@AgentId", SqlDbType.Int, AgentId);
DataAccess.AddInParameter(command, "@UsersId", SqlDbType.VarChar, UsersId);
DataAccess.AddInParameter(command, "@TypesId", SqlDbType.Int, TypesId);
SqlDataReader reader = DataAccess.ExecuteReader(command);
if (reader != null)
{
while (reader.Read())
{
OtherInvoiceList otherInv = new OtherInvoiceList();
otherInv.ACAmount = reader["ACAmount"] is DBNull ? 0 : Convert.ToDouble(reader["ACAmount"]);
otherInv.Agent = reader["Agent"] is DBNull ? string.Empty : (String)reader["Agent"];
otherInv.CreatedOn = reader["CreatedOn"] is DBNull ? string.Empty : (Convert.ToString(reader["CreatedOn"]));
otherInv.Due = reader["Due"] is DBNull ? 0 : Convert.ToDouble(reader["Due"]);
otherInv.InvoiceId = reader["InvoiceId"] is DBNull ? 0 : Convert.ToInt32(reader["InvoiceId"]);
otherInv.InvoiceType = reader["InvoiceType"] is DBNull ? string.Empty : Convert.ToString(reader["InvoiceType"]);
otherInv.Paid = reader["Paid"] is DBNull ? 0 : Convert.ToDouble(reader["Paid"]);
otherInv.VAmount = reader["VAmount"] is DBNull ? 0 : Convert.ToDouble(reader["VAmount"]);
otherInv.VDue = reader["VDue"] is DBNull ? 0 : Convert.ToDouble(reader["VDue"]);
otherInv.Vendor = reader["Vendor"] is DBNull ? string.Empty : (String)reader["Vendor"];
otherInv.VPaid = reader["VPaid"] is DBNull ? 0 : Convert.ToDouble(reader["VPaid"]);
otherInv.User = reader["UserName"] is DBNull ? string.Empty : (String)reader["UserName"];
otherInvList.Add(otherInv);
}
}
reader.Close();
return(otherInvList);
}
}
catch (Exception ex)
{
return(otherInvList);
}
}
public List <OtherInvoiceList> GetVendorOutstandingOtherInvoiceList(int VendorId)
{
List <OtherInvoiceList> otherInvList = new List <OtherInvoiceList>();
try
{
using (SqlConnection connection = DataAccess.CreateConnection())
{
SqlCommand command = DataAccess.CreateCommand(connection);
DataAccess.CreateStoredprocedure(command, "GetVendorOutstandingOtherInvoiceList_SP");
DataAccess.AddInParameter(command, "@VendorId", SqlDbType.Int, VendorId);
SqlDataReader reader = DataAccess.ExecuteReader(command);
if (reader != null)
{
while (reader.Read())
{
OtherInvoiceList otherInv = new OtherInvoiceList();
otherInv.ACAmount = reader["ACAmount"] is DBNull ? 0 : Convert.ToDouble(reader["ACAmount"]);
otherInv.Agent = reader["Agent"] is DBNull ? string.Empty : (String)reader["Agent"];
otherInv.CreatedOn = reader["CreatedOn"] is DBNull ? string.Empty : (Convert.ToString(reader["CreatedOn"]));
otherInv.Due = reader["Due"] is DBNull ? 0 : Convert.ToDouble(reader["Due"]);
otherInv.InvoiceId = reader["InvoiceId"] is DBNull ? 0 : Convert.ToInt32(reader["InvoiceId"]);
otherInv.InvoiceType = reader["InvoiceType"] is DBNull ? string.Empty : Convert.ToString(reader["InvoiceType"]);
otherInv.Paid = reader["Paid"] is DBNull ? 0 : Convert.ToDouble(reader["Paid"]);
otherInv.VAmount = reader["VAmount"] is DBNull ? 0 : Convert.ToDouble(reader["VAmount"]);
otherInv.VDue = reader["VDue"] is DBNull ? 0 : Convert.ToDouble(reader["VDue"]);
otherInv.Vendor = reader["Vendor"] is DBNull ? string.Empty : (String)reader["Vendor"];
otherInv.VPaid = reader["VPaid"] is DBNull ? 0 : Convert.ToDouble(reader["VPaid"]);
otherInv.User = reader["UserName"] is DBNull ? string.Empty : (String)reader["UserName"];
otherInvList.Add(otherInv);
}
}
reader.Close();
return(otherInvList);
}
}
catch (Exception ex)
{
return(otherInvList);
}
}
