public int DalSaveNewTopMaterial(object topMaterial)
{
int res = 0;
TopMaterial_Dal topMaterial_Dal = new TopMaterial_Dal();
topMaterial_Dal = topMaterial as TopMaterial_Dal;
using (KarmenDbContext db = new KarmenDbContext())
{
var temp = db.TopMaterial.Any(c => c.Type == topMaterial_Dal.Type && c.CrossReference == topMaterial_Dal.CrossReference);
if (temp == false)
{
// Add new element to Db
db.TopMaterial.Add(new TopMaterials
{
IdColour = topMaterial_Dal.IdColour,
Type = topMaterial_Dal.Type,
CrossReference = topMaterial_Dal.CrossReference,
UseUnuse = topMaterial_Dal.UseUnuse
});
db.SaveChanges();
// Get element from Db
var users = db.TopMaterial.Any(c => c.Type == topMaterial_Dal.Type && c.CrossReference == topMaterial_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 DalChangeExistedTopMaterial(object topMaterial)
{
int res = 0;
TopMaterial_Dal topMaterial_Dal = new TopMaterial_Dal();
topMaterial_Dal = topMaterial as TopMaterial_Dal;
using (KarmenDbContext db = new KarmenDbContext())
{
var temp = db.TopMaterial.FirstOrDefault(c => c.Id == topMaterial_Dal.Id);
//Change data
temp.IdColour = topMaterial_Dal.IdColour;
temp.Type = topMaterial_Dal.Type;
temp.CrossReference = topMaterial_Dal.CrossReference;
temp.UseUnuse = topMaterial_Dal.UseUnuse;
//Save changes
db.SaveChanges();
}
res = 1;
return(res);
}
