public DataTable getInvoiceDetails(BORetailBillDetails objBORetailBillDetails)
{
DataTable dt = new DataTable();
dt = objDALRetailBillDetails.getInvoiceDetails(objBORetailBillDetails);
return(dt);
}
public DataTable getInvoiceDetails(BORetailBillDetails objBORetailBillDetails)
{
string strCmd = "";
try
{
//Initialization
objDB_Utility = new DB_Utility();
SqlConnection con = objDB_Utility.funcOpenConnection();
strCmd = "SELECT ric.invoice_no, ric.patient_name, ric.address, ric.contact_no, ric.doctor, ric.total_mrp, ric.discount,ric.net_amount ";
strCmd += "FROM retail_invoice_record ric ";
strCmd += "WHERE ric.invoice_date BETWEEN '" + objBORetailBillDetails.fromDate + "' AND '" + objBORetailBillDetails.toDate + "' ";
if (objBORetailBillDetails.searchBy == "Invoice Number" && objBORetailBillDetails.searchText != "")
{
strCmd += "AND ric.invoice_no like '" + objBORetailBillDetails.searchText + "%' ";
}
else if (objBORetailBillDetails.searchBy == "Patient Name" && objBORetailBillDetails.searchText != "")
{
strCmd += "AND ric.patient_name like '" + objBORetailBillDetails.searchText + "%' ";
}
else if (objBORetailBillDetails.searchBy == "Contact Number" && objBORetailBillDetails.searchText != "")
{
strCmd += "AND ric.contact_no like '" + objBORetailBillDetails.searchText + "%' ";
}
else if (objBORetailBillDetails.searchBy == "Doctor" && objBORetailBillDetails.searchText != "")
{
strCmd += "AND ric.doctor like '" + objBORetailBillDetails.searchText + "%' ";
}
cmd = new SqlCommand(strCmd, con);
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "Retail_Invoice_Details");
return(ds.Tables[0]);
}
catch (Exception ex)
{
string filePath = @"..\ErrorLog.log";
using (System.IO.StreamWriter writer = new StreamWriter(filePath, true))
{
writer.WriteLine("Error Code : 00024" + Environment.NewLine + "Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace +
"" + Environment.NewLine + "Date :" + DateTime.Now.ToString());
writer.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine);
writer.WriteLine(strCmd);
}
//Send datatable with error code
DataTable dt = new DataTable();
DataColumn dc1 = new DataColumn("error");
dt.Columns.Add(dc1);
dt.Rows.Add("00024");
return(dt);
}
finally
{
objDB_Utility.funcCloseConnection();
}
}
