public List<Company> GetAllDDL() { TCRepositoryDataContext context = DataBaseUtils.GetContext(); Company entity = new Company() { IdCompany = -1, Name = "Selecciona..." }; List<Company> entList = new List<Company>(); List<tbl_Companies> dbListCompanies = context.tbl_Companies.Where(c => c.IdStatus == 1).ToList(); foreach (var drItem in dbListCompanies) { Company entItem = new Company(); AssignDataObjectToEntity(drItem, ref entItem); entList.Add(entItem); } entList.Insert(0, entity); return entList; }
public List<Company> GetAll() { TCRepositoryDataContext context = DataBaseUtils.GetContext(); List<tbl_Companies> dbListCompanies = context.tbl_Companies.ToList(); List<Company> entList = new List<Company>(); foreach (var drItem in dbListCompanies) { Company entItem = new Company(); AssignDataObjectToEntity(drItem, ref entItem); entList.Add(entItem); } return entList; }
public bool Save(Company newCompany) { bool blResult = false; try { if (newCompany.IdCompany == 0) { blResult = Insert(newCompany); } else { blResult = Update(newCompany); } } catch { return false; } return blResult; }
private void AssignDataObjectToEntity(tbl_Companies dbCompany, ref Company entCompany) { entCompany.IdCompany = dbCompany.IdCompany; entCompany.Name = dbCompany.Name; entCompany.Description = dbCompany.Description; entCompany.EntStatus = new Status() { IdStatus= dbCompany.tbl_Status.IdStatus, Name= dbCompany.tbl_Status.Name}; }
private bool Update(Company entCompany) { TCRepositoryDataContext context = DataBaseUtils.GetContext(); tbl_Companies dbCompany = context.tbl_Companies.Where(c => c.IdCompany == entCompany.IdCompany).FirstOrDefault(); if (dbCompany != null) { try { dbCompany.Name = entCompany.Name; dbCompany.Description = entCompany.Description; dbCompany.IdStatus = entCompany.EntStatus.IdStatus; context.SubmitChanges(); return true; } catch { return false; } } return false; }
private bool Insert(Company entCompany) { TCRepositoryDataContext context = DataBaseUtils.GetContext(); tbl_Companies dbCompany = new tbl_Companies() { Description = entCompany.Description, Name = entCompany.Name, IdStatus = entCompany.EntStatus.IdStatus }; try { context.tbl_Companies.InsertOnSubmit(dbCompany); context.SubmitChanges(); return true; } catch { return false; } }