private void UpdateRecord() { dbo_DimProductSubcategoryClass oclsdbo_DimProductSubcategory = new dbo_DimProductSubcategoryClass(); dbo_DimProductSubcategoryClass clsdbo_DimProductSubcategory = new dbo_DimProductSubcategoryClass(); oclsdbo_DimProductSubcategory.ProductSubcategoryKey = System.Convert.ToInt32(Session["ProductSubcategoryKey"]); oclsdbo_DimProductSubcategory = dbo_DimProductSubcategoryDataClass.Select_Record(oclsdbo_DimProductSubcategory); if (VerifyData() == true) { SetData(clsdbo_DimProductSubcategory); bool bSucess = false; bSucess = dbo_DimProductSubcategoryDataClass.Update(oclsdbo_DimProductSubcategory, clsdbo_DimProductSubcategory); if (bSucess == true) { pnlForm.Visible = false; pnlSave.Visible = false; pnlGrid.Visible = true; lblMode.InnerText = ""; Session.Remove("dvdbo_DimProductSubcategory"); LoadGriddbo_DimProductSubcategory(); } else { ec.ShowMessage(" Update failed. ", " Dbo. Dim Product Subcategory "); } } }
public static bool Delete(dbo_DimProductSubcategoryClass clsdbo_DimProductSubcategory) { SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection(); string deleteStatement = "DELETE FROM " + " [dbo].[DimProductSubcategory] " + "WHERE " + " [ProductSubcategoryKey] = @OldProductSubcategoryKey " + " AND ((@OldProductSubcategoryAlternateKey IS NULL AND [ProductSubcategoryAlternateKey] IS NULL) OR [ProductSubcategoryAlternateKey] = @OldProductSubcategoryAlternateKey) " + " AND [EnglishProductSubcategoryName] = @OldEnglishProductSubcategoryName " + " AND [SpanishProductSubcategoryName] = @OldSpanishProductSubcategoryName " + " AND [FrenchProductSubcategoryName] = @OldFrenchProductSubcategoryName " + " AND ((@OldProductCategoryKey IS NULL AND [ProductCategoryKey] IS NULL) OR [ProductCategoryKey] = @OldProductCategoryKey) " + ""; SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection); deleteCommand.CommandType = CommandType.Text; deleteCommand.Parameters.AddWithValue("@OldProductSubcategoryKey", clsdbo_DimProductSubcategory.ProductSubcategoryKey); if (clsdbo_DimProductSubcategory.ProductSubcategoryAlternateKey.HasValue == true) { deleteCommand.Parameters.AddWithValue("@OldProductSubcategoryAlternateKey", clsdbo_DimProductSubcategory.ProductSubcategoryAlternateKey); } else { deleteCommand.Parameters.AddWithValue("@OldProductSubcategoryAlternateKey", DBNull.Value); } deleteCommand.Parameters.AddWithValue("@OldEnglishProductSubcategoryName", clsdbo_DimProductSubcategory.EnglishProductSubcategoryName); deleteCommand.Parameters.AddWithValue("@OldSpanishProductSubcategoryName", clsdbo_DimProductSubcategory.SpanishProductSubcategoryName); deleteCommand.Parameters.AddWithValue("@OldFrenchProductSubcategoryName", clsdbo_DimProductSubcategory.FrenchProductSubcategoryName); if (clsdbo_DimProductSubcategory.ProductCategoryKey.HasValue == true) { deleteCommand.Parameters.AddWithValue("@OldProductCategoryKey", clsdbo_DimProductSubcategory.ProductCategoryKey); } else { deleteCommand.Parameters.AddWithValue("@OldProductCategoryKey", DBNull.Value); } try { connection.Open(); int count = deleteCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException) { return(false); } finally { connection.Close(); } }
private void UpdateRecord() { try { TextBox txtProductSubcategoryKey = (TextBox)grddbo_DimProductSubcategory.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtProductSubcategoryKey"); TextBox txtProductSubcategoryAlternateKey = (TextBox)grddbo_DimProductSubcategory.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtProductSubcategoryAlternateKey"); TextBox txtEnglishProductSubcategoryName = (TextBox)grddbo_DimProductSubcategory.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtEnglishProductSubcategoryName"); TextBox txtSpanishProductSubcategoryName = (TextBox)grddbo_DimProductSubcategory.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSpanishProductSubcategoryName"); TextBox txtFrenchProductSubcategoryName = (TextBox)grddbo_DimProductSubcategory.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtFrenchProductSubcategoryName"); DropDownList txtProductCategoryKey = (DropDownList)grddbo_DimProductSubcategory.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtProductCategoryKey"); dbo_DimProductSubcategoryClass oclsdbo_DimProductSubcategory = new dbo_DimProductSubcategoryClass(); dbo_DimProductSubcategoryClass clsdbo_DimProductSubcategory = new dbo_DimProductSubcategoryClass(); oclsdbo_DimProductSubcategory.ProductSubcategoryKey = System.Convert.ToInt32(txtProductSubcategoryKey.Text); oclsdbo_DimProductSubcategory = dbo_DimProductSubcategoryDataClass.Select_Record(oclsdbo_DimProductSubcategory); if (VerifyData() == true) { if (string.IsNullOrEmpty(txtProductSubcategoryAlternateKey.Text)) { clsdbo_DimProductSubcategory.ProductSubcategoryAlternateKey = null; } else { clsdbo_DimProductSubcategory.ProductSubcategoryAlternateKey = System.Convert.ToInt32(txtProductSubcategoryAlternateKey.Text); } clsdbo_DimProductSubcategory.EnglishProductSubcategoryName = System.Convert.ToString(txtEnglishProductSubcategoryName.Text); clsdbo_DimProductSubcategory.SpanishProductSubcategoryName = System.Convert.ToString(txtSpanishProductSubcategoryName.Text); clsdbo_DimProductSubcategory.FrenchProductSubcategoryName = System.Convert.ToString(txtFrenchProductSubcategoryName.Text); if (string.IsNullOrEmpty(txtProductCategoryKey.SelectedValue)) { clsdbo_DimProductSubcategory.ProductCategoryKey = null; } else { clsdbo_DimProductSubcategory.ProductCategoryKey = System.Convert.ToInt32(txtProductCategoryKey.SelectedValue); } bool bSucess = false; bSucess = dbo_DimProductSubcategoryDataClass.Update(oclsdbo_DimProductSubcategory, clsdbo_DimProductSubcategory); if (bSucess == true) { Session.Remove("dvdbo_DimProductSubcategory"); grddbo_DimProductSubcategory.EditIndex = -1; LoadGriddbo_DimProductSubcategory(); } else { ec.ShowMessage(" Update failed. ", " Dbo. Dim Product Subcategory "); } } } catch { } }
public static dbo_DimProductSubcategoryClass Select_Record(dbo_DimProductSubcategoryClass clsdbo_DimProductSubcategoryPara) { dbo_DimProductSubcategoryClass clsdbo_DimProductSubcategory = new dbo_DimProductSubcategoryClass(); SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection(); string selectStatement = "SELECT " + " [ProductSubcategoryKey] " + " ,[ProductSubcategoryAlternateKey] " + " ,[EnglishProductSubcategoryName] " + " ,[SpanishProductSubcategoryName] " + " ,[FrenchProductSubcategoryName] " + " ,[ProductCategoryKey] " + "FROM " + " [dbo].[DimProductSubcategory] " + "WHERE " + " [ProductSubcategoryKey] = @ProductSubcategoryKey " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; selectCommand.Parameters.AddWithValue("@ProductSubcategoryKey", clsdbo_DimProductSubcategoryPara.ProductSubcategoryKey); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsdbo_DimProductSubcategory.ProductSubcategoryKey = System.Convert.ToInt32(reader["ProductSubcategoryKey"]); clsdbo_DimProductSubcategory.ProductSubcategoryAlternateKey = reader["ProductSubcategoryAlternateKey"] is DBNull ? null : (Int32?)reader["ProductSubcategoryAlternateKey"]; clsdbo_DimProductSubcategory.EnglishProductSubcategoryName = System.Convert.ToString(reader["EnglishProductSubcategoryName"]); clsdbo_DimProductSubcategory.SpanishProductSubcategoryName = System.Convert.ToString(reader["SpanishProductSubcategoryName"]); clsdbo_DimProductSubcategory.FrenchProductSubcategoryName = System.Convert.ToString(reader["FrenchProductSubcategoryName"]); clsdbo_DimProductSubcategory.ProductCategoryKey = reader["ProductCategoryKey"] is DBNull ? null : (Int32?)reader["ProductCategoryKey"]; } else { clsdbo_DimProductSubcategory = null; } reader.Close(); } catch (SqlException) { return(clsdbo_DimProductSubcategory); } finally { connection.Close(); } return(clsdbo_DimProductSubcategory); }
private void Edit() { try { dbo_DimProductSubcategoryClass clsdbo_DimProductSubcategory = new dbo_DimProductSubcategoryClass(); Label lblProductSubcategoryKey = (Label)grddbo_DimProductSubcategory.Rows[grddbo_DimProductSubcategory.EditIndex].FindControl("lblProductSubcategoryKey"); clsdbo_DimProductSubcategory.ProductSubcategoryKey = System.Convert.ToInt32(lblProductSubcategoryKey.Text); clsdbo_DimProductSubcategory = dbo_DimProductSubcategoryDataClass.Select_Record(clsdbo_DimProductSubcategory); Session["ProductCategoryKey_SelectedValue"] = clsdbo_DimProductSubcategory.ProductCategoryKey; LoadGriddbo_DimProductSubcategory(); } catch { } }
private void InsertRecord() { try { TextBox txtNewProductSubcategoryAlternateKey = (TextBox)grddbo_DimProductSubcategory.FooterRow.FindControl("txtNewProductSubcategoryAlternateKey"); TextBox txtNewEnglishProductSubcategoryName = (TextBox)grddbo_DimProductSubcategory.FooterRow.FindControl("txtNewEnglishProductSubcategoryName"); TextBox txtNewSpanishProductSubcategoryName = (TextBox)grddbo_DimProductSubcategory.FooterRow.FindControl("txtNewSpanishProductSubcategoryName"); TextBox txtNewFrenchProductSubcategoryName = (TextBox)grddbo_DimProductSubcategory.FooterRow.FindControl("txtNewFrenchProductSubcategoryName"); DropDownList txtNewProductCategoryKey = (DropDownList)grddbo_DimProductSubcategory.FooterRow.FindControl("txtNewProductCategoryKey"); dbo_DimProductSubcategoryClass clsdbo_DimProductSubcategory = new dbo_DimProductSubcategoryClass(); if (VerifyDataNew() == true) { if (string.IsNullOrEmpty(txtNewProductSubcategoryAlternateKey.Text)) { clsdbo_DimProductSubcategory.ProductSubcategoryAlternateKey = null; } else { clsdbo_DimProductSubcategory.ProductSubcategoryAlternateKey = System.Convert.ToInt32(txtNewProductSubcategoryAlternateKey.Text); } clsdbo_DimProductSubcategory.EnglishProductSubcategoryName = System.Convert.ToString(txtNewEnglishProductSubcategoryName.Text); clsdbo_DimProductSubcategory.SpanishProductSubcategoryName = System.Convert.ToString(txtNewSpanishProductSubcategoryName.Text); clsdbo_DimProductSubcategory.FrenchProductSubcategoryName = System.Convert.ToString(txtNewFrenchProductSubcategoryName.Text); if (string.IsNullOrEmpty(txtNewProductCategoryKey.SelectedValue)) { clsdbo_DimProductSubcategory.ProductCategoryKey = null; } else { clsdbo_DimProductSubcategory.ProductCategoryKey = System.Convert.ToInt32(txtNewProductCategoryKey.SelectedValue); } bool bSucess = false; bSucess = dbo_DimProductSubcategoryDataClass.Add(clsdbo_DimProductSubcategory); if (bSucess == true) { Session.Remove("dvdbo_DimProductSubcategory"); LoadGriddbo_DimProductSubcategory(); } else { ec.ShowMessage(" Insert failed. ", " Dbo. Dim Product Subcategory "); } } } catch { } }
private void DeleteRecord() { dbo_DimProductSubcategoryClass clsdbo_DimProductSubcategory = new dbo_DimProductSubcategoryClass(); Label lblProductSubcategoryKey = (Label)grddbo_DimProductSubcategory.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblProductSubcategoryKey"); clsdbo_DimProductSubcategory.ProductSubcategoryKey = System.Convert.ToInt32(lblProductSubcategoryKey.Text); clsdbo_DimProductSubcategory = dbo_DimProductSubcategoryDataClass.Select_Record(clsdbo_DimProductSubcategory); bool bSucess = false; bSucess = dbo_DimProductSubcategoryDataClass.Delete(clsdbo_DimProductSubcategory); if (bSucess == true) { Session.Remove("dvdbo_DimProductSubcategory"); LoadGriddbo_DimProductSubcategory(); } else { ec.ShowMessage(" Delete failed. ", " Dbo. Dim Product Subcategory "); } }
private void SetData(dbo_DimProductSubcategoryClass clsdbo_DimProductSubcategory) { if (string.IsNullOrEmpty(txtProductSubcategoryAlternateKey.Text)) { clsdbo_DimProductSubcategory.ProductSubcategoryAlternateKey = null; } else { clsdbo_DimProductSubcategory.ProductSubcategoryAlternateKey = System.Convert.ToInt32(txtProductSubcategoryAlternateKey.Text); } clsdbo_DimProductSubcategory.EnglishProductSubcategoryName = System.Convert.ToString(txtEnglishProductSubcategoryName.Text); clsdbo_DimProductSubcategory.SpanishProductSubcategoryName = System.Convert.ToString(txtSpanishProductSubcategoryName.Text); clsdbo_DimProductSubcategory.FrenchProductSubcategoryName = System.Convert.ToString(txtFrenchProductSubcategoryName.Text); if (string.IsNullOrEmpty(txtProductCategoryKey.SelectedValue)) { clsdbo_DimProductSubcategory.ProductCategoryKey = null; } else { clsdbo_DimProductSubcategory.ProductCategoryKey = System.Convert.ToInt32(txtProductCategoryKey.SelectedValue); } }
private void GetData() { ClearRecord(); dbo_DimProductSubcategoryClass clsdbo_DimProductSubcategory = new dbo_DimProductSubcategoryClass(); clsdbo_DimProductSubcategory.ProductSubcategoryKey = System.Convert.ToInt32(Session["ProductSubcategoryKey"]); clsdbo_DimProductSubcategory = dbo_DimProductSubcategoryDataClass.Select_Record(clsdbo_DimProductSubcategory); if ((clsdbo_DimProductSubcategory != null)) { try { txtProductSubcategoryKey.Text = System.Convert.ToString(clsdbo_DimProductSubcategory.ProductSubcategoryKey); if (clsdbo_DimProductSubcategory.ProductSubcategoryAlternateKey == null) { txtProductSubcategoryAlternateKey.Text = default(string); } else { txtProductSubcategoryAlternateKey.Text = System.Convert.ToString(clsdbo_DimProductSubcategory.ProductSubcategoryAlternateKey); } txtEnglishProductSubcategoryName.Text = System.Convert.ToString(clsdbo_DimProductSubcategory.EnglishProductSubcategoryName); txtSpanishProductSubcategoryName.Text = System.Convert.ToString(clsdbo_DimProductSubcategory.SpanishProductSubcategoryName); txtFrenchProductSubcategoryName.Text = System.Convert.ToString(clsdbo_DimProductSubcategory.FrenchProductSubcategoryName); if (clsdbo_DimProductSubcategory.ProductCategoryKey == null) { txtProductCategoryKey.SelectedValue = default(string); } else { txtProductCategoryKey.SelectedValue = System.Convert.ToString(clsdbo_DimProductSubcategory.ProductCategoryKey); } } catch (Exception ex) { ec.ShowMessage(ex.Message, " Dbo. Dim Product Subcategory "); } } }
private void InsertRecord() { dbo_DimProductSubcategoryClass clsdbo_DimProductSubcategory = new dbo_DimProductSubcategoryClass(); if (VerifyData() == true) { SetData(clsdbo_DimProductSubcategory); bool bSucess = false; bSucess = dbo_DimProductSubcategoryDataClass.Add(clsdbo_DimProductSubcategory); if (bSucess == true) { pnlForm.Visible = false; pnlSave.Visible = false; pnlGrid.Visible = true; lblMode.InnerText = ""; Session.Remove("dvdbo_DimProductSubcategory"); LoadGriddbo_DimProductSubcategory(); } else { ec.ShowMessage(" Insert failed. ", " Dbo. Dim Product Subcategory "); } } }
public static bool Update(dbo_DimProductSubcategoryClass olddbo_DimProductSubcategoryClass, dbo_DimProductSubcategoryClass newdbo_DimProductSubcategoryClass) { SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection(); string updateStatement = "UPDATE " + " [dbo].[DimProductSubcategory] " + "SET " + " [ProductSubcategoryAlternateKey] = @NewProductSubcategoryAlternateKey " + " ,[EnglishProductSubcategoryName] = @NewEnglishProductSubcategoryName " + " ,[SpanishProductSubcategoryName] = @NewSpanishProductSubcategoryName " + " ,[FrenchProductSubcategoryName] = @NewFrenchProductSubcategoryName " + " ,[ProductCategoryKey] = @NewProductCategoryKey " + "WHERE " + " [ProductSubcategoryKey] = @OldProductSubcategoryKey " + " AND ((@OldProductSubcategoryAlternateKey IS NULL AND [ProductSubcategoryAlternateKey] IS NULL) OR [ProductSubcategoryAlternateKey] = @OldProductSubcategoryAlternateKey) " + " AND [EnglishProductSubcategoryName] = @OldEnglishProductSubcategoryName " + " AND [SpanishProductSubcategoryName] = @OldSpanishProductSubcategoryName " + " AND [FrenchProductSubcategoryName] = @OldFrenchProductSubcategoryName " + " AND ((@OldProductCategoryKey IS NULL AND [ProductCategoryKey] IS NULL) OR [ProductCategoryKey] = @OldProductCategoryKey) " + ""; SqlCommand updateCommand = new SqlCommand(updateStatement, connection); updateCommand.CommandType = CommandType.Text; if (newdbo_DimProductSubcategoryClass.ProductSubcategoryAlternateKey.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewProductSubcategoryAlternateKey", newdbo_DimProductSubcategoryClass.ProductSubcategoryAlternateKey); } else { updateCommand.Parameters.AddWithValue("@NewProductSubcategoryAlternateKey", DBNull.Value); } updateCommand.Parameters.AddWithValue("@NewEnglishProductSubcategoryName", newdbo_DimProductSubcategoryClass.EnglishProductSubcategoryName); updateCommand.Parameters.AddWithValue("@NewSpanishProductSubcategoryName", newdbo_DimProductSubcategoryClass.SpanishProductSubcategoryName); updateCommand.Parameters.AddWithValue("@NewFrenchProductSubcategoryName", newdbo_DimProductSubcategoryClass.FrenchProductSubcategoryName); if (newdbo_DimProductSubcategoryClass.ProductCategoryKey.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewProductCategoryKey", newdbo_DimProductSubcategoryClass.ProductCategoryKey); } else { updateCommand.Parameters.AddWithValue("@NewProductCategoryKey", DBNull.Value); } updateCommand.Parameters.AddWithValue("@OldProductSubcategoryKey", olddbo_DimProductSubcategoryClass.ProductSubcategoryKey); if (olddbo_DimProductSubcategoryClass.ProductSubcategoryAlternateKey.HasValue == true) { updateCommand.Parameters.AddWithValue("@OldProductSubcategoryAlternateKey", olddbo_DimProductSubcategoryClass.ProductSubcategoryAlternateKey); } else { updateCommand.Parameters.AddWithValue("@OldProductSubcategoryAlternateKey", DBNull.Value); } updateCommand.Parameters.AddWithValue("@OldEnglishProductSubcategoryName", olddbo_DimProductSubcategoryClass.EnglishProductSubcategoryName); updateCommand.Parameters.AddWithValue("@OldSpanishProductSubcategoryName", olddbo_DimProductSubcategoryClass.SpanishProductSubcategoryName); updateCommand.Parameters.AddWithValue("@OldFrenchProductSubcategoryName", olddbo_DimProductSubcategoryClass.FrenchProductSubcategoryName); if (olddbo_DimProductSubcategoryClass.ProductCategoryKey.HasValue == true) { updateCommand.Parameters.AddWithValue("@OldProductCategoryKey", olddbo_DimProductSubcategoryClass.ProductCategoryKey); } else { updateCommand.Parameters.AddWithValue("@OldProductCategoryKey", DBNull.Value); } try { connection.Open(); int count = updateCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException) { return(false); } finally { connection.Close(); } }
public static bool Add(dbo_DimProductSubcategoryClass clsdbo_DimProductSubcategory) { SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection(); string insertStatement = "INSERT " + " [dbo].[DimProductSubcategory] " + " ( " + " [ProductSubcategoryAlternateKey] " + " ,[EnglishProductSubcategoryName] " + " ,[SpanishProductSubcategoryName] " + " ,[FrenchProductSubcategoryName] " + " ,[ProductCategoryKey] " + " ) " + "VALUES " + " ( " + " @ProductSubcategoryAlternateKey " + " ,@EnglishProductSubcategoryName " + " ,@SpanishProductSubcategoryName " + " ,@FrenchProductSubcategoryName " + " ,@ProductCategoryKey " + " ) " + ""; SqlCommand insertCommand = new SqlCommand(insertStatement, connection); insertCommand.CommandType = CommandType.Text; if (clsdbo_DimProductSubcategory.ProductSubcategoryAlternateKey.HasValue == true) { insertCommand.Parameters.AddWithValue("@ProductSubcategoryAlternateKey", clsdbo_DimProductSubcategory.ProductSubcategoryAlternateKey); } else { insertCommand.Parameters.AddWithValue("@ProductSubcategoryAlternateKey", DBNull.Value); } insertCommand.Parameters.AddWithValue("@EnglishProductSubcategoryName", clsdbo_DimProductSubcategory.EnglishProductSubcategoryName); insertCommand.Parameters.AddWithValue("@SpanishProductSubcategoryName", clsdbo_DimProductSubcategory.SpanishProductSubcategoryName); insertCommand.Parameters.AddWithValue("@FrenchProductSubcategoryName", clsdbo_DimProductSubcategory.FrenchProductSubcategoryName); if (clsdbo_DimProductSubcategory.ProductCategoryKey.HasValue == true) { insertCommand.Parameters.AddWithValue("@ProductCategoryKey", clsdbo_DimProductSubcategory.ProductCategoryKey); } else { insertCommand.Parameters.AddWithValue("@ProductCategoryKey", DBNull.Value); } try { connection.Open(); int count = insertCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException) { return(false); } finally { connection.Close(); } }