public ContactCategoryENT SelectByPK(SqlInt32 ContactCategoryID) { using (SqlConnection objConn = new SqlConnection(ConnectionString)) { objConn.Open(); using (SqlCommand objCmd = objConn.CreateCommand()) { try { #region Prepare Command objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "PR_ContactCategory_SelectByPK"; objCmd.Parameters.AddWithValue("@ContactCategoryID", ContactCategoryID); #endregion Prepare Command #region ReadData and Set Controls ContactCategoryENT entContactCategory = new ContactCategoryENT(); using (SqlDataReader objSDR = objCmd.ExecuteReader()) { while (objSDR.Read()) { if (!objSDR["ContactCategoryID"].Equals(DBNull.Value)) { entContactCategory.ContactCategoryID = Convert.ToInt32(objSDR["ContactCategoryID"]); } if (!objSDR["ContactCategoryName"].Equals(DBNull.Value)) { entContactCategory.ContactCategoryName = Convert.ToString(objSDR["ContactCategoryName"]); } } } return(entContactCategory); #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(); } } } } }
protected void btnSave_Click(object sender, EventArgs e) { #region Server Side Validation lblError.Text = ""; if (txtContactCategoryName.Text.Trim().ToUpper() == "") { lblError.Text += "Enter ContactCategory Name <br/>"; } if (lblError.Text != "") { return; } #endregion Server Side Validation #region Collecting Data ContactCategoryENT entContactCategory = new ContactCategoryENT(); if (txtContactCategoryName.Text.Trim().ToUpper() != "") { entContactCategory.ContactCategoryName = txtContactCategoryName.Text.Trim().ToUpper(); } ContactCategoryBAL balContactCategory = new ContactCategoryBAL(); #endregion Collecting Data if (Request.QueryString["ContactCategoryID"] == null) { #region insertingData if (balContactCategory.Insert(entContactCategory)) { Response.Redirect("~/AdminPanel/ContactCategory/ContactCategoryList.aspx"); } else { lblError.Text = balContactCategory.Message; } #endregion insertingData } else { #region updatingData entContactCategory.ContactCategoryID = Convert.ToInt32(Request.QueryString["ContactCategoryID"]); if (balContactCategory.Update(entContactCategory)) { Response.Redirect("~/AdminPanel/ContactCategory/ContactCategoryList.aspx"); } else { lblError.Text = balContactCategory.Message; } #endregion updatingData } }
public Boolean Update(ContactCategoryENT entContactCategory) { ContactCategoryDAL dalContactCategory = new ContactCategoryDAL(); if (dalContactCategory.Update(entContactCategory)) { return(true); } else { Message = dalContactCategory.Message; return(false); } }
public Boolean Insert(ContactCategoryENT entContactCategory) { using (SqlConnection objConn = new SqlConnection(ConnectionString)) { objConn.Open(); using (SqlCommand objCmd = objConn.CreateCommand()) { try { #region Prepare Command objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "PR_ContactCategory_Insert"; objCmd.Parameters.Add("@ContactCategoryID", SqlDbType.Int).Direction = ParameterDirection.Output; objCmd.Parameters.AddWithValue("@ContactCategoryName", SqlDbType.VarChar).Value = entContactCategory.ContactCategoryName; #endregion Prepare Command objCmd.ExecuteNonQuery(); if (objCmd.Parameters["@ContactCategoryID"] != null) { entContactCategory.ContactCategoryID = Convert.ToInt32(objCmd.Parameters["@ContactCategoryID"].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(); } } } } }
private void fillControls(SqlInt32 ContactCategoryID) { ContactCategoryENT entContactCategory = new ContactCategoryENT(); ContactCategoryBAL balContactCategory = new ContactCategoryBAL(); entContactCategory = balContactCategory.SelectByPK(ContactCategoryID); if (entContactCategory != null) { if (!entContactCategory.ContactCategoryName.IsNull) { txtContactCategoryName.Text = entContactCategory.ContactCategoryName.Value.ToString(); } } else { lblError.Text = balContactCategory.Message; } }
public Boolean Update(ContactCategoryENT entContactCategory) { using (SqlConnection objConn = new SqlConnection(ConnectionString)) { objConn.Open(); using (SqlCommand objCmd = objConn.CreateCommand()) { try { #region Prepare Command objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "PR_ContactCategory_UpdateByPK"; objCmd.Parameters.AddWithValue("@ContactCategoryID", entContactCategory.ContactCategoryID); objCmd.Parameters.AddWithValue("@ContactCategoryName", entContactCategory.ContactCategoryName); #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(); } } } } }