public Models.Requisition GetMasterDetails(string categoryId, string LanguageId, string SchoolId, string isConfirmed)
{
Requisition lst_req = new Requisition();
List <Language> lst_language = new List <Language>();
DataTable dtMastData = new DataTable();
lst_req.ReqSessionCode = Convert.ToString(Session["ReqSessionCode"]);
lst_req.isConfirmed = isConfirmed;
//Session["ReqSessionCode"] = "";
if (Convert.ToString(categoryId) != null && Convert.ToString(LanguageId) != null && Convert.ToString(categoryId) != "" && Convert.ToString(LanguageId) != "")
{
List <RequisitionTrxDtl> lst_book = new List <RequisitionTrxDtl>();
try
{
DataTable dtReqDtl = new DataTable();
if (Convert.ToString(lst_req.ReqSessionCode) != null && Convert.ToString(lst_req.ReqSessionCode) != "")
{
dtReqDtl = objDbTrx.GetRequisitionViewDataByReqId(lst_req.ReqSessionCode);
}
DataTable dtBook = objDbTrx.GetBookMasterDetailsById(Convert.ToInt64(categoryId), Convert.ToInt64(LanguageId));
if (dtBook.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dtBook.Rows.Count; iCnt++)
{
RequisitionTrxDtl rq = new RequisitionTrxDtl();
rq.BookName = dtBook.Rows[iCnt]["BOOK_NAME"].ToString();
rq.BookID = Convert.ToInt64(dtBook.Rows[iCnt]["ID"].ToString());
rq.classname = dtBook.Rows[iCnt]["CLASS"].ToString();
if (Convert.ToString(lst_req.ReqSessionCode) != null && Convert.ToString(lst_req.ReqSessionCode) != "")
{
if (dtReqDtl.Rows.Count > 0)
{
for (int jCnt = 0; jCnt < dtReqDtl.Rows.Count; jCnt++)
{
if (Convert.ToInt64(dtBook.Rows[iCnt]["ID"].ToString()) == Convert.ToInt64(dtReqDtl.Rows[jCnt]["BOOK_ID"].ToString()))
{
rq.StudentEnrolled = Convert.ToInt32(dtReqDtl.Rows[jCnt]["PREV_REQUISITION_QTY"].ToString());
rq.QtyRequirement = Convert.ToInt32(dtReqDtl.Rows[jCnt]["CURR_REQUISITION_QTY"].ToString());
break;
}
}
}
}
lst_book.Add(rq);
}
}
lst_req.reqTrxCollection = lst_book;
}
catch (Exception ex) { }
}
if (Convert.ToString(SchoolId) != null)
{
try
{
dtMastData = objDbTrx.GetSchoolMasterDetailsById(Convert.ToInt64(SchoolId), Convert.ToInt64(GlobalSettings.oUserData.CircleID));
if (dtMastData.Rows.Count > 0)
{
lst_req.school_contact_no = Convert.ToString(dtMastData.Rows[0]["SCHOOL_PHONE_NO"].ToString());
lst_req.school_email_id = Convert.ToString(dtMastData.Rows[0]["SCHOOL_EMAIL_ID"].ToString());
dtMastData.Dispose();
}
}
catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); }
}
try
{
dtMastData = objDbTrx.GetLanguageMasterDetails();
if (dtMastData.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dtMastData.Rows.Count; iCnt++)
{
Language rq = new Language();
rq.language_name = Convert.ToString(dtMastData.Rows[iCnt]["LANGUAGE"].ToString());
rq.LanguageID = Convert.ToInt32(dtMastData.Rows[iCnt]["ID"].ToString());
lst_language.Add(rq);
}
dtMastData.Dispose();
}
lst_req.languageCollection = lst_language;
List <Category> lst_category = new List <Category>();
try
{
dtMastData = objDbTrx.GetBookCategoryMasterDetails();
if (dtMastData.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dtMastData.Rows.Count; iCnt++)
{
Category rq = new Category();
rq.Category_name = Convert.ToString(dtMastData.Rows[iCnt]["BOOK_CATEGORY"].ToString());
rq.CategoryID = Convert.ToInt32(dtMastData.Rows[iCnt]["ID"].ToString());
lst_category.Add(rq);
}
dtMastData.Dispose();
}
lst_req.categoryCollection = lst_category;
}
catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); }
List <School> lst_school = new List <School>();
try
{
dtMastData = objDbTrx.GetSchoolMasterDetailsByCircleId(Convert.ToInt16(GlobalSettings.oUserData.CircleID));
if (dtMastData.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dtMastData.Rows.Count; iCnt++)
{
School rq = new School();
rq.School_name = Convert.ToString(dtMastData.Rows[iCnt]["SCHOOL_NAME"].ToString());
rq.SchoolID = Convert.ToInt32(dtMastData.Rows[iCnt]["ID"].ToString());
rq.schooldisplaytext = Convert.ToString(dtMastData.Rows[iCnt]["SCHOOL_CODE"].ToString()) + "_" + Convert.ToString(dtMastData.Rows[iCnt]["SCHOOL_NAME"].ToString());
lst_school.Add(rq);
}
dtMastData.Dispose();
}
lst_req.schoolCollection = lst_school;
lst_req.CircleID = Convert.ToInt32(GlobalSettings.oUserData.CircleID);
lst_req.RequisitionDate = DateTime.Now.ToString("dd-MMM-yyyy HH:MM tt").ToUpper();
if (Convert.ToString(categoryId) != null && Convert.ToString(LanguageId) != null)
{
lst_req.cat_up_id = Convert.ToString(categoryId.ToString());
lst_req.lan_up_id = Convert.ToString(LanguageId.ToString());
}
else
{
lst_req.cat_up_id = "Select";
lst_req.lan_up_id = "Select";
}
if (Convert.ToString(Session["SchooldCode"]) == "")
{
if (Convert.ToString(SchoolId) == null)
{
lst_req.code_school = "Select";
}
else
{
lst_req.code_school = SchoolId.ToString();
}
}
else
{
lst_req.code_school = Convert.ToString(Session["SchooldCode"]);
Session["SchooldCode"] = "";
try
{
dtMastData = objDbTrx.GetSchoolMasterDetailsBySchoolId(Convert.ToInt64(lst_req.code_school));
if (dtMastData.Rows.Count > 0)
{
lst_req.school_contact_no = Convert.ToString(dtMastData.Rows[0]["SCHOOL_PHONE_NO"].ToString());
lst_req.school_email_id = Convert.ToString(dtMastData.Rows[0]["SCHOOL_EMAIL_ID"].ToString());
dtMastData.Dispose();
}
}
catch (Exception ex)
{
}
}
}
catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); }
}
catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); }
return(lst_req);
}
public ActionResult TrxSchRequisitionUpdate(SchRequisition objSchRequisition)
{
Requisition objRequisition = new Requisition();
try
{
if (objSchRequisition != null)
{
objRequisition.SchoolID = Convert.ToInt32(objSchRequisition.SchoolID <= default(int) ? objSchRequisition.MstSchool.SchoolID : objSchRequisition.SchoolID);
objRequisition.LanguageID = objSchRequisition.MstLanguage.LanguageID;
objRequisition.CategoryID = objSchRequisition.MstCategory.CategoryID;
objRequisition.CircleID = objSchRequisition.CircleID > default(int) ? objSchRequisition.CircleID : Convert.ToInt32(GlobalSettings.oUserData.CircleID);
objRequisition.BookID = objSchRequisition.BookID;
objRequisition.RequisitionID = objSchRequisition.RequisitionID;
objRequisition.RequisitionDate = string.IsNullOrWhiteSpace(objSchRequisition.RequisitionDate) ? DateTime.Now.ToString() : objSchRequisition.RequisitionDate;
objRequisition.ReqSessionCode = objSchRequisition.RequisitionCode;
objRequisition.UserId = GlobalSettings.oUserData.UserId;
objRequisition.SaveStatus = objSchRequisition.SaveStatus.ToString();
objRequisition.reqTrxCollection = new List <RequisitionTrxDtl>();
foreach (var sobj in objSchRequisition.reqTrxCollection)
{
var robj = new RequisitionTrxDtl();
robj.BookCode = sobj.BookCode;
robj.BookID = sobj.BookID;
robj.BookName = sobj.BookName;
robj.classname = sobj.ClassName;
robj.QtyRequirement = sobj.RequisitionQuantity;
robj.RequisitionQuantity = sobj.RequisitionQuantity;
robj.StockQuantity = sobj.StockQuantity;
robj.StudentEnrolled = sobj.StudentEnrolled;
robj.PreviousYearReqQty = sobj.PreviousYearRequirement;
objRequisition.reqTrxCollection.Add(robj);
}
}
for (int iCnt = 0; iCnt < objRequisition.reqTrxCollection.Count; iCnt++)
{
objRequisition.reqTrxCollection[iCnt].RequisitionQuantity = objRequisition.reqTrxCollection[iCnt].StudentEnrolled - objRequisition.reqTrxCollection[iCnt].StockQuantity;
objRequisition.reqTrxCollection[iCnt].QtyRequirement = objRequisition.reqTrxCollection[iCnt].RequisitionQuantity;
}
string reqGenCode = "";
objRequisition.AY_ID = objSchRequisition.AcademicYearID = GlobalSettings.oUserData.AcademicYearId;
//objSchRequisition.UserId = GlobalSettings.oUserData.UserId;
if (objRequisition.RequisitionID <= 0)
{
objRequisition.SaveStatus = "1";
//objDbTrx.InsertInSchRequisition(objSchRequisition, out reqGenCode);
var result = objDbTrx.InsertInRequisition(objRequisition, GlobalSettings.oAcademicYear.PFX_REQ, GlobalSettings.oAcademicYear.FormatNumberPaddingCount, out reqGenCode);
if (result)
{
objDbTrx.AutoMapBookCode();
}
TempData["AppMessage"] = "Requisition created successfully and the requisition code is " + reqGenCode;
}
else if (objRequisition.RequisitionID > 0)
{
reqGenCode = objRequisition.ReqSessionCode;
objRequisition.SaveStatus = objSchRequisition.CircleID > default(int) ? objRequisition.SaveStatus : "0";
//objDbTrx.UpdateInSchRequisition(objSchRequisition);
var result = objDbTrx.UpdateInRequisition(objRequisition);
if (result)
{
objDbTrx.AutoMapBookCode();
}
TempData["AppMessage"] = "Requisition updated successfully for the requisition code is " + reqGenCode;
}
}
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", "SchRequisionView"));
}
