public int DalSaveNewFootBed(object footBed)
{
int res = 0;
FootBed_Dal footBed_dal = new FootBed_Dal();
footBed_dal = footBed as FootBed_Dal;
using (KarmenDbContext db = new KarmenDbContext())
{
var temp = db.Footbed.Any(c => c.Type == footBed_dal.Type && c.CrossReference == footBed_dal.CrossReference);
if (temp == false)
{
// Add new element to Db
db.Footbed.Add(new Footbeds {
Type = footBed_dal.Type,
CrossReference = footBed_dal.CrossReference,
AdditionalInformation = footBed_dal.AdditionalInformation
});
db.SaveChanges();
// Get element from Db
var users = db.Footbed.Any(c => c.Type == footBed_dal.Type && c.CrossReference == footBed_dal.CrossReference);
res = (users == false) ? 0 : 1; //0 - Saving Error; 1 - Saving is correct
}
else
{
res = 2; //This note is already created in Db
}
}
return(res);
}
public int DalChangeExistedFootBed(object footBed)
{
int res = 0;
FootBed_Dal footBed_dal = new FootBed_Dal();
footBed_dal = footBed as FootBed_Dal;
using (KarmenDbContext db = new KarmenDbContext())
{
var temp = db.Footbed.FirstOrDefault(c => c.Id == footBed_dal.Id);
//Change selected data
temp.Type = footBed_dal.Type;
temp.CrossReference = footBed_dal.CrossReference;
temp.AdditionalInformation = footBed_dal.AdditionalInformation;
//Save changes
db.SaveChanges();
}
res = 1;
return(res);
}
