public JsonResult HolidayList(HolidayListEntity holidayEntity) { Master objMaster = new Master(); //return null; UserEntity objUserEntity = UserEntity.GetInstance(); return(Json(objMaster.AddHoliday(holidayEntity))); }
public ActionResult HolidayList() { HolidayListEntity holidayEntity = new HolidayListEntity(); holidayEntity.flag = 'G'; holidayEntity.reportId = "16"; TempData["HolidayList"] = new Master().AddHoliday(holidayEntity); return(PartialView()); }
public ResultEntity AddHoliday(HolidayListEntity holidayEntity) { objUserEntity = (UserEntity)HttpContext.Current.Session["UserDetails"]; ResultEntity result = new ResultEntity(); try { SqlParameter[] sqlParameter = new SqlParameter[12]; sqlParameter[0] = new SqlParameter("@ACADEMIC_ID", holidayEntity.acyr); sqlParameter[1] = new SqlParameter("@HOLIDAY_ID", holidayEntity.hldy); sqlParameter[2] = new SqlParameter("@START_DATE", holidayEntity.wfDate); sqlParameter[3] = new SqlParameter("@END_DATE", holidayEntity.wtDate); sqlParameter[4] = new SqlParameter("@RH_ID", holidayEntity.res); sqlParameter[5] = new SqlParameter("@CUSTOMER_ID", objUserEntity.customerId); sqlParameter[6] = new SqlParameter("@USER_ID", objUserEntity.userId); sqlParameter[7] = new SqlParameter("@IS_ACTIVE", holidayEntity.active); sqlParameter[8] = new SqlParameter("@REPORT_ID", Convert.ToInt32(holidayEntity.reportId)); sqlParameter[9] = new SqlParameter("@OPER_TYPE", holidayEntity.flag); sqlParameter[10] = new SqlParameter("@FLAG", SqlDbType.Char); sqlParameter[10].Direction = ParameterDirection.Output; sqlParameter[10].Size = 1; sqlParameter[11] = new SqlParameter("@MSG", SqlDbType.NVarChar); sqlParameter[11].Direction = ParameterDirection.Output; sqlParameter[11].Size = 500; DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "SP_HOLIDAY_LIST", sqlParameter); result.flag = sqlParameter[10].Value.ToString(); result.msg = sqlParameter[11].Value.ToString(); if (result.flag.ToUpper() == "S") { if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { result.addParams = CommonFunc.DtToJSON(ds.Tables[0]); } } } return(result); } catch (Exception ex) { Excep.WriteException(ex); return(result); } }