public int DalSaveNewLining(object lining)
{
int res = 0;
Lining_Dal lining_dal = new Lining_Dal();
lining_dal = lining as Lining_Dal;
using (KarmenDbContext db = new KarmenDbContext())
{
var temp = db.Lining.Any(c => c.Name == lining_dal.Name && c.CrossReference == lining_dal.CrossReference);
if (temp == false)
{
// Add new element to Db
db.Lining.Add(new Linings
{
Name = lining_dal.Name,
Season = lining_dal.Season,
AdditionalInformation = lining_dal.AdditionalInformation,
CrossReference = lining_dal.CrossReference,
UseUnuse = lining_dal.UseUnuse
});
db.SaveChanges();
// Get element from Db
var users = db.Lining.Any(c => c.Name == lining_dal.Name && c.CrossReference == lining_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 DalChangeExistedLining(object lining)
{
int res = 0;
Lining_Dal lining_dal = new Lining_Dal();
lining_dal = lining as Lining_Dal;
using (KarmenDbContext db = new KarmenDbContext())
{
var temp = db.Lining.FirstOrDefault(c => c.Id == lining_dal.Id);
// Change data
temp.Name = lining_dal.Name;
temp.Season = lining_dal.Season;
temp.AdditionalInformation = lining_dal.AdditionalInformation;
temp.CrossReference = lining_dal.CrossReference;
temp.UseUnuse = lining_dal.UseUnuse;
//Save changes
db.SaveChanges();
}
res = 1;
return(res);
}
