private void UpdateRecord()
{
dbo_DimAccountClass oclsdbo_DimAccount = new dbo_DimAccountClass();
dbo_DimAccountClass clsdbo_DimAccount = new dbo_DimAccountClass();
oclsdbo_DimAccount.AccountKey = System.Convert.ToInt32(Session["AccountKey"]);
oclsdbo_DimAccount = dbo_DimAccountDataClass.Select_Record(oclsdbo_DimAccount);
if (VerifyData() == true)
{
SetData(clsdbo_DimAccount);
bool bSucess = false;
bSucess = dbo_DimAccountDataClass.Update(oclsdbo_DimAccount, clsdbo_DimAccount);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_DimAccount");
LoadGriddbo_DimAccount();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Dim Account ");
}
}
}
public static dbo_DimAccountClass Select_Record(dbo_DimAccountClass clsdbo_DimAccountPara)
{
dbo_DimAccountClass clsdbo_DimAccount = new dbo_DimAccountClass();
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string selectStatement
= "SELECT "
+ " [AccountKey] "
+ " ,[ParentAccountKey] "
+ " ,[AccountCodeAlternateKey] "
+ " ,[ParentAccountCodeAlternateKey] "
+ " ,[AccountDescription] "
+ " ,[AccountType] "
+ " ,[Operator] "
+ " ,[CustomMembers] "
+ " ,[ValueType] "
+ " ,[CustomMemberOptions] "
+ "FROM "
+ " [dbo].[DimAccount] "
+ "WHERE "
+ " [AccountKey] = @AccountKey "
+ "";
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
selectCommand.CommandType = CommandType.Text;
selectCommand.Parameters.AddWithValue("@AccountKey", clsdbo_DimAccountPara.AccountKey);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_DimAccount.AccountKey = System.Convert.ToInt32(reader["AccountKey"]);
clsdbo_DimAccount.ParentAccountKey = reader["ParentAccountKey"] is DBNull ? null : (Int32?)reader["ParentAccountKey"];
clsdbo_DimAccount.AccountCodeAlternateKey = reader["AccountCodeAlternateKey"] is DBNull ? null : (Int32?)reader["AccountCodeAlternateKey"];
clsdbo_DimAccount.ParentAccountCodeAlternateKey = reader["ParentAccountCodeAlternateKey"] is DBNull ? null : (Int32?)reader["ParentAccountCodeAlternateKey"];
clsdbo_DimAccount.AccountDescription = reader["AccountDescription"] is DBNull ? null : reader["AccountDescription"].ToString();
clsdbo_DimAccount.AccountType = reader["AccountType"] is DBNull ? null : reader["AccountType"].ToString();
clsdbo_DimAccount.Operator = reader["Operator"] is DBNull ? null : reader["Operator"].ToString();
clsdbo_DimAccount.CustomMembers = reader["CustomMembers"] is DBNull ? null : reader["CustomMembers"].ToString();
clsdbo_DimAccount.ValueType = reader["ValueType"] is DBNull ? null : reader["ValueType"].ToString();
clsdbo_DimAccount.CustomMemberOptions = reader["CustomMemberOptions"] is DBNull ? null : reader["CustomMemberOptions"].ToString();
}
else
{
clsdbo_DimAccount = null;
}
reader.Close();
}
catch (SqlException)
{
return(clsdbo_DimAccount);
}
finally
{
connection.Close();
}
return(clsdbo_DimAccount);
}
private void Edit()
{
try {
dbo_DimAccountClass clsdbo_DimAccount = new dbo_DimAccountClass();
Label lblAccountKey = (Label)grddbo_DimAccount.Rows[grddbo_DimAccount.EditIndex].FindControl("lblAccountKey");
clsdbo_DimAccount.AccountKey = System.Convert.ToInt32(lblAccountKey.Text);
clsdbo_DimAccount = dbo_DimAccountDataClass.Select_Record(clsdbo_DimAccount);
Session["ParentAccountKey_SelectedValue"] = clsdbo_DimAccount.ParentAccountKey;
LoadGriddbo_DimAccount();
} catch {
}
}
private void DeleteRecord()
{
dbo_DimAccountClass clsdbo_DimAccount = new dbo_DimAccountClass();
Label lblAccountKey = (Label)grddbo_DimAccount.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblAccountKey");
clsdbo_DimAccount.AccountKey = System.Convert.ToInt32(lblAccountKey.Text);
clsdbo_DimAccount = dbo_DimAccountDataClass.Select_Record(clsdbo_DimAccount);
bool bSucess = false;
bSucess = dbo_DimAccountDataClass.Delete(clsdbo_DimAccount);
if (bSucess == true)
{
Session.Remove("dvdbo_DimAccount");
LoadGriddbo_DimAccount();
}
else
{
ec.ShowMessage(" Delete failed. ", " Dbo. Dim Account ");
}
}
private void InsertRecord()
{
dbo_DimAccountClass clsdbo_DimAccount = new dbo_DimAccountClass();
if (VerifyData() == true)
{
SetData(clsdbo_DimAccount);
bool bSucess = false;
bSucess = dbo_DimAccountDataClass.Add(clsdbo_DimAccount);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_DimAccount");
LoadGriddbo_DimAccount();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Dim Account ");
}
}
}
private void SetData(dbo_DimAccountClass clsdbo_DimAccount)
{
if (string.IsNullOrEmpty(txtParentAccountKey.SelectedValue))
{
clsdbo_DimAccount.ParentAccountKey = null;
}
else
{
clsdbo_DimAccount.ParentAccountKey = System.Convert.ToInt32(txtParentAccountKey.SelectedValue);
}
if (string.IsNullOrEmpty(txtAccountCodeAlternateKey.Text))
{
clsdbo_DimAccount.AccountCodeAlternateKey = null;
}
else
{
clsdbo_DimAccount.AccountCodeAlternateKey = System.Convert.ToInt32(txtAccountCodeAlternateKey.Text);
}
if (string.IsNullOrEmpty(txtParentAccountCodeAlternateKey.Text))
{
clsdbo_DimAccount.ParentAccountCodeAlternateKey = null;
}
else
{
clsdbo_DimAccount.ParentAccountCodeAlternateKey = System.Convert.ToInt32(txtParentAccountCodeAlternateKey.Text);
}
if (string.IsNullOrEmpty(txtAccountDescription.Text))
{
clsdbo_DimAccount.AccountDescription = null;
}
else
{
clsdbo_DimAccount.AccountDescription = txtAccountDescription.Text;
}
if (string.IsNullOrEmpty(txtAccountType.Text))
{
clsdbo_DimAccount.AccountType = null;
}
else
{
clsdbo_DimAccount.AccountType = txtAccountType.Text;
}
if (string.IsNullOrEmpty(txtOperator.Text))
{
clsdbo_DimAccount.Operator = null;
}
else
{
clsdbo_DimAccount.Operator = txtOperator.Text;
}
if (string.IsNullOrEmpty(txtCustomMembers.Text))
{
clsdbo_DimAccount.CustomMembers = null;
}
else
{
clsdbo_DimAccount.CustomMembers = txtCustomMembers.Text;
}
if (string.IsNullOrEmpty(txtValueType.Text))
{
clsdbo_DimAccount.ValueType = null;
}
else
{
clsdbo_DimAccount.ValueType = txtValueType.Text;
}
if (string.IsNullOrEmpty(txtCustomMemberOptions.Text))
{
clsdbo_DimAccount.CustomMemberOptions = null;
}
else
{
clsdbo_DimAccount.CustomMemberOptions = txtCustomMemberOptions.Text;
}
}
private void GetData()
{
ClearRecord();
dbo_DimAccountClass clsdbo_DimAccount = new dbo_DimAccountClass();
clsdbo_DimAccount.AccountKey = System.Convert.ToInt32(Session["AccountKey"]);
clsdbo_DimAccount = dbo_DimAccountDataClass.Select_Record(clsdbo_DimAccount);
if ((clsdbo_DimAccount != null))
{
try {
txtAccountKey.Text = System.Convert.ToString(clsdbo_DimAccount.AccountKey);
if (clsdbo_DimAccount.ParentAccountKey == null)
{
txtParentAccountKey.SelectedValue = default(string);
}
else
{
txtParentAccountKey.SelectedValue = System.Convert.ToString(clsdbo_DimAccount.ParentAccountKey);
}
if (clsdbo_DimAccount.AccountCodeAlternateKey == null)
{
txtAccountCodeAlternateKey.Text = default(string);
}
else
{
txtAccountCodeAlternateKey.Text = System.Convert.ToString(clsdbo_DimAccount.AccountCodeAlternateKey);
}
if (clsdbo_DimAccount.ParentAccountCodeAlternateKey == null)
{
txtParentAccountCodeAlternateKey.Text = default(string);
}
else
{
txtParentAccountCodeAlternateKey.Text = System.Convert.ToString(clsdbo_DimAccount.ParentAccountCodeAlternateKey);
}
if (clsdbo_DimAccount.AccountDescription == null)
{
txtAccountDescription.Text = default(string);
}
else
{
txtAccountDescription.Text = System.Convert.ToString(clsdbo_DimAccount.AccountDescription);
}
if (clsdbo_DimAccount.AccountType == null)
{
txtAccountType.Text = default(string);
}
else
{
txtAccountType.Text = System.Convert.ToString(clsdbo_DimAccount.AccountType);
}
if (clsdbo_DimAccount.Operator == null)
{
txtOperator.Text = default(string);
}
else
{
txtOperator.Text = System.Convert.ToString(clsdbo_DimAccount.Operator);
}
if (clsdbo_DimAccount.CustomMembers == null)
{
txtCustomMembers.Text = default(string);
}
else
{
txtCustomMembers.Text = System.Convert.ToString(clsdbo_DimAccount.CustomMembers);
}
if (clsdbo_DimAccount.ValueType == null)
{
txtValueType.Text = default(string);
}
else
{
txtValueType.Text = System.Convert.ToString(clsdbo_DimAccount.ValueType);
}
if (clsdbo_DimAccount.CustomMemberOptions == null)
{
txtCustomMemberOptions.Text = default(string);
}
else
{
txtCustomMemberOptions.Text = System.Convert.ToString(clsdbo_DimAccount.CustomMemberOptions);
}
}
catch (Exception ex)
{
ec.ShowMessage(ex.Message, " Dbo. Dim Account ");
}
}
}
public static bool Delete(dbo_DimAccountClass clsdbo_DimAccount)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string deleteStatement
= "DELETE FROM "
+ " [dbo].[DimAccount] "
+ "WHERE "
+ " [AccountKey] = @OldAccountKey "
+ " AND ((@OldParentAccountKey IS NULL AND [ParentAccountKey] IS NULL) OR [ParentAccountKey] = @OldParentAccountKey) "
+ " AND ((@OldAccountCodeAlternateKey IS NULL AND [AccountCodeAlternateKey] IS NULL) OR [AccountCodeAlternateKey] = @OldAccountCodeAlternateKey) "
+ " AND ((@OldParentAccountCodeAlternateKey IS NULL AND [ParentAccountCodeAlternateKey] IS NULL) OR [ParentAccountCodeAlternateKey] = @OldParentAccountCodeAlternateKey) "
+ " AND ((@OldAccountDescription IS NULL AND [AccountDescription] IS NULL) OR [AccountDescription] = @OldAccountDescription) "
+ " AND ((@OldAccountType IS NULL AND [AccountType] IS NULL) OR [AccountType] = @OldAccountType) "
+ " AND ((@OldOperator IS NULL AND [Operator] IS NULL) OR [Operator] = @OldOperator) "
+ " AND ((@OldCustomMembers IS NULL AND [CustomMembers] IS NULL) OR [CustomMembers] = @OldCustomMembers) "
+ " AND ((@OldValueType IS NULL AND [ValueType] IS NULL) OR [ValueType] = @OldValueType) "
+ " AND ((@OldCustomMemberOptions IS NULL AND [CustomMemberOptions] IS NULL) OR [CustomMemberOptions] = @OldCustomMemberOptions) "
+ "";
SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection);
deleteCommand.CommandType = CommandType.Text;
deleteCommand.Parameters.AddWithValue("@OldAccountKey", clsdbo_DimAccount.AccountKey);
if (clsdbo_DimAccount.ParentAccountKey.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldParentAccountKey", clsdbo_DimAccount.ParentAccountKey);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldParentAccountKey", DBNull.Value);
}
if (clsdbo_DimAccount.AccountCodeAlternateKey.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldAccountCodeAlternateKey", clsdbo_DimAccount.AccountCodeAlternateKey);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldAccountCodeAlternateKey", DBNull.Value);
}
if (clsdbo_DimAccount.ParentAccountCodeAlternateKey.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldParentAccountCodeAlternateKey", clsdbo_DimAccount.ParentAccountCodeAlternateKey);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldParentAccountCodeAlternateKey", DBNull.Value);
}
if (clsdbo_DimAccount.AccountDescription != null)
{
deleteCommand.Parameters.AddWithValue("@OldAccountDescription", clsdbo_DimAccount.AccountDescription);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldAccountDescription", DBNull.Value);
}
if (clsdbo_DimAccount.AccountType != null)
{
deleteCommand.Parameters.AddWithValue("@OldAccountType", clsdbo_DimAccount.AccountType);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldAccountType", DBNull.Value);
}
if (clsdbo_DimAccount.Operator != null)
{
deleteCommand.Parameters.AddWithValue("@OldOperator", clsdbo_DimAccount.Operator);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldOperator", DBNull.Value);
}
if (clsdbo_DimAccount.CustomMembers != null)
{
deleteCommand.Parameters.AddWithValue("@OldCustomMembers", clsdbo_DimAccount.CustomMembers);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldCustomMembers", DBNull.Value);
}
if (clsdbo_DimAccount.ValueType != null)
{
deleteCommand.Parameters.AddWithValue("@OldValueType", clsdbo_DimAccount.ValueType);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldValueType", DBNull.Value);
}
if (clsdbo_DimAccount.CustomMemberOptions != null)
{
deleteCommand.Parameters.AddWithValue("@OldCustomMemberOptions", clsdbo_DimAccount.CustomMemberOptions);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldCustomMemberOptions", 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_DimAccountClass olddbo_DimAccountClass,
dbo_DimAccountClass newdbo_DimAccountClass)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string updateStatement
= "UPDATE "
+ " [dbo].[DimAccount] "
+ "SET "
+ " [ParentAccountKey] = @NewParentAccountKey "
+ " ,[AccountCodeAlternateKey] = @NewAccountCodeAlternateKey "
+ " ,[ParentAccountCodeAlternateKey] = @NewParentAccountCodeAlternateKey "
+ " ,[AccountDescription] = @NewAccountDescription "
+ " ,[AccountType] = @NewAccountType "
+ " ,[Operator] = @NewOperator "
+ " ,[CustomMembers] = @NewCustomMembers "
+ " ,[ValueType] = @NewValueType "
+ " ,[CustomMemberOptions] = @NewCustomMemberOptions "
+ "WHERE "
+ " [AccountKey] = @OldAccountKey "
+ " AND ((@OldParentAccountKey IS NULL AND [ParentAccountKey] IS NULL) OR [ParentAccountKey] = @OldParentAccountKey) "
+ " AND ((@OldAccountCodeAlternateKey IS NULL AND [AccountCodeAlternateKey] IS NULL) OR [AccountCodeAlternateKey] = @OldAccountCodeAlternateKey) "
+ " AND ((@OldParentAccountCodeAlternateKey IS NULL AND [ParentAccountCodeAlternateKey] IS NULL) OR [ParentAccountCodeAlternateKey] = @OldParentAccountCodeAlternateKey) "
+ " AND ((@OldAccountDescription IS NULL AND [AccountDescription] IS NULL) OR [AccountDescription] = @OldAccountDescription) "
+ " AND ((@OldAccountType IS NULL AND [AccountType] IS NULL) OR [AccountType] = @OldAccountType) "
+ " AND ((@OldOperator IS NULL AND [Operator] IS NULL) OR [Operator] = @OldOperator) "
+ " AND ((@OldCustomMembers IS NULL AND [CustomMembers] IS NULL) OR [CustomMembers] = @OldCustomMembers) "
+ " AND ((@OldValueType IS NULL AND [ValueType] IS NULL) OR [ValueType] = @OldValueType) "
+ " AND ((@OldCustomMemberOptions IS NULL AND [CustomMemberOptions] IS NULL) OR [CustomMemberOptions] = @OldCustomMemberOptions) "
+ "";
SqlCommand updateCommand = new SqlCommand(updateStatement, connection);
updateCommand.CommandType = CommandType.Text;
if (newdbo_DimAccountClass.ParentAccountKey.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewParentAccountKey", newdbo_DimAccountClass.ParentAccountKey);
}
else
{
updateCommand.Parameters.AddWithValue("@NewParentAccountKey", DBNull.Value);
}
if (newdbo_DimAccountClass.AccountCodeAlternateKey.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewAccountCodeAlternateKey", newdbo_DimAccountClass.AccountCodeAlternateKey);
}
else
{
updateCommand.Parameters.AddWithValue("@NewAccountCodeAlternateKey", DBNull.Value);
}
if (newdbo_DimAccountClass.ParentAccountCodeAlternateKey.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewParentAccountCodeAlternateKey", newdbo_DimAccountClass.ParentAccountCodeAlternateKey);
}
else
{
updateCommand.Parameters.AddWithValue("@NewParentAccountCodeAlternateKey", DBNull.Value);
}
if (newdbo_DimAccountClass.AccountDescription != null)
{
updateCommand.Parameters.AddWithValue("@NewAccountDescription", newdbo_DimAccountClass.AccountDescription);
}
else
{
updateCommand.Parameters.AddWithValue("@NewAccountDescription", DBNull.Value);
}
if (newdbo_DimAccountClass.AccountType != null)
{
updateCommand.Parameters.AddWithValue("@NewAccountType", newdbo_DimAccountClass.AccountType);
}
else
{
updateCommand.Parameters.AddWithValue("@NewAccountType", DBNull.Value);
}
if (newdbo_DimAccountClass.Operator != null)
{
updateCommand.Parameters.AddWithValue("@NewOperator", newdbo_DimAccountClass.Operator);
}
else
{
updateCommand.Parameters.AddWithValue("@NewOperator", DBNull.Value);
}
if (newdbo_DimAccountClass.CustomMembers != null)
{
updateCommand.Parameters.AddWithValue("@NewCustomMembers", newdbo_DimAccountClass.CustomMembers);
}
else
{
updateCommand.Parameters.AddWithValue("@NewCustomMembers", DBNull.Value);
}
if (newdbo_DimAccountClass.ValueType != null)
{
updateCommand.Parameters.AddWithValue("@NewValueType", newdbo_DimAccountClass.ValueType);
}
else
{
updateCommand.Parameters.AddWithValue("@NewValueType", DBNull.Value);
}
if (newdbo_DimAccountClass.CustomMemberOptions != null)
{
updateCommand.Parameters.AddWithValue("@NewCustomMemberOptions", newdbo_DimAccountClass.CustomMemberOptions);
}
else
{
updateCommand.Parameters.AddWithValue("@NewCustomMemberOptions", DBNull.Value);
}
updateCommand.Parameters.AddWithValue("@OldAccountKey", olddbo_DimAccountClass.AccountKey);
if (olddbo_DimAccountClass.ParentAccountKey.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@OldParentAccountKey", olddbo_DimAccountClass.ParentAccountKey);
}
else
{
updateCommand.Parameters.AddWithValue("@OldParentAccountKey", DBNull.Value);
}
if (olddbo_DimAccountClass.AccountCodeAlternateKey.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@OldAccountCodeAlternateKey", olddbo_DimAccountClass.AccountCodeAlternateKey);
}
else
{
updateCommand.Parameters.AddWithValue("@OldAccountCodeAlternateKey", DBNull.Value);
}
if (olddbo_DimAccountClass.ParentAccountCodeAlternateKey.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@OldParentAccountCodeAlternateKey", olddbo_DimAccountClass.ParentAccountCodeAlternateKey);
}
else
{
updateCommand.Parameters.AddWithValue("@OldParentAccountCodeAlternateKey", DBNull.Value);
}
if (olddbo_DimAccountClass.AccountDescription != null)
{
updateCommand.Parameters.AddWithValue("@OldAccountDescription", olddbo_DimAccountClass.AccountDescription);
}
else
{
updateCommand.Parameters.AddWithValue("@OldAccountDescription", DBNull.Value);
}
if (olddbo_DimAccountClass.AccountType != null)
{
updateCommand.Parameters.AddWithValue("@OldAccountType", olddbo_DimAccountClass.AccountType);
}
else
{
updateCommand.Parameters.AddWithValue("@OldAccountType", DBNull.Value);
}
if (olddbo_DimAccountClass.Operator != null)
{
updateCommand.Parameters.AddWithValue("@OldOperator", olddbo_DimAccountClass.Operator);
}
else
{
updateCommand.Parameters.AddWithValue("@OldOperator", DBNull.Value);
}
if (olddbo_DimAccountClass.CustomMembers != null)
{
updateCommand.Parameters.AddWithValue("@OldCustomMembers", olddbo_DimAccountClass.CustomMembers);
}
else
{
updateCommand.Parameters.AddWithValue("@OldCustomMembers", DBNull.Value);
}
if (olddbo_DimAccountClass.ValueType != null)
{
updateCommand.Parameters.AddWithValue("@OldValueType", olddbo_DimAccountClass.ValueType);
}
else
{
updateCommand.Parameters.AddWithValue("@OldValueType", DBNull.Value);
}
if (olddbo_DimAccountClass.CustomMemberOptions != null)
{
updateCommand.Parameters.AddWithValue("@OldCustomMemberOptions", olddbo_DimAccountClass.CustomMemberOptions);
}
else
{
updateCommand.Parameters.AddWithValue("@OldCustomMemberOptions", 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_DimAccountClass clsdbo_DimAccount)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string insertStatement
= "INSERT "
+ " [dbo].[DimAccount] "
+ " ( "
+ " [ParentAccountKey] "
+ " ,[AccountCodeAlternateKey] "
+ " ,[ParentAccountCodeAlternateKey] "
+ " ,[AccountDescription] "
+ " ,[AccountType] "
+ " ,[Operator] "
+ " ,[CustomMembers] "
+ " ,[ValueType] "
+ " ,[CustomMemberOptions] "
+ " ) "
+ "VALUES "
+ " ( "
+ " @ParentAccountKey "
+ " ,@AccountCodeAlternateKey "
+ " ,@ParentAccountCodeAlternateKey "
+ " ,@AccountDescription "
+ " ,@AccountType "
+ " ,@Operator "
+ " ,@CustomMembers "
+ " ,@ValueType "
+ " ,@CustomMemberOptions "
+ " ) "
+ "";
SqlCommand insertCommand = new SqlCommand(insertStatement, connection);
insertCommand.CommandType = CommandType.Text;
if (clsdbo_DimAccount.ParentAccountKey.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@ParentAccountKey", clsdbo_DimAccount.ParentAccountKey);
}
else
{
insertCommand.Parameters.AddWithValue("@ParentAccountKey", DBNull.Value);
}
if (clsdbo_DimAccount.AccountCodeAlternateKey.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@AccountCodeAlternateKey", clsdbo_DimAccount.AccountCodeAlternateKey);
}
else
{
insertCommand.Parameters.AddWithValue("@AccountCodeAlternateKey", DBNull.Value);
}
if (clsdbo_DimAccount.ParentAccountCodeAlternateKey.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@ParentAccountCodeAlternateKey", clsdbo_DimAccount.ParentAccountCodeAlternateKey);
}
else
{
insertCommand.Parameters.AddWithValue("@ParentAccountCodeAlternateKey", DBNull.Value);
}
if (clsdbo_DimAccount.AccountDescription != null)
{
insertCommand.Parameters.AddWithValue("@AccountDescription", clsdbo_DimAccount.AccountDescription);
}
else
{
insertCommand.Parameters.AddWithValue("@AccountDescription", DBNull.Value);
}
if (clsdbo_DimAccount.AccountType != null)
{
insertCommand.Parameters.AddWithValue("@AccountType", clsdbo_DimAccount.AccountType);
}
else
{
insertCommand.Parameters.AddWithValue("@AccountType", DBNull.Value);
}
if (clsdbo_DimAccount.Operator != null)
{
insertCommand.Parameters.AddWithValue("@Operator", clsdbo_DimAccount.Operator);
}
else
{
insertCommand.Parameters.AddWithValue("@Operator", DBNull.Value);
}
if (clsdbo_DimAccount.CustomMembers != null)
{
insertCommand.Parameters.AddWithValue("@CustomMembers", clsdbo_DimAccount.CustomMembers);
}
else
{
insertCommand.Parameters.AddWithValue("@CustomMembers", DBNull.Value);
}
if (clsdbo_DimAccount.ValueType != null)
{
insertCommand.Parameters.AddWithValue("@ValueType", clsdbo_DimAccount.ValueType);
}
else
{
insertCommand.Parameters.AddWithValue("@ValueType", DBNull.Value);
}
if (clsdbo_DimAccount.CustomMemberOptions != null)
{
insertCommand.Parameters.AddWithValue("@CustomMemberOptions", clsdbo_DimAccount.CustomMemberOptions);
}
else
{
insertCommand.Parameters.AddWithValue("@CustomMemberOptions", 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 txtAccountKey = (TextBox)grddbo_DimAccount.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtAccountKey");
DropDownList txtParentAccountKey = (DropDownList)grddbo_DimAccount.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtParentAccountKey");
TextBox txtAccountCodeAlternateKey = (TextBox)grddbo_DimAccount.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtAccountCodeAlternateKey");
TextBox txtParentAccountCodeAlternateKey = (TextBox)grddbo_DimAccount.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtParentAccountCodeAlternateKey");
TextBox txtAccountDescription = (TextBox)grddbo_DimAccount.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtAccountDescription");
TextBox txtAccountType = (TextBox)grddbo_DimAccount.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtAccountType");
TextBox txtOperator = (TextBox)grddbo_DimAccount.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtOperator");
TextBox txtCustomMembers = (TextBox)grddbo_DimAccount.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtCustomMembers");
TextBox txtValueType = (TextBox)grddbo_DimAccount.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtValueType");
TextBox txtCustomMemberOptions = (TextBox)grddbo_DimAccount.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtCustomMemberOptions");
dbo_DimAccountClass oclsdbo_DimAccount = new dbo_DimAccountClass();
dbo_DimAccountClass clsdbo_DimAccount = new dbo_DimAccountClass();
oclsdbo_DimAccount.AccountKey = System.Convert.ToInt32(txtAccountKey.Text);
oclsdbo_DimAccount = dbo_DimAccountDataClass.Select_Record(oclsdbo_DimAccount);
if (VerifyData() == true)
{
if (string.IsNullOrEmpty(txtParentAccountKey.SelectedValue))
{
clsdbo_DimAccount.ParentAccountKey = null;
}
else
{
clsdbo_DimAccount.ParentAccountKey = System.Convert.ToInt32(txtParentAccountKey.SelectedValue);
}
if (string.IsNullOrEmpty(txtAccountCodeAlternateKey.Text))
{
clsdbo_DimAccount.AccountCodeAlternateKey = null;
}
else
{
clsdbo_DimAccount.AccountCodeAlternateKey = System.Convert.ToInt32(txtAccountCodeAlternateKey.Text);
}
if (string.IsNullOrEmpty(txtParentAccountCodeAlternateKey.Text))
{
clsdbo_DimAccount.ParentAccountCodeAlternateKey = null;
}
else
{
clsdbo_DimAccount.ParentAccountCodeAlternateKey = System.Convert.ToInt32(txtParentAccountCodeAlternateKey.Text);
}
if (string.IsNullOrEmpty(txtAccountDescription.Text))
{
clsdbo_DimAccount.AccountDescription = null;
}
else
{
clsdbo_DimAccount.AccountDescription = txtAccountDescription.Text;
}
if (string.IsNullOrEmpty(txtAccountType.Text))
{
clsdbo_DimAccount.AccountType = null;
}
else
{
clsdbo_DimAccount.AccountType = txtAccountType.Text;
}
if (string.IsNullOrEmpty(txtOperator.Text))
{
clsdbo_DimAccount.Operator = null;
}
else
{
clsdbo_DimAccount.Operator = txtOperator.Text;
}
if (string.IsNullOrEmpty(txtCustomMembers.Text))
{
clsdbo_DimAccount.CustomMembers = null;
}
else
{
clsdbo_DimAccount.CustomMembers = txtCustomMembers.Text;
}
if (string.IsNullOrEmpty(txtValueType.Text))
{
clsdbo_DimAccount.ValueType = null;
}
else
{
clsdbo_DimAccount.ValueType = txtValueType.Text;
}
if (string.IsNullOrEmpty(txtCustomMemberOptions.Text))
{
clsdbo_DimAccount.CustomMemberOptions = null;
}
else
{
clsdbo_DimAccount.CustomMemberOptions = txtCustomMemberOptions.Text;
}
bool bSucess = false;
bSucess = dbo_DimAccountDataClass.Update(oclsdbo_DimAccount, clsdbo_DimAccount);
if (bSucess == true)
{
Session.Remove("dvdbo_DimAccount");
grddbo_DimAccount.EditIndex = -1;
LoadGriddbo_DimAccount();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Dim Account ");
}
}
} catch {
}
}
private void InsertRecord()
{
try {
DropDownList txtNewParentAccountKey = (DropDownList)grddbo_DimAccount.FooterRow.FindControl("txtNewParentAccountKey");
TextBox txtNewAccountCodeAlternateKey = (TextBox)grddbo_DimAccount.FooterRow.FindControl("txtNewAccountCodeAlternateKey");
TextBox txtNewParentAccountCodeAlternateKey = (TextBox)grddbo_DimAccount.FooterRow.FindControl("txtNewParentAccountCodeAlternateKey");
TextBox txtNewAccountDescription = (TextBox)grddbo_DimAccount.FooterRow.FindControl("txtNewAccountDescription");
TextBox txtNewAccountType = (TextBox)grddbo_DimAccount.FooterRow.FindControl("txtNewAccountType");
TextBox txtNewOperator = (TextBox)grddbo_DimAccount.FooterRow.FindControl("txtNewOperator");
TextBox txtNewCustomMembers = (TextBox)grddbo_DimAccount.FooterRow.FindControl("txtNewCustomMembers");
TextBox txtNewValueType = (TextBox)grddbo_DimAccount.FooterRow.FindControl("txtNewValueType");
TextBox txtNewCustomMemberOptions = (TextBox)grddbo_DimAccount.FooterRow.FindControl("txtNewCustomMemberOptions");
dbo_DimAccountClass clsdbo_DimAccount = new dbo_DimAccountClass();
if (VerifyDataNew() == true)
{
if (string.IsNullOrEmpty(txtNewParentAccountKey.SelectedValue))
{
clsdbo_DimAccount.ParentAccountKey = null;
}
else
{
clsdbo_DimAccount.ParentAccountKey = System.Convert.ToInt32(txtNewParentAccountKey.SelectedValue);
}
if (string.IsNullOrEmpty(txtNewAccountCodeAlternateKey.Text))
{
clsdbo_DimAccount.AccountCodeAlternateKey = null;
}
else
{
clsdbo_DimAccount.AccountCodeAlternateKey = System.Convert.ToInt32(txtNewAccountCodeAlternateKey.Text);
}
if (string.IsNullOrEmpty(txtNewParentAccountCodeAlternateKey.Text))
{
clsdbo_DimAccount.ParentAccountCodeAlternateKey = null;
}
else
{
clsdbo_DimAccount.ParentAccountCodeAlternateKey = System.Convert.ToInt32(txtNewParentAccountCodeAlternateKey.Text);
}
if (string.IsNullOrEmpty(txtNewAccountDescription.Text))
{
clsdbo_DimAccount.AccountDescription = null;
}
else
{
clsdbo_DimAccount.AccountDescription = txtNewAccountDescription.Text;
}
if (string.IsNullOrEmpty(txtNewAccountType.Text))
{
clsdbo_DimAccount.AccountType = null;
}
else
{
clsdbo_DimAccount.AccountType = txtNewAccountType.Text;
}
if (string.IsNullOrEmpty(txtNewOperator.Text))
{
clsdbo_DimAccount.Operator = null;
}
else
{
clsdbo_DimAccount.Operator = txtNewOperator.Text;
}
if (string.IsNullOrEmpty(txtNewCustomMembers.Text))
{
clsdbo_DimAccount.CustomMembers = null;
}
else
{
clsdbo_DimAccount.CustomMembers = txtNewCustomMembers.Text;
}
if (string.IsNullOrEmpty(txtNewValueType.Text))
{
clsdbo_DimAccount.ValueType = null;
}
else
{
clsdbo_DimAccount.ValueType = txtNewValueType.Text;
}
if (string.IsNullOrEmpty(txtNewCustomMemberOptions.Text))
{
clsdbo_DimAccount.CustomMemberOptions = null;
}
else
{
clsdbo_DimAccount.CustomMemberOptions = txtNewCustomMemberOptions.Text;
}
bool bSucess = false;
bSucess = dbo_DimAccountDataClass.Add(clsdbo_DimAccount);
if (bSucess == true)
{
Session.Remove("dvdbo_DimAccount");
LoadGriddbo_DimAccount();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Dim Account ");
}
}
} catch {
}
}
