protected void btnSave_Click(object sender, EventArgs e)
{
FinalDemo.PL.ContactsProperties objContacts = new PL.ContactsProperties();
if (!String.IsNullOrEmpty(Request.QueryString["Id"]))
{
objContacts.Id = Convert.ToInt32(Request.QueryString["Id"].ToString());
}
else
{
objContacts.Id = 0;
}
objContacts.FirstName = txtFirstName.Text.Trim();
objContacts.LastName = txtLastName.Text.Trim();
objContacts.Phone = txtPhone.Text.Trim();
objContacts.Mobile = txtMobile.Text.Trim();
objContacts.City = txtCity.Text.Trim();
objContacts.Modified = DateTime.Now;
if (fileupload1.FileName.Length > 0)
{
string str_Upload_File_Save_With_New_Name = System.Guid.NewGuid().ToString() + System.IO.Path.GetExtension(fileupload1.FileName);
objContacts.ProfiePhoto = str_Upload_File_Save_With_New_Name;
fileupload1.SaveAs(Server.MapPath("~/upload") + "/" + str_Upload_File_Save_With_New_Name);
}
FinalDemo.BAL.ContactsService proxy = new BAL.ContactsService();
bool result = false;
if (!String.IsNullOrEmpty(Request.QueryString["Id"]))
{
result = proxy.Update(objContacts);
Response.Redirect("ViewAllContacts.aspx");
}
else
{
result = proxy.Insert(objContacts);
Response.Redirect("ViewAllContacts.aspx");
}
}
/// <summary>
/// Populate business objects from the data reader
/// </summary>
/// <param name="dataReader">data reader</param>
/// <returns>list of clContacts</returns>
internal List<ContactsProperties> PopulateObjectsFromReader(IDataReader dataReader)
{
List<ContactsProperties> list = new List<ContactsProperties>();
while (dataReader.Read())
{
ContactsProperties businessObject = new ContactsProperties();
PopulateBusinessObjectFromReader(businessObject, dataReader);
list.Add(businessObject);
}
return list;
}
/// <summary>
/// Populate business object from data reader
/// </summary>
/// <param name="businessObject">business object</param>
/// <param name="dataReader">data reader</param>
internal void PopulateBusinessObjectFromReader(ContactsProperties businessObject, IDataReader dataReader)
{
businessObject.Id = dataReader.GetInt32(dataReader.GetOrdinal("Id"));
if (!dataReader.IsDBNull(dataReader.GetOrdinal("FirstName")))
{
businessObject.FirstName = dataReader.GetString(dataReader.GetOrdinal("FirstName"));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal("LastName")))
{
businessObject.LastName = dataReader.GetString(dataReader.GetOrdinal("LastName"));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal("City")))
{
businessObject.City = dataReader.GetString(dataReader.GetOrdinal("City"));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal("Phone")))
{
businessObject.Phone = dataReader.GetString(dataReader.GetOrdinal("Phone"));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal("Mobile")))
{
businessObject.Mobile = dataReader.GetString(dataReader.GetOrdinal("Mobile"));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal("ProfiePhoto")))
{
businessObject.ProfiePhoto = dataReader.GetString(dataReader.GetOrdinal("ProfiePhoto"));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal("Modified")))
{
businessObject.Modified = dataReader.GetDateTime(dataReader.GetOrdinal("Modified"));
}
}
/// <summary>
/// update row in the table
/// </summary>
/// <param name="businessObject">business object</param>
/// <returns>true for successfully updated</returns>
public bool Update(ContactsProperties businessObject)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "dbo.[spContacts_Update]";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new SqlParameter("@Id", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Id));
sqlCommand.Parameters.Add(new SqlParameter("@FirstName", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.FirstName));
sqlCommand.Parameters.Add(new SqlParameter("@LastName", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.LastName));
sqlCommand.Parameters.Add(new SqlParameter("@City", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.City));
sqlCommand.Parameters.Add(new SqlParameter("@Phone", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Phone));
sqlCommand.Parameters.Add(new SqlParameter("@Mobile", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Mobile));
sqlCommand.Parameters.Add(new SqlParameter("@ProfiePhoto", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ProfiePhoto));
sqlCommand.Parameters.Add(new SqlParameter("@Modified", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Modified));
MainConnection.Open();
sqlCommand.ExecuteNonQuery();
return true;
}
catch (Exception ex)
{
throw new Exception("clContacts::Update::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
/// <summary>
/// Select by primary key
/// </summary>
/// <param name="keys">primary keys</param>
/// <returns>clContacts business object</returns>
public ContactsProperties SelectByPrimaryKey(int keys)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "dbo.[spContacts_SelectByPrimaryKey]";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new SqlParameter("@Id", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, keys));
MainConnection.Open();
IDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
ContactsProperties businessObject = new ContactsProperties();
PopulateBusinessObjectFromReader(businessObject, dataReader);
return businessObject;
}
else
{
return null;
}
}
catch (Exception ex)
{
throw new Exception("clContacts::SelectByPrimaryKey::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
public bool Update(ContactsProperties businessObject)
{
clContactsSql objContactSql = new clContactsSql();
return objContactSql.Update(businessObject);
}
public bool Insert(ContactsProperties businessObject)
{
clContactsSql objContactSql = new clContactsSql();
return objContactSql.Insert(businessObject);
}