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();
}
}
