/// <summary>
/// 管理员信息添加
/// </summary>
/// <param name="t">Administrator对象</param>
/// <returns></returns>
public int Add(Administrator t)
{
using (EFContext Context = new EFContext())
{
var jieguo = from s in Context.Administrator
select s;
if (jieguo.FirstOrDefault() == null)
{
Administrator administrator = new Administrator()
{
AdministratorAccount = t.AdministratorAccount,
AdministratorPwd = t.AdministratorPwd
};
DbEntityEntry <Administrator> dbEntityAdm = Context.Entry <Administrator>(administrator);
dbEntityAdm.State = System.Data.Entity.EntityState.Added;
return(Context.SaveChanges());
}
else
{
jieguo = jieguo.Where(a => a.AdministratorAccount == t.AdministratorAccount && a.AdministratorPwd == t.AdministratorPwd);
if (jieguo.FirstOrDefault() != null)
{
return(1);
}
else
{
return(0);
}
}
}
}
/// <summary>
/// 管理员信息添加
/// </summary>
/// <param name="t">Administrator对象</param>
/// <returns></returns>
public int AddLogin(UserInfo t)
{
using (EFContext Context = new EFContext())
{
var jieguo = from s in Context.UserInfo
select s;
if (jieguo.FirstOrDefault() == null)
{
UserInfo userInfo = new UserInfo()
{
UserName = t.UserName,
UserPwd = t.UserPwd
};
DbEntityEntry <UserInfo> dbEntityAdm = Context.Entry <UserInfo>(userInfo);
dbEntityAdm.State = System.Data.Entity.EntityState.Added;
return(Context.SaveChanges());
}
else
{
jieguo = jieguo.Where(a => a.UserName == t.UserName && a.UserPwd == t.UserPwd);
if (jieguo.FirstOrDefault() != null)
{
return(1);
}
else
{
return(0);
}
}
}
}
public int Add(Courier t)
{
using (EFContext Context = new EFContext())
{
DbEntityEntry <Courier> dbEntityAdm = Context.Entry <Courier>(t);
dbEntityAdm.State = System.Data.Entity.EntityState.Added;
return(Context.SaveChanges());
}
}
/// <summary>
/// 添加到购物车
/// </summary>
/// <param name="t">购物车对象(接收字段:UID 用户id int,GID 商品id int,Num 购买数量 int )</param>
/// <returns></returns>
public int Add(ShoppingCart t)
{
using (EFContext Context = new EFContext())
{
DbEntityEntry <ShoppingCart> dbEntityAdm = Context.Entry <ShoppingCart>(t);
dbEntityAdm.State = System.Data.Entity.EntityState.Added;
return(Context.SaveChanges());
}
}
/// <summary>
/// 商品添加
/// </summary>
/// <param name="t">商品对象</param>
/// <returns></returns>
public int Add(GoodsInfo t)
{
using (EFContext Context = new EFContext())
{
t.GoodCreateTime = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
DbEntityEntry <GoodsInfo> dbEntityAdm = Context.Entry <GoodsInfo>(t);
dbEntityAdm.State = System.Data.Entity.EntityState.Added;
return(Context.SaveChanges());
}
}
/// <summary>
/// 用户添加
/// </summary>
/// <param name="t">用户对象</param>
/// <returns></returns>
public int Add(UserInfo t)
{
UserInfo data = t as UserInfo;
using (EFContext Context = new EFContext())
{
DbEntityEntry <UserInfo> dbEntityUser = Context.Entry <UserInfo>(data);
dbEntityUser.State = System.Data.Entity.EntityState.Added;
return(Context.SaveChanges());
}
}
public void UpdateEntiteit(Entiteit entiteitToUpdate)
{
/*
* foreach (var trend in entiteitToUpdate.Trends)
* {
* //ctx.Entry(trend).State = System.Data.Entity.EntityState.Added;
* ctx.Trends.Attach(trend);
* }
*/
ctx.Entry(entiteitToUpdate).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
}
public Deelplatform UpdateDeelplatform(Deelplatform uDeelplatform)
{
Deelplatform toChange = ReadDeelplatform(uDeelplatform.DeelplatformId);
if (toChange != null)
{
toChange.Naam = uDeelplatform.Naam;
toChange.Tagline = uDeelplatform.Tagline;
toChange.Entiteiten = uDeelplatform.Entiteiten;
ctx.Entry(toChange).State = System.Data.Entity.EntityState.Modified;
}
ctx.SaveChanges();
return(toChange);
}
public void AdicionaPerfil(Perfil perfil)
{
Perfil p = VerificaPerfil(perfil);
if (p == null)
{
_efContext.Perfis.Add(perfil);
}
else
{
p.Descricao = perfil.Descricao;
_efContext.Entry(p).State = EntityState.Modified;
}
_efContext.SaveChanges();
}
/// <summary>
/// 修改密码或修改发货信息
/// </summary>
/// <param name="t">Administrator对象</param>
/// <returns></returns>
public int Upt(Administrator t)
{
using (EFContext Context = new EFContext())
{
Context.Entry(t).State = System.Data.Entity.EntityState.Modified;
if (t.AdministratorPwd == null)
{
//修改发货信息禁止其他字段更新
Context.Entry(t).Property("AdministratorAccount").IsModified = false;
Context.Entry(t).Property("AdministratorPwd").IsModified = false;
}
else
{
//修改密码禁止其他字段更新
Context.Entry(t).Property("AdministratorAccount").IsModified = false;
Context.Entry(t).Property("DeliveryName").IsModified = false;
Context.Entry(t).Property("DeliveryAddress").IsModified = false;
Context.Entry(t).Property("DeliveryPhone").IsModified = false;
}
return(Context.SaveChanges());
}
}
public void Edit(Condominio objeto)
{
ctx.Entry(objeto).State = EntityState.Modified;
ctx.SaveChanges();
}
public Persoon UpdatePerson(Persoon UpdatedPerson)
{
ctx.Entry(UpdatedPerson).State = EntityState.Modified;
ctx.SaveChanges();
return(UpdatedPerson);
}
public void updatePost(Post postToUpdate)
{
ctx.Entry(postToUpdate).State = EntityState.Modified;
ctx.SaveChanges();
}
/// <summary>
/// 修改用户信息或修改密码
/// </summary>
/// <param name="t">用户对象</param>
/// <returns></returns>
public int Upt(UserInfo t)
{
using (EFContext Context = new EFContext())
{
Context.Entry(t).State = System.Data.Entity.EntityState.Modified;
if (t.UserPwd == null)
{
//修改用户信息禁止其他字段更新
Context.Entry(t).Property("UserAccount").IsModified = false;
Context.Entry(t).Property("UserPwd").IsModified = false;
Context.Entry(t).Property("UserCraeteTime").IsModified = false;
}
else
{
//修改密码禁止其他字段更新
Context.Entry(t).Property("UserAccount").IsModified = false;
Context.Entry(t).Property("PhotoPath").IsModified = false;
Context.Entry(t).Property("UserName").IsModified = false;
Context.Entry(t).Property("PhoneNumber").IsModified = false;
Context.Entry(t).Property("Email").IsModified = false;
Context.Entry(t).Property("Sex").IsModified = false;
Context.Entry(t).Property("UserCraeteTime").IsModified = false;
}
return(Context.SaveChanges());
}
}
/// <summary>
/// 新增方法
/// </summary>
/// <param name="entity">要新增的对象</param>
/// <returns>受影响行数</returns>
public int Add(T entity)
{
db.Entry <T>(entity).State = EntityState.Added;//告诉我们现在执行的状态是新增
//保存上面的数据,并且得到受影响行数
return(db.SaveChanges());
}
public void AddAlert(Alert alert)
{
ctx.Alerts.Add(alert);
ctx.Entry(alert.Entiteit).State = EntityState.Unchanged;
ctx.SaveChanges();
}
public void UpdateGrafiek(Grafiek grafiekToUpdate)
{
//ctx.Entry(grafiekToUpdate.Entiteiten).State = EntityState.Unchanged;
ctx.Entry(grafiekToUpdate).State = EntityState.Modified;
ctx.SaveChanges();
}
