public JsonResult GetSchBookRequisitionCalculatedDtlByChallanId(Int32 InChallanId)
{
List <BookRequisitionCalculatedDtl> objLstBookRequisitionCalculatedDtl = new List <BookRequisitionCalculatedDtl>();
try
{
DataTable dt = objDbTrx.GetSchBookDtlByChallanId(InChallanId);
if (dt.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dt.Rows.Count; iCnt++)
{
BookRequisitionCalculatedDtl objBookRequisitionCalculatedDtl = new BookRequisitionCalculatedDtl();
objBookRequisitionCalculatedDtl.BookCode = dt.Rows[iCnt]["BOOK_CODE"].ToString();
objBookRequisitionCalculatedDtl.Qty = Convert.ToInt32(dt.Rows[iCnt]["Qty"].ToString());
objBookRequisitionCalculatedDtl.TotWeight = Convert.ToDouble(dt.Rows[iCnt]["TotWeight"].ToString());
objLstBookRequisitionCalculatedDtl.Add(objBookRequisitionCalculatedDtl);
}
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(Json(objLstBookRequisitionCalculatedDtl, JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateSchChallan(string BinderAllotMentCode, Int32 ChallanId)
{
SchProvisionalChallan objSchProvisionalChallan = new SchProvisionalChallan();
DataTable dt = new DataTable();
List <BookRequisitionCalculatedDtl> ObjlstBookRequisitionCalculatedDtl = new List <BookRequisitionCalculatedDtl>();
Int32 RequiredQty = 0;
Int32 IssuedQty = 0;
Double RequiredWeight = 0;
Double IssuedWeight = 0;
bool IsError = false;
try
{
if (BinderAllotMentCode.Length > 0)
{
DataSet dtBinderinfo = objDbTrx.GetBinderAllotmentDtlByCode(BinderAllotMentCode, ChallanId);
if (dtBinderinfo.Tables[1].Rows.Count > 0)
{
Int32 Qty = Convert.ToInt32(dtBinderinfo.Tables[1].Rows[0]["QTY"].ToString());
Int32 QtyToBeIssued = Convert.ToInt32(dtBinderinfo.Tables[1].Rows[0]["AllotedQty"].ToString()) + Convert.ToInt32(dtBinderinfo.Tables[1].Rows[0]["LOT"].ToString());;
if (QtyToBeIssued > Qty)
{
objSchProvisionalChallan.UpdateCode = "ERROR";
objSchProvisionalChallan.UpdateMessage = "Quantity to be issued will be " + QtyToBeIssued + " and it can not be more than the requisiont qty" + Qty + " for Book " + dtBinderinfo.Tables[1].Rows[0]["BOOK_CODE"].ToString() + " - " + dtBinderinfo.Tables[1].Rows[0]["BOOK_NAME"].ToString();
IsError = true;
}
}
if (dtBinderinfo.Tables[0].Rows.Count == 0 || dtBinderinfo.Tables[0] == null)
{
objSchProvisionalChallan.UpdateCode = "ERROR";
objSchProvisionalChallan.UpdateMessage = "Allotment code " + BinderAllotMentCode + " is Invalid. Please try with some other Allotment Code";
IsError = true;
}
if (dtBinderinfo.Tables[0].Rows.Count > 0 && IsError == false)
{
objSchProvisionalChallan.ChallanId = ChallanId;
objSchProvisionalChallan.BinderAllotMentCode = BinderAllotMentCode;
objSchProvisionalChallan.AcademicYearID = GlobalSettings.oUserData.AcademicYearId;
objSchProvisionalChallan.UserId = GlobalSettings.oUserData.UserId;
objSchProvisionalChallan.BinderAllotMentId = Convert.ToInt32(dtBinderinfo.Tables[0].Rows[0]["ID"].ToString());
objSchProvisionalChallan.ChallanQty = 1;
dt = objDbTrx.IsValidBinderAllotmentBookDtl(objSchProvisionalChallan.ChallanId, objSchProvisionalChallan.BinderAllotMentId);
if (dt == null || dt.Rows.Count == 0)
{
objSchProvisionalChallan.UpdateCode = "ERROR";
objSchProvisionalChallan.UpdateMessage = "Invalid Binder book details. The Book details is not available for this challan.";
// return Json(objSchProvisionalChallan, JsonRequestBehavior.AllowGet);
}
else
{
Int32 ReqQty = Convert.ToInt32(dtBinderinfo.Tables[0].Rows[0]["REQ_QTY"].ToString());
Int32 QtyIssued = Convert.ToInt32(dtBinderinfo.Tables[0].Rows[0]["QTY_ISSUED"].ToString());
if (QtyIssued < ReqQty)
{
bool isUpdated = objDbTrx.UpdateSchChallan(objSchProvisionalChallan);
if (isUpdated == true)
{
objSchProvisionalChallan.UpdateCode = "SUCCESS";
objSchProvisionalChallan.UpdateMessage = "Lot Quantity updated successfully";
}
else
{
objSchProvisionalChallan.UpdateCode = "ERROR";
objSchProvisionalChallan.UpdateMessage = "Lot Quantity updated unsccessfull";
}
}
else
{
objSchProvisionalChallan.UpdateCode = "ERROR";
objSchProvisionalChallan.UpdateMessage = "Allotment Quantity is not valid.All the lot for allotment code " + BinderAllotMentCode + " is complited.";
}
}
}
}
dt = objDbTrx.GetProbChallanBookDetailsById(ChallanId);
DataTable dtBookAllotedQty = objDbTrx.GetBookAllotedQtyByChallaId(ChallanId);
if (dt.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < dt.Rows.Count; iCnt++)
{
BookRequisitionCalculatedDtl objBookRequisitionCalculatedDtl = new BookRequisitionCalculatedDtl();
objBookRequisitionCalculatedDtl.Class = dt.Rows[iCnt]["CLASS"].ToString();
objBookRequisitionCalculatedDtl.BookCode = dt.Rows[iCnt]["BOOK_CODE"].ToString();
objBookRequisitionCalculatedDtl.BookName = dt.Rows[iCnt]["BOOK_NAME"].ToString();
objBookRequisitionCalculatedDtl.Qty = Convert.ToInt32(dt.Rows[iCnt]["Qty"].ToString());
objBookRequisitionCalculatedDtl.TotWeight = Convert.ToDouble(dt.Rows[iCnt]["TotWeight"].ToString());
objBookRequisitionCalculatedDtl.ChallanQty = 0;
RequiredQty = RequiredQty + objBookRequisitionCalculatedDtl.Qty;
RequiredWeight = RequiredWeight + objBookRequisitionCalculatedDtl.TotWeight;
for (int jCnt = 0; jCnt < dtBookAllotedQty.Rows.Count; jCnt++)
{
if (dt.Rows[iCnt]["BOOK_CODE"].ToString() == dtBookAllotedQty.Rows[jCnt]["BOOK_CODE"].ToString())
{
objBookRequisitionCalculatedDtl.ChallanQty = Convert.ToInt32(dtBookAllotedQty.Rows[jCnt]["AllotedQty"].ToString());
IssuedQty = IssuedQty + objBookRequisitionCalculatedDtl.ChallanQty;
IssuedWeight = IssuedWeight + Convert.ToDouble(dtBookAllotedQty.Rows[jCnt]["TotWeight"].ToString());
break;
}
}
ObjlstBookRequisitionCalculatedDtl.Add(objBookRequisitionCalculatedDtl);
}
}
objSchProvisionalChallan.BookRequisitionCalculatedDtlCollection = ObjlstBookRequisitionCalculatedDtl;
objSchProvisionalChallan.RequiredQty = RequiredQty;
objSchProvisionalChallan.IssuedQty = IssuedQty;
objSchProvisionalChallan.RemainigQty = RequiredQty - IssuedQty;
objSchProvisionalChallan.RequiredWeight = RequiredWeight;
objSchProvisionalChallan.IssuedWeight = IssuedWeight;
objSchProvisionalChallan.RemainigWeight = RequiredWeight - IssuedWeight;
}
catch (Exception ex)
{
objSchProvisionalChallan.UpdateCode = "ERROR";
objSchProvisionalChallan.UpdateMessage = "Some Error occured. please contact system administrator.";
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(Json(objSchProvisionalChallan, JsonRequestBehavior.AllowGet));
}
