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