public JsonResult SelectData() { string Code = string.Empty, Message = string.Empty; List <mSCFDates> _list = new List <mSCFDates>(); try { SCFRepository _objRepo = new SCFRepository(); DataSet _ds = _objRepo.Opr_ProgrammeLevel_Ch_CloseDT(new mSCFDatesSave { Type = "Select" }); if (_ds != null) { if (_ds.Tables[0].Rows.Count > 0) { foreach (DataRow _dr in _ds.Tables[0].Rows) { _list.Add(new mSCFDates { ProgrammeLevel = _dr["ProgrammeLevel"].ToString(), ClosingDate = Convert.ToDateTime(_dr["ClosingDate"].ToString()).ToString("yyyy-MM-dd HH-mm-ss"), StartingDateApproveReject = Convert.ToDateTime(_dr["StartingDateApproveReject"].ToString()).ToString("yyyy-MM-dd HH-mm-ss"), ClosingDateApproveReject = Convert.ToDateTime(_dr["ClosingDateApproveReject"].ToString()).ToString("yyyy-MM-dd HH-mm-ss") }); } } } } catch (NullReferenceException) { Code = "error"; Message = "Your session has been expired. Kindly refresh and try again."; } catch (Exception) { Code = "error"; Message = "Error from server side. Kindly refresh and try again."; } return(Json(new { List = _list, c = Code, m = Message }, JsonRequestBehavior.AllowGet )); }
public JsonResult SaveData(mSCFDatesSave _obj) { string Code = string.Empty, Message = string.Empty, Error = string.Empty; try { SCFRepository _objRepo = new SCFRepository(); _obj.Type = "Update"; #region Change Config File Data Configuration configFile = null; if (System.Web.HttpContext.Current != null) { configFile = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~"); } else { configFile = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); } var settings = configFile.AppSettings.Settings; if (settings["StudentChoiceFillingDateTime"] == null) { settings.Add("StudentChoiceFillingDateTime", _obj.StudentChoiceFillingDateTime); } else { settings["StudentChoiceFillingDateTime"].Value = _obj.StudentChoiceFillingDateTime; } configFile.Save(ConfigurationSaveMode.Modified); ConfigurationManager.RefreshSection(configFile.AppSettings.SectionInformation.Name); #endregion DataSet _ds = _objRepo.Opr_ProgrammeLevel_Ch_CloseDT(_obj); if (_ds != null) { if (_ds.Tables[0].Rows.Count > 0) { Code = "success"; Message = "Dates have been updated."; } } } catch (NullReferenceException ex) { Code = "error"; Message = "Your session has been expired. Kindly refresh and try again."; Error = ex.Message; } catch (Exception ex) { Code = "error"; Message = "Error from server side. Kindly refresh and try again."; Error = ex.Message; } return(Json(new { c = Code, m = Message, e = Error }, JsonRequestBehavior.AllowGet )); }