public DataSet MisChequePrint(MISChequePrint mischequePrint)
{
DataSet ds = new DataSet();
Connect();
try
{
HospitlLocationID();
SqlCommand cmd = new SqlCommand("ReportMisChequePrint", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@FromDate", mischequePrint.DateFrom);
cmd.Parameters.AddWithValue("@ToDate", mischequePrint.DateTo);
cmd.Parameters.AddWithValue("@BankName", mischequePrint.BankName);
cmd.Parameters.AddWithValue("@BookName", mischequePrint.BookName);
cmd.Parameters.AddWithValue("@PayeeName", mischequePrint.PayeeName);
cmd.Parameters.AddWithValue("@AccountName", mischequePrint.AccountName);
cmd.Parameters.AddWithValue("@ChequeStatus", mischequePrint.ChequeStatus);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
con.Close();
return ds;
}
catch (Exception)
{
return ds;
}
}
public ActionResult MISChequePrint()
{
MISChequePrint obj = new MISChequePrint();
return View();
}
