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