private List <MstSchool> SchoolDetail(Int32 SchoolId)
{
List <MstSchool> lstMstSchool = new List <MstSchool>();
try
{
DataTable dt = objDbTrx.GetSchoolMasterDetailsBySchoolId(SchoolId);
if (dt.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dt.Rows.Count; iCnt++)
{
MstSchool objSchool = new MstSchool();
objSchool.SchoolID = Convert.ToInt32(dt.Rows[iCnt]["ID"].ToString());
objSchool.SchoolName = dt.Rows[iCnt]["SCHOOL_NAME"].ToString();
objSchool.SchoolEmailid = dt.Rows[iCnt]["SCHOOL_EMAIL_ID"].ToString();
objSchool.SchoolMobile = dt.Rows[iCnt]["SCHOOL_PHONE_NO"].ToString();
objSchool.SchoolCode = dt.Rows[iCnt]["SCHOOL_CODE"].ToString();
lstMstSchool.Add(objSchool);
}
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(lstMstSchool);
}
public JsonResult GetSchoolMasterDtl(string circleid = "")
{
List <MstSchool> lstMstSchool = new List <MstSchool>();
try
{
DataTable dt = objDbTrx.GetSchoolMasterDetailsByCircleId(!string.IsNullOrWhiteSpace(circleid) && circleid != "-1" ? Convert.ToInt16(circleid) : Convert.ToInt16(GlobalSettings.oUserData.CircleID));
if (dt.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dt.Rows.Count; iCnt++)
{
MstSchool objSchool = new MstSchool();
objSchool.SchoolID = Convert.ToInt32(dt.Rows[iCnt]["ID"].ToString());
objSchool.SchoolCode = dt.Rows[iCnt]["SCHOOL_CODE"].ToString();
//objSchool.SchoolName = dt.Rows[iCnt]["SCHOOL_CODE"].ToString() + "_" + dt.Rows[iCnt]["SCHOOL_NAME"].ToString();
objSchool.SchoolName = dt.Rows[iCnt]["SCHOOL_NAME"].ToString();
lstMstSchool.Add(objSchool);
}
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(Json(lstMstSchool));
}
public JsonResult isDuplicateRecordExistInSchool(Int32 InDataUniqueId, string InSchoolCode)
{
List <MstSchool> lstMstSchool = new List <MstSchool>();
try
{
DataTable dtMstCircle = objDbTrx.isDuplicateRecordExistInSchool(InDataUniqueId, InSchoolCode);
if (dtMstCircle.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dtMstCircle.Rows.Count; iCnt++)
{
MstSchool objMstSchool = new MstSchool();
objMstSchool.SchoolCode = dtMstCircle.Rows[iCnt]["SCHOOL_CODE"].ToString();
objMstSchool.SchoolName = dtMstCircle.Rows[iCnt]["SCHOOL_NAME"].ToString();
objMstSchool.CircleName = dtMstCircle.Rows[iCnt]["CIRCLE_NAME"].ToString();
lstMstSchool.Add(objMstSchool);
}
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(Json(lstMstSchool, JsonRequestBehavior.AllowGet));
}
public ActionResult MstSchoolUpdate(MstSchool objMstSchool)
{
try
{
string reqGenCode = "";
objMstSchool.UserId = GlobalSettings.oUserData.UserId;
objMstSchool.CircleId = Convert.ToInt32(GlobalSettings.oUserData.CircleID);
objMstSchool.DistrictID = Convert.ToInt32(GlobalSettings.oUserData.DistrictID);
if (objMstSchool.SchoolID <= 0)
{
objDbTrx.InsertInSchool(objMstSchool, out reqGenCode);
TempData["AppMessage"] = "School Name " + objMstSchool.SchoolName + " and school Code " + objMstSchool.SchoolCode + " Saved successfully";
}
else if (objMstSchool.SchoolID > 0)
{
objDbTrx.UpdateInSchool(objMstSchool);
TempData["AppMessage"] = "School Name " + objMstSchool.SchoolName + " and school Code " + objMstSchool.SchoolCode + " Updated successfully";
}
}
catch (Exception ex)
{
TempData["AppMessage"] = "Some Error has occurred while performing your activity. Please contact the System Administrator for further assistance.";
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(RedirectToAction("Index", "MstSchoolView"));
}
public ActionResult Index(Int64?DataUniqueId)
{
ViewBag.Active = "MstSchoolView";
MstSchool objMstSchool = new MstSchool();
if (DataUniqueId == null || DataUniqueId <= 0)
{
objMstSchool.SchoolID = -1;
}
else if (DataUniqueId > 0)
{
try
{
DataTable dtRequisition = objDbTrx.GetSchoolMasterDetailsBySchoolId(Convert.ToInt64(DataUniqueId));
if (dtRequisition.Rows.Count > 0)
{
objMstSchool.SchoolID = Convert.ToInt32(dtRequisition.Rows[0]["ID"].ToString());
objMstSchool.CircleId = Convert.ToInt32(dtRequisition.Rows[0]["CIRCLE_ID"].ToString());
objMstSchool.SchoolCode = dtRequisition.Rows[0]["SCHOOL_CODE"].ToString();
objMstSchool.SchoolName = dtRequisition.Rows[0]["SCHOOL_NAME"].ToString();
objMstSchool.SchoolAdrees = dtRequisition.Rows[0]["SCHOOL_ADDRESS"].ToString();
objMstSchool.SchoolEmailid = dtRequisition.Rows[0]["SCHOOL_EMAIL_ID"].ToString();
objMstSchool.SchoolMobile = dtRequisition.Rows[0]["SCHOOL_PHONE_NO"].ToString();
objMstSchool.SchoolAlternateMobile = dtRequisition.Rows[0]["SCHOOL_ALT_PHONE_NO"].ToString();
objMstSchool.DeleivaryAddress = dtRequisition.Rows[0]["SCHOOL_DELIVARY_ADDRESS"].ToString();
objMstSchool.PoliceStation = dtRequisition.Rows[0]["POLICE_STATION"].ToString();
objMstSchool.PostalCode = dtRequisition.Rows[0]["POSTAL_CODE"].ToString();
}
}
catch (Exception ex)
{
TempData["AppMessage"] = "Some Error has occurred while performing your activity. Please contact the System Administrator for further assistance.";
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
}
return(View(objMstSchool));
}
public ActionResult GetSchoolMasterListData(string startDate, string endDate)
{
List <MstSchool> objMstSchoolList = new List <MstSchool>();
try
{
Int16 CircleId = Convert.ToInt16(GlobalSettings.oUserData.CircleID);
DataTable dtSchool = objDbTrx.GetSchoolMasterDetailsByCircleId(CircleId);
if (dtSchool.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dtSchool.Rows.Count; iCnt++)
{
MstSchool objMstSchool = new MstSchool();
objMstSchool.SchoolID = Convert.ToInt32(dtSchool.Rows[iCnt]["ID"].ToString());
objMstSchool.CircleId = Convert.ToInt32(dtSchool.Rows[iCnt]["CIRCLE_ID"].ToString());
objMstSchool.SchoolCode = dtSchool.Rows[iCnt]["SCHOOL_CODE"].ToString();
objMstSchool.SchoolName = dtSchool.Rows[iCnt]["SCHOOL_NAME"].ToString();
objMstSchool.SchoolAdrees = dtSchool.Rows[iCnt]["SCHOOL_ADDRESS"].ToString();
objMstSchool.SchoolEmailid = dtSchool.Rows[iCnt]["SCHOOL_EMAIL_ID"].ToString();
objMstSchool.SchoolMobile = dtSchool.Rows[iCnt]["SCHOOL_PHONE_NO"].ToString();
objMstSchool.SchoolAlternateMobile = dtSchool.Rows[iCnt]["SCHOOL_ALT_PHONE_NO"].ToString();
objMstSchool.DeleivaryAddress = dtSchool.Rows[iCnt]["SCHOOL_DELIVARY_ADDRESS"].ToString();
objMstSchool.PoliceStation = dtSchool.Rows[iCnt]["POLICE_STATION"].ToString();
objMstSchool.PostalCode = dtSchool.Rows[iCnt]["POSTAL_CODE"].ToString();
objMstSchoolList.Add(objMstSchool);
}
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(Json(objMstSchoolList, JsonRequestBehavior.AllowGet));
// return View();
}
