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