public Boolean Insert(ContactsENT entContacts)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_Contacts_Insert";
objCmd.Parameters.Add("@ContactsID", SqlDbType.Int).Direction = ParameterDirection.Output;
objCmd.Parameters.AddWithValue("@PersonName", SqlDbType.VarChar).Value = entContacts.PersonName;
objCmd.Parameters.AddWithValue("@Address", SqlDbType.VarChar).Value = entContacts.Address;
objCmd.Parameters.AddWithValue("@CityID", SqlDbType.Int).Value = entContacts.CityID;
objCmd.Parameters.AddWithValue("@StateID", SqlDbType.Int).Value = entContacts.StateID;
objCmd.Parameters.AddWithValue("@CountryID", SqlDbType.Int).Value = entContacts.CountryID;
objCmd.Parameters.AddWithValue("@Pincode", SqlDbType.VarChar).Value = entContacts.Pincode;
objCmd.Parameters.AddWithValue("@MobileNo", SqlDbType.VarChar).Value = entContacts.MobileNo;
objCmd.Parameters.AddWithValue("@PhoneNo", SqlDbType.VarChar).Value = entContacts.PhoneNo;
objCmd.Parameters.AddWithValue("@Email", SqlDbType.VarChar).Value = entContacts.Email;
objCmd.Parameters.AddWithValue("@Gender", SqlDbType.VarChar).Value = entContacts.Gender;
objCmd.Parameters.AddWithValue("@Age", SqlDbType.Int).Value = entContacts.Age;
objCmd.Parameters.AddWithValue("@BirthDate", SqlDbType.DateTime).Value = entContacts.BirthDate;
objCmd.Parameters.AddWithValue("@BloodGroupID", SqlDbType.Int).Value = entContacts.BloodGroupID;
objCmd.Parameters.AddWithValue("@Profession", SqlDbType.VarChar).Value = entContacts.Profession;
objCmd.Parameters.AddWithValue("@ContactCategoryID", SqlDbType.Int).Value = entContacts.ContactCategoryID;
#endregion Prepare Command
objCmd.ExecuteNonQuery();
if (objCmd.Parameters["@ContactsID"] != null)
{
entContacts.ContactID = Convert.ToInt32(objCmd.Parameters["@ContactsID"].Value);
}
return(true);
}
catch (SqlException sqlex)
{
Message = sqlex.InnerException.Message.ToString();
return(false);
}
catch (Exception ex)
{
Message = ex.InnerException.Message.ToString();
return(false);
}
finally
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
}
}
}
public Boolean Update(ContactsENT entContacts)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_Contacts_UpdateByPK";
objCmd.Parameters.AddWithValue("@ContactID", entContacts.ContactID);
objCmd.Parameters.AddWithValue("@PersonName", entContacts.PersonName);
objCmd.Parameters.AddWithValue("@Address", entContacts.Address);
objCmd.Parameters.AddWithValue("@CityID", entContacts.CityID);
objCmd.Parameters.AddWithValue("@StateID", entContacts.StateID);
objCmd.Parameters.AddWithValue("@CountryID", entContacts.CountryID);
objCmd.Parameters.AddWithValue("@Pincode", entContacts.Pincode);
objCmd.Parameters.AddWithValue("@MobileNo", entContacts.MobileNo);
objCmd.Parameters.AddWithValue("@PhoneNo", entContacts.PhoneNo);
objCmd.Parameters.AddWithValue("@Email", entContacts.Email);
objCmd.Parameters.AddWithValue("@Gender", entContacts.Gender);
objCmd.Parameters.AddWithValue("@Age", entContacts.Age);
objCmd.Parameters.AddWithValue("@BirthDate", entContacts.BirthDate);
objCmd.Parameters.AddWithValue("@BloodGroupID", entContacts.BloodGroupID);
objCmd.Parameters.AddWithValue("@Profession", entContacts.Profession);
objCmd.Parameters.AddWithValue("@ContactCategoryID", entContacts.ContactCategoryID);
#endregion Prepare Command
objCmd.ExecuteNonQuery();
return(true);
}
catch (SqlException sqlex)
{
Message = sqlex.InnerException.Message.ToString();
return(false);
}
catch (Exception ex)
{
Message = ex.InnerException.Message.ToString();
return(false);
}
finally
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
}
}
}
public Boolean Update(ContactsENT entContacts)
{
ContactsDAL dalContacts = new ContactsDAL();
if (dalContacts.Update(entContacts))
{
return(true);
}
else
{
Message = dalContacts.Message;
return(false);
}
}
public ContactsENT SelectByPK(SqlInt32 ContactsID)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_Contacts_SelectByPK";
objCmd.Parameters.AddWithValue("@ContactsID", ContactsID);
#endregion Prepare Command
#region ReadData and Set Controls
ContactsENT entContacts = new ContactsENT();
using (SqlDataReader objSDR = objCmd.ExecuteReader())
{
while (objSDR.Read())
{
if (!objSDR["ContactID"].Equals(DBNull.Value))
{
entContacts.ContactID = Convert.ToInt32(objSDR["ContactID"]);
}
if (!objSDR["PersonName"].Equals(DBNull.Value))
{
entContacts.PersonName = Convert.ToString(objSDR["PersonName"]);
}
if (!objSDR["Address"].Equals(DBNull.Value))
{
entContacts.Address = Convert.ToString(objSDR["Address"]);
}
if (!objSDR["CityID"].Equals(DBNull.Value))
{
entContacts.CityID = Convert.ToInt32(objSDR["CityID"]);
}
if (!objSDR["StateID"].Equals(DBNull.Value))
{
entContacts.StateID = Convert.ToInt32(objSDR["StateID"]);
}
if (!objSDR["CountryID"].Equals(DBNull.Value))
{
entContacts.CountryID = Convert.ToInt32(objSDR["CountryID"]);
}
if (!objSDR["Pincode"].Equals(DBNull.Value))
{
entContacts.Pincode = Convert.ToString(objSDR["Pincode"]);
}
if (!objSDR["MobileNo"].Equals(DBNull.Value))
{
entContacts.MobileNo = Convert.ToString(objSDR["MobileNo"]);
}
if (!objSDR["PhoneNo"].Equals(DBNull.Value))
{
entContacts.PhoneNo = Convert.ToString(objSDR["PhoneNo"]);
}
if (!objSDR["Email"].Equals(DBNull.Value))
{
entContacts.Email = Convert.ToString(objSDR["Email"]);
}
if (!objSDR["Gender"].Equals(DBNull.Value))
{
entContacts.Gender = Convert.ToString(objSDR["Gender"]);
}
if (!objSDR["Age"].Equals(DBNull.Value))
{
entContacts.Age = Convert.ToInt32(objSDR["Age"]);
}
if (!objSDR["BirthDate"].Equals(DBNull.Value))
{
entContacts.BirthDate = Convert.ToDateTime(objSDR["BirthDate"]);
}
if (!objSDR["BloodGroupID"].Equals(DBNull.Value))
{
entContacts.BloodGroupID = Convert.ToInt32(objSDR["BloodGroupID"]);
}
if (!objSDR["Profession"].Equals(DBNull.Value))
{
entContacts.Profession = Convert.ToString(objSDR["Profession"]);
}
if (!objSDR["ContactCategoryID"].Equals(DBNull.Value))
{
entContacts.ContactCategoryID = Convert.ToInt32(objSDR["ContactCategoryID"]);
}
}
}
return(entContacts);
#endregion ReadData and Set Controls
}
catch (SqlException sqlex)
{
Message = sqlex.InnerException.Message.ToString();
return(null);
}
catch (Exception ex)
{
Message = ex.InnerException.Message.ToString();
return(null);
}
finally
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
}
}
}
private void fillControls(SqlInt32 ContactID)
{
ContactsENT entContact = new ContactsENT();
ContactsBAL balContact = new ContactsBAL();
entContact = balContact.SelectByPK(ContactID);
if (entContact != null)
{
if (!entContact.PersonName.IsNull)
{
txtPersonName.Text = entContact.PersonName.Value.ToString();
}
if (!entContact.Pincode.IsNull)
{
txtPincode.Text = entContact.Pincode.Value.ToString();
}
if (!entContact.MobileNo.IsNull)
{
txtMobileNo.Text = entContact.MobileNo.Value.ToString();
}
if (!entContact.Address.IsNull)
{
txtAddress.Text = entContact.Address.Value.ToString();
}
if (!entContact.Email.IsNull)
{
txtEmail.Text = entContact.Email.Value.ToString();
}
if (!entContact.PhoneNo.IsNull)
{
txtPhoneNo.Text = entContact.PhoneNo.Value.ToString();
}
if (!entContact.Profession.IsNull)
{
txtProfession.Text = entContact.Profession.Value.ToString();
}
if (!entContact.StateID.IsNull)
{
ddlState.SelectedValue = entContact.StateID.Value.ToString();
}
if (!entContact.CityID.IsNull)
{
ddlCity.SelectedValue = entContact.CityID.Value.ToString();
}
if (!entContact.CountryID.IsNull)
{
ddlCountry.SelectedValue = entContact.CountryID.Value.ToString();
}
if (!entContact.ContactCategoryID.IsNull)
{
ddlContactCategory.SelectedValue = entContact.ContactCategoryID.Value.ToString();
}
if (!entContact.BloodGroupID.IsNull)
{
ddlBloodGroup.SelectedValue = entContact.BloodGroupID.Value.ToString();
}
if (!entContact.Gender.IsNull)
{
ddlGender.SelectedValue = entContact.Gender.Value.ToString();
}
if (!entContact.BirthDate.IsNull)
{
txtBirthDate.Text = DateTime.Parse(entContact.BirthDate.ToString()).ToString("yyyy-MM-dd");
}
}
else
{
lblError.Text = balContact.Message;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region Server Side Validation
lblError.Text = "";
if (txtPersonName.Text.Trim().ToUpper() == "")
{
lblError.Text += "Enter Contact Name <br/>";
}
if (txtMobileNo.Text.Trim() == "")
{
lblError.Text += "Enter Mobile No <br/>";
}
if (ddlBloodGroup.SelectedValue == "-1")
{
lblError.Text += "Please Select Bloodgroup <br/>";
}
if (ddlContactCategory.SelectedValue == "-1")
{
lblError.Text += "Please Select Contact Category <br/>";
}
if (lblError.Text != "")
{
return;
}
#endregion Server Side Validation
#region Collecting Data
ContactsENT entContact = new ContactsENT();
if (ddlBloodGroup.SelectedValue != "-1" && ddlContactCategory.SelectedValue != "-1" && txtPersonName.Text.Trim().ToUpper() != "" && txtMobileNo.Text.Trim() != "")
{
entContact.PersonName = txtPersonName.Text.Trim().ToUpper();
entContact.MobileNo = txtMobileNo.Text.Trim();
entContact.BloodGroupID = Convert.ToInt32(ddlBloodGroup.SelectedValue);
entContact.ContactCategoryID = Convert.ToInt32(ddlContactCategory.SelectedValue);
}
#region Reading Remaining Data
if (txtAddress.Text.Trim().ToUpper() != "")
{
entContact.Address = txtAddress.Text.Trim().ToUpper();
}
if (txtPincode.Text.Trim() != "")
{
entContact.Pincode = txtPincode.Text.Trim();
}
if (txtEmail.Text.Trim().ToLower() != "")
{
entContact.Email = txtEmail.Text.Trim().ToLower();
}
if (txtPhoneNo.Text.Trim() != "")
{
entContact.PhoneNo = txtPhoneNo.Text.Trim();
}
if (txtProfession.Text.Trim().ToUpper() != "")
{
entContact.Profession = txtProfession.Text.Trim().ToUpper();
}
if (txtBirthDate.Text.Trim() != "")
{
if (DateTime.Parse(txtBirthDate.Text.Trim()) <= DateTime.Now)
{
entContact.BirthDate = SqlDateTime.Parse(txtBirthDate.Text.Trim());
}
else
{
lblError.Text += "Invalid Birthdate";
return;
}
}
if (!entContact.BirthDate.IsNull)
{
entContact.Age = (DateTime.Now.Subtract(DateTime.Parse(entContact.BirthDate.ToString())).Days / 365);
}
if (ddlCity.SelectedValue != "-1")
{
entContact.CityID = Convert.ToInt32(ddlCity.SelectedValue);
}
if (ddlState.SelectedValue != "-1")
{
entContact.StateID = Convert.ToInt32(ddlState.SelectedValue);
}
if (ddlCountry.SelectedValue != "-1")
{
entContact.CountryID = Convert.ToInt32(ddlCountry.SelectedValue);
}
if (ddlGender.SelectedValue != "-1")
{
entContact.Gender = ddlGender.SelectedValue;
}
#endregion Reading Remaining Data
#endregion Collecting Data
ContactsBAL balContact = new ContactsBAL();
if (Request.QueryString["ContactID"] == null)
{
#region insertingData
if (balContact.Insert(entContact))
{
Response.Redirect("~/AdminPanel/Contact/ContactList.aspx");
}
else
{
lblError.Text = balContact.Message;
}
#endregion insertingData
}
else
{
#region updatingData
entContact.ContactID = Convert.ToInt32(Request.QueryString["ContactID"]);
if (balContact.Update(entContact))
{
Response.Redirect("~/AdminPanel/Contact/ContactList.aspx");
}
else
{
lblError.Text = balContact.Message;
}
#endregion updatingData
}
}
