public async Task <IActionResult> Delete(int?id) { if (id != null) { TableAddress address = await _context.PersTableAddresson.FirstOrDefaultAsync(p => p.AddressId == id); Tablelocality tablelocality = await _context.Tablelocality.FirstOrDefaultAsync(p => p.localityId == address.localityId); TableDistrict tableDistrict = await _context.TableDistrict.FirstOrDefaultAsync(p => p.DistrictId == tablelocality.DistrictId); if (address != null) { _context.PersTableAddresson.Remove(address); await _context.SaveChangesAsync(); _context.Tablelocality.Remove(tablelocality); await _context.SaveChangesAsync(); _context.TableDistrict.Remove(tableDistrict); await _context.SaveChangesAsync(); return(RedirectToAction("OrganizationInformation")); } } return(NotFound()); }
public ColumnAddress(TableAddress address, string sColumnName) { m_sServerName = address.GetServerName(); m_sDatabaseName = address.GetDatabaseName(); m_sTableName = address.GetTableName(); m_sColumnName = sColumnName == null ? string.Empty : sColumnName.ToUpper(); }
public async Task <IActionResult> AddAdreess(InformationAboutTheAccountViewModel model) { int TableOrganizations = _context.TableOrganizations.Include(i => i.users).FirstOrDefault (i => User.Identity.Name == i.users.UserName).TableOrganizationsId; TableDistrict district = new TableDistrict { NameDistrict = model.District, AreaId = model.areaId }; _context.TableDistrict.Add(district); await _context.SaveChangesAsync(); Tablelocality tablelocality = new Tablelocality { Typelocality = model.TypesOfLocalities.ToString(), DistrictId = district.DistrictId, Namelocality = model.Namelocality }; _context.Tablelocality.Add(tablelocality); await _context.SaveChangesAsync(); TableAddress address = new TableAddress { Adress = model.Adress, PostalCode = model.PostalCode, TableOrganizationsId = TableOrganizations, localityId = tablelocality.localityId, }; _context.PersTableAddresson.Add(address); await _context.SaveChangesAsync(); return(RedirectToAction("OrganizationInformation")); }
public DatabaseAddress(TableAddress address) { m_sServerName = address.GetServerName(); m_sDatabaseName = address.GetDatabaseName(); }