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(); }