private void GetData() { ClearRecord(); dbo_FactProductInventoryClass clsdbo_FactProductInventory = new dbo_FactProductInventoryClass(); clsdbo_FactProductInventory.ProductKey = System.Convert.ToInt32(Session["ProductKey"]); clsdbo_FactProductInventory.DateKey = System.Convert.ToInt32(Session["DateKey"]); clsdbo_FactProductInventory = dbo_FactProductInventoryDataClass.Select_Record(clsdbo_FactProductInventory); if ((clsdbo_FactProductInventory != null)) { try { txtProductKey.SelectedValue = System.Convert.ToString(clsdbo_FactProductInventory.ProductKey); txtDateKey.SelectedValue = System.Convert.ToString(clsdbo_FactProductInventory.DateKey); txtMovementDate.Text = System.Convert.ToDateTime(clsdbo_FactProductInventory.MovementDate).ToShortDateString(); txtUnitCost.Text = System.Convert.ToString(clsdbo_FactProductInventory.UnitCost); txtUnitsIn.Text = System.Convert.ToString(clsdbo_FactProductInventory.UnitsIn); txtUnitsOut.Text = System.Convert.ToString(clsdbo_FactProductInventory.UnitsOut); txtUnitsBalance.Text = System.Convert.ToString(clsdbo_FactProductInventory.UnitsBalance); } catch (Exception ex) { ec.ShowMessage(ex.Message, " Dbo. Fact Product Inventory "); } } }
private void DeleteRecord() { dbo_FactProductInventoryClass clsdbo_FactProductInventory = new dbo_FactProductInventoryClass(); clsdbo_FactProductInventory.ProductKey = System.Convert.ToInt32(Session["ProductKey"]); clsdbo_FactProductInventory.DateKey = System.Convert.ToInt32(Session["DateKey"]); SetData(clsdbo_FactProductInventory); bool bSucess = false; bSucess = dbo_FactProductInventoryDataClass.Delete(clsdbo_FactProductInventory); if (bSucess == true) { pnlForm.Visible = false; pnlSave.Visible = false; pnlGrid.Visible = true; pnlDelete.Visible = false; lblMode.InnerText = ""; Session.Remove("dvdbo_FactProductInventory"); LoadGriddbo_FactProductInventory(); } else { ec.ShowMessage(" Delete failed. ", " Dbo. Fact Product Inventory "); } }
public static bool Add(dbo_FactProductInventoryClass clsdbo_FactProductInventory) { SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection(); string insertStatement = "INSERT " + " [dbo].[FactProductInventory] " + " ( " + " [ProductKey] " + " ,[DateKey] " + " ,[MovementDate] " + " ,[UnitCost] " + " ,[UnitsIn] " + " ,[UnitsOut] " + " ,[UnitsBalance] " + " ) " + "VALUES " + " ( " + " @ProductKey " + " ,@DateKey " + " ,@MovementDate " + " ,@UnitCost " + " ,@UnitsIn " + " ,@UnitsOut " + " ,@UnitsBalance " + " ) " + ""; SqlCommand insertCommand = new SqlCommand(insertStatement, connection); insertCommand.CommandType = CommandType.Text; insertCommand.Parameters.AddWithValue("@ProductKey", clsdbo_FactProductInventory.ProductKey); insertCommand.Parameters.AddWithValue("@DateKey", clsdbo_FactProductInventory.DateKey); insertCommand.Parameters.AddWithValue("@MovementDate", clsdbo_FactProductInventory.MovementDate); insertCommand.Parameters.AddWithValue("@UnitCost", clsdbo_FactProductInventory.UnitCost); insertCommand.Parameters.AddWithValue("@UnitsIn", clsdbo_FactProductInventory.UnitsIn); insertCommand.Parameters.AddWithValue("@UnitsOut", clsdbo_FactProductInventory.UnitsOut); insertCommand.Parameters.AddWithValue("@UnitsBalance", clsdbo_FactProductInventory.UnitsBalance); try { connection.Open(); int count = insertCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException) { return(false); } finally { connection.Close(); } }
private Boolean VerifyData() { if (txtProductKey.Text == "") { ec.ShowMessage(" Product Key is Required. ", " Dbo. Fact Product Inventory "); txtProductKey.Focus(); return(false); } if (txtDateKey.Text == "") { ec.ShowMessage(" Date Key is Required. ", " Dbo. Fact Product Inventory "); txtDateKey.Focus(); return(false); } if (txtUnitCost.Text == "") { ec.ShowMessage(" Unit Cost is Required. ", " Dbo. Fact Product Inventory "); txtUnitCost.Focus(); return(false); } if (txtUnitsIn.Text == "") { ec.ShowMessage(" Units In is Required. ", " Dbo. Fact Product Inventory "); txtUnitsIn.Focus(); return(false); } if (txtUnitsOut.Text == "") { ec.ShowMessage(" Units Out is Required. ", " Dbo. Fact Product Inventory "); txtUnitsOut.Focus(); return(false); } if (txtUnitsBalance.Text == "") { ec.ShowMessage(" Units Balance is Required. ", " Dbo. Fact Product Inventory "); txtUnitsBalance.Focus(); return(false); } if ( txtProductKey.SelectedIndex != -1 && txtDateKey.SelectedIndex != -1 ) { dbo_FactProductInventoryClass clsdbo_FactProductInventory = new dbo_FactProductInventoryClass(); clsdbo_FactProductInventory.ProductKey = System.Convert.ToInt32(txtProductKey.SelectedValue); clsdbo_FactProductInventory.DateKey = System.Convert.ToInt32(txtDateKey.SelectedValue); clsdbo_FactProductInventory = dbo_FactProductInventoryDataClass.Select_Record(clsdbo_FactProductInventory); if (clsdbo_FactProductInventory != null && (String)Session["Mode"] == "Add") { ec.ShowMessage(" Record already exists. ", " Dbo. Fact Product Inventory "); txtProductKey.Focus(); return(false); } } return(true); }
private void SetData(dbo_FactProductInventoryClass clsdbo_FactProductInventory) { clsdbo_FactProductInventory.ProductKey = System.Convert.ToInt32(txtProductKey.SelectedValue); clsdbo_FactProductInventory.DateKey = System.Convert.ToInt32(txtDateKey.SelectedValue); clsdbo_FactProductInventory.MovementDate = System.Convert.ToDateTime(txtMovementDate.Text); clsdbo_FactProductInventory.UnitCost = System.Convert.ToDecimal(txtUnitCost.Text); clsdbo_FactProductInventory.UnitsIn = System.Convert.ToInt32(txtUnitsIn.Text); clsdbo_FactProductInventory.UnitsOut = System.Convert.ToInt32(txtUnitsOut.Text); clsdbo_FactProductInventory.UnitsBalance = System.Convert.ToInt32(txtUnitsBalance.Text); }
public static dbo_FactProductInventoryClass Select_Record(dbo_FactProductInventoryClass clsdbo_FactProductInventoryPara) { dbo_FactProductInventoryClass clsdbo_FactProductInventory = new dbo_FactProductInventoryClass(); SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection(); string selectStatement = "SELECT " + " [ProductKey] " + " ,[DateKey] " + " ,[MovementDate] " + " ,[UnitCost] " + " ,[UnitsIn] " + " ,[UnitsOut] " + " ,[UnitsBalance] " + "FROM " + " [dbo].[FactProductInventory] " + "WHERE " + " [ProductKey] = @ProductKey " + " AND [DateKey] = @DateKey " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; selectCommand.Parameters.AddWithValue("@ProductKey", clsdbo_FactProductInventoryPara.ProductKey); selectCommand.Parameters.AddWithValue("@DateKey", clsdbo_FactProductInventoryPara.DateKey); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsdbo_FactProductInventory.ProductKey = System.Convert.ToInt32(reader["ProductKey"]); clsdbo_FactProductInventory.DateKey = System.Convert.ToInt32(reader["DateKey"]); clsdbo_FactProductInventory.MovementDate = System.Convert.ToDateTime(reader["MovementDate"]); clsdbo_FactProductInventory.UnitCost = System.Convert.ToDecimal(reader["UnitCost"]); clsdbo_FactProductInventory.UnitsIn = System.Convert.ToInt32(reader["UnitsIn"]); clsdbo_FactProductInventory.UnitsOut = System.Convert.ToInt32(reader["UnitsOut"]); clsdbo_FactProductInventory.UnitsBalance = System.Convert.ToInt32(reader["UnitsBalance"]); } else { clsdbo_FactProductInventory = null; } reader.Close(); } catch (SqlException) { return(clsdbo_FactProductInventory); } finally { connection.Close(); } return(clsdbo_FactProductInventory); }
public static bool Delete(dbo_FactProductInventoryClass clsdbo_FactProductInventory) { SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection(); string deleteStatement = "DELETE FROM " + " [dbo].[FactProductInventory] " + "WHERE " + " [ProductKey] = @OldProductKey " + " AND [DateKey] = @OldDateKey " + " AND [MovementDate] = @OldMovementDate " + " AND [UnitCost] = @OldUnitCost " + " AND [UnitsIn] = @OldUnitsIn " + " AND [UnitsOut] = @OldUnitsOut " + " AND [UnitsBalance] = @OldUnitsBalance " + ""; SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection); deleteCommand.CommandType = CommandType.Text; deleteCommand.Parameters.AddWithValue("@OldProductKey", clsdbo_FactProductInventory.ProductKey); deleteCommand.Parameters.AddWithValue("@OldDateKey", clsdbo_FactProductInventory.DateKey); deleteCommand.Parameters.AddWithValue("@OldMovementDate", clsdbo_FactProductInventory.MovementDate); deleteCommand.Parameters.AddWithValue("@OldUnitCost", clsdbo_FactProductInventory.UnitCost); deleteCommand.Parameters.AddWithValue("@OldUnitsIn", clsdbo_FactProductInventory.UnitsIn); deleteCommand.Parameters.AddWithValue("@OldUnitsOut", clsdbo_FactProductInventory.UnitsOut); deleteCommand.Parameters.AddWithValue("@OldUnitsBalance", clsdbo_FactProductInventory.UnitsBalance); 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_FactProductInventoryClass clsdbo_FactProductInventory = new dbo_FactProductInventoryClass(); Label lblProductKey = (Label)grddbo_FactProductInventory.Rows[grddbo_FactProductInventory.EditIndex].FindControl("lblProductKey"); clsdbo_FactProductInventory.ProductKey = System.Convert.ToInt32(lblProductKey.Text); Label lblDateKey = (Label)grddbo_FactProductInventory.Rows[grddbo_FactProductInventory.EditIndex].FindControl("lblDateKey"); clsdbo_FactProductInventory.DateKey = System.Convert.ToInt32(lblDateKey.Text); clsdbo_FactProductInventory = dbo_FactProductInventoryDataClass.Select_Record(clsdbo_FactProductInventory); Session["ProductKey_SelectedValue"] = clsdbo_FactProductInventory.ProductKey; Session["DateKey_SelectedValue"] = clsdbo_FactProductInventory.DateKey; LoadGriddbo_FactProductInventory(); } catch { } }
private void UpdateRecord() { try { DropDownList txtProductKey = (DropDownList)grddbo_FactProductInventory.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtProductKey"); DropDownList txtDateKey = (DropDownList)grddbo_FactProductInventory.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtDateKey"); TextBox txtMovementDate = (TextBox)grddbo_FactProductInventory.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtMovementDate"); TextBox txtUnitCost = (TextBox)grddbo_FactProductInventory.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtUnitCost"); TextBox txtUnitsIn = (TextBox)grddbo_FactProductInventory.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtUnitsIn"); TextBox txtUnitsOut = (TextBox)grddbo_FactProductInventory.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtUnitsOut"); TextBox txtUnitsBalance = (TextBox)grddbo_FactProductInventory.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtUnitsBalance"); dbo_FactProductInventoryClass oclsdbo_FactProductInventory = new dbo_FactProductInventoryClass(); dbo_FactProductInventoryClass clsdbo_FactProductInventory = new dbo_FactProductInventoryClass(); oclsdbo_FactProductInventory.ProductKey = System.Convert.ToInt32(txtProductKey.Text); oclsdbo_FactProductInventory.DateKey = System.Convert.ToInt32(txtDateKey.Text); oclsdbo_FactProductInventory = dbo_FactProductInventoryDataClass.Select_Record(oclsdbo_FactProductInventory); if (VerifyData() == true) { clsdbo_FactProductInventory.ProductKey = System.Convert.ToInt32(txtProductKey.SelectedValue); clsdbo_FactProductInventory.DateKey = System.Convert.ToInt32(txtDateKey.SelectedValue); clsdbo_FactProductInventory.MovementDate = System.Convert.ToDateTime(txtMovementDate.Text); clsdbo_FactProductInventory.UnitCost = System.Convert.ToDecimal(txtUnitCost.Text); clsdbo_FactProductInventory.UnitsIn = System.Convert.ToInt32(txtUnitsIn.Text); clsdbo_FactProductInventory.UnitsOut = System.Convert.ToInt32(txtUnitsOut.Text); clsdbo_FactProductInventory.UnitsBalance = System.Convert.ToInt32(txtUnitsBalance.Text); bool bSucess = false; bSucess = dbo_FactProductInventoryDataClass.Update(oclsdbo_FactProductInventory, clsdbo_FactProductInventory); if (bSucess == true) { Session.Remove("dvdbo_FactProductInventory"); grddbo_FactProductInventory.EditIndex = -1; LoadGriddbo_FactProductInventory(); } else { ec.ShowMessage(" Update failed. ", " Dbo. Fact Product Inventory "); } } } catch { } }
private void DeleteRecord() { dbo_FactProductInventoryClass clsdbo_FactProductInventory = new dbo_FactProductInventoryClass(); Label lblProductKey = (Label)grddbo_FactProductInventory.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblProductKey"); clsdbo_FactProductInventory.ProductKey = System.Convert.ToInt32(lblProductKey.Text); Label lblDateKey = (Label)grddbo_FactProductInventory.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblDateKey"); clsdbo_FactProductInventory.DateKey = System.Convert.ToInt32(lblDateKey.Text); clsdbo_FactProductInventory = dbo_FactProductInventoryDataClass.Select_Record(clsdbo_FactProductInventory); bool bSucess = false; bSucess = dbo_FactProductInventoryDataClass.Delete(clsdbo_FactProductInventory); if (bSucess == true) { Session.Remove("dvdbo_FactProductInventory"); LoadGriddbo_FactProductInventory(); } else { ec.ShowMessage(" Delete failed. ", " Dbo. Fact Product Inventory "); } }
private void InsertRecord() { dbo_FactProductInventoryClass clsdbo_FactProductInventory = new dbo_FactProductInventoryClass(); if (VerifyData() == true) { SetData(clsdbo_FactProductInventory); bool bSucess = false; bSucess = dbo_FactProductInventoryDataClass.Add(clsdbo_FactProductInventory); if (bSucess == true) { pnlForm.Visible = false; pnlSave.Visible = false; pnlGrid.Visible = true; lblMode.InnerText = ""; Session.Remove("dvdbo_FactProductInventory"); LoadGriddbo_FactProductInventory(); } else { ec.ShowMessage(" Insert failed. ", " Dbo. Fact Product Inventory "); } } }
private void InsertRecord() { try { DropDownList txtNewProductKey = (DropDownList)grddbo_FactProductInventory.FooterRow.FindControl("txtNewProductKey"); DropDownList txtNewDateKey = (DropDownList)grddbo_FactProductInventory.FooterRow.FindControl("txtNewDateKey"); TextBox txtNewMovementDate = (TextBox)grddbo_FactProductInventory.FooterRow.FindControl("txtNewMovementDate"); TextBox txtNewUnitCost = (TextBox)grddbo_FactProductInventory.FooterRow.FindControl("txtNewUnitCost"); TextBox txtNewUnitsIn = (TextBox)grddbo_FactProductInventory.FooterRow.FindControl("txtNewUnitsIn"); TextBox txtNewUnitsOut = (TextBox)grddbo_FactProductInventory.FooterRow.FindControl("txtNewUnitsOut"); TextBox txtNewUnitsBalance = (TextBox)grddbo_FactProductInventory.FooterRow.FindControl("txtNewUnitsBalance"); dbo_FactProductInventoryClass clsdbo_FactProductInventory = new dbo_FactProductInventoryClass(); if (VerifyDataNew() == true) { clsdbo_FactProductInventory.ProductKey = System.Convert.ToInt32(txtNewProductKey.SelectedValue); clsdbo_FactProductInventory.DateKey = System.Convert.ToInt32(txtNewDateKey.SelectedValue); clsdbo_FactProductInventory.MovementDate = System.Convert.ToDateTime(txtNewMovementDate.Text); clsdbo_FactProductInventory.UnitCost = System.Convert.ToDecimal(txtNewUnitCost.Text); clsdbo_FactProductInventory.UnitsIn = System.Convert.ToInt32(txtNewUnitsIn.Text); clsdbo_FactProductInventory.UnitsOut = System.Convert.ToInt32(txtNewUnitsOut.Text); clsdbo_FactProductInventory.UnitsBalance = System.Convert.ToInt32(txtNewUnitsBalance.Text); bool bSucess = false; bSucess = dbo_FactProductInventoryDataClass.Add(clsdbo_FactProductInventory); if (bSucess == true) { Session.Remove("dvdbo_FactProductInventory"); LoadGriddbo_FactProductInventory(); } else { ec.ShowMessage(" Insert failed. ", " Dbo. Fact Product Inventory "); } } } catch { } }
public static bool Update(dbo_FactProductInventoryClass olddbo_FactProductInventoryClass, dbo_FactProductInventoryClass newdbo_FactProductInventoryClass) { SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection(); string updateStatement = "UPDATE " + " [dbo].[FactProductInventory] " + "SET " + " [ProductKey] = @NewProductKey " + " ,[DateKey] = @NewDateKey " + " ,[MovementDate] = @NewMovementDate " + " ,[UnitCost] = @NewUnitCost " + " ,[UnitsIn] = @NewUnitsIn " + " ,[UnitsOut] = @NewUnitsOut " + " ,[UnitsBalance] = @NewUnitsBalance " + "WHERE " + " [ProductKey] = @OldProductKey " + " AND [DateKey] = @OldDateKey " + " AND [MovementDate] = @OldMovementDate " + " AND [UnitCost] = @OldUnitCost " + " AND [UnitsIn] = @OldUnitsIn " + " AND [UnitsOut] = @OldUnitsOut " + " AND [UnitsBalance] = @OldUnitsBalance " + ""; SqlCommand updateCommand = new SqlCommand(updateStatement, connection); updateCommand.CommandType = CommandType.Text; updateCommand.Parameters.AddWithValue("@NewProductKey", newdbo_FactProductInventoryClass.ProductKey); updateCommand.Parameters.AddWithValue("@NewDateKey", newdbo_FactProductInventoryClass.DateKey); updateCommand.Parameters.AddWithValue("@NewMovementDate", newdbo_FactProductInventoryClass.MovementDate); updateCommand.Parameters.AddWithValue("@NewUnitCost", newdbo_FactProductInventoryClass.UnitCost); updateCommand.Parameters.AddWithValue("@NewUnitsIn", newdbo_FactProductInventoryClass.UnitsIn); updateCommand.Parameters.AddWithValue("@NewUnitsOut", newdbo_FactProductInventoryClass.UnitsOut); updateCommand.Parameters.AddWithValue("@NewUnitsBalance", newdbo_FactProductInventoryClass.UnitsBalance); updateCommand.Parameters.AddWithValue("@OldProductKey", olddbo_FactProductInventoryClass.ProductKey); updateCommand.Parameters.AddWithValue("@OldDateKey", olddbo_FactProductInventoryClass.DateKey); updateCommand.Parameters.AddWithValue("@OldMovementDate", olddbo_FactProductInventoryClass.MovementDate); updateCommand.Parameters.AddWithValue("@OldUnitCost", olddbo_FactProductInventoryClass.UnitCost); updateCommand.Parameters.AddWithValue("@OldUnitsIn", olddbo_FactProductInventoryClass.UnitsIn); updateCommand.Parameters.AddWithValue("@OldUnitsOut", olddbo_FactProductInventoryClass.UnitsOut); updateCommand.Parameters.AddWithValue("@OldUnitsBalance", olddbo_FactProductInventoryClass.UnitsBalance); try { connection.Open(); int count = updateCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException) { return(false); } finally { connection.Close(); } }
private Boolean VerifyDataNew() { DropDownList txtNewProductKey = (DropDownList)grddbo_FactProductInventory.FooterRow.FindControl("txtNewProductKey"); DropDownList txtNewDateKey = (DropDownList)grddbo_FactProductInventory.FooterRow.FindControl("txtNewDateKey"); TextBox txtNewMovementDate = (TextBox)grddbo_FactProductInventory.FooterRow.FindControl("txtNewMovementDate"); TextBox txtNewUnitCost = (TextBox)grddbo_FactProductInventory.FooterRow.FindControl("txtNewUnitCost"); TextBox txtNewUnitsIn = (TextBox)grddbo_FactProductInventory.FooterRow.FindControl("txtNewUnitsIn"); TextBox txtNewUnitsOut = (TextBox)grddbo_FactProductInventory.FooterRow.FindControl("txtNewUnitsOut"); TextBox txtNewUnitsBalance = (TextBox)grddbo_FactProductInventory.FooterRow.FindControl("txtNewUnitsBalance"); if (txtNewProductKey.Text == "") { ec.ShowMessage(" Product Key is Required. ", " Dbo. Fact Product Inventory "); txtNewProductKey.Focus(); return(false); } if (txtNewDateKey.Text == "") { ec.ShowMessage(" Date Key is Required. ", " Dbo. Fact Product Inventory "); txtNewDateKey.Focus(); return(false); } if (txtNewUnitCost.Text == "") { ec.ShowMessage(" Unit Cost is Required. ", " Dbo. Fact Product Inventory "); txtNewUnitCost.Focus(); return(false); } if (txtNewUnitsIn.Text == "") { ec.ShowMessage(" Units In is Required. ", " Dbo. Fact Product Inventory "); txtNewUnitsIn.Focus(); return(false); } if (txtNewUnitsOut.Text == "") { ec.ShowMessage(" Units Out is Required. ", " Dbo. Fact Product Inventory "); txtNewUnitsOut.Focus(); return(false); } if (txtNewUnitsBalance.Text == "") { ec.ShowMessage(" Units Balance is Required. ", " Dbo. Fact Product Inventory "); txtNewUnitsBalance.Focus(); return(false); } if ( txtNewProductKey.SelectedIndex != -1 && txtNewDateKey.SelectedIndex != -1 ) { dbo_FactProductInventoryClass clsdbo_FactProductInventory = new dbo_FactProductInventoryClass(); clsdbo_FactProductInventory.ProductKey = System.Convert.ToInt32(txtNewProductKey.SelectedValue); clsdbo_FactProductInventory.DateKey = System.Convert.ToInt32(txtNewDateKey.SelectedValue); clsdbo_FactProductInventory = dbo_FactProductInventoryDataClass.Select_Record(clsdbo_FactProductInventory); if (clsdbo_FactProductInventory != null) { ec.ShowMessage(" Record already exists. ", " Dbo. Fact Product Inventory "); txtNewProductKey.Focus(); return(false); } } return(true); }