//for insert in the address public static void InsertInAddress(AddressData objAddress) { Contact_managerDataContext dc = new Contact_managerDataContext(); Addressbook addressbook = new Addressbook(); if (dc.States.First(e1 => e1.PKStateId == objAddress.FKStateId) != null && dc.UserDetails.First(e1 => e1.PKUserId == objAddress.FKUserId) != null) { addressbook.FKStateId = objAddress.FKStateId; addressbook.FKUserId = objAddress.FKUserId; addressbook.FirstName = objAddress.FirstName; addressbook.LastName = objAddress.LastName; addressbook.EmailId = objAddress.EmailId; addressbook.PhoneNo = objAddress.PhoneNo; addressbook.Address1 = objAddress.Address1; addressbook.Address2 = objAddress.Address2; addressbook.Street = objAddress.Street; addressbook.City = objAddress.City; addressbook.ZipCode = objAddress.ZipCode; addressbook.IsActive = objAddress.IsActive; dc.Addressbooks.InsertOnSubmit(addressbook); dc.SubmitChanges(); } else { throw new Exception("Plese Enter the valid Statename and UserName"); } }
public static void UpdateInAddress(AddressData objAddress) { Contact_managerDataContext dc = new Contact_managerDataContext(); Addressbook addressbook = dc.Addressbooks.First(e1 => e1.PKAddressId == objAddress.PKAddressId); if (dc.States.First(e1 => e1.PKStateId == objAddress.FKStateId) != null && dc.UserDetails.First(e1 => e1.PKUserId == objAddress.FKUserId) != null) { addressbook.FKStateId = objAddress.FKStateId; addressbook.FKUserId = objAddress.FKUserId; addressbook.FirstName = objAddress.FirstName; addressbook.LastName = objAddress.LastName; addressbook.EmailId = objAddress.EmailId; addressbook.PhoneNo = objAddress.PhoneNo; addressbook.Address1 = objAddress.Address1; addressbook.Address2 = objAddress.Address2; addressbook.Street = objAddress.Street; addressbook.City = objAddress.City; addressbook.ZipCode = objAddress.ZipCode; addressbook.IsActive = objAddress.IsActive; dc.SubmitChanges(); } else { throw new Exception("Please check the details "); } }
//for delete the state public static void DeleteInSatte(int stateId) { Contact_managerDataContext dc = new Contact_managerDataContext(); State state = dc.States.First(e1 => e1.PKStateId == stateId); dc.States.DeleteOnSubmit(state); dc.SubmitChanges(); }
//delete from the user detail public static void DeleteInUserDetail(int userId) { Contact_managerDataContext dc = new Contact_managerDataContext(); UserDetail us = dc.UserDetails.First(e1 => e1.PKUserId == userId); dc.UserDetails.DeleteOnSubmit(us); dc.SubmitChanges(); }
//for deleting public static void DeleteInAddress(int addreessId) { Contact_managerDataContext dc = new Contact_managerDataContext(); Addressbook addressbook = dc.Addressbooks.First(e1 => e1.PKAddressId == addreessId); dc.Addressbooks.DeleteOnSubmit(addressbook); dc.SubmitChanges(); }
//for deleting public static void DeleteCountry(int countryId) { Contact_managerDataContext dc = new Contact_managerDataContext(); Country country = dc.Countries.First(e1 => e1.PKCountryId == countryId); dc.Countries.DeleteOnSubmit(country); dc.SubmitChanges(); }
//for inserting public static void InsertNewCountry(Countrydata objcountryData) { Contact_managerDataContext dc = new Contact_managerDataContext(); Country country = new Country(); country.CountryName = objcountryData.CountryName; country.ZipCodeStart = objcountryData.ZipCodeStart; country.ZipCodeEnd = objcountryData.ZipCodeEnd; country.IsActive = objcountryData.IsActive; dc.Countries.InsertOnSubmit(country); dc.SubmitChanges(); }
//for updating public static void UpdateCountry(Countrydata objCountryData) { int countryId = objCountryData.PKCountry; Contact_managerDataContext dc = new Contact_managerDataContext(); Country country = dc.Countries.First(e1 => e1.PKCountryId == countryId); country.CountryName = objCountryData.CountryName; country.ZipCodeStart = objCountryData.ZipCodeStart; country.ZipCodeEnd = objCountryData.ZipCodeEnd; country.IsActive = objCountryData.IsActive; //dc.Countries.InsertOnSubmit(country); dc.SubmitChanges(); }
//update the user details public static void UpdateInUserDetail(UserData objUserData) { int userId = objUserData.UserId; Contact_managerDataContext dc = new Contact_managerDataContext(); UserDetail us = dc.UserDetails.First(e1 => e1.PKUserId == userId); us.UserName = objUserData.UserName; us.Password = objUserData.Password; us.FirstName = objUserData.FirstName; us.LastName = objUserData.LastName; us.EmailId = objUserData.EmailId; us.PhoneNo = objUserData.PhoneNo; us.IsActive = objUserData.IsActive; dc.SubmitChanges(); }
//to get insert data public static void InsertInUserDetail(UserData objUserData) { Contact_managerDataContext dc = new Contact_managerDataContext(); UserDetail us = new UserDetail(); us.UserName = objUserData.UserName; us.Password = objUserData.Password; us.FirstName = objUserData.FirstName; us.LastName = objUserData.LastName; us.EmailId = objUserData.EmailId; us.PhoneNo = objUserData.PhoneNo; us.IsActive = objUserData.IsActive; dc.UserDetails.InsertOnSubmit(us); dc.SubmitChanges(); }
//Update the value in state table public static void UpdateInState(StateData objStateDate) { Contact_managerDataContext dc = new Contact_managerDataContext(); State state = dc.States.First(e1 => e1.PKStateId == objStateDate.StateId); if (dc.Countries.First(e1 => e1.PKCountryId == objStateDate.FKCountryId) != null) { state.FKCountryId = objStateDate.FKCountryId; state.StateName = objStateDate.StateName; state.IsActive = objStateDate.IsActive; dc.SubmitChanges(); } else { throw new ApplicationException("please provide a valid country"); } }
public static void InsertInState(StateData objStateData) { int fKCountryId = objStateData.FKCountryId; Contact_managerDataContext dc = new Contact_managerDataContext(); State state = new State(); if (dc.Countries.First(e1 => e1.PKCountryId == fKCountryId) != null) { state.FKCountryId = fKCountryId; state.StateName = objStateData.StateName; state.IsActive = objStateData.IsActive; dc.States.InsertOnSubmit(state); dc.SubmitChanges(); } else { throw new ApplicationException("PLease inter the valid countryid"); } }