public ActionResult Requisition(Requisition objcust, string Command)
{
if (ModelState.IsValid)
{
string CircleId = "", UserId = "";
try { CircleId = GlobalSettings.oUserData.CircleID; UserId = GlobalSettings.oUserData.UserId; }
catch { CircleId = ""; UserId = ""; }
string ReqSessionCode = objcust.ReqSessionCode;
if (objcust.stat == true)
{
if (CircleId != "" && (Convert.ToString(ReqSessionCode) == null || Convert.ToString(ReqSessionCode) == ""))
{
try
{
objcust.CircleID = Convert.ToInt32(CircleId);
objcust.UserId = UserId;
string reqGenCode = "";
objcust.AY_ID = GlobalSettings.oUserData.AcademicYearId;
var result = objDbTrx.InsertInRequisition(objcust, GlobalSettings.oAcademicYear.PFX_REQ, GlobalSettings.oAcademicYear.FormatNumberPaddingCount, out reqGenCode);
if (result)
{
objDbTrx.AutoMapBookCode();
}
return(RedirectToAction("Index", "RequisionView"));
}
catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); }
finally { }
}
else if (Convert.ToString(ReqSessionCode) != null && Convert.ToString(ReqSessionCode) != "")
{
objcust.RequisitionID = Convert.ToInt64(ReqSessionCode);
objcust.CircleID = Convert.ToInt32(CircleId);
objcust.UserId = UserId;
var result = objDbTrx.UpdateInRequisition(objcust);
if (result)
{
objDbTrx.AutoMapBookCode();
}
}
else
{
return(RedirectToAction("Index", "CircleLogin"));
}
}
}
return(RedirectToAction("Index", "RequisionView"));
}
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"));
}
