public JsonResult GetSchRequisitionForProbChallanByChallanId(Int32 InChallanId)
{
List <SchRequisitionView> objSchRequisitionViewList = new List <SchRequisitionView>();
try
{
DataTable dt = objDbTrx.GetSchRequisitionForProbChallanById(InChallanId);
if (dt.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dt.Rows.Count; iCnt++)
{
SchRequisitionView objSchRequisitionView = new SchRequisitionView();
objSchRequisitionView.RequisitionID = Convert.ToInt64(dt.Rows[iCnt]["REQUISITION_ID"].ToString());
objSchRequisitionView.RequisitionCode = Convert.ToString(dt.Rows[iCnt]["REQ_CODE"].ToString());
objSchRequisitionView.RequisitionDate = Convert.ToDateTime(dt.Rows[iCnt]["REQUISITION_DATE"].ToString()).ToString("dd-MMM-yyyy");
objSchRequisitionView.SchoolCode = Convert.ToString(dt.Rows[iCnt]["SCHOOL_CODE"].ToString());
objSchRequisitionView.SchoolName = Convert.ToString(dt.Rows[iCnt]["SCHOOL_NAME"].ToString());
objSchRequisitionView.LanguageName = Convert.ToString(dt.Rows[iCnt]["LANGUAGE"].ToString());
objSchRequisitionView.RemainQuantity = Convert.ToInt32(dt.Rows[iCnt]["REMAIN_QTY"].ToString());
objSchRequisitionViewList.Add(objSchRequisitionView);
}
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(Json(objSchRequisitionViewList, JsonRequestBehavior.AllowGet));
}
public JsonResult GetSchRequisitionForProbChallan(Int16 InCircleID, Int16 InLanguageId, string BookCode)
{
List <SchRequisitionView> objSchRequisitionViewList = new List <SchRequisitionView>();
try
{
Int16 CircleId = InCircleID;
Int16 LanguageId = InLanguageId;
Int16 AccadYear = Convert.ToInt16(GlobalSettings.oUserData.AcademicYearId);
DataTable dt = objDbTrx.Sp_SchRequisitionForProbChallan(CircleId, AccadYear, InLanguageId, BookCode);
if (dt.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dt.Rows.Count; iCnt++)
{
SchRequisitionView objSchRequisitionView = new SchRequisitionView();
objSchRequisitionView.RequisitionID = Convert.ToInt64(dt.Rows[iCnt]["REQUISITION_ID"].ToString());
objSchRequisitionView.RequisitionCode = Convert.ToString(dt.Rows[iCnt]["REQ_CODE"].ToString());
objSchRequisitionView.RequisitionDate = Convert.ToDateTime(dt.Rows[iCnt]["REQUISITION_DATE"].ToString()).ToString("dd-MMM-yyyy");
objSchRequisitionView.SchoolCode = Convert.ToString(dt.Rows[iCnt]["SCHOOL_CODE"].ToString());
objSchRequisitionView.SchoolName = Convert.ToString(dt.Rows[iCnt]["SCHOOL_NAME"].ToString());
objSchRequisitionView.LanguageName = Convert.ToString(dt.Rows[iCnt]["LANGUAGE"].ToString());
objSchRequisitionView.RemainQuantity = Convert.ToInt32(dt.Rows[iCnt]["REMAIN_QTY"].ToString());
objSchRequisitionViewList.Add(objSchRequisitionView);
}
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(Json(objSchRequisitionViewList, JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
ViewBag.Active = "SchRequisionView";
SchRequisitionView objSchRequisitionView = new SchRequisitionView();
objSchRequisitionView.StartDate = Convert.ToDateTime(DateTime.Now).ToString("dd-MMM-yyyy");
objSchRequisitionView.EndDate = Convert.ToDateTime(DateTime.Now).ToString("dd-MMM-yyyy");
return(View(objSchRequisitionView));
}
public ActionResult GetSchRequisionViewListData(string startDate, string endDate, string circleId = "")
{
List <SchRequisitionView> objSchRequisitionViewList = new List <SchRequisitionView>();
try
{
Int16 CircleId = default(short);
if (!string.IsNullOrWhiteSpace(circleId) && circleId != "-1")
{
CircleId = Convert.ToInt16(circleId);
}
else
{
CircleId = Convert.ToInt16(GlobalSettings.oUserData.CircleID);
}
Int16 AccadYear = Convert.ToInt16(GlobalSettings.oUserData.AcademicYearId);
//DataTable dt = objDbTrx.GetSchRequisitionViewDataByCercleId(Convert.ToDateTime(startDate + " 00:00:00.000"), Convert.ToDateTime(endDate + " 23:59:59.999"), CircleId, AccadYear);
DataTable dt = objDbTrx.GetRequisitionViewNew(Convert.ToDateTime(startDate + " 00:00:00.000"), Convert.ToDateTime(endDate + " 23:59:59.999"), CircleId, AccadYear);
if (dt.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dt.Rows.Count; iCnt++)
{
SchRequisitionView objSchRequisitionView = new SchRequisitionView();
objSchRequisitionView.RequisitionID = Convert.ToInt64(dt.Rows[iCnt]["REQUISITION_ID"].ToString());
objSchRequisitionView.RequisitionCode = Convert.ToString(dt.Rows[iCnt]["REQ_CODE"].ToString());
objSchRequisitionView.RequisitionDate = Convert.ToDateTime(dt.Rows[iCnt]["REQUISITION_DATE"].ToString()).ToString("dd-MMM-yyyy");
objSchRequisitionView.SaveStatus = Convert.ToInt16(dt.Rows[iCnt]["SAVE_STATUS"].ToString());
objSchRequisitionView.SchoolCode = Convert.ToString(dt.Rows[iCnt]["SCHOOL_CODE"].ToString());
objSchRequisitionView.SchoolName = Convert.ToString(dt.Rows[iCnt]["SCHOOL_NAME"].ToString());
objSchRequisitionView.LanguageName = Convert.ToString(dt.Rows[iCnt]["LANGUAGE"].ToString());
objSchRequisitionView.Category = Convert.ToString(dt.Rows[iCnt]["BOOK_CATEGORY"].ToString());
objSchRequisitionView.LastUpdatedBy = Convert.ToString(dt.Rows[iCnt]["UPDATED_BY"].ToString());
objSchRequisitionView.LastUpdatedOn = Convert.ToDateTime(dt.Rows[iCnt]["UPDATED_TS"].ToString()).ToString("dd-MMM-yyyy");
objSchRequisitionView.ISAPPROVED = Convert.ToInt32(dt.Rows[iCnt]["ISAPPROVED"].ToString());
objSchRequisitionView.ISAPPROVED_DIST = Convert.ToInt32(dt.Rows[iCnt]["ISAPPROVED_DIST"].ToString());
objSchRequisitionView.ISAPPROVED_ADMIN = Convert.ToInt32(dt.Rows[iCnt]["ISAPPROVED_ADMIN"].ToString());
objSchRequisitionViewList.Add(objSchRequisitionView);
}
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(Json(objSchRequisitionViewList, JsonRequestBehavior.AllowGet));
// return View();
}
public ActionResult GetSchRequisionViewListData(string startDate, string endDate, string districtId = "", string circleId = "", int isapproved = 0)
{
List <SchRequisitionView> objSchRequisitionViewList = new List <SchRequisitionView>();
try
{
int CircleId = default(int);
int DistrictId = default(int);
int.TryParse(districtId, out DistrictId);
string usertype = string.Empty;
try
{
usertype = (GlobalSettings.oUserData).UserType;
}
catch { }
if (!string.IsNullOrWhiteSpace(circleId))
{
CircleId = Convert.ToInt32(circleId);
}
else
{
if (usertype != "2")
{
CircleId = Convert.ToInt32(!string.IsNullOrWhiteSpace(GlobalSettings.oUserData.CircleID) ? GlobalSettings.oUserData.CircleID : "-1");
}
else
{
CircleId = -1;
}
}
int IsForAdminApproval = default(int);
int AdminApprovalstatus = default(int);
int AccadYear = Convert.ToInt32(GlobalSettings.oUserData.AcademicYearId);
// DataTable dt = objDbTrx.GetRequisitionViewNewForApproval(Convert.ToDateTime(startDate + " 00:00:00.000"), Convert.ToDateTime(endDate + " 23:59:59.999"), DistrictId, CircleId, (usertype == "5" ? isapproved : 0), AccadYear, IsForDistApproval: (usertype == "5" ? 0 : (usertype == "2" ? 1 : 0)), DistApprovalstatus: (usertype == "2" ? isapproved : 0));
DataTable dt = objDbTrx.GetRequisitionViewNewForApproval(Convert.ToDateTime(startDate + " 00:00:00.000")
, Convert.ToDateTime(endDate + " 23:59:59.999"), DistrictId, CircleId
, (usertype == "5" ? isapproved : 0), AccadYear, IsForDistApproval: (usertype == "5" ? 0 : (usertype == "2" ? 1 : 0))
, DistApprovalstatus: (usertype == "2" ? isapproved : 0), IsForAdminApproval: (usertype == "5" ? 0 : (usertype == "3" ? 1 : 0)), AdminApprovalstatus: (usertype == "5" ? 0 : (usertype == "3" ? isapproved : 0)));
if (dt.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dt.Rows.Count; iCnt++)
{
var pp = dt.Rows[iCnt]["ISAPPROVED_ADMIN"];
Console.WriteLine(pp);
SchRequisitionView objSchRequisitionView = new SchRequisitionView();
objSchRequisitionView.RequisitionID = Convert.ToInt64(dt.Rows[iCnt]["REQUISITION_ID"].ToString());
try
{
objSchRequisitionView.ISAPPROVED = Convert.ToInt32(dt.Rows[iCnt]["ISAPPROVED"].ToString());
objSchRequisitionView.APPROVED_BY = dt.Rows[iCnt]["APPROVED_BY"].ToString();
if (!string.IsNullOrWhiteSpace(dt.Rows[iCnt]["APPROVED_TS"].ToString()))
{
objSchRequisitionView.APPROVED_TS = Convert.ToDateTime(dt.Rows[iCnt]["APPROVED_TS"].ToString());
}
}
catch
{
continue;
}
try
{
objSchRequisitionView.ISAPPROVED_DIST = Convert.ToInt32(dt.Rows[iCnt]["ISAPPROVED_DIST"].ToString());
objSchRequisitionView.APPROVED_BY_DIST = dt.Rows[iCnt]["APPROVED_BY_DIST"].ToString();
if (!string.IsNullOrWhiteSpace(dt.Rows[iCnt]["APPROVED_TS_DIST"].ToString()))
{
objSchRequisitionView.APPROVED_TS_DIST = Convert.ToDateTime(dt.Rows[iCnt]["APPROVED_TS_DIST"].ToString());
}
}
catch
{
continue;
}
objSchRequisitionView.RequisitionCode = Convert.ToString(dt.Rows[iCnt]["REQ_CODE"].ToString());
objSchRequisitionView.RequisitionDate = Convert.ToDateTime(dt.Rows[iCnt]["REQUISITION_DATE"].ToString()).ToString("dd-MMM-yyyy");
objSchRequisitionView.SaveStatus = Convert.ToInt16(dt.Rows[iCnt]["SAVE_STATUS"].ToString());
objSchRequisitionView.SchoolCode = Convert.ToString(dt.Rows[iCnt]["SCHOOL_CODE"].ToString());
objSchRequisitionView.SchoolName = Convert.ToString(dt.Rows[iCnt]["SCHOOL_NAME"].ToString());
objSchRequisitionView.LanguageName = Convert.ToString(dt.Rows[iCnt]["LANGUAGE"].ToString());
objSchRequisitionView.Category = Convert.ToString(dt.Rows[iCnt]["BOOK_CATEGORY"].ToString());
objSchRequisitionView.LastUpdatedBy = Convert.ToString(dt.Rows[iCnt]["UPDATED_BY"].ToString());
objSchRequisitionView.LastUpdatedOn = Convert.ToDateTime(dt.Rows[iCnt]["UPDATED_TS"].ToString()).ToString("dd-MMM-yyyy");
// 4.12.18 Admin approval section
try
{
objSchRequisitionView.ISAPPROVED_ADMIN = Convert.ToInt32(dt.Rows[iCnt]["ISAPPROVED_ADMIN"].ToString());
}
catch
{
continue;
}
objSchRequisitionViewList.Add(objSchRequisitionView);
}
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
//return Json(objSchRequisitionViewList, JsonRequestBehavior.AllowGet);
return(PartialView("_ReqList", objSchRequisitionViewList));
}
