private void UpdateRecord()
{
dbo_DimOrganizationClass oclsdbo_DimOrganization = new dbo_DimOrganizationClass();
dbo_DimOrganizationClass clsdbo_DimOrganization = new dbo_DimOrganizationClass();
oclsdbo_DimOrganization.OrganizationKey = System.Convert.ToInt32(Session["OrganizationKey"]);
oclsdbo_DimOrganization = dbo_DimOrganizationDataClass.Select_Record(oclsdbo_DimOrganization);
if (VerifyData() == true)
{
SetData(clsdbo_DimOrganization);
bool bSucess = false;
bSucess = dbo_DimOrganizationDataClass.Update(oclsdbo_DimOrganization, clsdbo_DimOrganization);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_DimOrganization");
LoadGriddbo_DimOrganization();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Dim Organization ");
}
}
}
private void SetData(dbo_DimOrganizationClass clsdbo_DimOrganization)
{
if (string.IsNullOrEmpty(txtParentOrganizationKey.SelectedValue))
{
clsdbo_DimOrganization.ParentOrganizationKey = null;
}
else
{
clsdbo_DimOrganization.ParentOrganizationKey = System.Convert.ToInt32(txtParentOrganizationKey.SelectedValue);
}
if (string.IsNullOrEmpty(txtPercentageOfOwnership.Text))
{
clsdbo_DimOrganization.PercentageOfOwnership = null;
}
else
{
clsdbo_DimOrganization.PercentageOfOwnership = txtPercentageOfOwnership.Text;
}
if (string.IsNullOrEmpty(txtOrganizationName.Text))
{
clsdbo_DimOrganization.OrganizationName = null;
}
else
{
clsdbo_DimOrganization.OrganizationName = txtOrganizationName.Text;
}
if (string.IsNullOrEmpty(txtCurrencyKey.SelectedValue))
{
clsdbo_DimOrganization.CurrencyKey = null;
}
else
{
clsdbo_DimOrganization.CurrencyKey = System.Convert.ToInt32(txtCurrencyKey.SelectedValue);
}
}
private void InsertRecord()
{
try {
DropDownList txtNewParentOrganizationKey = (DropDownList)grddbo_DimOrganization.FooterRow.FindControl("txtNewParentOrganizationKey");
TextBox txtNewPercentageOfOwnership = (TextBox)grddbo_DimOrganization.FooterRow.FindControl("txtNewPercentageOfOwnership");
TextBox txtNewOrganizationName = (TextBox)grddbo_DimOrganization.FooterRow.FindControl("txtNewOrganizationName");
DropDownList txtNewCurrencyKey = (DropDownList)grddbo_DimOrganization.FooterRow.FindControl("txtNewCurrencyKey");
dbo_DimOrganizationClass clsdbo_DimOrganization = new dbo_DimOrganizationClass();
if (VerifyDataNew() == true)
{
if (string.IsNullOrEmpty(txtNewParentOrganizationKey.SelectedValue))
{
clsdbo_DimOrganization.ParentOrganizationKey = null;
}
else
{
clsdbo_DimOrganization.ParentOrganizationKey = System.Convert.ToInt32(txtNewParentOrganizationKey.SelectedValue);
}
if (string.IsNullOrEmpty(txtNewPercentageOfOwnership.Text))
{
clsdbo_DimOrganization.PercentageOfOwnership = null;
}
else
{
clsdbo_DimOrganization.PercentageOfOwnership = txtNewPercentageOfOwnership.Text;
}
if (string.IsNullOrEmpty(txtNewOrganizationName.Text))
{
clsdbo_DimOrganization.OrganizationName = null;
}
else
{
clsdbo_DimOrganization.OrganizationName = txtNewOrganizationName.Text;
}
if (string.IsNullOrEmpty(txtNewCurrencyKey.SelectedValue))
{
clsdbo_DimOrganization.CurrencyKey = null;
}
else
{
clsdbo_DimOrganization.CurrencyKey = System.Convert.ToInt32(txtNewCurrencyKey.SelectedValue);
}
bool bSucess = false;
bSucess = dbo_DimOrganizationDataClass.Add(clsdbo_DimOrganization);
if (bSucess == true)
{
Session.Remove("dvdbo_DimOrganization");
LoadGriddbo_DimOrganization();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Dim Organization ");
}
}
} catch {
}
}
private void GetData()
{
ClearRecord();
dbo_DimOrganizationClass clsdbo_DimOrganization = new dbo_DimOrganizationClass();
clsdbo_DimOrganization.OrganizationKey = System.Convert.ToInt32(Session["OrganizationKey"]);
clsdbo_DimOrganization = dbo_DimOrganizationDataClass.Select_Record(clsdbo_DimOrganization);
if ((clsdbo_DimOrganization != null))
{
try {
txtOrganizationKey.Text = System.Convert.ToString(clsdbo_DimOrganization.OrganizationKey);
if (clsdbo_DimOrganization.ParentOrganizationKey == null)
{
txtParentOrganizationKey.SelectedValue = default(string);
}
else
{
txtParentOrganizationKey.SelectedValue = System.Convert.ToString(clsdbo_DimOrganization.ParentOrganizationKey);
}
if (clsdbo_DimOrganization.PercentageOfOwnership == null)
{
txtPercentageOfOwnership.Text = default(string);
}
else
{
txtPercentageOfOwnership.Text = System.Convert.ToString(clsdbo_DimOrganization.PercentageOfOwnership);
}
if (clsdbo_DimOrganization.OrganizationName == null)
{
txtOrganizationName.Text = default(string);
}
else
{
txtOrganizationName.Text = System.Convert.ToString(clsdbo_DimOrganization.OrganizationName);
}
if (clsdbo_DimOrganization.CurrencyKey == null)
{
txtCurrencyKey.SelectedValue = default(string);
}
else
{
txtCurrencyKey.SelectedValue = System.Convert.ToString(clsdbo_DimOrganization.CurrencyKey);
}
}
catch (Exception ex)
{
ec.ShowMessage(ex.Message, " Dbo. Dim Organization ");
}
}
}
public static dbo_DimOrganizationClass Select_Record(dbo_DimOrganizationClass clsdbo_DimOrganizationPara)
{
dbo_DimOrganizationClass clsdbo_DimOrganization = new dbo_DimOrganizationClass();
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string selectStatement
= "SELECT "
+ " [OrganizationKey] "
+ " ,[ParentOrganizationKey] "
+ " ,[PercentageOfOwnership] "
+ " ,[OrganizationName] "
+ " ,[CurrencyKey] "
+ "FROM "
+ " [dbo].[DimOrganization] "
+ "WHERE "
+ " [OrganizationKey] = @OrganizationKey "
+ "";
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
selectCommand.CommandType = CommandType.Text;
selectCommand.Parameters.AddWithValue("@OrganizationKey", clsdbo_DimOrganizationPara.OrganizationKey);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_DimOrganization.OrganizationKey = System.Convert.ToInt32(reader["OrganizationKey"]);
clsdbo_DimOrganization.ParentOrganizationKey = reader["ParentOrganizationKey"] is DBNull ? null : (Int32?)reader["ParentOrganizationKey"];
clsdbo_DimOrganization.PercentageOfOwnership = reader["PercentageOfOwnership"] is DBNull ? null : reader["PercentageOfOwnership"].ToString();
clsdbo_DimOrganization.OrganizationName = reader["OrganizationName"] is DBNull ? null : reader["OrganizationName"].ToString();
clsdbo_DimOrganization.CurrencyKey = reader["CurrencyKey"] is DBNull ? null : (Int32?)reader["CurrencyKey"];
}
else
{
clsdbo_DimOrganization = null;
}
reader.Close();
}
catch (SqlException)
{
return(clsdbo_DimOrganization);
}
finally
{
connection.Close();
}
return(clsdbo_DimOrganization);
}
private void Edit()
{
try {
dbo_DimOrganizationClass clsdbo_DimOrganization = new dbo_DimOrganizationClass();
Label lblOrganizationKey = (Label)grddbo_DimOrganization.Rows[grddbo_DimOrganization.EditIndex].FindControl("lblOrganizationKey");
clsdbo_DimOrganization.OrganizationKey = System.Convert.ToInt32(lblOrganizationKey.Text);
clsdbo_DimOrganization = dbo_DimOrganizationDataClass.Select_Record(clsdbo_DimOrganization);
Session["ParentOrganizationKey_SelectedValue"] = clsdbo_DimOrganization.ParentOrganizationKey;
Session["CurrencyKey_SelectedValue"] = clsdbo_DimOrganization.CurrencyKey;
LoadGriddbo_DimOrganization();
} catch {
}
}
private void DeleteRecord()
{
dbo_DimOrganizationClass clsdbo_DimOrganization = new dbo_DimOrganizationClass();
Label lblOrganizationKey = (Label)grddbo_DimOrganization.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblOrganizationKey");
clsdbo_DimOrganization.OrganizationKey = System.Convert.ToInt32(lblOrganizationKey.Text);
clsdbo_DimOrganization = dbo_DimOrganizationDataClass.Select_Record(clsdbo_DimOrganization);
bool bSucess = false;
bSucess = dbo_DimOrganizationDataClass.Delete(clsdbo_DimOrganization);
if (bSucess == true)
{
Session.Remove("dvdbo_DimOrganization");
LoadGriddbo_DimOrganization();
}
else
{
ec.ShowMessage(" Delete failed. ", " Dbo. Dim Organization ");
}
}
private void InsertRecord()
{
dbo_DimOrganizationClass clsdbo_DimOrganization = new dbo_DimOrganizationClass();
if (VerifyData() == true)
{
SetData(clsdbo_DimOrganization);
bool bSucess = false;
bSucess = dbo_DimOrganizationDataClass.Add(clsdbo_DimOrganization);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_DimOrganization");
LoadGriddbo_DimOrganization();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Dim Organization ");
}
}
}
public static bool Delete(dbo_DimOrganizationClass clsdbo_DimOrganization)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string deleteStatement
= "DELETE FROM "
+ " [dbo].[DimOrganization] "
+ "WHERE "
+ " [OrganizationKey] = @OldOrganizationKey "
+ " AND ((@OldParentOrganizationKey IS NULL AND [ParentOrganizationKey] IS NULL) OR [ParentOrganizationKey] = @OldParentOrganizationKey) "
+ " AND ((@OldPercentageOfOwnership IS NULL AND [PercentageOfOwnership] IS NULL) OR [PercentageOfOwnership] = @OldPercentageOfOwnership) "
+ " AND ((@OldOrganizationName IS NULL AND [OrganizationName] IS NULL) OR [OrganizationName] = @OldOrganizationName) "
+ " AND ((@OldCurrencyKey IS NULL AND [CurrencyKey] IS NULL) OR [CurrencyKey] = @OldCurrencyKey) "
+ "";
SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection);
deleteCommand.CommandType = CommandType.Text;
deleteCommand.Parameters.AddWithValue("@OldOrganizationKey", clsdbo_DimOrganization.OrganizationKey);
if (clsdbo_DimOrganization.ParentOrganizationKey.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldParentOrganizationKey", clsdbo_DimOrganization.ParentOrganizationKey);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldParentOrganizationKey", DBNull.Value);
}
if (clsdbo_DimOrganization.PercentageOfOwnership != null)
{
deleteCommand.Parameters.AddWithValue("@OldPercentageOfOwnership", clsdbo_DimOrganization.PercentageOfOwnership);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldPercentageOfOwnership", DBNull.Value);
}
if (clsdbo_DimOrganization.OrganizationName != null)
{
deleteCommand.Parameters.AddWithValue("@OldOrganizationName", clsdbo_DimOrganization.OrganizationName);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldOrganizationName", DBNull.Value);
}
if (clsdbo_DimOrganization.CurrencyKey.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldCurrencyKey", clsdbo_DimOrganization.CurrencyKey);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldCurrencyKey", DBNull.Value);
}
try
{
connection.Open();
int count = deleteCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
public static bool Update(dbo_DimOrganizationClass olddbo_DimOrganizationClass,
dbo_DimOrganizationClass newdbo_DimOrganizationClass)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string updateStatement
= "UPDATE "
+ " [dbo].[DimOrganization] "
+ "SET "
+ " [ParentOrganizationKey] = @NewParentOrganizationKey "
+ " ,[PercentageOfOwnership] = @NewPercentageOfOwnership "
+ " ,[OrganizationName] = @NewOrganizationName "
+ " ,[CurrencyKey] = @NewCurrencyKey "
+ "WHERE "
+ " [OrganizationKey] = @OldOrganizationKey "
+ " AND ((@OldParentOrganizationKey IS NULL AND [ParentOrganizationKey] IS NULL) OR [ParentOrganizationKey] = @OldParentOrganizationKey) "
+ " AND ((@OldPercentageOfOwnership IS NULL AND [PercentageOfOwnership] IS NULL) OR [PercentageOfOwnership] = @OldPercentageOfOwnership) "
+ " AND ((@OldOrganizationName IS NULL AND [OrganizationName] IS NULL) OR [OrganizationName] = @OldOrganizationName) "
+ " AND ((@OldCurrencyKey IS NULL AND [CurrencyKey] IS NULL) OR [CurrencyKey] = @OldCurrencyKey) "
+ "";
SqlCommand updateCommand = new SqlCommand(updateStatement, connection);
updateCommand.CommandType = CommandType.Text;
if (newdbo_DimOrganizationClass.ParentOrganizationKey.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewParentOrganizationKey", newdbo_DimOrganizationClass.ParentOrganizationKey);
}
else
{
updateCommand.Parameters.AddWithValue("@NewParentOrganizationKey", DBNull.Value);
}
if (newdbo_DimOrganizationClass.PercentageOfOwnership != null)
{
updateCommand.Parameters.AddWithValue("@NewPercentageOfOwnership", newdbo_DimOrganizationClass.PercentageOfOwnership);
}
else
{
updateCommand.Parameters.AddWithValue("@NewPercentageOfOwnership", DBNull.Value);
}
if (newdbo_DimOrganizationClass.OrganizationName != null)
{
updateCommand.Parameters.AddWithValue("@NewOrganizationName", newdbo_DimOrganizationClass.OrganizationName);
}
else
{
updateCommand.Parameters.AddWithValue("@NewOrganizationName", DBNull.Value);
}
if (newdbo_DimOrganizationClass.CurrencyKey.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewCurrencyKey", newdbo_DimOrganizationClass.CurrencyKey);
}
else
{
updateCommand.Parameters.AddWithValue("@NewCurrencyKey", DBNull.Value);
}
updateCommand.Parameters.AddWithValue("@OldOrganizationKey", olddbo_DimOrganizationClass.OrganizationKey);
if (olddbo_DimOrganizationClass.ParentOrganizationKey.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@OldParentOrganizationKey", olddbo_DimOrganizationClass.ParentOrganizationKey);
}
else
{
updateCommand.Parameters.AddWithValue("@OldParentOrganizationKey", DBNull.Value);
}
if (olddbo_DimOrganizationClass.PercentageOfOwnership != null)
{
updateCommand.Parameters.AddWithValue("@OldPercentageOfOwnership", olddbo_DimOrganizationClass.PercentageOfOwnership);
}
else
{
updateCommand.Parameters.AddWithValue("@OldPercentageOfOwnership", DBNull.Value);
}
if (olddbo_DimOrganizationClass.OrganizationName != null)
{
updateCommand.Parameters.AddWithValue("@OldOrganizationName", olddbo_DimOrganizationClass.OrganizationName);
}
else
{
updateCommand.Parameters.AddWithValue("@OldOrganizationName", DBNull.Value);
}
if (olddbo_DimOrganizationClass.CurrencyKey.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@OldCurrencyKey", olddbo_DimOrganizationClass.CurrencyKey);
}
else
{
updateCommand.Parameters.AddWithValue("@OldCurrencyKey", DBNull.Value);
}
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_DimOrganizationClass clsdbo_DimOrganization)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string insertStatement
= "INSERT "
+ " [dbo].[DimOrganization] "
+ " ( "
+ " [ParentOrganizationKey] "
+ " ,[PercentageOfOwnership] "
+ " ,[OrganizationName] "
+ " ,[CurrencyKey] "
+ " ) "
+ "VALUES "
+ " ( "
+ " @ParentOrganizationKey "
+ " ,@PercentageOfOwnership "
+ " ,@OrganizationName "
+ " ,@CurrencyKey "
+ " ) "
+ "";
SqlCommand insertCommand = new SqlCommand(insertStatement, connection);
insertCommand.CommandType = CommandType.Text;
if (clsdbo_DimOrganization.ParentOrganizationKey.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@ParentOrganizationKey", clsdbo_DimOrganization.ParentOrganizationKey);
}
else
{
insertCommand.Parameters.AddWithValue("@ParentOrganizationKey", DBNull.Value);
}
if (clsdbo_DimOrganization.PercentageOfOwnership != null)
{
insertCommand.Parameters.AddWithValue("@PercentageOfOwnership", clsdbo_DimOrganization.PercentageOfOwnership);
}
else
{
insertCommand.Parameters.AddWithValue("@PercentageOfOwnership", DBNull.Value);
}
if (clsdbo_DimOrganization.OrganizationName != null)
{
insertCommand.Parameters.AddWithValue("@OrganizationName", clsdbo_DimOrganization.OrganizationName);
}
else
{
insertCommand.Parameters.AddWithValue("@OrganizationName", DBNull.Value);
}
if (clsdbo_DimOrganization.CurrencyKey.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@CurrencyKey", clsdbo_DimOrganization.CurrencyKey);
}
else
{
insertCommand.Parameters.AddWithValue("@CurrencyKey", DBNull.Value);
}
try
{
connection.Open();
int count = insertCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
private void UpdateRecord()
{
try {
TextBox txtOrganizationKey = (TextBox)grddbo_DimOrganization.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtOrganizationKey");
DropDownList txtParentOrganizationKey = (DropDownList)grddbo_DimOrganization.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtParentOrganizationKey");
TextBox txtPercentageOfOwnership = (TextBox)grddbo_DimOrganization.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtPercentageOfOwnership");
TextBox txtOrganizationName = (TextBox)grddbo_DimOrganization.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtOrganizationName");
DropDownList txtCurrencyKey = (DropDownList)grddbo_DimOrganization.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtCurrencyKey");
dbo_DimOrganizationClass oclsdbo_DimOrganization = new dbo_DimOrganizationClass();
dbo_DimOrganizationClass clsdbo_DimOrganization = new dbo_DimOrganizationClass();
oclsdbo_DimOrganization.OrganizationKey = System.Convert.ToInt32(txtOrganizationKey.Text);
oclsdbo_DimOrganization = dbo_DimOrganizationDataClass.Select_Record(oclsdbo_DimOrganization);
if (VerifyData() == true)
{
if (string.IsNullOrEmpty(txtParentOrganizationKey.SelectedValue))
{
clsdbo_DimOrganization.ParentOrganizationKey = null;
}
else
{
clsdbo_DimOrganization.ParentOrganizationKey = System.Convert.ToInt32(txtParentOrganizationKey.SelectedValue);
}
if (string.IsNullOrEmpty(txtPercentageOfOwnership.Text))
{
clsdbo_DimOrganization.PercentageOfOwnership = null;
}
else
{
clsdbo_DimOrganization.PercentageOfOwnership = txtPercentageOfOwnership.Text;
}
if (string.IsNullOrEmpty(txtOrganizationName.Text))
{
clsdbo_DimOrganization.OrganizationName = null;
}
else
{
clsdbo_DimOrganization.OrganizationName = txtOrganizationName.Text;
}
if (string.IsNullOrEmpty(txtCurrencyKey.SelectedValue))
{
clsdbo_DimOrganization.CurrencyKey = null;
}
else
{
clsdbo_DimOrganization.CurrencyKey = System.Convert.ToInt32(txtCurrencyKey.SelectedValue);
}
bool bSucess = false;
bSucess = dbo_DimOrganizationDataClass.Update(oclsdbo_DimOrganization, clsdbo_DimOrganization);
if (bSucess == true)
{
Session.Remove("dvdbo_DimOrganization");
grddbo_DimOrganization.EditIndex = -1;
LoadGriddbo_DimOrganization();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Dim Organization ");
}
}
} catch {
}
}
