private void DeleteRecord() { dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass(); Label lblSalesOrderNumber = (Label)grddbo_FactInternetSalesReason.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblSalesOrderNumber"); clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(lblSalesOrderNumber.Text); Label lblSalesOrderLineNumber = (Label)grddbo_FactInternetSalesReason.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblSalesOrderLineNumber"); clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(lblSalesOrderLineNumber.Text); Label lblSalesReasonKey = (Label)grddbo_FactInternetSalesReason.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblSalesReasonKey"); clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(lblSalesReasonKey.Text); clsdbo_FactInternetSalesReason = dbo_FactInternetSalesReasonDataClass.Select_Record(clsdbo_FactInternetSalesReason); bool bSucess = false; bSucess = dbo_FactInternetSalesReasonDataClass.Delete(clsdbo_FactInternetSalesReason); if (bSucess == true) { Session.Remove("dvdbo_FactInternetSalesReason"); LoadGriddbo_FactInternetSalesReason(); } else { ec.ShowMessage(" Delete failed. ", " Dbo. Fact Internet Sales Reason "); } }
private void DeleteRecord() { dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass(); clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(Session["SalesOrderNumber"]); clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(Session["SalesOrderLineNumber"]); clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(Session["SalesReasonKey"]); SetData(clsdbo_FactInternetSalesReason); bool bSucess = false; bSucess = dbo_FactInternetSalesReasonDataClass.Delete(clsdbo_FactInternetSalesReason); if (bSucess == true) { pnlForm.Visible = false; pnlSave.Visible = false; pnlGrid.Visible = true; pnlDelete.Visible = false; lblMode.InnerText = ""; Session.Remove("dvdbo_FactInternetSalesReason"); LoadGriddbo_FactInternetSalesReason(); } else { ec.ShowMessage(" Delete failed. ", " Dbo. Fact Internet Sales Reason "); } }
private void UpdateRecord() { try { DropDownList txtSalesOrderNumber = (DropDownList)grddbo_FactInternetSalesReason.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSalesOrderNumber"); DropDownList txtSalesOrderLineNumber = (DropDownList)grddbo_FactInternetSalesReason.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSalesOrderLineNumber"); DropDownList txtSalesReasonKey = (DropDownList)grddbo_FactInternetSalesReason.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSalesReasonKey"); dbo_FactInternetSalesReasonClass oclsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass(); dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass(); oclsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(txtSalesOrderNumber.Text); oclsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(txtSalesOrderLineNumber.Text); oclsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(txtSalesReasonKey.Text); oclsdbo_FactInternetSalesReason = dbo_FactInternetSalesReasonDataClass.Select_Record(oclsdbo_FactInternetSalesReason); if (VerifyData() == true) { clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(txtSalesOrderNumber.SelectedValue); clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(txtSalesOrderLineNumber.SelectedValue); clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(txtSalesReasonKey.SelectedValue); bool bSucess = false; bSucess = dbo_FactInternetSalesReasonDataClass.Update(oclsdbo_FactInternetSalesReason, clsdbo_FactInternetSalesReason); if (bSucess == true) { Session.Remove("dvdbo_FactInternetSalesReason"); grddbo_FactInternetSalesReason.EditIndex = -1; LoadGriddbo_FactInternetSalesReason(); } else { ec.ShowMessage(" Update failed. ", " Dbo. Fact Internet Sales Reason "); } } } catch { } }
private void InsertRecord() { try { DropDownList txtNewSalesOrderNumber = (DropDownList)grddbo_FactInternetSalesReason.FooterRow.FindControl("txtNewSalesOrderNumber"); DropDownList txtNewSalesOrderLineNumber = (DropDownList)grddbo_FactInternetSalesReason.FooterRow.FindControl("txtNewSalesOrderLineNumber"); DropDownList txtNewSalesReasonKey = (DropDownList)grddbo_FactInternetSalesReason.FooterRow.FindControl("txtNewSalesReasonKey"); dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass(); if (VerifyDataNew() == true) { clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(txtNewSalesOrderNumber.SelectedValue); clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(txtNewSalesOrderLineNumber.SelectedValue); clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(txtNewSalesReasonKey.SelectedValue); bool bSucess = false; bSucess = dbo_FactInternetSalesReasonDataClass.Add(clsdbo_FactInternetSalesReason); if (bSucess == true) { Session.Remove("dvdbo_FactInternetSalesReason"); LoadGriddbo_FactInternetSalesReason(); } else { ec.ShowMessage(" Insert failed. ", " Dbo. Fact Internet Sales Reason "); } } } catch { } }
public static dbo_FactInternetSalesReasonClass Select_Record(dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReasonPara) { dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass(); SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection(); string selectStatement = "SELECT " + " [SalesOrderNumber] " + " ,[SalesOrderLineNumber] " + " ,[SalesReasonKey] " + "FROM " + " [dbo].[FactInternetSalesReason] " + "WHERE " + " [SalesOrderNumber] = @SalesOrderNumber " + " AND [SalesOrderLineNumber] = @SalesOrderLineNumber " + " AND [SalesReasonKey] = @SalesReasonKey " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; selectCommand.Parameters.AddWithValue("@SalesOrderNumber", clsdbo_FactInternetSalesReasonPara.SalesOrderNumber); selectCommand.Parameters.AddWithValue("@SalesOrderLineNumber", clsdbo_FactInternetSalesReasonPara.SalesOrderLineNumber); selectCommand.Parameters.AddWithValue("@SalesReasonKey", clsdbo_FactInternetSalesReasonPara.SalesReasonKey); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(reader["SalesOrderNumber"]); clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(reader["SalesOrderLineNumber"]); clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(reader["SalesReasonKey"]); } else { clsdbo_FactInternetSalesReason = null; } reader.Close(); } catch (SqlException) { return(clsdbo_FactInternetSalesReason); } finally { connection.Close(); } return(clsdbo_FactInternetSalesReason); }
public static bool Update(dbo_FactInternetSalesReasonClass olddbo_FactInternetSalesReasonClass, dbo_FactInternetSalesReasonClass newdbo_FactInternetSalesReasonClass) { SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection(); string updateStatement = "UPDATE " + " [dbo].[FactInternetSalesReason] " + "SET " + " [SalesOrderNumber] = @NewSalesOrderNumber " + " ,[SalesOrderLineNumber] = @NewSalesOrderLineNumber " + " ,[SalesReasonKey] = @NewSalesReasonKey " + "WHERE " + " [SalesOrderNumber] = @OldSalesOrderNumber " + " AND [SalesOrderLineNumber] = @OldSalesOrderLineNumber " + " AND [SalesReasonKey] = @OldSalesReasonKey " + ""; SqlCommand updateCommand = new SqlCommand(updateStatement, connection); updateCommand.CommandType = CommandType.Text; updateCommand.Parameters.AddWithValue("@NewSalesOrderNumber", newdbo_FactInternetSalesReasonClass.SalesOrderNumber); updateCommand.Parameters.AddWithValue("@NewSalesOrderLineNumber", newdbo_FactInternetSalesReasonClass.SalesOrderLineNumber); updateCommand.Parameters.AddWithValue("@NewSalesReasonKey", newdbo_FactInternetSalesReasonClass.SalesReasonKey); updateCommand.Parameters.AddWithValue("@OldSalesOrderNumber", olddbo_FactInternetSalesReasonClass.SalesOrderNumber); updateCommand.Parameters.AddWithValue("@OldSalesOrderLineNumber", olddbo_FactInternetSalesReasonClass.SalesOrderLineNumber); updateCommand.Parameters.AddWithValue("@OldSalesReasonKey", olddbo_FactInternetSalesReasonClass.SalesReasonKey); 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_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason) { SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection(); string insertStatement = "INSERT " + " [dbo].[FactInternetSalesReason] " + " ( " + " [SalesOrderNumber] " + " ,[SalesOrderLineNumber] " + " ,[SalesReasonKey] " + " ) " + "VALUES " + " ( " + " @SalesOrderNumber " + " ,@SalesOrderLineNumber " + " ,@SalesReasonKey " + " ) " + ""; SqlCommand insertCommand = new SqlCommand(insertStatement, connection); insertCommand.CommandType = CommandType.Text; insertCommand.Parameters.AddWithValue("@SalesOrderNumber", clsdbo_FactInternetSalesReason.SalesOrderNumber); insertCommand.Parameters.AddWithValue("@SalesOrderLineNumber", clsdbo_FactInternetSalesReason.SalesOrderLineNumber); insertCommand.Parameters.AddWithValue("@SalesReasonKey", clsdbo_FactInternetSalesReason.SalesReasonKey); 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() { DropDownList txtNewSalesOrderNumber = (DropDownList)grddbo_FactInternetSalesReason.FooterRow.FindControl("txtNewSalesOrderNumber"); DropDownList txtNewSalesOrderLineNumber = (DropDownList)grddbo_FactInternetSalesReason.FooterRow.FindControl("txtNewSalesOrderLineNumber"); DropDownList txtNewSalesReasonKey = (DropDownList)grddbo_FactInternetSalesReason.FooterRow.FindControl("txtNewSalesReasonKey"); if (txtNewSalesOrderNumber.Text == "") { ec.ShowMessage(" Sales Order Number is Required. ", " Dbo. Fact Internet Sales Reason "); txtNewSalesOrderNumber.Focus(); return(false); } if (txtNewSalesOrderLineNumber.Text == "") { ec.ShowMessage(" Sales Order Line Number is Required. ", " Dbo. Fact Internet Sales Reason "); txtNewSalesOrderLineNumber.Focus(); return(false); } if (txtNewSalesReasonKey.Text == "") { ec.ShowMessage(" Sales Reason Key is Required. ", " Dbo. Fact Internet Sales Reason "); txtNewSalesReasonKey.Focus(); return(false); } if ( txtNewSalesOrderNumber.SelectedIndex != -1 && txtNewSalesOrderLineNumber.SelectedIndex != -1 && txtNewSalesReasonKey.SelectedIndex != -1 ) { dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass(); clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(txtNewSalesOrderNumber.SelectedValue); clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(txtNewSalesOrderLineNumber.SelectedValue); clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(txtNewSalesReasonKey.SelectedValue); clsdbo_FactInternetSalesReason = dbo_FactInternetSalesReasonDataClass.Select_Record(clsdbo_FactInternetSalesReason); if (clsdbo_FactInternetSalesReason != null) { ec.ShowMessage(" Record already exists. ", " Dbo. Fact Internet Sales Reason "); txtNewSalesOrderNumber.Focus(); return(false); } } return(true); }
private void Edit() { try { dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass(); Label lblSalesOrderNumber = (Label)grddbo_FactInternetSalesReason.Rows[grddbo_FactInternetSalesReason.EditIndex].FindControl("lblSalesOrderNumber"); clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(lblSalesOrderNumber.Text); Label lblSalesOrderLineNumber = (Label)grddbo_FactInternetSalesReason.Rows[grddbo_FactInternetSalesReason.EditIndex].FindControl("lblSalesOrderLineNumber"); clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(lblSalesOrderLineNumber.Text); Label lblSalesReasonKey = (Label)grddbo_FactInternetSalesReason.Rows[grddbo_FactInternetSalesReason.EditIndex].FindControl("lblSalesReasonKey"); clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(lblSalesReasonKey.Text); clsdbo_FactInternetSalesReason = dbo_FactInternetSalesReasonDataClass.Select_Record(clsdbo_FactInternetSalesReason); Session["SalesOrderNumber_SelectedValue"] = clsdbo_FactInternetSalesReason.SalesOrderNumber; Session["SalesOrderLineNumber_SelectedValue"] = clsdbo_FactInternetSalesReason.SalesOrderLineNumber; Session["SalesReasonKey_SelectedValue"] = clsdbo_FactInternetSalesReason.SalesReasonKey; LoadGriddbo_FactInternetSalesReason(); } catch { } }
private Boolean VerifyData() { if (txtSalesOrderNumber.Text == "") { ec.ShowMessage(" Sales Order Number is Required. ", " Dbo. Fact Internet Sales Reason "); txtSalesOrderNumber.Focus(); return(false); } if (txtSalesOrderLineNumber.Text == "") { ec.ShowMessage(" Sales Order Line Number is Required. ", " Dbo. Fact Internet Sales Reason "); txtSalesOrderLineNumber.Focus(); return(false); } if (txtSalesReasonKey.Text == "") { ec.ShowMessage(" Sales Reason Key is Required. ", " Dbo. Fact Internet Sales Reason "); txtSalesReasonKey.Focus(); return(false); } if ( txtSalesOrderNumber.SelectedIndex != -1 && txtSalesOrderLineNumber.SelectedIndex != -1 && txtSalesReasonKey.SelectedIndex != -1 ) { dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass(); clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(txtSalesOrderNumber.SelectedValue); clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(txtSalesOrderLineNumber.SelectedValue); clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(txtSalesReasonKey.SelectedValue); clsdbo_FactInternetSalesReason = dbo_FactInternetSalesReasonDataClass.Select_Record(clsdbo_FactInternetSalesReason); if (clsdbo_FactInternetSalesReason != null && (String)Session["Mode"] == "Add") { ec.ShowMessage(" Record already exists. ", " Dbo. Fact Internet Sales Reason "); txtSalesOrderNumber.Focus(); return(false); } } return(true); }
public static bool Delete(dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason) { SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection(); string deleteStatement = "DELETE FROM " + " [dbo].[FactInternetSalesReason] " + "WHERE " + " [SalesOrderNumber] = @OldSalesOrderNumber " + " AND [SalesOrderLineNumber] = @OldSalesOrderLineNumber " + " AND [SalesReasonKey] = @OldSalesReasonKey " + ""; SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection); deleteCommand.CommandType = CommandType.Text; deleteCommand.Parameters.AddWithValue("@OldSalesOrderNumber", clsdbo_FactInternetSalesReason.SalesOrderNumber); deleteCommand.Parameters.AddWithValue("@OldSalesOrderLineNumber", clsdbo_FactInternetSalesReason.SalesOrderLineNumber); deleteCommand.Parameters.AddWithValue("@OldSalesReasonKey", clsdbo_FactInternetSalesReason.SalesReasonKey); try { connection.Open(); int count = deleteCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException) { return(false); } finally { connection.Close(); } }
private void InsertRecord() { dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass(); if (VerifyData() == true) { SetData(clsdbo_FactInternetSalesReason); bool bSucess = false; bSucess = dbo_FactInternetSalesReasonDataClass.Add(clsdbo_FactInternetSalesReason); if (bSucess == true) { pnlForm.Visible = false; pnlSave.Visible = false; pnlGrid.Visible = true; lblMode.InnerText = ""; Session.Remove("dvdbo_FactInternetSalesReason"); LoadGriddbo_FactInternetSalesReason(); } else { ec.ShowMessage(" Insert failed. ", " Dbo. Fact Internet Sales Reason "); } } }
private void GetData() { ClearRecord(); dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass(); clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(Session["SalesOrderNumber"]); clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(Session["SalesOrderLineNumber"]); clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(Session["SalesReasonKey"]); clsdbo_FactInternetSalesReason = dbo_FactInternetSalesReasonDataClass.Select_Record(clsdbo_FactInternetSalesReason); if ((clsdbo_FactInternetSalesReason != null)) { try { txtSalesOrderNumber.SelectedValue = System.Convert.ToString(clsdbo_FactInternetSalesReason.SalesOrderNumber); txtSalesOrderLineNumber.SelectedValue = System.Convert.ToString(clsdbo_FactInternetSalesReason.SalesOrderLineNumber); txtSalesReasonKey.SelectedValue = System.Convert.ToString(clsdbo_FactInternetSalesReason.SalesReasonKey); } catch (Exception ex) { ec.ShowMessage(ex.Message, " Dbo. Fact Internet Sales Reason "); } } }
private void SetData(dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason) { clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(txtSalesOrderNumber.SelectedValue); clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(txtSalesOrderLineNumber.SelectedValue); clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(txtSalesReasonKey.SelectedValue); }