private SchRequisition SchRequisitionDtl(Int64?ReqisitionId)
{
SchRequisition objSchRequisition = new SchRequisition();
if (ReqisitionId == null || ReqisitionId <= 0)
{
objSchRequisition.RequisitionDate = DateTime.Now.ToString("dd-MMM-yyyy").ToUpper();
//objSchRequisition.RequisitionCode = "REQ/XX/XXXXXXX";
objSchRequisition.RequisitionCode = string.Format("{0}{1}", GlobalSettings.oAcademicYear.PFX_REQ, new String('X', GlobalSettings.oAcademicYear.FormatNumberPaddingCount));
objSchRequisition.RequisitionID = -1;
}
else if (ReqisitionId > 0)
{
try
{
//DataTable dtRequisition = objDbTrx.GetSchRequisitionByReqId(Convert.ToInt64(ReqisitionId));
DataTable dtRequisition = objDbTrx.GetRequisitionViewDataByReqId(ReqisitionId.ToString());
if (dtRequisition.Rows.Count > 0)
{
objSchRequisition.RequisitionDate = Convert.ToDateTime(dtRequisition.Rows[0]["REQUISITION_DATE"]).ToString("dd-MMM-yyyy");
objSchRequisition.RequisitionCode = dtRequisition.Rows[0]["REQ_CODE"].ToString();
objSchRequisition.RequisitionID = Convert.ToInt64(dtRequisition.Rows[0]["REQUISITION_ID"].ToString());
objSchRequisition.SchoolID = Convert.ToInt64(dtRequisition.Rows[0]["SCHOOL_ID"].ToString());
objSchRequisition.LanguageID = Convert.ToInt16(dtRequisition.Rows[0]["LANGUAGE_ID"].ToString());
objSchRequisition.CategoryID = Convert.ToInt16(dtRequisition.Rows[0]["CATEGORY_ID"].ToString());
objSchRequisition.SaveStatus = Convert.ToInt16(dtRequisition.Rows[0]["SAVE_STATUS"].ToString());
objSchRequisition.MstLanguage = new MstLanguage()
{
LanguageID = objSchRequisition.LanguageID
};
objSchRequisition.MstCategory = new MstCategory()
{
CategoryID = objSchRequisition.CategoryID
};
objSchRequisition.MstSchool = new MstSchool()
{
SchoolID = objSchRequisition.SchoolID
};
}
}
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(objSchRequisition);
}
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"));
}
