public int editByBearing(string id, string name, string no)
{
int flag = 0;
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
Bearing bear = new Bearing()
{
BearingId = int.Parse(id),
Code = int.Parse(no),
Name = name,
UpdateBy=1,
UpdateDatetime=DateTime.Now
};
DbEntityEntry<Bearing> entry = entities.Entry<Bearing>(bear);
entry.State = System.Data.EntityState.Unchanged;
entry.Property("Code").IsModified = true;
entry.Property("Name").IsModified = true;
entry.Property("UpdateBy").IsModified = true;
entry.Property("UpdateDatetime").IsModified = true;
try
{
flag = entities.SaveChanges();
}
catch (Exception ex)
{
ex.ToString();
}
}
return flag;
}
public int delByBearing(string id)
{
int flag = 0;
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
Bearing bear = new Bearing()
{
BearingId = int.Parse(id),
UpdateBy=1,
Deleted = 1,
UpdateDatetime=DateTime.Now
};
DbEntityEntry<Bearing> entry = entities.Entry<Bearing>(bear);
entry.State = System.Data.EntityState.Unchanged;
entry.Property("UpdateBy").IsModified = true;
entry.Property("Deleted").IsModified = true;
entry.Property("UpdateDatetime").IsModified = true;
try
{
entities.Configuration.ValidateOnSaveEnabled = false;
flag = entities.SaveChanges();
entities.Configuration.ValidateOnSaveEnabled = true;
}
catch (Exception ex)
{
ex.ToString();
}
}
return flag;
}
public int addBearing(string name, string no)
{
int flag = 0;
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
Bearing bear = new Bearing()
{
Code = int.Parse(no),
Name = name,
CreateDatetime = DateTime.Now,
CreateBy = 1,
Deleted = 1,
Status = 1
};
entities.Bearing.Add(bear);
try
{
flag = entities.SaveChanges();
}
catch (Exception ex)
{
ex.ToString();
}
}
return flag;
}