public int DalChangeExistedComponent(object component)
{
int res = 0;
Component_Dal component_dal = new Component_Dal();
component_dal = component as Component_Dal;
using (KarmenDbContext db = new KarmenDbContext())
{
var temp = db.Component.FirstOrDefault(c => c.Id == component_dal.Id);
//Change selected data
temp.TypeOfComponent = component_dal.TypeOfComponent;
temp.IdColour = component_dal.IdColour;
temp.Size = component_dal.Size;
temp.UseUnuse = component_dal.UseUnuse;
temp.CrossReference = component_dal.CrossReference;
temp.AdditionalInformation = component_dal.AdditionalInformation;
temp.IdMaterilOfCovering = component_dal.IdMaterilOfCovering;
temp.Height = component_dal.Height;
temp.Width = component_dal.Width;
temp.Form = component_dal.Form;
temp.Type = component_dal.Type;
//Save changes
db.SaveChanges();
}
res = 1;
return(res);
}
public int DalSaveNewComponent(object component)
{
int res = 0;
Component_Dal component_dal = new Component_Dal();
component_dal = component as Component_Dal;
using (KarmenDbContext db = new KarmenDbContext())
{
var temp = db.Component.Any(c => c.TypeOfComponent == component_dal.TypeOfComponent && c.CrossReference == component_dal.CrossReference);
if (temp == false)
{
// Add new element to Db
db.Component.Add(new Components {
TypeOfComponent = component_dal.TypeOfComponent,
IdColour = component_dal.IdColour,
Size = component_dal.Size,
UseUnuse = component_dal.UseUnuse,
CrossReference = component_dal.CrossReference,
AdditionalInformation = component_dal.AdditionalInformation,
IdMaterilOfCovering = component_dal.IdMaterilOfCovering,
Height = component_dal.Height,
Width = component_dal.Width,
Form = component_dal.Form,
Type = component_dal.Type
});
db.SaveChanges();
// Get element from Db
var users = db.Component.Any(c => c.TypeOfComponent == component_dal.TypeOfComponent && c.CrossReference == component_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);
}
