private void UpdateRecord()
{
dbo_FactSurveyResponseClass oclsdbo_FactSurveyResponse = new dbo_FactSurveyResponseClass();
dbo_FactSurveyResponseClass clsdbo_FactSurveyResponse = new dbo_FactSurveyResponseClass();
oclsdbo_FactSurveyResponse.SurveyResponseKey = System.Convert.ToInt32(Session["SurveyResponseKey"]);
oclsdbo_FactSurveyResponse = dbo_FactSurveyResponseDataClass.Select_Record(oclsdbo_FactSurveyResponse);
if (VerifyData() == true)
{
SetData(clsdbo_FactSurveyResponse);
bool bSucess = false;
bSucess = dbo_FactSurveyResponseDataClass.Update(oclsdbo_FactSurveyResponse, clsdbo_FactSurveyResponse);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_FactSurveyResponse");
LoadGriddbo_FactSurveyResponse();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Fact Survey Response ");
}
}
}
private void GetData()
{
ClearRecord();
dbo_FactSurveyResponseClass clsdbo_FactSurveyResponse = new dbo_FactSurveyResponseClass();
clsdbo_FactSurveyResponse.SurveyResponseKey = System.Convert.ToInt32(Session["SurveyResponseKey"]);
clsdbo_FactSurveyResponse = dbo_FactSurveyResponseDataClass.Select_Record(clsdbo_FactSurveyResponse);
if ((clsdbo_FactSurveyResponse != null))
{
try {
txtSurveyResponseKey.Text = System.Convert.ToString(clsdbo_FactSurveyResponse.SurveyResponseKey);
txtDateKey.SelectedValue = System.Convert.ToString(clsdbo_FactSurveyResponse.DateKey);
txtCustomerKey.SelectedValue = System.Convert.ToString(clsdbo_FactSurveyResponse.CustomerKey);
txtProductCategoryKey.Text = System.Convert.ToString(clsdbo_FactSurveyResponse.ProductCategoryKey);
txtEnglishProductCategoryName.Text = System.Convert.ToString(clsdbo_FactSurveyResponse.EnglishProductCategoryName);
txtProductSubcategoryKey.Text = System.Convert.ToString(clsdbo_FactSurveyResponse.ProductSubcategoryKey);
txtEnglishProductSubcategoryName.Text = System.Convert.ToString(clsdbo_FactSurveyResponse.EnglishProductSubcategoryName);
if (clsdbo_FactSurveyResponse.Date == null)
{
txtDate.Text = DateTime.Now.ToString();
}
else
{
txtDate.Text = System.Convert.ToDateTime(clsdbo_FactSurveyResponse.Date).ToShortDateString();
}
}
catch (Exception ex)
{
ec.ShowMessage(ex.Message, " Dbo. Fact Survey Response ");
}
}
}
public static bool Delete(dbo_FactSurveyResponseClass clsdbo_FactSurveyResponse)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string deleteStatement
= "DELETE FROM "
+ " [dbo].[FactSurveyResponse] "
+ "WHERE "
+ " [SurveyResponseKey] = @OldSurveyResponseKey "
+ " AND [DateKey] = @OldDateKey "
+ " AND [CustomerKey] = @OldCustomerKey "
+ " AND [ProductCategoryKey] = @OldProductCategoryKey "
+ " AND [EnglishProductCategoryName] = @OldEnglishProductCategoryName "
+ " AND [ProductSubcategoryKey] = @OldProductSubcategoryKey "
+ " AND [EnglishProductSubcategoryName] = @OldEnglishProductSubcategoryName "
+ " AND ((@OldDate IS NULL AND [Date] IS NULL) OR [Date] = @OldDate) "
+ "";
SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection);
deleteCommand.CommandType = CommandType.Text;
deleteCommand.Parameters.AddWithValue("@OldSurveyResponseKey", clsdbo_FactSurveyResponse.SurveyResponseKey);
deleteCommand.Parameters.AddWithValue("@OldDateKey", clsdbo_FactSurveyResponse.DateKey);
deleteCommand.Parameters.AddWithValue("@OldCustomerKey", clsdbo_FactSurveyResponse.CustomerKey);
deleteCommand.Parameters.AddWithValue("@OldProductCategoryKey", clsdbo_FactSurveyResponse.ProductCategoryKey);
deleteCommand.Parameters.AddWithValue("@OldEnglishProductCategoryName", clsdbo_FactSurveyResponse.EnglishProductCategoryName);
deleteCommand.Parameters.AddWithValue("@OldProductSubcategoryKey", clsdbo_FactSurveyResponse.ProductSubcategoryKey);
deleteCommand.Parameters.AddWithValue("@OldEnglishProductSubcategoryName", clsdbo_FactSurveyResponse.EnglishProductSubcategoryName);
if (clsdbo_FactSurveyResponse.Date.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldDate", clsdbo_FactSurveyResponse.Date);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldDate", 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 dbo_FactSurveyResponseClass Select_Record(dbo_FactSurveyResponseClass clsdbo_FactSurveyResponsePara)
{
dbo_FactSurveyResponseClass clsdbo_FactSurveyResponse = new dbo_FactSurveyResponseClass();
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string selectStatement
= "SELECT "
+ " [SurveyResponseKey] "
+ " ,[DateKey] "
+ " ,[CustomerKey] "
+ " ,[ProductCategoryKey] "
+ " ,[EnglishProductCategoryName] "
+ " ,[ProductSubcategoryKey] "
+ " ,[EnglishProductSubcategoryName] "
+ " ,[Date] "
+ "FROM "
+ " [dbo].[FactSurveyResponse] "
+ "WHERE "
+ " [SurveyResponseKey] = @SurveyResponseKey "
+ "";
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
selectCommand.CommandType = CommandType.Text;
selectCommand.Parameters.AddWithValue("@SurveyResponseKey", clsdbo_FactSurveyResponsePara.SurveyResponseKey);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_FactSurveyResponse.SurveyResponseKey = System.Convert.ToInt32(reader["SurveyResponseKey"]);
clsdbo_FactSurveyResponse.DateKey = System.Convert.ToInt32(reader["DateKey"]);
clsdbo_FactSurveyResponse.CustomerKey = System.Convert.ToInt32(reader["CustomerKey"]);
clsdbo_FactSurveyResponse.ProductCategoryKey = System.Convert.ToInt32(reader["ProductCategoryKey"]);
clsdbo_FactSurveyResponse.EnglishProductCategoryName = System.Convert.ToString(reader["EnglishProductCategoryName"]);
clsdbo_FactSurveyResponse.ProductSubcategoryKey = System.Convert.ToInt32(reader["ProductSubcategoryKey"]);
clsdbo_FactSurveyResponse.EnglishProductSubcategoryName = System.Convert.ToString(reader["EnglishProductSubcategoryName"]);
clsdbo_FactSurveyResponse.Date = reader["Date"] is DBNull ? null : (DateTime?)reader["Date"];
}
else
{
clsdbo_FactSurveyResponse = null;
}
reader.Close();
}
catch (SqlException)
{
return(clsdbo_FactSurveyResponse);
}
finally
{
connection.Close();
}
return(clsdbo_FactSurveyResponse);
}
private void UpdateRecord()
{
try {
TextBox txtSurveyResponseKey = (TextBox)grddbo_FactSurveyResponse.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSurveyResponseKey");
DropDownList txtDateKey = (DropDownList)grddbo_FactSurveyResponse.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtDateKey");
DropDownList txtCustomerKey = (DropDownList)grddbo_FactSurveyResponse.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtCustomerKey");
TextBox txtProductCategoryKey = (TextBox)grddbo_FactSurveyResponse.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtProductCategoryKey");
TextBox txtEnglishProductCategoryName = (TextBox)grddbo_FactSurveyResponse.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtEnglishProductCategoryName");
TextBox txtProductSubcategoryKey = (TextBox)grddbo_FactSurveyResponse.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtProductSubcategoryKey");
TextBox txtEnglishProductSubcategoryName = (TextBox)grddbo_FactSurveyResponse.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtEnglishProductSubcategoryName");
TextBox txtDate = (TextBox)grddbo_FactSurveyResponse.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtDate");
dbo_FactSurveyResponseClass oclsdbo_FactSurveyResponse = new dbo_FactSurveyResponseClass();
dbo_FactSurveyResponseClass clsdbo_FactSurveyResponse = new dbo_FactSurveyResponseClass();
oclsdbo_FactSurveyResponse.SurveyResponseKey = System.Convert.ToInt32(txtSurveyResponseKey.Text);
oclsdbo_FactSurveyResponse = dbo_FactSurveyResponseDataClass.Select_Record(oclsdbo_FactSurveyResponse);
if (VerifyData() == true)
{
clsdbo_FactSurveyResponse.DateKey = System.Convert.ToInt32(txtDateKey.SelectedValue);
clsdbo_FactSurveyResponse.CustomerKey = System.Convert.ToInt32(txtCustomerKey.SelectedValue);
clsdbo_FactSurveyResponse.ProductCategoryKey = System.Convert.ToInt32(txtProductCategoryKey.Text);
clsdbo_FactSurveyResponse.EnglishProductCategoryName = System.Convert.ToString(txtEnglishProductCategoryName.Text);
clsdbo_FactSurveyResponse.ProductSubcategoryKey = System.Convert.ToInt32(txtProductSubcategoryKey.Text);
clsdbo_FactSurveyResponse.EnglishProductSubcategoryName = System.Convert.ToString(txtEnglishProductSubcategoryName.Text);
if (string.IsNullOrEmpty(txtDate.Text))
{
clsdbo_FactSurveyResponse.Date = null;
}
else
{
clsdbo_FactSurveyResponse.Date = System.Convert.ToDateTime(txtDate.Text);
}
bool bSucess = false;
bSucess = dbo_FactSurveyResponseDataClass.Update(oclsdbo_FactSurveyResponse, clsdbo_FactSurveyResponse);
if (bSucess == true)
{
Session.Remove("dvdbo_FactSurveyResponse");
grddbo_FactSurveyResponse.EditIndex = -1;
LoadGriddbo_FactSurveyResponse();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Fact Survey Response ");
}
}
} catch {
}
}
private void Edit()
{
try {
dbo_FactSurveyResponseClass clsdbo_FactSurveyResponse = new dbo_FactSurveyResponseClass();
Label lblSurveyResponseKey = (Label)grddbo_FactSurveyResponse.Rows[grddbo_FactSurveyResponse.EditIndex].FindControl("lblSurveyResponseKey");
clsdbo_FactSurveyResponse.SurveyResponseKey = System.Convert.ToInt32(lblSurveyResponseKey.Text);
clsdbo_FactSurveyResponse = dbo_FactSurveyResponseDataClass.Select_Record(clsdbo_FactSurveyResponse);
Session["DateKey_SelectedValue"] = clsdbo_FactSurveyResponse.DateKey;
Session["CustomerKey_SelectedValue"] = clsdbo_FactSurveyResponse.CustomerKey;
LoadGriddbo_FactSurveyResponse();
} catch {
}
}
private void SetData(dbo_FactSurveyResponseClass clsdbo_FactSurveyResponse)
{
clsdbo_FactSurveyResponse.DateKey = System.Convert.ToInt32(txtDateKey.SelectedValue);
clsdbo_FactSurveyResponse.CustomerKey = System.Convert.ToInt32(txtCustomerKey.SelectedValue);
clsdbo_FactSurveyResponse.ProductCategoryKey = System.Convert.ToInt32(txtProductCategoryKey.Text);
clsdbo_FactSurveyResponse.EnglishProductCategoryName = System.Convert.ToString(txtEnglishProductCategoryName.Text);
clsdbo_FactSurveyResponse.ProductSubcategoryKey = System.Convert.ToInt32(txtProductSubcategoryKey.Text);
clsdbo_FactSurveyResponse.EnglishProductSubcategoryName = System.Convert.ToString(txtEnglishProductSubcategoryName.Text);
if (string.IsNullOrEmpty(txtDate.Text))
{
clsdbo_FactSurveyResponse.Date = null;
}
else
{
clsdbo_FactSurveyResponse.Date = System.Convert.ToDateTime(txtDate.Text);
}
}
private void InsertRecord()
{
try {
DropDownList txtNewDateKey = (DropDownList)grddbo_FactSurveyResponse.FooterRow.FindControl("txtNewDateKey");
DropDownList txtNewCustomerKey = (DropDownList)grddbo_FactSurveyResponse.FooterRow.FindControl("txtNewCustomerKey");
TextBox txtNewProductCategoryKey = (TextBox)grddbo_FactSurveyResponse.FooterRow.FindControl("txtNewProductCategoryKey");
TextBox txtNewEnglishProductCategoryName = (TextBox)grddbo_FactSurveyResponse.FooterRow.FindControl("txtNewEnglishProductCategoryName");
TextBox txtNewProductSubcategoryKey = (TextBox)grddbo_FactSurveyResponse.FooterRow.FindControl("txtNewProductSubcategoryKey");
TextBox txtNewEnglishProductSubcategoryName = (TextBox)grddbo_FactSurveyResponse.FooterRow.FindControl("txtNewEnglishProductSubcategoryName");
TextBox txtNewDate = (TextBox)grddbo_FactSurveyResponse.FooterRow.FindControl("txtNewDate");
dbo_FactSurveyResponseClass clsdbo_FactSurveyResponse = new dbo_FactSurveyResponseClass();
if (VerifyDataNew() == true)
{
clsdbo_FactSurveyResponse.DateKey = System.Convert.ToInt32(txtNewDateKey.SelectedValue);
clsdbo_FactSurveyResponse.CustomerKey = System.Convert.ToInt32(txtNewCustomerKey.SelectedValue);
clsdbo_FactSurveyResponse.ProductCategoryKey = System.Convert.ToInt32(txtNewProductCategoryKey.Text);
clsdbo_FactSurveyResponse.EnglishProductCategoryName = System.Convert.ToString(txtNewEnglishProductCategoryName.Text);
clsdbo_FactSurveyResponse.ProductSubcategoryKey = System.Convert.ToInt32(txtNewProductSubcategoryKey.Text);
clsdbo_FactSurveyResponse.EnglishProductSubcategoryName = System.Convert.ToString(txtNewEnglishProductSubcategoryName.Text);
if (string.IsNullOrEmpty(txtNewDate.Text))
{
clsdbo_FactSurveyResponse.Date = null;
}
else
{
clsdbo_FactSurveyResponse.Date = System.Convert.ToDateTime(txtNewDate.Text);
}
bool bSucess = false;
bSucess = dbo_FactSurveyResponseDataClass.Add(clsdbo_FactSurveyResponse);
if (bSucess == true)
{
Session.Remove("dvdbo_FactSurveyResponse");
LoadGriddbo_FactSurveyResponse();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Fact Survey Response ");
}
}
} catch {
}
}
private void DeleteRecord()
{
dbo_FactSurveyResponseClass clsdbo_FactSurveyResponse = new dbo_FactSurveyResponseClass();
Label lblSurveyResponseKey = (Label)grddbo_FactSurveyResponse.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblSurveyResponseKey");
clsdbo_FactSurveyResponse.SurveyResponseKey = System.Convert.ToInt32(lblSurveyResponseKey.Text);
clsdbo_FactSurveyResponse = dbo_FactSurveyResponseDataClass.Select_Record(clsdbo_FactSurveyResponse);
bool bSucess = false;
bSucess = dbo_FactSurveyResponseDataClass.Delete(clsdbo_FactSurveyResponse);
if (bSucess == true)
{
Session.Remove("dvdbo_FactSurveyResponse");
LoadGriddbo_FactSurveyResponse();
}
else
{
ec.ShowMessage(" Delete failed. ", " Dbo. Fact Survey Response ");
}
}
private void InsertRecord()
{
dbo_FactSurveyResponseClass clsdbo_FactSurveyResponse = new dbo_FactSurveyResponseClass();
if (VerifyData() == true)
{
SetData(clsdbo_FactSurveyResponse);
bool bSucess = false;
bSucess = dbo_FactSurveyResponseDataClass.Add(clsdbo_FactSurveyResponse);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_FactSurveyResponse");
LoadGriddbo_FactSurveyResponse();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Fact Survey Response ");
}
}
}
public static bool Update(dbo_FactSurveyResponseClass olddbo_FactSurveyResponseClass,
dbo_FactSurveyResponseClass newdbo_FactSurveyResponseClass)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string updateStatement
= "UPDATE "
+ " [dbo].[FactSurveyResponse] "
+ "SET "
+ " [DateKey] = @NewDateKey "
+ " ,[CustomerKey] = @NewCustomerKey "
+ " ,[ProductCategoryKey] = @NewProductCategoryKey "
+ " ,[EnglishProductCategoryName] = @NewEnglishProductCategoryName "
+ " ,[ProductSubcategoryKey] = @NewProductSubcategoryKey "
+ " ,[EnglishProductSubcategoryName] = @NewEnglishProductSubcategoryName "
+ " ,[Date] = @NewDate "
+ "WHERE "
+ " [SurveyResponseKey] = @OldSurveyResponseKey "
+ " AND [DateKey] = @OldDateKey "
+ " AND [CustomerKey] = @OldCustomerKey "
+ " AND [ProductCategoryKey] = @OldProductCategoryKey "
+ " AND [EnglishProductCategoryName] = @OldEnglishProductCategoryName "
+ " AND [ProductSubcategoryKey] = @OldProductSubcategoryKey "
+ " AND [EnglishProductSubcategoryName] = @OldEnglishProductSubcategoryName "
+ " AND ((@OldDate IS NULL AND [Date] IS NULL) OR [Date] = @OldDate) "
+ "";
SqlCommand updateCommand = new SqlCommand(updateStatement, connection);
updateCommand.CommandType = CommandType.Text;
updateCommand.Parameters.AddWithValue("@NewDateKey", newdbo_FactSurveyResponseClass.DateKey);
updateCommand.Parameters.AddWithValue("@NewCustomerKey", newdbo_FactSurveyResponseClass.CustomerKey);
updateCommand.Parameters.AddWithValue("@NewProductCategoryKey", newdbo_FactSurveyResponseClass.ProductCategoryKey);
updateCommand.Parameters.AddWithValue("@NewEnglishProductCategoryName", newdbo_FactSurveyResponseClass.EnglishProductCategoryName);
updateCommand.Parameters.AddWithValue("@NewProductSubcategoryKey", newdbo_FactSurveyResponseClass.ProductSubcategoryKey);
updateCommand.Parameters.AddWithValue("@NewEnglishProductSubcategoryName", newdbo_FactSurveyResponseClass.EnglishProductSubcategoryName);
if (newdbo_FactSurveyResponseClass.Date.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewDate", newdbo_FactSurveyResponseClass.Date);
}
else
{
updateCommand.Parameters.AddWithValue("@NewDate", DBNull.Value);
}
updateCommand.Parameters.AddWithValue("@OldSurveyResponseKey", olddbo_FactSurveyResponseClass.SurveyResponseKey);
updateCommand.Parameters.AddWithValue("@OldDateKey", olddbo_FactSurveyResponseClass.DateKey);
updateCommand.Parameters.AddWithValue("@OldCustomerKey", olddbo_FactSurveyResponseClass.CustomerKey);
updateCommand.Parameters.AddWithValue("@OldProductCategoryKey", olddbo_FactSurveyResponseClass.ProductCategoryKey);
updateCommand.Parameters.AddWithValue("@OldEnglishProductCategoryName", olddbo_FactSurveyResponseClass.EnglishProductCategoryName);
updateCommand.Parameters.AddWithValue("@OldProductSubcategoryKey", olddbo_FactSurveyResponseClass.ProductSubcategoryKey);
updateCommand.Parameters.AddWithValue("@OldEnglishProductSubcategoryName", olddbo_FactSurveyResponseClass.EnglishProductSubcategoryName);
if (olddbo_FactSurveyResponseClass.Date.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@OldDate", olddbo_FactSurveyResponseClass.Date);
}
else
{
updateCommand.Parameters.AddWithValue("@OldDate", 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_FactSurveyResponseClass clsdbo_FactSurveyResponse)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string insertStatement
= "INSERT "
+ " [dbo].[FactSurveyResponse] "
+ " ( "
+ " [DateKey] "
+ " ,[CustomerKey] "
+ " ,[ProductCategoryKey] "
+ " ,[EnglishProductCategoryName] "
+ " ,[ProductSubcategoryKey] "
+ " ,[EnglishProductSubcategoryName] "
+ " ,[Date] "
+ " ) "
+ "VALUES "
+ " ( "
+ " @DateKey "
+ " ,@CustomerKey "
+ " ,@ProductCategoryKey "
+ " ,@EnglishProductCategoryName "
+ " ,@ProductSubcategoryKey "
+ " ,@EnglishProductSubcategoryName "
+ " ,@Date "
+ " ) "
+ "";
SqlCommand insertCommand = new SqlCommand(insertStatement, connection);
insertCommand.CommandType = CommandType.Text;
insertCommand.Parameters.AddWithValue("@DateKey", clsdbo_FactSurveyResponse.DateKey);
insertCommand.Parameters.AddWithValue("@CustomerKey", clsdbo_FactSurveyResponse.CustomerKey);
insertCommand.Parameters.AddWithValue("@ProductCategoryKey", clsdbo_FactSurveyResponse.ProductCategoryKey);
insertCommand.Parameters.AddWithValue("@EnglishProductCategoryName", clsdbo_FactSurveyResponse.EnglishProductCategoryName);
insertCommand.Parameters.AddWithValue("@ProductSubcategoryKey", clsdbo_FactSurveyResponse.ProductSubcategoryKey);
insertCommand.Parameters.AddWithValue("@EnglishProductSubcategoryName", clsdbo_FactSurveyResponse.EnglishProductSubcategoryName);
if (clsdbo_FactSurveyResponse.Date.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Date", clsdbo_FactSurveyResponse.Date);
}
else
{
insertCommand.Parameters.AddWithValue("@Date", DBNull.Value);
}
try
{
connection.Open();
int count = insertCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
