public ActionResult Index(Int64?ReqisitionId, int circleId = 0)
{
ViewBag.Active = "TrxSchRequisition";
ViewBag.RequisitionLock = false;
int _circleId = default(int);
if (ReqisitionId.HasValue)
{
string objSsn = ((SARASWATIPRESSNEW.UserSec)System.Web.HttpContext.Current.Session["UserSec"]) != null ? ((SARASWATIPRESSNEW.UserSec)System.Web.HttpContext.Current.Session["UserSec"]).CircleID : default(int).ToString();
if (circleId <= default(int))
{
int.TryParse(objSsn, out _circleId);
}
else
{
_circleId = circleId;
}
List <CircleLock> lstCircleLock = new List <CircleLock>();
DataTable dtCircleLock = objDbTrx.GetCircleLockByCircleId(_circleId);
if (dtCircleLock != null && dtCircleLock.Rows.Count > default(int))
{
for (int i = 0; i < dtCircleLock.Rows.Count; i++)
{
CircleLock objCircleLock = new CircleLock();
objCircleLock.id = Convert.ToInt32(dtCircleLock.Rows[i]["id"]);
objCircleLock.circle_id = Convert.ToInt32(dtCircleLock.Rows[i]["circle_id"]);
objCircleLock.Req_lock = dtCircleLock.Rows[i]["Req_lock"].ToString();
objCircleLock.Req_year = dtCircleLock.Rows[i]["Req_year"].ToString();
objCircleLock.Stock_lock = dtCircleLock.Rows[i]["Stock_lock"].ToString();
objCircleLock.ReqLockDate = DateTime.Parse(dtCircleLock.Rows[i]["ReqLockDate"].ToString());
lstCircleLock.Add(objCircleLock);
}
//lstCircleLock.RemoveAll(c => !c.Req_year.Contains("/19"));
var circlelock = lstCircleLock.FirstOrDefault();
if (circlelock != null)
{
var reqLockStatus = (DateTime.Today > circlelock.ReqLockDate && circlelock.Req_lock == "1") ? true : false;
ViewBag.RequisitionLock = reqLockStatus;
}
}
// var reqLockStatus = ? lstCircleLock.FirstOrDefault().Req_lock : default(int).ToString();
//ViewBag.RequisitionLock = if(DateTime.Today==
}
var schRequisitionDetails = SchRequisitionDtl(ReqisitionId);
return(View(schRequisitionDetails));
}
public PartialViewResult GetReqListTrnf(int distid, int destcrclid, long catid, long langid)
{
StockUpdate lst_req = new StockUpdate();
List <StockTrxDtl> lst_requisition = new List <StockTrxDtl>();
try
{
#region [GetStockLockDetails]
string objSsn = ((SARASWATIPRESSNEW.UserSec)System.Web.HttpContext.Current.Session["UserSec"]) != null ? ((SARASWATIPRESSNEW.UserSec)System.Web.HttpContext.Current.Session["UserSec"]).CircleID : default(int).ToString();
int _circleId = Convert.ToInt32(objSsn);
List <CircleLock> lstCircleLock = new List <CircleLock>();
DataTable dtCircleLock = objDbTrx.GetCircleLockByCircleId(_circleId);
if (dtCircleLock != null && dtCircleLock.Rows.Count > default(int))
{
for (int i = 0; i < dtCircleLock.Rows.Count; i++)
{
CircleLock objCircleLock = new CircleLock();
objCircleLock.id = Convert.ToInt32(dtCircleLock.Rows[i]["id"]);
objCircleLock.circle_id = Convert.ToInt32(dtCircleLock.Rows[i]["circle_id"]);
objCircleLock.Req_lock = dtCircleLock.Rows[i]["Req_lock"].ToString();
objCircleLock.Req_year = dtCircleLock.Rows[i]["Req_year"].ToString();
objCircleLock.Stock_lock = dtCircleLock.Rows[i]["Stock_lock"].ToString();
//objCircleLock.ReqLockDate = DateTime.Parse(dtCircleLock.Rows[i]["Stock_lock"].ToString());
lstCircleLock.Add(objCircleLock);
}
//lstCircleLock.RemoveAll(c => !c.Req_year.Contains("/19"));
ViewBag.StockLock = lstCircleLock.FirstOrDefault() != null?lstCircleLock.FirstOrDefault().Stock_lock : default(int).ToString();
}
#endregion [GetStockLockDetails]
DataTable dtMastData = objDbTrx.GetReqStokDetailsWithTrnf(catid, langid, _circleId, destcrclid);
//dtMastData = dtMastData.AsEnumerable().OrderBy(r => r.Field<int>("ID")).CopyToDataTable();
if (dtMastData.Rows.Count > 0)
{
ViewBag.IsAlreadyConfirmed = dtMastData.Rows[0]["ISCONFIRMED"] != null && !string.IsNullOrWhiteSpace(dtMastData.Rows[0]["ISCONFIRMED"].ToString()) ? Convert.ToInt32(dtMastData.Rows[0]["ISCONFIRMED"].ToString()) : default(int);
//ViewBag.IsAlreadyConfirmed = 0;
for (int i = 0; i < dtMastData.Rows.Count; i++)
{
StockTrxDtl rq = new StockTrxDtl();
rq.AutoID = Convert.ToInt64(!string.IsNullOrWhiteSpace(dtMastData.Rows[i]["CIRCLE_STOCK_UPDATE_AUTO_ID"].ToString()) ? dtMastData.Rows[i]["CIRCLE_STOCK_UPDATE_AUTO_ID"].ToString() : "0");
rq.BookName = Convert.ToString(dtMastData.Rows[i]["BOOK_NAME"].ToString());
rq.BOOK_CODE = dtMastData.Rows[i]["BOOK_CODE"].ToString();
rq.BookID = Convert.ToInt32(dtMastData.Rows[i]["ID"].ToString());
rq.tot = 0;
rq.StockUpdateQuantity = 0;
if (Convert.ToString(dtMastData.Rows[i]["TOT"]).Trim() != "")
{
rq.tot = Convert.ToInt16(dtMastData.Rows[i]["TOT"].ToString());
}
if (Convert.ToString(dtMastData.Rows[i]["STOCK_UPDATE_QTY"]).Trim() != "")
{
rq.StockUpdateQuantity = Convert.ToInt16(dtMastData.Rows[i]["STOCK_UPDATE_QTY"].ToString());
}
if (Convert.ToString(dtMastData.Rows[i]["STOCK_DAMAGE_QTY"]).Trim() != "")
{
rq.StockDamageQuantity = Convert.ToInt16(dtMastData.Rows[i]["STOCK_DAMAGE_QTY"].ToString());
}
if (Convert.ToString(dtMastData.Rows[i]["STOCK_DAMAGE_QTY_AFTERCONF"]).Trim() != "")
{
rq.STOCK_DAMAGE_QTY_AFTERCONF = Convert.ToInt16(dtMastData.Rows[i]["STOCK_DAMAGE_QTY_AFTERCONF"].ToString());
}
if (Convert.ToString(dtMastData.Rows[i]["TOTAL_TRNF_BOOKS"]).Trim() != "")
{
rq.TOTAL_TRNF_BOOKS = Convert.ToInt32(dtMastData.Rows[i]["TOTAL_TRNF_BOOKS"].ToString());
}
if (Convert.ToString(dtMastData.Rows[i]["TMP_ORGN_CIRCLE"]).Trim() != "")
{
rq.TMP_ORGN_CIRCLE = Convert.ToInt32(dtMastData.Rows[i]["TMP_ORGN_CIRCLE"].ToString());
}
if (Convert.ToString(dtMastData.Rows[i]["TMP_DESTN_CIRCLE"]).Trim() != "")
{
rq.TMP_DESTN_CIRCLE = Convert.ToInt32(dtMastData.Rows[i]["TMP_DESTN_CIRCLE"].ToString());
}
if (Convert.ToString(dtMastData.Rows[i]["STOCK_UPDATE_TIMESTAMP"]).Trim() != "")
{
rq.TimeStamp = dtMastData.Rows[i]["STOCK_UPDATE_TIMESTAMP"].ToString();
}
else
{
rq.TimeStamp = DateTime.Now.ToString("dd-MMM-yyyy hh:mm tt");
}
rq.ISCONFIRMED = Convert.ToInt32(Convert.ToString(dtMastData.Rows[i]["ISCONFIRMED"] != null && !string.IsNullOrWhiteSpace(dtMastData.Rows[i]["ISCONFIRMED"].ToString()) ? dtMastData.Rows[i]["ISCONFIRMED"] : default(int)));
try
{
var noOfBooks = Convert.ToInt16(rq.tot);
var stockUpdateQuantity = Convert.ToInt16(rq.StockUpdateQuantity);
var stockDamageQty = Convert.ToInt16(rq.StockDamageQuantity);
var balance = 0;
if (stockUpdateQuantity < noOfBooks)
{
balance = (Convert.ToInt16(rq.tot) - Convert.ToInt16(Math.Abs(Convert.ToInt32(rq.StockUpdateQuantity) - Convert.ToInt32(rq.StockDamageQuantity))));
}
rq.Balance = balance;
}
catch { rq.Balance = 0; }
lst_requisition.Add(rq);
}
}
lst_req.reqStockCollection = lst_requisition;
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
//return Json(new { lst_req.reqStockCollection }, JsonRequestBehavior.AllowGet);
return(PartialView("_reqCollectionTrnf", lst_req));
}
