public void Create(Department dpt)
{
using (var ctx = new LYLQEntities())
{
ctx.Departments.Add(dpt);
ctx.SaveChanges();
}
}
public void Create(InStore dpt)
{
using (var ctx = new LYLQEntities())
{
ctx.InStores.Add(dpt);
ctx.SaveChanges();
}
}
public void Create(Materiel mat)
{
using (var ctx = new LYLQEntities())
{
ctx.Materiels.Add(mat);
ctx.SaveChanges();
}
}
public void Create(OutStore ots)
{
using (var ctx = new LYLQEntities())
{
ctx.OutStores.Add(ots);
ctx.SaveChanges();
}
}
public void Create(User user)
{
using (var ctx = new LYLQEntities())
{
user.Id = Guid.NewGuid().ToString();
ctx.Users.Add(user);
ctx.SaveChanges();
}
}
public void Delete(string code)
{
using (var ctx = new LYLQEntities())
{
var dbDpts = from dbDpt in ctx.Departments
where dbDpt.Code == code
select dbDpt;
ctx.Departments.Remove(dbDpts.First());
ctx.SaveChanges();
}
}
public void Delete(string id)
{
using (var ctx = new LYLQEntities())
{
var dbUsers = from dbUser in ctx.Users
where dbUser.Id == id
select dbUser;
ctx.Users.Remove(dbUsers.First());
ctx.SaveChanges();
}
}
public void Delete(string code)
{
using (var ctx = new LYLQEntities())
{
var dbUsers = from dbMaterial in ctx.Materiels
where dbMaterial.Code == code
select dbMaterial;
ctx.Materiels.Remove(dbUsers.First());
ctx.SaveChanges();
}
}
public void Delete(string id)
{
using (var ctx = new LYLQEntities())
{
var dbInsts = from dbInst in ctx.InStores
where dbInst.Id == id
select dbInst;
var dbModelInSt = dbInsts.First();
ctx.InStores.Remove(dbModelInSt);
ctx.SaveChanges();
}
}
public void Update(Materiel mat)
{
using (var ctx = new LYLQEntities())
{
var dbMats = from dbMat in ctx.Materiels
where dbMat.Code == mat.Code
select dbMat;
var dbModelDpt = dbMats.First();
dbModelDpt.Name = mat.Name;
dbModelDpt.UpdatedBy = mat.UpdatedBy;
dbModelDpt.UpdatedDate = DateTime.Now;
ctx.SaveChanges();
}
}
public void Update(User user)
{
using (var ctx = new LYLQEntities()){
var dbUsers = from dbUser in ctx.Users
where dbUser.Id == user.Id
select dbUser;
var dbModelUser = dbUsers.First();
dbModelUser.Password = user.Password;
dbModelUser.Demartment = user.Demartment;
dbModelUser.Enabled = user.Enabled;
dbModelUser.UpdatedBy = user.UpdatedBy;
dbModelUser.UpdatedDate = DateTime.Now;
ctx.SaveChanges();
}
}
public void Update(Department dpt)
{
using (var ctx = new LYLQEntities())
{
var dbDpts = from dbDpt in ctx.Departments
where dbDpt.Code == dpt.Code
select dbDpt;
var dbModelDpt = dbDpts.First();
dbModelDpt.Name = dpt.Name;
dbModelDpt.UpdatedBy = dpt.UpdatedBy;
dbModelDpt.UpdatedDate = DateTime.Now;
ctx.SaveChanges();
}
}
public void OutStore(InStore dpt)
{
using (var ctx = new LYLQEntities())
{
var dbInsts = from dbInst in ctx.InStores
where dbInst.Id == dpt.Id
select dbInst;
var dbModelInSt = dbInsts.First();
dbModelInSt.RemainNumber = dpt.RemainNumber;
dbModelInSt.RemainTotalPrice = dpt.RemainTotalPrice;
dbModelInSt.UpdatedBy = dpt.UpdatedBy;
dbModelInSt.UpdatedDate = DateTime.Now;
ctx.SaveChanges();
}
}
public void Update(OutStore outStore)
{
using (var ctx = new LYLQEntities())
{
var dbOuts = from dbOut in ctx.OutStores
where dbOut.Id == outStore.Id
select dbOut;
var dbModelOut = dbOuts.First();
dbModelOut.InstoreId = outStore.InstoreId;
dbModelOut.Code = outStore.Code;
dbModelOut.UnitPrice = outStore.UnitPrice;
dbModelOut.Number = outStore.Number;
dbModelOut.TotalPrice = outStore.TotalPrice;
dbModelOut.Department = outStore.Department;
dbModelOut.Type = outStore.Type;
dbModelOut.UpdatedBy = outStore.UpdatedBy;
dbModelOut.UpdatedDate = DateTime.Now;
ctx.SaveChanges();
}
}