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