// GET: Master public ActionResult Academic() { AcademicEntity academicEntity = new AcademicEntity(); academicEntity.flag = 'G'; academicEntity.reportId = "1"; TempData["AcademicData"] = new Master().AddAcademicYear(academicEntity); return(PartialView()); }
public ResultEntity AddAcademicYear(AcademicEntity academicEntity) { ResultEntity result = new ResultEntity(); try { SqlParameter[] sqlParameter = new SqlParameter[11]; sqlParameter[0] = new SqlParameter("@YEAR_ID", academicEntity.yearId); sqlParameter[1] = new SqlParameter("@CUSTOMER_ID", Convert.ToInt32(objUserEntity.customerId)); sqlParameter[2] = new SqlParameter("@USER_ID", objUserEntity.userId); sqlParameter[3] = new SqlParameter("@YEAR", academicEntity.academicYear); sqlParameter[4] = new SqlParameter("@START_DATE", academicEntity.wfDate); sqlParameter[5] = new SqlParameter("@END_DATE", academicEntity.wtDate); sqlParameter[6] = new SqlParameter("@IS_ACTIVE", academicEntity.active); sqlParameter[7] = new SqlParameter("@OPER_TYPE", academicEntity.flag); sqlParameter[8] = new SqlParameter("@REPORT_ID", Convert.ToInt32(academicEntity.reportId)); sqlParameter[9] = new SqlParameter("@FLAG", SqlDbType.Char); sqlParameter[9].Direction = ParameterDirection.Output; sqlParameter[9].Size = 1; sqlParameter[10] = new SqlParameter("@MSG", SqlDbType.NVarChar); sqlParameter[10].Direction = ParameterDirection.Output; sqlParameter[10].Size = 500; DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "SP_ACADEMIC_YEAR", sqlParameter); result.flag = sqlParameter[9].Value.ToString(); result.msg = sqlParameter[10].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); } }
public JsonResult Academic(AcademicEntity academicEntity) { UserEntity objUserEntity = UserEntity.GetInstance(); return(Json(new Master().AddAcademicYear(academicEntity))); }