/// <summary> /// To update the Address /// </summary> /// <param name="PKAddressId">int</param> /// <param name="FKStateId">int</param> /// <param name="FKUserId">int</param> /// <param name="FirstName">string</param> /// <param name="LastName">string</param> /// <param name="EmailId">string</param> /// <param name="PhoneNo">string</param> /// <param name="Address1">string</param> /// <param name="Address2">string</param> /// <param name="City">string</param> /// <param name="Street">string</param> /// <param name="ZipCode">long</param> /// <param name="IsActive">bool</param> public void UpdateAddressbook(int PKAddressId, int FKStateId, int FKUserId, string FirstName, string LastName, string EmailId, string PhoneNo, string Address1, string Address2, string City, string Street, long ZipCode, bool IsActive) { Addressbook objAddbook = new Addressbook(PKAddressId, FKStateId, FKUserId, FirstName, LastName, EmailId, PhoneNo, Address1, Address2, Street, City, ZipCode, IsActive); objAddbook.Validate(); AddressbookDB.ManageAddress(objAddbook, ActionType.Update); }
//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 "); } }
//this has to be completed public void update <t>(Addressbook objaddresss, int id) //where t:Addressbook { if (id == 4) { // AddressBookDB.UpdateAddress<t>(objaddresss); } }
//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 adding the data in the table public void AddAddress(Addressbook addressbook) { using (TransactionScope trans = new TransactionScope()) { context.Addressbooks.Add(addressbook); context.SaveChanges(); trans.Complete(); trans.Dispose(); } }
//this has to be done. //public void UpdateAddress<t>(Addressbook objAddress) //where t:Addressbook //{ // try // { // context.Entry(objAddress).State = EntityState.Modified; // context.SaveChanges(); // } // catch (Exception ex) // { // throw ex; // } //} //for deleting the data in the table public void DeleteAddress(Addressbook addressbook) { using (TransactionScope trans = new TransactionScope()) { addressbook = context.Addressbooks.Find(addressbook.PKAddressId); context.Addressbooks.Remove(addressbook); context.SaveChanges(); trans.Complete(); trans.Dispose(); } }
//public Addressbook GetAddress(int addressId) //{ // return context.Addressbooks.Where(address => address.PKAddressId == addressId).SingleOrDefault(); //} public void UpdateAddress(Addressbook objAddress) { try { context.Entry(objAddress).State = EntityState.Modified; context.SaveChanges(); } catch (Exception ex) { throw ex; } }
/// <summary> /// To perform the CRUD operations on Address /// </summary> /// <param name="objAddressbook">Addressbbok</param> /// <param name="action">ActionType</param> public static void ManageAddress(Addressbook objAddressbook, ActionType action) { try { string spName = "spManageAddress"; SqlParameter pActionType = new SqlParameter("@ActionType", SqlDbType.TinyInt); SqlParameter pPKAddressId = new SqlParameter("@PKAddressId", SqlDbType.Int); SqlParameter pFKStateId = new SqlParameter("@FKStateId", SqlDbType.Int); SqlParameter pFKUserId = new SqlParameter("@FKUserId", SqlDbType.Int); SqlParameter pFirstName = new SqlParameter("@FirstName", SqlDbType.VarChar, 50); SqlParameter pLastName = new SqlParameter("@LastName", SqlDbType.VarChar, 50); SqlParameter pEmailId = new SqlParameter("@EmailId", SqlDbType.VarChar, 50); SqlParameter pPhoneNo = new SqlParameter("@PhoneNo", SqlDbType.VarChar, 50); SqlParameter pAddress1 = new SqlParameter("@Address1", SqlDbType.VarChar, 50); SqlParameter pAddress2 = new SqlParameter("@Address2", SqlDbType.VarChar, 50); SqlParameter pStreet = new SqlParameter("@Street", SqlDbType.VarChar, 50); SqlParameter pCity = new SqlParameter("@City", SqlDbType.VarChar, 50); SqlParameter pZipCode = new SqlParameter("@ZipCode", SqlDbType.BigInt, 50); SqlParameter pIsActive = new SqlParameter("@IsActive", SqlDbType.Bit); pActionType.Value = action; if (action == ActionType.Add) { pPKAddressId.Direction = ParameterDirection.Input; } else { pPKAddressId.Value = objAddressbook.PKAddressId; } if (action == ActionType.Add || action == ActionType.Update) { pFKStateId.Value = objAddressbook.FKStateId; pFKUserId.Value = objAddressbook.FKUserId; pFirstName.Value = objAddressbook.FirstName; pLastName.Value = objAddressbook.LastName; pEmailId.Value = objAddressbook.EmailId; pPhoneNo.Value = objAddressbook.PhoneNo; pAddress1.Value = objAddressbook.Address1; pAddress2.Value = objAddressbook.Address2; pStreet.Value = objAddressbook.Street; pCity.Value = objAddressbook.City; pZipCode.Value = objAddressbook.ZipCode; pIsActive.Value = objAddressbook.IsActive; } SqlHelper.ExecuteNonQuery(Helper.connectionstring, CommandType.StoredProcedure, spName, pActionType, pPKAddressId, pFKStateId, pFKUserId, pFirstName, pLastName, pEmailId, pPhoneNo, pAddress1, pAddress2, pStreet, pCity, pZipCode, pIsActive); } catch (Exception ex) { throw ex; } }
public void UpdateAddressbook(Addressbook address) { try { context.Entry(address).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } catch (InvalidOperationException) { Addressbook oldEntry = context.Addressbooks.Find(address.PKAddressId); context.Entry(oldEntry).CurrentValues.SetValues(address); context.SaveChanges(); } }
private void btnDelete_Click(object sender, EventArgs e) { addressbook = new Addressbook(); addressbook.PKAddressId = (int)dgvAddressBook.SelectedRows[0].Cells[0].Value; DialogResult dr = MessageBox.Show("Are you sure you want to Delete", "Delete", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { try { interaction.Delete(addressbook, 4); } catch (Exception) { MessageBox.Show("Problem in the delete of Address form"); } } dgvAddressBook.DataSource = interaction.Getdetails(4); }
/// <summary> /// This method is used to update existing AddressBook in the database /// </summary> /// <remarks> /// DateCreated: 24th Oct 2016 /// Edited By: Rakesh (25-Oct-2016) , Phani (2-Nov-2016) /// </remarks> /// <exception cref="HttpResponseException">Will be thrown when there is a problem in updating AddressBook in database</exception> /// <param name="address">contians data of existed Addressbook which is to be updated</param> /// <param name="request">contains current request message</param> /// <returns>list of all AddressBooks if HttpStatusCode is OK</returns> public HttpResponseMessage Put(Addressbook address, HttpRequestMessage request) { try { if (!ModelState.IsValid) { return(request.CreateResponse(HttpStatusCode.BadRequest, GetErrorMessages())); } objAddressBookBO.UpdateAddressbook(address); return(request.CreateResponse(HttpStatusCode.OK, objAddressBookBO.GetAddresses())); } catch (Exception ex) { var resp = new HttpResponseMessage(HttpStatusCode.NotFound) { Content = new StringContent(ex.Message), ReasonPhrase = ex.Message }; throw new HttpResponseException(resp); } }
//public IEnumerable<Addressbook> Get(int userId, string userName) //{ // return objAddressBookBO.GetAddresses(); //} //public IEnumerable<Addressbook> Get(int countryId, int stateId, bool status) //{ // if (Helper.CurrentUserRole != "Admin") // return objAddressBookBO.GetAddresses(0, stateId, status,Helper.CurrentUserID); // else // return objAddressBookBO.GetAddresses(0, stateId, status); //} /// <summary> /// This method is used to add new Address to the database /// </summary> /// <remarks> /// DateCreated: 24th Oct 2016 /// Edited By: Rakesh (25-Oct-2016) , Phani (2-Nov-2016) /// </remarks> /// <exception cref="HttpResponseException">Will be thrown when there is a problem in adding new Address to database</exception> /// <param name="address">contians data of new AddressBook which is to be added</param> /// <param name="request">contains current request message</param> /// <returns>list of all AddressBooks if HttpStatusCode is OK</returns> public HttpResponseMessage Post([FromBody] Addressbook address, HttpRequestMessage request) { address.FKUserId = Helper.CurrentUserID; try { if (!ModelState.IsValid) { return(request.CreateResponse(HttpStatusCode.BadRequest, GetErrorMessages())); } objAddressBookBO.InsertAddressbook(address); return(request.CreateResponse(HttpStatusCode.OK, objAddressBookBO.GetAddresses())); } catch (Exception ex) { var resp = new HttpResponseMessage(HttpStatusCode.NotFound) { Content = new StringContent(ex.Message), ReasonPhrase = ex.Message }; throw new HttpResponseException(resp); } }
/// <summary> /// To fetch the Address by AddressId /// </summary> /// <param name="PKUserId">int</param> /// <returns>Addressbook</returns> public static Addressbook GetAddGetAddressByAddressId(int PKAddressId) { try { string spName = "spGetAllAddressById"; SqlParameter pPKAddressId = new SqlParameter("@PKAddressId", SqlDbType.Int); pPKAddressId.Value = PKAddressId; SqlDataReader drRow = SqlHelper.ExecuteReader(Helper.connectionstring, CommandType.StoredProcedure, spName, pPKAddressId); Addressbook objAddbook = null; string Lname = ""; if (drRow.HasRows) { drRow.Read(); int pkid = drRow.GetInt32(drRow.GetOrdinal("PKAddressId")); string statename = drRow.GetString(drRow.GetOrdinal("StateName")); int stateid = drRow.GetInt32(drRow.GetOrdinal("FKStateId")); int UserId = drRow.GetInt32(drRow.GetOrdinal("FKUserId")); string Fname = drRow.GetString(drRow.GetOrdinal("FirstName")); Lname = drRow.IsDBNull(drRow.GetOrdinal("LastName")) ? "" : drRow.GetString(drRow.GetOrdinal("LastName")); string EId = drRow.GetString(drRow.GetOrdinal("EmailId")); string Pno = drRow.GetString(drRow.GetOrdinal("PhoneNo")); string Add1 = drRow.GetString(drRow.GetOrdinal("Address1")); string Add2 = drRow.GetString(drRow.GetOrdinal("Address2")); string st = drRow.GetString(drRow.GetOrdinal("Street")); string ct = drRow.GetString(drRow.GetOrdinal("City")); long zpcode = drRow.GetInt64(drRow.GetOrdinal("ZipCode")); bool Isact = Convert.ToBoolean(drRow["IsActive"]); int fkCountryId = drRow.GetInt32(drRow.GetOrdinal("FKCountryId")); objAddbook = new Addressbook(pkid, statename, stateid, fkCountryId, UserId, Fname, Lname, EId, Pno, Add1, Add2, st, ct, zpcode, Isact); } drRow.Close(); return(objAddbook); } catch (Exception ex) { throw ex; } }
/// <summary> /// This method is used to retrieve Address based on Address Id. /// </summary> /// <remarks> /// DateCreated: 24th Oct 2016 /// Edited By: Rakesh (25-Oct-2016) , Phani (2-Nov-2016) /// </remarks> /// <exception cref="HttpResponseException">Will be thrown when there is a problem in retrieving data from database</exception> /// <param name="id">contains Address Id</param> /// <param name="request">contains current request message</param> /// <returns>AddressBook if HttpStatusCode is OK</returns> public HttpResponseMessage Get(int id, HttpRequestMessage request) { try { if (id == 0) { return(request.CreateResponse(HttpStatusCode.BadRequest, "Bad request.")); } Addressbook address = objAddressBookBO.GetById(id); if (address == null) { return(request.CreateResponse(HttpStatusCode.NoContent)); } return(request.CreateResponse(HttpStatusCode.OK, address)); } catch (Exception ex) { var resp = new HttpResponseMessage(HttpStatusCode.NotFound) { Content = new StringContent(ex.Message), ReasonPhrase = ex.Message }; throw new HttpResponseException(resp); } }
public void InsertAddressbook(Addressbook address) { context.Addressbooks.Add(address); context.SaveChanges(); }
/// <summary> /// To delete the Addressbook /// </summary> /// <param name="PKAddressId">int</param> public void DeleteAddressbook(int PKAddressId) { Addressbook objAddbook = new Addressbook(PKAddressId, 0, 0, "", "", "", "", "", "", "", "", 0, false); AddressbookDB.ManageAddress(objAddbook, ActionType.Delete); }
/// <summary> /// Adds a single record to Addressbook table /// </summary> /// <param name="objAddbook">Addressbook</param> public void InsertAddressbook(Addressbook objAddbook) { objAddbook.Validate(); AddressbookDB.ManageAddress(objAddbook, ActionType.Add); }
/// <summary> /// This method is used for updating AddressBook /// </summary> /// <remarks> /// Date Created: 24th Oct 2016 /// Edited By : Phani ( 4-11-2016) /// </remarks> /// <param name="address">Contains details of existed address</param> public void UpdateAddressbook(Addressbook address) { objAddressBookRepository.UpdateAddressbook(address); }
/// <summary> /// This method is used for Inserting new address /// </summary> /// <remarks> /// Date Created: 24th Oct 2016 /// Edited By : Phani ( 4-11-2016) /// </remarks> /// <param name="address">contains details of new address</param> public void InsertAddressbook(Addressbook address) { objAddressBookRepository.InsertAddressbook(address); }