public int DalSaveNewKindOfBlock(object kindOfBlock)
{
int res = 0;
KindOfBlock_Dal kindOfBlock_dal = new KindOfBlock_Dal();
kindOfBlock_dal = kindOfBlock as KindOfBlock_Dal;
using (KarmenDbContext db = new KarmenDbContext())
{
var temp = db.KindOfBlock.Any(c => c.Name == kindOfBlock_dal.Name && c.CrossReference == kindOfBlock_dal.CrossReference);
if (temp == false)
{
// Add new element to Db
db.KindOfBlock.Add(new KindOfBlocks
{
Name = kindOfBlock_dal.Name,
AdditionalInformation = kindOfBlock_dal.AdditionalInformation,
CrossReference = kindOfBlock_dal.CrossReference
});
db.SaveChanges();
// Get element from Db
var users = db.KindOfBlock.Any(c => c.Name == kindOfBlock_dal.Name && c.CrossReference == kindOfBlock_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 DalChangeExistedKindOfBlock(object kindOfBlock)
{
int res = 0;
KindOfBlock_Dal kindOfBlock_dal = new KindOfBlock_Dal();
kindOfBlock_dal = kindOfBlock as KindOfBlock_Dal;
using (KarmenDbContext db = new KarmenDbContext())
{
var temp = db.KindOfBlock.FirstOrDefault(c => c.Id == kindOfBlock_dal.Id);
// Change data
temp.Name = kindOfBlock_dal.Name;
temp.AdditionalInformation = kindOfBlock_dal.AdditionalInformation;
temp.CrossReference = kindOfBlock_dal.CrossReference;
//Save changes
db.SaveChanges();
}
res = 1;
return(res);
}