public ActionResult SaveEmptyMove(EmptyMoveVM D)
{
bool status = false;
string mes = "";
var w = (from y in db.UserLogins
where y.UserID.ToString() == User.Identity.Name
select new { y.WorkStationID }).FirstOrDefault();
var wn = db.Warehouses.Where(x => x.WarehouseID == w.WorkStationID).FirstOrDefault();
string s1 = w.WorkStationID.ToString();
string s2 = string.Concat(s1 + "100000");
int TrNo = Convert.ToInt32(s2);
var maxNO = (from n in db.EmptyMoveMasters where n.WarehouseID == w.WorkStationID select n.TransactionNo).DefaultIfEmpty(TrNo).Max();
var maxTrNo = maxNO + 1;
int v = maxTrNo;
if (ModelState.IsValid)
{
if (D.TransactionType == 28)
{
D.Status = "A";
}
else if (D.TransactionType == 29)
{
D.Status = "T";
}
else if (D.TransactionType == 30)
{
D.Status = "C";
}
else if (D.TransactionType == 31)
{
D.Status = "P";
}
else if (D.TransactionType == 32)
{
D.Status = "D";
}
else if (D.TransactionType == 34)
{
D.Status = "O";
}
else
{
D.Status = "A";
}
if (D.DriverID == null)
{
D.DriverID = 0;
}
if (D.LocationID == null)
{
D.LocationID = "TBL000";
}
if (D.BinNo == null)
{
D.BinNo = "20000";
}
EmptyMoveMaster dbo = new EmptyMoveMaster
{
TransactionNo = maxTrNo,
WarehouseID = D.WarehouseID,
ReferenceNo = D.ReferenceNo,
ToWarehouse = D.ToWarehouse,
FromWarehouse = D.WarehouseID,
DriverID = D.DriverID,
VehicleNo = D.VehicleNo,
TotalEmpty = D.TotalEmpty,
TotalBox = D.TotalBox,
TransactionType = D.TransactionType,
LocationID = D.LocationID,
BinNo = D.BinNo,
Status = D.Status,
Remarks = D.Remarks,
TransactionDate = DateTime.Today,
CreateDate = DateTime.Now,
CreateBy = User.Identity.Name
};
db.EmptyMoveMasters.Add(dbo);
foreach (var i in D.emptydetail)
{
EmptyMoveDetail obd = new EmptyMoveDetail();
obd.WarehouseID = D.WarehouseID;
obd.ProductID = i.ProductID;
obd.TransactionNo = maxTrNo;
obd.Boxes = i.Boxes;
obd.QuantityCase = i.QuantityCase;
obd.CreateBy = User.Identity.Name;
obd.CreateDate = DateTime.Now;
db.EmptyMoveDetails.Add(obd);
}
db.SaveChanges();
status = true;
db.Dispose();
ModelState.Clear();
}
else
{
status = false;
}
return(new JsonResult {
Data = new { status = status, mes = mes, v = v }
});
}
public JsonResult TransfferData(EmptyTransferVM S)
{
bool status = false;
string mes = "";
var w = (from y in db.UserLogins
where y.UserID.ToString() == User.Identity.Name
select new { y.WorkStationID }).FirstOrDefault();
var wn = db.Warehouses.Where(x => x.WarehouseID == w.WorkStationID).FirstOrDefault();
string s1 = w.WorkStationID.ToString();
string s2 = string.Concat(s1 + "100000");
int TrNo = Convert.ToInt32(s2);
var maxNO = (from n in db.EmptyMoveMasters where n.WarehouseID == w.WorkStationID select n.TransactionNo).DefaultIfEmpty(TrNo).Max();
var maxTrNo = maxNO + 1;
int v = maxTrNo;
try
{
if (ModelState.IsValid)
{
EmptyMoveMaster dm = new EmptyMoveMaster();
{
dm.TransactionType = 33;
dm.TransactionNo = maxTrNo;
dm.WarehouseID = S.WarehouseID;
dm.FromWarehouse = S.FromWarehouse;
dm.ToWarehouse = S.WarehouseID;
dm.TransactionDate = DateTime.Today;
dm.TotalEmpty = S.TotalEmpty;
dm.TotalBox = S.TotalBox;
dm.BinNo = S.BinNo;
dm.LocationID = S.LocationID;
dm.DriverID = S.DriverID;
dm.VehicleNo = "0";
dm.ReferenceNo = S.ReferenceNo;
dm.Remarks = S.Remarks;
dm.Status = "A";
dm.CreateBy = User.Identity.Name;
dm.CreateDate = DateTime.Now;
}
db.EmptyMoveMasters.Add(dm);
foreach (var i in S.emptydetail)
{
EmptyMoveDetail dmd = new EmptyMoveDetail();
dmd.ProductID = i.ProductID;
dmd.WarehouseID = S.WarehouseID;
dmd.TransactionNo = maxTrNo;
dmd.QuantityCase = i.QuantityCase;
dmd.Boxes = i.Boxes;
dmd.CreateBy = User.Identity.Name;
dmd.CreateDate = DateTime.Now;
db.EmptyMoveDetails.Add(dmd);
}
var pt = db.spEmptyTransferInformation(S.FromWarehouse, S.TransactionNo, "U", User.Identity.Name);
db.SaveChanges();
status = true;
db.Dispose();
}
else
{
status = false;
}
return(new JsonResult {
Data = new { status = status, mes = mes, v = v }
});
}
catch (Exception ex)
{
string mess = ex.Message;
return(Json(new { status = "error", message = "Transaction No Not Found" }));
}
}