public void AddNewMessages(MessagesFromBulidingModel messageModel)
{
AccessControlSystemEntities context = new AccessControlSystemEntities();
MessageFromBuilding messageDB = new MessageFromBuilding();
messageDB.Subject = messageModel.Subject;
messageDB.Value = messageModel.Text;
context.MessageFromBuildings.Add(messageDB);
context.SaveChanges();
foreach (var item in messageModel.Companies)
{
MessagesOfCompany newDBItem = new MessagesOfCompany();
newDBItem.CompanyId = item.Id;
newDBItem.MessageFromBuildingId = messageDB.Id;
context.MessagesOfCompanies.Add(newDBItem);
}
context.SaveChanges();
}
private MessageToCompanyModel MapToMessageFromBulidingModel(MessagesOfCompany messageFromCompanyDB, AccessControlSystemEntities context)
{
MessageToCompanyModel messsageToCompany = new MessageToCompanyModel();
messsageToCompany.Id = messageFromCompanyDB.Id;
messsageToCompany.CompanyId = messageFromCompanyDB.CompanyId;
messsageToCompany.CompanyName = (from x in context.Companies
where x.Id == messageFromCompanyDB.CompanyId
select x.Name
).FirstOrDefault();
messsageToCompany.Subject = (from x in context.MessageFromBuildings
where x.Id == messageFromCompanyDB.MessageFromBuildingId
select x.Subject
).FirstOrDefault();
messsageToCompany.Text = (from x in context.MessageFromBuildings
where x.Id == messageFromCompanyDB.MessageFromBuildingId
select x.Value
).FirstOrDefault();
return(messsageToCompany);
}
