public MemoTallyStockByRfidViewModel MemoTallyStockByRfid(int LoginID, int OrderID, string RFIDs)
{
MemoTallyStockByRfidViewModel objTS = new MemoTallyStockByRfidViewModel();
var cmd = context.Database.Connection.CreateCommand();
// @orderDetailsId,@MemoID,@LotNos,@LoginId,@CustomerID,@isConfirmed,@isSellDirect,@memoMode,@salesAvgDiscount,@remark,@RaiseEvent
cmd.CommandText = string.Format("exec proc_MemoTallyStockByRfid {0},{1},'{2}'", LoginID.ToString(), OrderID.ToString(), RFIDs);
try
{
context.Database.Connection.Open();
// Run the sproc
var reader = cmd.ExecuteReader();
// Read OrderDetail from the first result set
objTS.InMemo = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <inventoryDetailsViewModel>(reader).ToList();
reader.NextResult();
objTS.InBox = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <inventoryDetailsViewModel>(reader).ToList();
}
finally
{
context.Database.Connection.Close();
}
return(objTS);
}
public MemoTallyStockByRfidViewModel MemoTallyStockByRfid(int LoginID, int OrderID, string RFIDs)
{
MemoTallyStockByRfidViewModel objModel = uow.Orders.MemoTallyStockByRfid(LoginID, OrderID, RFIDs);
objModel.Final = new List <inventoryDetailsViewModel>();
for (int i = 0; i < objModel.InMemo.Count; i++)
{
if (string.IsNullOrEmpty(objModel.InMemo[i].rfid))
{
objModel.InMemo[i].RFIDStatus = "RFID Not Assigned";
objModel.Final.Add(objModel.InMemo[i]);
objModel.InMemo.RemoveAt(i);
i--;
continue;
}
for (int j = 0; j < objModel.InBox.Count; j++)
{
if (objModel.InMemo[i].inventoryID == objModel.InBox[j].inventoryID)
{
objModel.InMemo[i].RFIDStatus = "On Memo";
objModel.Final.Add(objModel.InMemo[i]);
objModel.InMemo.RemoveAt(i);
objModel.InBox.RemoveAt(j);
i--;
break;
}
}
}
for (int i = 0; i < objModel.InMemo.Count; i++)
{
objModel.InMemo[i].RFIDStatus = "Missed Lotnumber";
objModel.Final.Add(objModel.InMemo[i]);
}
for (int i = 0; i < objModel.InBox.Count; i++)
{
objModel.InBox[i].RFIDStatus = "Not This Memo";
objModel.Final.Add(objModel.InBox[i]);
}
return(objModel);
}
public ActionResult TallyMemoByRfid(int OrderID, string RFIDs)
{
try
{
int LoginID = GetLogin();
if (LoginID > 0)
{
MemoTallyStockByRfidViewModel objLst = this.objSvc.MemoTallyStockByRfid(LoginID, OrderID, RFIDs);
return(Json(new Response {
Code = 200, IsSuccess = true, Message = "", Result = objLst
}));
}
return(Json(new Response {
IsSuccess = false, Message = string.Format(StringResource.Invalid, "Session")
}));
}
catch (Exception ex)
{
ErrorLog.Log("MemoController", "MemoTallyStockByRfid", ex);
return(Json(new Response {
IsSuccess = false, Message = ex.Message
}));
}
}
