public ActionResult RenewalReport(RenewalSearch obj, string actionType)
{
if (string.Equals(actionType, "Download"))
{
if (!string.IsNullOrEmpty(obj.Exactdate))
{
obj.Fromdate = null;
obj.Todate = null;
}
else if (!string.IsNullOrEmpty(obj.Fromdate) && !string.IsNullOrEmpty(obj.Todate))
{
obj.Exactdate = "1990-01-01 00:00:00.000";
}
if (string.IsNullOrEmpty(obj.RenewalSearchID))
{
ModelState.AddModelError("Error", "Please select By Exact Date or By Between Date !");
}
else if (string.IsNullOrEmpty(obj.Exactdate) && obj.RenewalSearchID == "1")
{
ModelState.AddModelError("Error", "Please enter Exact date!");
}
else if (string.IsNullOrEmpty(obj.Fromdate) && obj.RenewalSearchID == "2")
{
ModelState.AddModelError("Error", "Please enter From date!");
}
else if (string.IsNullOrEmpty(obj.Todate) && obj.RenewalSearchID == "2")
{
ModelState.AddModelError("Error", "Please enter To date!");
}
else
{
DataSet ds = objIRecepit.Get_RenewalReport(obj);
ds.Tables[0].TableName = "RecepitDataset";
if (ds.Tables[0].Rows.Count > 0)
{
ReportClass rptH = new ReportClass();
rptH.FileName = Server.MapPath("~/Reports/ExactDate.rpt");
rptH.Load();
rptH.SetDataSource(ds.Tables[0]);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/pdf", "RenewalReport.pdf"));
}
}
}
return(View(obj));
}
public DataSet Get_RenewalReport(RenewalSearch objRS)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Mystring"].ToString()))
{
con.Open();
DataSet ds = new DataSet();
try
{
SqlCommand cmd = new SqlCommand("Usp_GetAllRenwalrecordsFromBetweenDate", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@exactdate", objRS.Exactdate);
cmd.Parameters.AddWithValue("@Paymentfromdt", objRS.Fromdate);
cmd.Parameters.AddWithValue("@Paymenttodt", objRS.Todate);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds);
if (ds.Tables.Count > 0)
{
return(ds);
}
else
{
return(ds = null);
}
}
catch (Exception)
{
throw;
}
finally
{
ds.Dispose();
}
}
}
