private void DeleteRecord()
{
dbo_FactAdditionalInternationalProductDescriptionClass clsdbo_FactAdditionalInternationalProductDescription = new dbo_FactAdditionalInternationalProductDescriptionClass();
clsdbo_FactAdditionalInternationalProductDescription.ProductKey = System.Convert.ToInt32(Session["ProductKey"]);
clsdbo_FactAdditionalInternationalProductDescription.CultureName = System.Convert.ToString(Session["CultureName"]);
SetData(clsdbo_FactAdditionalInternationalProductDescription);
bool bSucess = false;
bSucess = dbo_FactAdditionalInternationalProductDescriptionDataClass.Delete(clsdbo_FactAdditionalInternationalProductDescription);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
pnlDelete.Visible = false;
lblMode.InnerText = "";
Session.Remove("dvdbo_FactAdditionalInternationalProductDescription");
LoadGriddbo_FactAdditionalInternationalProductDescription();
}
else
{
ec.ShowMessage(" Delete failed. ", " Dbo. Fact Additional International Product Description ");
}
}
private void UpdateRecord()
{
try {
TextBox txtProductKey = (TextBox)grddbo_FactAdditionalInternationalProductDescription.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtProductKey");
TextBox txtCultureName = (TextBox)grddbo_FactAdditionalInternationalProductDescription.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtCultureName");
TextBox txtProductDescription = (TextBox)grddbo_FactAdditionalInternationalProductDescription.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtProductDescription");
dbo_FactAdditionalInternationalProductDescriptionClass oclsdbo_FactAdditionalInternationalProductDescription = new dbo_FactAdditionalInternationalProductDescriptionClass();
dbo_FactAdditionalInternationalProductDescriptionClass clsdbo_FactAdditionalInternationalProductDescription = new dbo_FactAdditionalInternationalProductDescriptionClass();
oclsdbo_FactAdditionalInternationalProductDescription.ProductKey = System.Convert.ToInt32(txtProductKey.Text);
oclsdbo_FactAdditionalInternationalProductDescription.CultureName = System.Convert.ToString(txtCultureName.Text);
oclsdbo_FactAdditionalInternationalProductDescription = dbo_FactAdditionalInternationalProductDescriptionDataClass.Select_Record(oclsdbo_FactAdditionalInternationalProductDescription);
if (VerifyData() == true)
{
clsdbo_FactAdditionalInternationalProductDescription.ProductKey = System.Convert.ToInt32(txtProductKey.Text);
clsdbo_FactAdditionalInternationalProductDescription.CultureName = System.Convert.ToString(txtCultureName.Text);
clsdbo_FactAdditionalInternationalProductDescription.ProductDescription = System.Convert.ToString(txtProductDescription.Text);
bool bSucess = false;
bSucess = dbo_FactAdditionalInternationalProductDescriptionDataClass.Update(oclsdbo_FactAdditionalInternationalProductDescription, clsdbo_FactAdditionalInternationalProductDescription);
if (bSucess == true)
{
Session.Remove("dvdbo_FactAdditionalInternationalProductDescription");
grddbo_FactAdditionalInternationalProductDescription.EditIndex = -1;
LoadGriddbo_FactAdditionalInternationalProductDescription();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Fact Additional International Product Description ");
}
}
} catch {
}
}
private void InsertRecord()
{
try {
TextBox txtNewProductKey = (TextBox)grddbo_FactAdditionalInternationalProductDescription.FooterRow.FindControl("txtNewProductKey");
TextBox txtNewCultureName = (TextBox)grddbo_FactAdditionalInternationalProductDescription.FooterRow.FindControl("txtNewCultureName");
TextBox txtNewProductDescription = (TextBox)grddbo_FactAdditionalInternationalProductDescription.FooterRow.FindControl("txtNewProductDescription");
dbo_FactAdditionalInternationalProductDescriptionClass clsdbo_FactAdditionalInternationalProductDescription = new dbo_FactAdditionalInternationalProductDescriptionClass();
if (VerifyDataNew() == true)
{
clsdbo_FactAdditionalInternationalProductDescription.ProductKey = System.Convert.ToInt32(txtNewProductKey.Text);
clsdbo_FactAdditionalInternationalProductDescription.CultureName = System.Convert.ToString(txtNewCultureName.Text);
clsdbo_FactAdditionalInternationalProductDescription.ProductDescription = System.Convert.ToString(txtNewProductDescription.Text);
bool bSucess = false;
bSucess = dbo_FactAdditionalInternationalProductDescriptionDataClass.Add(clsdbo_FactAdditionalInternationalProductDescription);
if (bSucess == true)
{
Session.Remove("dvdbo_FactAdditionalInternationalProductDescription");
LoadGriddbo_FactAdditionalInternationalProductDescription();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Fact Additional International Product Description ");
}
}
} catch {
}
}
private void Edit()
{
try {
dbo_FactAdditionalInternationalProductDescriptionClass clsdbo_FactAdditionalInternationalProductDescription = new dbo_FactAdditionalInternationalProductDescriptionClass();
Label lblProductKey = (Label)grddbo_FactAdditionalInternationalProductDescription.Rows[grddbo_FactAdditionalInternationalProductDescription.EditIndex].FindControl("lblProductKey");
clsdbo_FactAdditionalInternationalProductDescription.ProductKey = System.Convert.ToInt32(lblProductKey.Text);
Label lblCultureName = (Label)grddbo_FactAdditionalInternationalProductDescription.Rows[grddbo_FactAdditionalInternationalProductDescription.EditIndex].FindControl("lblCultureName");
clsdbo_FactAdditionalInternationalProductDescription.CultureName = System.Convert.ToString(lblCultureName.Text);
clsdbo_FactAdditionalInternationalProductDescription = dbo_FactAdditionalInternationalProductDescriptionDataClass.Select_Record(clsdbo_FactAdditionalInternationalProductDescription);
LoadGriddbo_FactAdditionalInternationalProductDescription();
} catch {
}
}
public static bool Update(dbo_FactAdditionalInternationalProductDescriptionClass olddbo_FactAdditionalInternationalProductDescriptionClass,
dbo_FactAdditionalInternationalProductDescriptionClass newdbo_FactAdditionalInternationalProductDescriptionClass)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string updateStatement
= "UPDATE "
+ " [dbo].[FactAdditionalInternationalProductDescription] "
+ "SET "
+ " [ProductKey] = @NewProductKey "
+ " ,[CultureName] = @NewCultureName "
+ " ,[ProductDescription] = @NewProductDescription "
+ "WHERE "
+ " [ProductKey] = @OldProductKey "
+ " AND [CultureName] = @OldCultureName "
+ " AND [ProductDescription] = @OldProductDescription "
+ "";
SqlCommand updateCommand = new SqlCommand(updateStatement, connection);
updateCommand.CommandType = CommandType.Text;
updateCommand.Parameters.AddWithValue("@NewProductKey", newdbo_FactAdditionalInternationalProductDescriptionClass.ProductKey);
updateCommand.Parameters.AddWithValue("@NewCultureName", newdbo_FactAdditionalInternationalProductDescriptionClass.CultureName);
updateCommand.Parameters.AddWithValue("@NewProductDescription", newdbo_FactAdditionalInternationalProductDescriptionClass.ProductDescription);
updateCommand.Parameters.AddWithValue("@OldProductKey", olddbo_FactAdditionalInternationalProductDescriptionClass.ProductKey);
updateCommand.Parameters.AddWithValue("@OldCultureName", olddbo_FactAdditionalInternationalProductDescriptionClass.CultureName);
updateCommand.Parameters.AddWithValue("@OldProductDescription", olddbo_FactAdditionalInternationalProductDescriptionClass.ProductDescription);
try
{
connection.Open();
int count = updateCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
public static dbo_FactAdditionalInternationalProductDescriptionClass Select_Record(dbo_FactAdditionalInternationalProductDescriptionClass clsdbo_FactAdditionalInternationalProductDescriptionPara)
{
dbo_FactAdditionalInternationalProductDescriptionClass clsdbo_FactAdditionalInternationalProductDescription = new dbo_FactAdditionalInternationalProductDescriptionClass();
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string selectStatement
= "SELECT "
+ " [ProductKey] "
+ " ,[CultureName] "
+ " ,[ProductDescription] "
+ "FROM "
+ " [dbo].[FactAdditionalInternationalProductDescription] "
+ "WHERE "
+ " [ProductKey] = @ProductKey "
+ " AND [CultureName] = @CultureName "
+ "";
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
selectCommand.CommandType = CommandType.Text;
selectCommand.Parameters.AddWithValue("@ProductKey", clsdbo_FactAdditionalInternationalProductDescriptionPara.ProductKey);
selectCommand.Parameters.AddWithValue("@CultureName", clsdbo_FactAdditionalInternationalProductDescriptionPara.CultureName);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_FactAdditionalInternationalProductDescription.ProductKey = System.Convert.ToInt32(reader["ProductKey"]);
clsdbo_FactAdditionalInternationalProductDescription.CultureName = System.Convert.ToString(reader["CultureName"]);
clsdbo_FactAdditionalInternationalProductDescription.ProductDescription = System.Convert.ToString(reader["ProductDescription"]);
}
else
{
clsdbo_FactAdditionalInternationalProductDescription = null;
}
reader.Close();
}
catch (SqlException)
{
return(clsdbo_FactAdditionalInternationalProductDescription);
}
finally
{
connection.Close();
}
return(clsdbo_FactAdditionalInternationalProductDescription);
}
public static bool Add(dbo_FactAdditionalInternationalProductDescriptionClass clsdbo_FactAdditionalInternationalProductDescription)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string insertStatement
= "INSERT "
+ " [dbo].[FactAdditionalInternationalProductDescription] "
+ " ( "
+ " [ProductKey] "
+ " ,[CultureName] "
+ " ,[ProductDescription] "
+ " ) "
+ "VALUES "
+ " ( "
+ " @ProductKey "
+ " ,@CultureName "
+ " ,@ProductDescription "
+ " ) "
+ "";
SqlCommand insertCommand = new SqlCommand(insertStatement, connection);
insertCommand.CommandType = CommandType.Text;
insertCommand.Parameters.AddWithValue("@ProductKey", clsdbo_FactAdditionalInternationalProductDescription.ProductKey);
insertCommand.Parameters.AddWithValue("@CultureName", clsdbo_FactAdditionalInternationalProductDescription.CultureName);
insertCommand.Parameters.AddWithValue("@ProductDescription", clsdbo_FactAdditionalInternationalProductDescription.ProductDescription);
try
{
connection.Open();
int count = insertCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
private Boolean VerifyDataNew()
{
TextBox txtNewProductKey = (TextBox)grddbo_FactAdditionalInternationalProductDescription.FooterRow.FindControl("txtNewProductKey");
TextBox txtNewCultureName = (TextBox)grddbo_FactAdditionalInternationalProductDescription.FooterRow.FindControl("txtNewCultureName");
TextBox txtNewProductDescription = (TextBox)grddbo_FactAdditionalInternationalProductDescription.FooterRow.FindControl("txtNewProductDescription");
if (txtNewProductKey.Text == "")
{
ec.ShowMessage(" Product Key is Required. ", " Dbo. Fact Additional International Product Description ");
txtNewProductKey.Focus();
return(false);
}
if (txtNewCultureName.Text == "")
{
ec.ShowMessage(" Culture Name is Required. ", " Dbo. Fact Additional International Product Description ");
txtNewCultureName.Focus();
return(false);
}
if (txtNewProductDescription.Text == "")
{
ec.ShowMessage(" Product Description is Required. ", " Dbo. Fact Additional International Product Description ");
txtNewProductDescription.Focus();
return(false);
}
if (
txtNewProductKey.Text != "" &&
txtNewCultureName.Text != ""
)
{
dbo_FactAdditionalInternationalProductDescriptionClass clsdbo_FactAdditionalInternationalProductDescription = new dbo_FactAdditionalInternationalProductDescriptionClass();
clsdbo_FactAdditionalInternationalProductDescription.ProductKey = System.Convert.ToInt32(txtNewProductKey.Text);
clsdbo_FactAdditionalInternationalProductDescription.CultureName = System.Convert.ToString(txtNewCultureName.Text);
clsdbo_FactAdditionalInternationalProductDescription = dbo_FactAdditionalInternationalProductDescriptionDataClass.Select_Record(clsdbo_FactAdditionalInternationalProductDescription);
if (clsdbo_FactAdditionalInternationalProductDescription != null)
{
ec.ShowMessage(" Record already exists. ", " Dbo. Fact Additional International Product Description ");
txtNewProductKey.Focus();
return(false);
}
}
return(true);
}
public static bool Delete(dbo_FactAdditionalInternationalProductDescriptionClass clsdbo_FactAdditionalInternationalProductDescription)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string deleteStatement
= "DELETE FROM "
+ " [dbo].[FactAdditionalInternationalProductDescription] "
+ "WHERE "
+ " [ProductKey] = @OldProductKey "
+ " AND [CultureName] = @OldCultureName "
+ " AND [ProductDescription] = @OldProductDescription "
+ "";
SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection);
deleteCommand.CommandType = CommandType.Text;
deleteCommand.Parameters.AddWithValue("@OldProductKey", clsdbo_FactAdditionalInternationalProductDescription.ProductKey);
deleteCommand.Parameters.AddWithValue("@OldCultureName", clsdbo_FactAdditionalInternationalProductDescription.CultureName);
deleteCommand.Parameters.AddWithValue("@OldProductDescription", clsdbo_FactAdditionalInternationalProductDescription.ProductDescription);
try
{
connection.Open();
int count = deleteCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
private Boolean VerifyData()
{
if (txtProductKey.Text == "")
{
ec.ShowMessage(" Product Key is Required. ", " Dbo. Fact Additional International Product Description ");
txtProductKey.Focus();
return(false);
}
if (txtCultureName.Text == "")
{
ec.ShowMessage(" Culture Name is Required. ", " Dbo. Fact Additional International Product Description ");
txtCultureName.Focus();
return(false);
}
if (txtProductDescription.Text == "")
{
ec.ShowMessage(" Product Description is Required. ", " Dbo. Fact Additional International Product Description ");
txtProductDescription.Focus();
return(false);
}
if (
txtProductKey.Text != "" &&
txtCultureName.Text != ""
)
{
dbo_FactAdditionalInternationalProductDescriptionClass clsdbo_FactAdditionalInternationalProductDescription = new dbo_FactAdditionalInternationalProductDescriptionClass();
clsdbo_FactAdditionalInternationalProductDescription.ProductKey = System.Convert.ToInt32(txtProductKey.Text);
clsdbo_FactAdditionalInternationalProductDescription.CultureName = System.Convert.ToString(txtCultureName.Text);
clsdbo_FactAdditionalInternationalProductDescription = dbo_FactAdditionalInternationalProductDescriptionDataClass.Select_Record(clsdbo_FactAdditionalInternationalProductDescription);
if (clsdbo_FactAdditionalInternationalProductDescription != null && (String)Session["Mode"] == "Add")
{
ec.ShowMessage(" Record already exists. ", " Dbo. Fact Additional International Product Description ");
txtProductKey.Focus();
return(false);
}
}
return(true);
}
private void GetData()
{
ClearRecord();
dbo_FactAdditionalInternationalProductDescriptionClass clsdbo_FactAdditionalInternationalProductDescription = new dbo_FactAdditionalInternationalProductDescriptionClass();
clsdbo_FactAdditionalInternationalProductDescription.ProductKey = System.Convert.ToInt32(Session["ProductKey"]);
clsdbo_FactAdditionalInternationalProductDescription.CultureName = System.Convert.ToString(Session["CultureName"]);
clsdbo_FactAdditionalInternationalProductDescription = dbo_FactAdditionalInternationalProductDescriptionDataClass.Select_Record(clsdbo_FactAdditionalInternationalProductDescription);
if ((clsdbo_FactAdditionalInternationalProductDescription != null))
{
try {
txtProductKey.Text = System.Convert.ToString(clsdbo_FactAdditionalInternationalProductDescription.ProductKey);
txtCultureName.Text = System.Convert.ToString(clsdbo_FactAdditionalInternationalProductDescription.CultureName);
txtProductDescription.Text = System.Convert.ToString(clsdbo_FactAdditionalInternationalProductDescription.ProductDescription);
}
catch (Exception ex)
{
ec.ShowMessage(ex.Message, " Dbo. Fact Additional International Product Description ");
}
}
}
private void DeleteRecord()
{
dbo_FactAdditionalInternationalProductDescriptionClass clsdbo_FactAdditionalInternationalProductDescription = new dbo_FactAdditionalInternationalProductDescriptionClass();
Label lblProductKey = (Label)grddbo_FactAdditionalInternationalProductDescription.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblProductKey");
clsdbo_FactAdditionalInternationalProductDescription.ProductKey = System.Convert.ToInt32(lblProductKey.Text);
Label lblCultureName = (Label)grddbo_FactAdditionalInternationalProductDescription.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblCultureName");
clsdbo_FactAdditionalInternationalProductDescription.CultureName = System.Convert.ToString(lblCultureName.Text);
clsdbo_FactAdditionalInternationalProductDescription = dbo_FactAdditionalInternationalProductDescriptionDataClass.Select_Record(clsdbo_FactAdditionalInternationalProductDescription);
bool bSucess = false;
bSucess = dbo_FactAdditionalInternationalProductDescriptionDataClass.Delete(clsdbo_FactAdditionalInternationalProductDescription);
if (bSucess == true)
{
Session.Remove("dvdbo_FactAdditionalInternationalProductDescription");
LoadGriddbo_FactAdditionalInternationalProductDescription();
}
else
{
ec.ShowMessage(" Delete failed. ", " Dbo. Fact Additional International Product Description ");
}
}
private void InsertRecord()
{
dbo_FactAdditionalInternationalProductDescriptionClass clsdbo_FactAdditionalInternationalProductDescription = new dbo_FactAdditionalInternationalProductDescriptionClass();
if (VerifyData() == true)
{
SetData(clsdbo_FactAdditionalInternationalProductDescription);
bool bSucess = false;
bSucess = dbo_FactAdditionalInternationalProductDescriptionDataClass.Add(clsdbo_FactAdditionalInternationalProductDescription);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_FactAdditionalInternationalProductDescription");
LoadGriddbo_FactAdditionalInternationalProductDescription();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Fact Additional International Product Description ");
}
}
}
private void SetData(dbo_FactAdditionalInternationalProductDescriptionClass clsdbo_FactAdditionalInternationalProductDescription)
{
clsdbo_FactAdditionalInternationalProductDescription.ProductKey = System.Convert.ToInt32(txtProductKey.Text);
clsdbo_FactAdditionalInternationalProductDescription.CultureName = System.Convert.ToString(txtCultureName.Text);
clsdbo_FactAdditionalInternationalProductDescription.ProductDescription = System.Convert.ToString(txtProductDescription.Text);
}
