public ActionResult GetAllSP()
{
List <SPNames> lstAllSP = new List <SPNames>();
try
{
DataTable SPNameData = BLScript.GetAllSPNames();
if (SPNameData != null && SPNameData.Rows.Count > 0)
{
foreach (DataRow rowItem in SPNameData.Rows)
{
SPNames objSPName = new SPNames()
{
SPName = Convert.ToString(rowItem["name"]),
Create_Date = Convert.ToString(rowItem["create_date"]),
Modify_Date = Convert.ToString(rowItem["modify_date"])
};
lstAllSP.Add(objSPName);
}
}
}
catch (Exception ex)
{
AppConstant.WriteLogFile(ex.ToString());
}
return(View(lstAllSP));
}
public ActionResult GetSPBetweenDates(FormCollection objCollection)
{
List <SPNames> lstAllSP = new List <SPNames>();
try
{
string strFromDate = objCollection["fromdate"] != null?Convert.ToString(objCollection["fromdate"]) : "";
string strToDate = objCollection["todate"] != null?Convert.ToString(objCollection["todate"]) : "";
DateTime?sqlFromDate = !string.IsNullOrEmpty(strFromDate) ? Convert.ToDateTime(strFromDate) : (DateTime?)null;
DateTime?sqlToDate = !string.IsNullOrEmpty(strToDate) ? Convert.ToDateTime(strToDate) : (DateTime?)null;
if (sqlToDate.HasValue)
{
sqlToDate = sqlToDate.Value.AddMinutes(1439);
}
DataTable SPNameData = BLScript.GetModifyedSPNamesBetweenDates(sqlFromDate.Value, sqlToDate.Value);
if (SPNameData != null && SPNameData.Rows.Count > 0)
{
foreach (DataRow rowItem in SPNameData.Rows)
{
SPNames objSPName = new SPNames()
{
SPName = Convert.ToString(rowItem["name"]),
Create_Date = Convert.ToString(rowItem["create_date"]),
Modify_Date = Convert.ToString(rowItem["modify_date"])
};
lstAllSP.Add(objSPName);
}
}
ViewBag.FromDate = strFromDate;
ViewBag.ToDate = strToDate;
}
catch (Exception ex)
{
AppConstant.WriteLogFile(ex.ToString());
}
return(View(lstAllSP));
}
