public bool queryUpdateContractMove(ContractMove c)
{
if (LoginInfo.Position == 1 || LoginInfo.Position == 3) //Начальник или Кладовщик
{
using (DataBaseContext db = new DataBaseContext())
{
try
{
ContractMove contract = db.ContractMoves.Find(c.Id);
contract.StoreCellToId = c.StoreCellToId;
contract.StoreCellFromId = c.StoreCellFromId;
contract.ProductId = c.ProductId;
contract.Amount = c.Amount;
contract.Date = c.Date;
db.SaveChanges();
}
catch (Exception e)
{
return(false);
}
return(true);
}
}
return(false);
}
public ContractMoveTable(ContractMove contractMove, StoreCell storeCellFrom, StoreCell storeCellTo, Storehouse storehouseFrom, Storehouse storehouseTo)
{
this.contractMove = contractMove;
this.storeCellFrom = storeCellFrom;
this.storeCellTo = storeCellTo;
this.storehouseFrom = storehouseFrom;
this.storehouseTo = storehouseTo;
}
public ContractMove queryFindContractMoveById(int Id)
{
if (LoginInfo.Position == 1 || LoginInfo.Position == 3) //Начальник или Кладовщик
{
using (DataBaseContext db = new DataBaseContext())
{
ContractMove c = db.ContractMoves.Find(Id);
c.StoreCellFromObj = c.StoreCellFromObj;
c.StoreCellToObj = c.StoreCellToObj;
//StoreCellTable sct = new StoreCellTable(c.StoreCellFromObj,
return(c);
}
}
return(null);
}
public bool queryAddContractMove(ContractMove c)
{
if (LoginInfo.Position == 1 || LoginInfo.Position == 3) //Начальник или Кладовщик
{
using (DataBaseContext db = new DataBaseContext())
{
try
{
db.ContractMoves.Add(c);
db.SaveChanges();
}
catch (Exception e)
{
return(false);
}
return(true);
}
}
return(false);
}
public bool queryDeleteContractMove(int Id)
{
if (LoginInfo.Position == 1 || LoginInfo.Position == 3) //Начальник или Кладовщик
{
using (DataBaseContext db = new DataBaseContext())
{
try
{
ContractMove contract = db.ContractMoves.Find(Id);
db.ContractMoves.Remove(contract);
db.SaveChanges();
}
catch (Exception e)
{
return(false);
}
return(true);
}
}
return(false);
}