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