//Save New Data for all tables of DB
#region
public int DalSaveNewColour(object colour)
{
int res = 0;
Colour_Dal colour_dal = new Colour_Dal();
colour_dal = colour as Colour_Dal;
using (KarmenDbContext db = new KarmenDbContext())
{
var temp = db.Colour.Any(c => c.Colour == colour_dal.Colour);
if (temp == false)
{
// Add new element to Db
db.Colour.Add(new Colours {
Colour = colour_dal.Colour
});
db.SaveChanges();
// Get element from Db
var users = db.Colour.Any(c => c.Colour == colour_dal.Colour);
res = (users == false) ? 0 : 1; //0 - Saving Error; 1 - Saving is correct
}
else
{
res = 2; //This note is already created in Db
}
}
return(res);
}
//Change Existed Data for all tables of DB
#region
public int DalChangeExistedColour(object colour)
{
int res = 0;
Colour_Dal colour_dal = new Colour_Dal();
colour_dal = colour as Colour_Dal;
using (KarmenDbContext db = new KarmenDbContext())
{
var temp = db.Colour.FirstOrDefault(c => c.Id == colour_dal.Id);
//Change selected data
temp.Colour = colour_dal.Colour;
//Save changes
db.SaveChanges();
}
res = 1;
return(res);
}
