public int DalSaveNewMaterialOfSole(object materialOfSole)
{
int res = 0;
MaterialOfSole_Dal materialOfSole_dal = new MaterialOfSole_Dal();
materialOfSole_dal = materialOfSole as MaterialOfSole_Dal;
using (KarmenDbContext db = new KarmenDbContext())
{
var temp = db.MaterialOfSole.Any(c => c.Name == materialOfSole_dal.Name && c.CrossReference == materialOfSole_dal.CrossReference);
if (temp == false)
{
// Add new element to Db
db.MaterialOfSole.Add(new MaterialsOfSole
{
Name = materialOfSole_dal.Name,
IdColour = materialOfSole_dal.IdColour,
CrossReference = materialOfSole_dal.CrossReference,
UseUnuse = materialOfSole_dal.UseUnuse
});
db.SaveChanges();
// Get element from Db
var users = db.MaterialOfSole.Any(c => c.Name == materialOfSole_dal.Name && c.CrossReference == materialOfSole_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 DalChangeExistedMaterialOfSole(object materialOfSole)
{
int res = 0;
MaterialOfSole_Dal materialOfSole_dal = new MaterialOfSole_Dal();
materialOfSole_dal = materialOfSole as MaterialOfSole_Dal;
using (KarmenDbContext db = new KarmenDbContext())
{
var temp = db.MaterialOfSole.FirstOrDefault(c => c.Id == materialOfSole_dal.Id);
// Change data
temp.Name = materialOfSole_dal.Name;
temp.IdColour = materialOfSole_dal.IdColour;
temp.CrossReference = materialOfSole_dal.CrossReference;
temp.UseUnuse = materialOfSole_dal.UseUnuse;
//Save changes
db.SaveChanges();
}
res = 1;
return(res);
}
