/// <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);
}