public void Create(ConsultingViewModel db) { var entity = new Consulting_Table(); entity.ConsultingDate = (DateTime)db.ConsultingDate.Date; entity.Beneficiaries_ID = db.Beneficiaries_ID; var q = entities.Beneficiaries_Table.Where(p => p.Beneficiaries_ID == db.Beneficiaries_ID).SingleOrDefault(); db.BeneficiariesIDNumber = q.BeneficiariesIDNumber; db.BeneficiariesName = q.BeneficiariesName; db.Gender = q.Gender_Table.GenderName; entity.Area_ID = db.Area_ID; entity.BeneficiariesAge = db.BeneficiariesAge; entity.Governorate_ID = db.Governorate_ID; entity.CounselingRequired = HttpUtility.HtmlDecode(db.CounselingRequired); entity.CounselingRendered = HttpUtility.HtmlDecode(db.CounselingRendered); entity.CounselingStatus = db.CounselingStatus; entity.TypeOfCaseID = db.TypeOfCaseID; entity.IssuesTypeID = db.IssuesTypeID; entity.ProjectID = db.ProjectID; entity.UserID = db.UserID; entities.Consulting_Table.Add(entity); entities.SaveChanges(); db.ConsultingID = entity.ConsultingID; }
public void Destroy(ConsultingViewModel db) { var entity = new Consulting_Table(); entity.ConsultingID = db.ConsultingID; entities.Consulting_Table.Attach(entity); entities.Consulting_Table.Remove(entity); entities.SaveChanges(); }
public void Create(ConsultingViewModel db) { var entity = new Consulting_Table(); entity.ConsultingNumber = db.ConsultingNumber; entity.ConsultingDate = (DateTime)db.ConsultingDate.Date; entity.ConsultantName = db.ConsultantName; entity.CounselingRequired = HttpUtility.HtmlDecode(db.CounselingRequired); entity.CounselingRendered = HttpUtility.HtmlDecode(db.CounselingRendered); entity.ConsultingProvider = db.ConsultingProvider; entity.CounselingStatus = db.CounselingStatus; entity.UserID = db.UserID; entities.Consulting_Table.Add(entity); entities.SaveChanges(); db.ConsultingID = entity.ConsultingID; }
public void Update(ConsultingViewModel db) { var entity = new Consulting_Table(); entity.ConsultingID = db.ConsultingID; entity.ConsultingNumber = db.ConsultingNumber; entity.ConsultingDate = (DateTime)db.ConsultingDate.Date; entity.ConsultantName = db.ConsultantName; entity.CounselingRequired = HttpUtility.HtmlDecode(db.CounselingRequired); entity.CounselingRendered = HttpUtility.HtmlDecode(db.CounselingRendered); entity.CounselingStatus = db.CounselingStatus; entity.CounselingStatus = db.CounselingStatus; entity.UserID = db.UserID; entities.Consulting_Table.Attach(entity); entities.Entry(entity).State = EntityState.Modified; entities.SaveChanges(); }