private void UpdateRecord() { dbo_DimDepartmentGroupClass oclsdbo_DimDepartmentGroup = new dbo_DimDepartmentGroupClass(); dbo_DimDepartmentGroupClass clsdbo_DimDepartmentGroup = new dbo_DimDepartmentGroupClass(); oclsdbo_DimDepartmentGroup.DepartmentGroupKey = System.Convert.ToInt32(Session["DepartmentGroupKey"]); oclsdbo_DimDepartmentGroup = dbo_DimDepartmentGroupDataClass.Select_Record(oclsdbo_DimDepartmentGroup); if (VerifyData() == true) { SetData(clsdbo_DimDepartmentGroup); bool bSucess = false; bSucess = dbo_DimDepartmentGroupDataClass.Update(oclsdbo_DimDepartmentGroup, clsdbo_DimDepartmentGroup); if (bSucess == true) { pnlForm.Visible = false; pnlSave.Visible = false; pnlGrid.Visible = true; lblMode.InnerText = ""; Session.Remove("dvdbo_DimDepartmentGroup"); LoadGriddbo_DimDepartmentGroup(); } else { ec.ShowMessage(" Update failed. ", " Dbo. Dim Department Group "); } } }
public static bool Add(dbo_DimDepartmentGroupClass clsdbo_DimDepartmentGroup) { SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection(); string insertStatement = "INSERT " + " [dbo].[DimDepartmentGroup] " + " ( " + " [ParentDepartmentGroupKey] " + " ,[DepartmentGroupName] " + " ) " + "VALUES " + " ( " + " @ParentDepartmentGroupKey " + " ,@DepartmentGroupName " + " ) " + ""; SqlCommand insertCommand = new SqlCommand(insertStatement, connection); insertCommand.CommandType = CommandType.Text; if (clsdbo_DimDepartmentGroup.ParentDepartmentGroupKey.HasValue == true) { insertCommand.Parameters.AddWithValue("@ParentDepartmentGroupKey", clsdbo_DimDepartmentGroup.ParentDepartmentGroupKey); } else { insertCommand.Parameters.AddWithValue("@ParentDepartmentGroupKey", DBNull.Value); } if (clsdbo_DimDepartmentGroup.DepartmentGroupName != null) { insertCommand.Parameters.AddWithValue("@DepartmentGroupName", clsdbo_DimDepartmentGroup.DepartmentGroupName); } else { insertCommand.Parameters.AddWithValue("@DepartmentGroupName", DBNull.Value); } try { connection.Open(); int count = insertCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException) { return(false); } finally { connection.Close(); } }
public static bool Delete(dbo_DimDepartmentGroupClass clsdbo_DimDepartmentGroup) { SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection(); string deleteStatement = "DELETE FROM " + " [dbo].[DimDepartmentGroup] " + "WHERE " + " [DepartmentGroupKey] = @OldDepartmentGroupKey " + " AND ((@OldParentDepartmentGroupKey IS NULL AND [ParentDepartmentGroupKey] IS NULL) OR [ParentDepartmentGroupKey] = @OldParentDepartmentGroupKey) " + " AND ((@OldDepartmentGroupName IS NULL AND [DepartmentGroupName] IS NULL) OR [DepartmentGroupName] = @OldDepartmentGroupName) " + ""; SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection); deleteCommand.CommandType = CommandType.Text; deleteCommand.Parameters.AddWithValue("@OldDepartmentGroupKey", clsdbo_DimDepartmentGroup.DepartmentGroupKey); if (clsdbo_DimDepartmentGroup.ParentDepartmentGroupKey.HasValue == true) { deleteCommand.Parameters.AddWithValue("@OldParentDepartmentGroupKey", clsdbo_DimDepartmentGroup.ParentDepartmentGroupKey); } else { deleteCommand.Parameters.AddWithValue("@OldParentDepartmentGroupKey", DBNull.Value); } if (clsdbo_DimDepartmentGroup.DepartmentGroupName != null) { deleteCommand.Parameters.AddWithValue("@OldDepartmentGroupName", clsdbo_DimDepartmentGroup.DepartmentGroupName); } else { deleteCommand.Parameters.AddWithValue("@OldDepartmentGroupName", 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 Edit() { try { dbo_DimDepartmentGroupClass clsdbo_DimDepartmentGroup = new dbo_DimDepartmentGroupClass(); Label lblDepartmentGroupKey = (Label)grddbo_DimDepartmentGroup.Rows[grddbo_DimDepartmentGroup.EditIndex].FindControl("lblDepartmentGroupKey"); clsdbo_DimDepartmentGroup.DepartmentGroupKey = System.Convert.ToInt32(lblDepartmentGroupKey.Text); clsdbo_DimDepartmentGroup = dbo_DimDepartmentGroupDataClass.Select_Record(clsdbo_DimDepartmentGroup); Session["ParentDepartmentGroupKey_SelectedValue"] = clsdbo_DimDepartmentGroup.ParentDepartmentGroupKey; LoadGriddbo_DimDepartmentGroup(); } catch { } }
private void UpdateRecord() { try { TextBox txtDepartmentGroupKey = (TextBox)grddbo_DimDepartmentGroup.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtDepartmentGroupKey"); DropDownList txtParentDepartmentGroupKey = (DropDownList)grddbo_DimDepartmentGroup.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtParentDepartmentGroupKey"); TextBox txtDepartmentGroupName = (TextBox)grddbo_DimDepartmentGroup.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtDepartmentGroupName"); dbo_DimDepartmentGroupClass oclsdbo_DimDepartmentGroup = new dbo_DimDepartmentGroupClass(); dbo_DimDepartmentGroupClass clsdbo_DimDepartmentGroup = new dbo_DimDepartmentGroupClass(); oclsdbo_DimDepartmentGroup.DepartmentGroupKey = System.Convert.ToInt32(txtDepartmentGroupKey.Text); oclsdbo_DimDepartmentGroup = dbo_DimDepartmentGroupDataClass.Select_Record(oclsdbo_DimDepartmentGroup); if (VerifyData() == true) { if (string.IsNullOrEmpty(txtParentDepartmentGroupKey.SelectedValue)) { clsdbo_DimDepartmentGroup.ParentDepartmentGroupKey = null; } else { clsdbo_DimDepartmentGroup.ParentDepartmentGroupKey = System.Convert.ToInt32(txtParentDepartmentGroupKey.SelectedValue); } if (string.IsNullOrEmpty(txtDepartmentGroupName.Text)) { clsdbo_DimDepartmentGroup.DepartmentGroupName = null; } else { clsdbo_DimDepartmentGroup.DepartmentGroupName = txtDepartmentGroupName.Text; } bool bSucess = false; bSucess = dbo_DimDepartmentGroupDataClass.Update(oclsdbo_DimDepartmentGroup, clsdbo_DimDepartmentGroup); if (bSucess == true) { Session.Remove("dvdbo_DimDepartmentGroup"); grddbo_DimDepartmentGroup.EditIndex = -1; LoadGriddbo_DimDepartmentGroup(); } else { ec.ShowMessage(" Update failed. ", " Dbo. Dim Department Group "); } } } catch { } }
public static dbo_DimDepartmentGroupClass Select_Record(dbo_DimDepartmentGroupClass clsdbo_DimDepartmentGroupPara) { dbo_DimDepartmentGroupClass clsdbo_DimDepartmentGroup = new dbo_DimDepartmentGroupClass(); SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection(); string selectStatement = "SELECT " + " [DepartmentGroupKey] " + " ,[ParentDepartmentGroupKey] " + " ,[DepartmentGroupName] " + "FROM " + " [dbo].[DimDepartmentGroup] " + "WHERE " + " [DepartmentGroupKey] = @DepartmentGroupKey " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; selectCommand.Parameters.AddWithValue("@DepartmentGroupKey", clsdbo_DimDepartmentGroupPara.DepartmentGroupKey); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsdbo_DimDepartmentGroup.DepartmentGroupKey = System.Convert.ToInt32(reader["DepartmentGroupKey"]); clsdbo_DimDepartmentGroup.ParentDepartmentGroupKey = reader["ParentDepartmentGroupKey"] is DBNull ? null : (Int32?)reader["ParentDepartmentGroupKey"]; clsdbo_DimDepartmentGroup.DepartmentGroupName = reader["DepartmentGroupName"] is DBNull ? null : reader["DepartmentGroupName"].ToString(); } else { clsdbo_DimDepartmentGroup = null; } reader.Close(); } catch (SqlException) { return(clsdbo_DimDepartmentGroup); } finally { connection.Close(); } return(clsdbo_DimDepartmentGroup); }
private void SetData(dbo_DimDepartmentGroupClass clsdbo_DimDepartmentGroup) { if (string.IsNullOrEmpty(txtParentDepartmentGroupKey.SelectedValue)) { clsdbo_DimDepartmentGroup.ParentDepartmentGroupKey = null; } else { clsdbo_DimDepartmentGroup.ParentDepartmentGroupKey = System.Convert.ToInt32(txtParentDepartmentGroupKey.SelectedValue); } if (string.IsNullOrEmpty(txtDepartmentGroupName.Text)) { clsdbo_DimDepartmentGroup.DepartmentGroupName = null; } else { clsdbo_DimDepartmentGroup.DepartmentGroupName = txtDepartmentGroupName.Text; } }
private void DeleteRecord() { dbo_DimDepartmentGroupClass clsdbo_DimDepartmentGroup = new dbo_DimDepartmentGroupClass(); Label lblDepartmentGroupKey = (Label)grddbo_DimDepartmentGroup.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblDepartmentGroupKey"); clsdbo_DimDepartmentGroup.DepartmentGroupKey = System.Convert.ToInt32(lblDepartmentGroupKey.Text); clsdbo_DimDepartmentGroup = dbo_DimDepartmentGroupDataClass.Select_Record(clsdbo_DimDepartmentGroup); bool bSucess = false; bSucess = dbo_DimDepartmentGroupDataClass.Delete(clsdbo_DimDepartmentGroup); if (bSucess == true) { Session.Remove("dvdbo_DimDepartmentGroup"); LoadGriddbo_DimDepartmentGroup(); } else { ec.ShowMessage(" Delete failed. ", " Dbo. Dim Department Group "); } }
private void InsertRecord() { try { DropDownList txtNewParentDepartmentGroupKey = (DropDownList)grddbo_DimDepartmentGroup.FooterRow.FindControl("txtNewParentDepartmentGroupKey"); TextBox txtNewDepartmentGroupName = (TextBox)grddbo_DimDepartmentGroup.FooterRow.FindControl("txtNewDepartmentGroupName"); dbo_DimDepartmentGroupClass clsdbo_DimDepartmentGroup = new dbo_DimDepartmentGroupClass(); if (VerifyDataNew() == true) { if (string.IsNullOrEmpty(txtNewParentDepartmentGroupKey.SelectedValue)) { clsdbo_DimDepartmentGroup.ParentDepartmentGroupKey = null; } else { clsdbo_DimDepartmentGroup.ParentDepartmentGroupKey = System.Convert.ToInt32(txtNewParentDepartmentGroupKey.SelectedValue); } if (string.IsNullOrEmpty(txtNewDepartmentGroupName.Text)) { clsdbo_DimDepartmentGroup.DepartmentGroupName = null; } else { clsdbo_DimDepartmentGroup.DepartmentGroupName = txtNewDepartmentGroupName.Text; } bool bSucess = false; bSucess = dbo_DimDepartmentGroupDataClass.Add(clsdbo_DimDepartmentGroup); if (bSucess == true) { Session.Remove("dvdbo_DimDepartmentGroup"); LoadGriddbo_DimDepartmentGroup(); } else { ec.ShowMessage(" Insert failed. ", " Dbo. Dim Department Group "); } } } catch { } }
private void InsertRecord() { dbo_DimDepartmentGroupClass clsdbo_DimDepartmentGroup = new dbo_DimDepartmentGroupClass(); if (VerifyData() == true) { SetData(clsdbo_DimDepartmentGroup); bool bSucess = false; bSucess = dbo_DimDepartmentGroupDataClass.Add(clsdbo_DimDepartmentGroup); if (bSucess == true) { pnlForm.Visible = false; pnlSave.Visible = false; pnlGrid.Visible = true; lblMode.InnerText = ""; Session.Remove("dvdbo_DimDepartmentGroup"); LoadGriddbo_DimDepartmentGroup(); } else { ec.ShowMessage(" Insert failed. ", " Dbo. Dim Department Group "); } } }
private void GetData() { ClearRecord(); dbo_DimDepartmentGroupClass clsdbo_DimDepartmentGroup = new dbo_DimDepartmentGroupClass(); clsdbo_DimDepartmentGroup.DepartmentGroupKey = System.Convert.ToInt32(Session["DepartmentGroupKey"]); clsdbo_DimDepartmentGroup = dbo_DimDepartmentGroupDataClass.Select_Record(clsdbo_DimDepartmentGroup); if ((clsdbo_DimDepartmentGroup != null)) { try { txtDepartmentGroupKey.Text = System.Convert.ToString(clsdbo_DimDepartmentGroup.DepartmentGroupKey); if (clsdbo_DimDepartmentGroup.ParentDepartmentGroupKey == null) { txtParentDepartmentGroupKey.SelectedValue = default(string); } else { txtParentDepartmentGroupKey.SelectedValue = System.Convert.ToString(clsdbo_DimDepartmentGroup.ParentDepartmentGroupKey); } if (clsdbo_DimDepartmentGroup.DepartmentGroupName == null) { txtDepartmentGroupName.Text = default(string); } else { txtDepartmentGroupName.Text = System.Convert.ToString(clsdbo_DimDepartmentGroup.DepartmentGroupName); } } catch (Exception ex) { ec.ShowMessage(ex.Message, " Dbo. Dim Department Group "); } } }
public static bool Update(dbo_DimDepartmentGroupClass olddbo_DimDepartmentGroupClass, dbo_DimDepartmentGroupClass newdbo_DimDepartmentGroupClass) { SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection(); string updateStatement = "UPDATE " + " [dbo].[DimDepartmentGroup] " + "SET " + " [ParentDepartmentGroupKey] = @NewParentDepartmentGroupKey " + " ,[DepartmentGroupName] = @NewDepartmentGroupName " + "WHERE " + " [DepartmentGroupKey] = @OldDepartmentGroupKey " + " AND ((@OldParentDepartmentGroupKey IS NULL AND [ParentDepartmentGroupKey] IS NULL) OR [ParentDepartmentGroupKey] = @OldParentDepartmentGroupKey) " + " AND ((@OldDepartmentGroupName IS NULL AND [DepartmentGroupName] IS NULL) OR [DepartmentGroupName] = @OldDepartmentGroupName) " + ""; SqlCommand updateCommand = new SqlCommand(updateStatement, connection); updateCommand.CommandType = CommandType.Text; if (newdbo_DimDepartmentGroupClass.ParentDepartmentGroupKey.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewParentDepartmentGroupKey", newdbo_DimDepartmentGroupClass.ParentDepartmentGroupKey); } else { updateCommand.Parameters.AddWithValue("@NewParentDepartmentGroupKey", DBNull.Value); } if (newdbo_DimDepartmentGroupClass.DepartmentGroupName != null) { updateCommand.Parameters.AddWithValue("@NewDepartmentGroupName", newdbo_DimDepartmentGroupClass.DepartmentGroupName); } else { updateCommand.Parameters.AddWithValue("@NewDepartmentGroupName", DBNull.Value); } updateCommand.Parameters.AddWithValue("@OldDepartmentGroupKey", olddbo_DimDepartmentGroupClass.DepartmentGroupKey); if (olddbo_DimDepartmentGroupClass.ParentDepartmentGroupKey.HasValue == true) { updateCommand.Parameters.AddWithValue("@OldParentDepartmentGroupKey", olddbo_DimDepartmentGroupClass.ParentDepartmentGroupKey); } else { updateCommand.Parameters.AddWithValue("@OldParentDepartmentGroupKey", DBNull.Value); } if (olddbo_DimDepartmentGroupClass.DepartmentGroupName != null) { updateCommand.Parameters.AddWithValue("@OldDepartmentGroupName", olddbo_DimDepartmentGroupClass.DepartmentGroupName); } else { updateCommand.Parameters.AddWithValue("@OldDepartmentGroupName", DBNull.Value); } try { connection.Open(); int count = updateCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException) { return(false); } finally { connection.Close(); } }