public void Update(ContactsBAL obj) { try { //Local con.Open(); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Contacts_Update"; cmd.Parameters.Clear(); cmd.Parameters.Add("@cnt_id", SqlDbType.Int).Value = obj.cnt_id; cmd.Parameters.Add("@cnt_FirstName", SqlDbType.VarChar).Value = obj.cnt_FirstName; cmd.Parameters.Add("@cnt_LastName", SqlDbType.VarChar).Value = obj.cnt_LastName; cmd.Parameters.Add("@cnt_Number", SqlDbType.VarChar).Value = obj.cnt_Number; cmd.Parameters.Add("@status", SqlDbType.Bit).Value = obj.status; cmd.ExecuteNonQuery(); con.Close(); } catch (SqlException e1) { MessageBox.Show(e1.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void FillGridViewContact() { ContactsBAL balContact = new ContactsBAL(); DataTable dtContact = new DataTable(); dtContact = balContact.SelectAll(); if (dtContact != null && dtContact.Rows.Count > 0) { gvContactList.DataSource = dtContact; gvContactList.DataBind(); } }
protected void gvContactList_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandArgument != null) { ContactsBAL balContact = new ContactsBAL(); if (balContact.Delete(Convert.ToInt32(e.CommandArgument.ToString().Trim()))) { Response.Redirect("~/Adminpanel/Contact/ContactList.aspx"); lblError.Text = ""; } else { lblError.Text = balContact.Message; } } }
public List <ContactsBAL> Search(ContactsBAL obj) { try { //Local SqlDataReader dr; List <ContactsBAL> listt = new List <ContactsBAL>(); con.Open(); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Contacts_Search"; cmd.Parameters.Clear(); cmd.Parameters.Add("@cnt_id", SqlDbType.Int).Value = obj.cnt_id; cmd.Parameters.Add("@cnt_FirstName", SqlDbType.VarChar).Value = obj.cnt_FirstName; cmd.Parameters.Add("@cnt_LastName", SqlDbType.VarChar).Value = obj.cnt_LastName; cmd.Parameters.Add("@cnt_Number", SqlDbType.VarChar).Value = obj.cnt_Number; cmd.Parameters.Add("@status", SqlDbType.Bit).Value = obj.status; dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { ContactsBAL obj1 = new ContactsBAL(); float x = 0; obj1.cnt_id = Convert.ToInt32(dr["cnt_id"].ToString()); obj1.cnt_FirstName = dr["cnt_FirstName"].ToString(); obj1.cnt_LastName = dr["cnt_LastName"].ToString(); obj1.cnt_Number = dr["cnt_Number"].ToString(); obj1.status = (bool)dr["status"]; listt.Add(obj1); } } dr.Close(); con.Close(); return(listt); } catch (SqlException e) { MessageBox.Show(e.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } return(null); }
public void Save() { if (Validate_txt_firstname() && Validate_txt_LastName() && ValidatephoneNo()) { ContactsBAL contact = new ContactsBAL(); contact.cnt_id = id; contact.cnt_FirstName = txt_firstname.Text; contact.cnt_LastName = txt_LastName.Text; contact.cnt_Number = txt_Number.Text; contact.status = true; if (contact.cnt_id == 0) { db.Add(contact); } else { db.Update(contact); } LoadPhonebook(); Clear(); } }
public List <ContactsBAL> LoadAll_SQLQuery(string query) { try { //Local SqlDataReader dr; List <ContactsBAL> listt = new List <ContactsBAL>(); con.Open(); cmd.Connection = con; cmd.CommandType = CommandType.Text; cmd.CommandText = "query"; dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { ContactsBAL obj1 = new ContactsBAL(); float x = 0; obj1.cnt_id = Convert.ToInt32(dr["cnt_id"].ToString()); obj1.cnt_FirstName = dr["cnt_FirstName"].ToString(); obj1.cnt_LastName = dr["cnt_LastName"].ToString(); obj1.cnt_Number = dr["cnt_Number"].ToString(); obj1.status = (bool)dr["status"]; listt.Add(obj1); } } dr.Close(); con.Close(); return(listt); } catch (SqlException e) { MessageBox.Show(e.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } return(null); }
public ContactsBAL LoadbyId(int obj) { try { //Local SqlDataReader dr; con.Open(); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Contacts_LOADByID"; cmd.Parameters.Clear(); cmd.Parameters.Add("@cnt_id", SqlDbType.Int).Value = obj; dr = cmd.ExecuteReader(); ContactsBAL obj1 = new ContactsBAL(); if (dr.HasRows) { while (dr.Read()) { float x = 0; obj1.cnt_id = Convert.ToInt32(dr["cnt_id"].ToString()); obj1.cnt_FirstName = dr["cnt_FirstName"].ToString(); obj1.cnt_LastName = dr["cnt_LastName"].ToString(); obj1.cnt_Number = dr["cnt_Number"].ToString(); obj1.status = (bool)dr["status"]; } } dr.Close(); con.Close(); return(obj1); } catch (SqlException e) { MessageBox.Show(e.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } return(null); }
public ContactController(IHostingEnvironment hostingEnvironment) { contactsBal = new ContactsBAL(hostingEnvironment); }
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 } }