private void DeleteRecord()
{
dbo_FactInternetSalesClass clsdbo_FactInternetSales = new dbo_FactInternetSalesClass();
clsdbo_FactInternetSales.SalesOrderNumber = System.Convert.ToString(Session["SalesOrderNumber"]);
clsdbo_FactInternetSales.SalesOrderLineNumber = System.Convert.ToByte(Session["SalesOrderLineNumber"]);
SetData(clsdbo_FactInternetSales);
bool bSucess = false;
bSucess = dbo_FactInternetSalesDataClass.Delete(clsdbo_FactInternetSales);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
pnlDelete.Visible = false;
lblMode.InnerText = "";
Session.Remove("dvdbo_FactInternetSales");
LoadGriddbo_FactInternetSales();
}
else
{
ec.ShowMessage(" Delete failed. ", " Dbo. Fact Internet Sales ");
}
}
private void InsertRecord()
{
dbo_FactInternetSalesClass clsdbo_FactInternetSales = new dbo_FactInternetSalesClass();
if (VerifyData() == true)
{
SetData(clsdbo_FactInternetSales);
bool bSucess = false;
bSucess = dbo_FactInternetSalesDataClass.Add(clsdbo_FactInternetSales);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_FactInternetSales");
LoadGriddbo_FactInternetSales();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Fact Internet Sales ");
}
}
}
private Boolean VerifyData()
{
if (txtSalesOrderNumber.Text == "")
{
ec.ShowMessage(" Sales Order Number is Required. ", " Dbo. Fact Internet Sales ");
txtSalesOrderNumber.Focus();
return(false);
}
if (txtSalesOrderLineNumber.Text == "")
{
ec.ShowMessage(" Sales Order Line Number is Required. ", " Dbo. Fact Internet Sales ");
txtSalesOrderLineNumber.Focus();
return(false);
}
if (txtProductKey.Text == "")
{
ec.ShowMessage(" Product Key is Required. ", " Dbo. Fact Internet Sales ");
txtProductKey.Focus();
return(false);
}
if (txtOrderDateKey.Text == "")
{
ec.ShowMessage(" Order Date Key is Required. ", " Dbo. Fact Internet Sales ");
txtOrderDateKey.Focus();
return(false);
}
if (txtDueDateKey.Text == "")
{
ec.ShowMessage(" Due Date Key is Required. ", " Dbo. Fact Internet Sales ");
txtDueDateKey.Focus();
return(false);
}
if (txtShipDateKey.Text == "")
{
ec.ShowMessage(" Ship Date Key is Required. ", " Dbo. Fact Internet Sales ");
txtShipDateKey.Focus();
return(false);
}
if (txtCustomerKey.Text == "")
{
ec.ShowMessage(" Customer Key is Required. ", " Dbo. Fact Internet Sales ");
txtCustomerKey.Focus();
return(false);
}
if (txtPromotionKey.Text == "")
{
ec.ShowMessage(" Promotion Key is Required. ", " Dbo. Fact Internet Sales ");
txtPromotionKey.Focus();
return(false);
}
if (txtCurrencyKey.Text == "")
{
ec.ShowMessage(" Currency Key is Required. ", " Dbo. Fact Internet Sales ");
txtCurrencyKey.Focus();
return(false);
}
if (txtSalesTerritoryKey.Text == "")
{
ec.ShowMessage(" Sales Territory Key is Required. ", " Dbo. Fact Internet Sales ");
txtSalesTerritoryKey.Focus();
return(false);
}
if (txtRevisionNumber.Text == "")
{
ec.ShowMessage(" Revision Number is Required. ", " Dbo. Fact Internet Sales ");
txtRevisionNumber.Focus();
return(false);
}
if (txtOrderQuantity.Text == "")
{
ec.ShowMessage(" Order Quantity is Required. ", " Dbo. Fact Internet Sales ");
txtOrderQuantity.Focus();
return(false);
}
if (txtUnitPrice.Text == "")
{
ec.ShowMessage(" Unit Price is Required. ", " Dbo. Fact Internet Sales ");
txtUnitPrice.Focus();
return(false);
}
if (txtExtendedAmount.Text == "")
{
ec.ShowMessage(" Extended Amount is Required. ", " Dbo. Fact Internet Sales ");
txtExtendedAmount.Focus();
return(false);
}
if (txtUnitPriceDiscountPct.Text == "")
{
ec.ShowMessage(" Unit Price Discount Pct is Required. ", " Dbo. Fact Internet Sales ");
txtUnitPriceDiscountPct.Focus();
return(false);
}
if (txtDiscountAmount.Text == "")
{
ec.ShowMessage(" Discount Amount is Required. ", " Dbo. Fact Internet Sales ");
txtDiscountAmount.Focus();
return(false);
}
if (txtProductStandardCost.Text == "")
{
ec.ShowMessage(" Product Standard Cost is Required. ", " Dbo. Fact Internet Sales ");
txtProductStandardCost.Focus();
return(false);
}
if (txtTotalProductCost.Text == "")
{
ec.ShowMessage(" Total Product Cost is Required. ", " Dbo. Fact Internet Sales ");
txtTotalProductCost.Focus();
return(false);
}
if (txtSalesAmount.Text == "")
{
ec.ShowMessage(" Sales Amount is Required. ", " Dbo. Fact Internet Sales ");
txtSalesAmount.Focus();
return(false);
}
if (txtTaxAmt.Text == "")
{
ec.ShowMessage(" Tax Amt is Required. ", " Dbo. Fact Internet Sales ");
txtTaxAmt.Focus();
return(false);
}
if (txtFreight.Text == "")
{
ec.ShowMessage(" Freight is Required. ", " Dbo. Fact Internet Sales ");
txtFreight.Focus();
return(false);
}
if (
txtSalesOrderNumber.Text != "" &&
txtSalesOrderLineNumber.Text != ""
)
{
dbo_FactInternetSalesClass clsdbo_FactInternetSales = new dbo_FactInternetSalesClass();
clsdbo_FactInternetSales.SalesOrderNumber = System.Convert.ToString(txtSalesOrderNumber.Text);
clsdbo_FactInternetSales.SalesOrderLineNumber = System.Convert.ToByte(txtSalesOrderLineNumber.Text);
clsdbo_FactInternetSales = dbo_FactInternetSalesDataClass.Select_Record(clsdbo_FactInternetSales);
if (clsdbo_FactInternetSales != null && (String)Session["Mode"] == "Add")
{
ec.ShowMessage(" Record already exists. ", " Dbo. Fact Internet Sales ");
txtSalesOrderNumber.Focus();
return(false);
}
}
return(true);
}
private void SetData(dbo_FactInternetSalesClass clsdbo_FactInternetSales)
{
clsdbo_FactInternetSales.SalesOrderNumber = System.Convert.ToString(txtSalesOrderNumber.Text);
clsdbo_FactInternetSales.SalesOrderLineNumber = System.Convert.ToByte(txtSalesOrderLineNumber.Text);
clsdbo_FactInternetSales.ProductKey = System.Convert.ToInt32(txtProductKey.SelectedValue);
clsdbo_FactInternetSales.OrderDateKey = System.Convert.ToInt32(txtOrderDateKey.SelectedValue);
clsdbo_FactInternetSales.DueDateKey = System.Convert.ToInt32(txtDueDateKey.SelectedValue);
clsdbo_FactInternetSales.ShipDateKey = System.Convert.ToInt32(txtShipDateKey.SelectedValue);
clsdbo_FactInternetSales.CustomerKey = System.Convert.ToInt32(txtCustomerKey.SelectedValue);
clsdbo_FactInternetSales.PromotionKey = System.Convert.ToInt32(txtPromotionKey.SelectedValue);
clsdbo_FactInternetSales.CurrencyKey = System.Convert.ToInt32(txtCurrencyKey.SelectedValue);
clsdbo_FactInternetSales.SalesTerritoryKey = System.Convert.ToInt32(txtSalesTerritoryKey.SelectedValue);
clsdbo_FactInternetSales.RevisionNumber = System.Convert.ToByte(txtRevisionNumber.Text);
clsdbo_FactInternetSales.OrderQuantity = System.Convert.ToInt16(txtOrderQuantity.Text);
clsdbo_FactInternetSales.UnitPrice = System.Convert.ToDecimal(txtUnitPrice.Text);
clsdbo_FactInternetSales.ExtendedAmount = System.Convert.ToDecimal(txtExtendedAmount.Text);
clsdbo_FactInternetSales.UnitPriceDiscountPct = System.Convert.ToDecimal(txtUnitPriceDiscountPct.Text);
clsdbo_FactInternetSales.DiscountAmount = System.Convert.ToDecimal(txtDiscountAmount.Text);
clsdbo_FactInternetSales.ProductStandardCost = System.Convert.ToDecimal(txtProductStandardCost.Text);
clsdbo_FactInternetSales.TotalProductCost = System.Convert.ToDecimal(txtTotalProductCost.Text);
clsdbo_FactInternetSales.SalesAmount = System.Convert.ToDecimal(txtSalesAmount.Text);
clsdbo_FactInternetSales.TaxAmt = System.Convert.ToDecimal(txtTaxAmt.Text);
clsdbo_FactInternetSales.Freight = System.Convert.ToDecimal(txtFreight.Text);
if (string.IsNullOrEmpty(txtCarrierTrackingNumber.Text))
{
clsdbo_FactInternetSales.CarrierTrackingNumber = null;
}
else
{
clsdbo_FactInternetSales.CarrierTrackingNumber = txtCarrierTrackingNumber.Text;
}
if (string.IsNullOrEmpty(txtCustomerPONumber.Text))
{
clsdbo_FactInternetSales.CustomerPONumber = null;
}
else
{
clsdbo_FactInternetSales.CustomerPONumber = txtCustomerPONumber.Text;
}
if (string.IsNullOrEmpty(txtOrderDate.Text))
{
clsdbo_FactInternetSales.OrderDate = null;
}
else
{
clsdbo_FactInternetSales.OrderDate = System.Convert.ToDateTime(txtOrderDate.Text);
}
if (string.IsNullOrEmpty(txtDueDate.Text))
{
clsdbo_FactInternetSales.DueDate = null;
}
else
{
clsdbo_FactInternetSales.DueDate = System.Convert.ToDateTime(txtDueDate.Text);
}
if (string.IsNullOrEmpty(txtShipDate.Text))
{
clsdbo_FactInternetSales.ShipDate = null;
}
else
{
clsdbo_FactInternetSales.ShipDate = System.Convert.ToDateTime(txtShipDate.Text);
}
}
private void GetData()
{
ClearRecord();
dbo_FactInternetSalesClass clsdbo_FactInternetSales = new dbo_FactInternetSalesClass();
clsdbo_FactInternetSales.SalesOrderNumber = System.Convert.ToString(Session["SalesOrderNumber"]);
clsdbo_FactInternetSales.SalesOrderLineNumber = System.Convert.ToByte(Session["SalesOrderLineNumber"]);
clsdbo_FactInternetSales = dbo_FactInternetSalesDataClass.Select_Record(clsdbo_FactInternetSales);
if ((clsdbo_FactInternetSales != null))
{
try {
txtSalesOrderNumber.Text = System.Convert.ToString(clsdbo_FactInternetSales.SalesOrderNumber);
txtSalesOrderLineNumber.Text = System.Convert.ToString(clsdbo_FactInternetSales.SalesOrderLineNumber);
txtProductKey.SelectedValue = System.Convert.ToString(clsdbo_FactInternetSales.ProductKey);
txtOrderDateKey.SelectedValue = System.Convert.ToString(clsdbo_FactInternetSales.OrderDateKey);
txtDueDateKey.SelectedValue = System.Convert.ToString(clsdbo_FactInternetSales.DueDateKey);
txtShipDateKey.SelectedValue = System.Convert.ToString(clsdbo_FactInternetSales.ShipDateKey);
txtCustomerKey.SelectedValue = System.Convert.ToString(clsdbo_FactInternetSales.CustomerKey);
txtPromotionKey.SelectedValue = System.Convert.ToString(clsdbo_FactInternetSales.PromotionKey);
txtCurrencyKey.SelectedValue = System.Convert.ToString(clsdbo_FactInternetSales.CurrencyKey);
txtSalesTerritoryKey.SelectedValue = System.Convert.ToString(clsdbo_FactInternetSales.SalesTerritoryKey);
txtRevisionNumber.Text = System.Convert.ToString(clsdbo_FactInternetSales.RevisionNumber);
txtOrderQuantity.Text = System.Convert.ToString(clsdbo_FactInternetSales.OrderQuantity);
txtUnitPrice.Text = System.Convert.ToString(clsdbo_FactInternetSales.UnitPrice);
txtExtendedAmount.Text = System.Convert.ToString(clsdbo_FactInternetSales.ExtendedAmount);
txtUnitPriceDiscountPct.Text = System.Convert.ToString(clsdbo_FactInternetSales.UnitPriceDiscountPct);
txtDiscountAmount.Text = System.Convert.ToString(clsdbo_FactInternetSales.DiscountAmount);
txtProductStandardCost.Text = System.Convert.ToString(clsdbo_FactInternetSales.ProductStandardCost);
txtTotalProductCost.Text = System.Convert.ToString(clsdbo_FactInternetSales.TotalProductCost);
txtSalesAmount.Text = System.Convert.ToString(clsdbo_FactInternetSales.SalesAmount);
txtTaxAmt.Text = System.Convert.ToString(clsdbo_FactInternetSales.TaxAmt);
txtFreight.Text = System.Convert.ToString(clsdbo_FactInternetSales.Freight);
if (clsdbo_FactInternetSales.CarrierTrackingNumber == null)
{
txtCarrierTrackingNumber.Text = default(string);
}
else
{
txtCarrierTrackingNumber.Text = System.Convert.ToString(clsdbo_FactInternetSales.CarrierTrackingNumber);
}
if (clsdbo_FactInternetSales.CustomerPONumber == null)
{
txtCustomerPONumber.Text = default(string);
}
else
{
txtCustomerPONumber.Text = System.Convert.ToString(clsdbo_FactInternetSales.CustomerPONumber);
}
if (clsdbo_FactInternetSales.OrderDate == null)
{
txtOrderDate.Text = DateTime.Now.ToString();
}
else
{
txtOrderDate.Text = System.Convert.ToDateTime(clsdbo_FactInternetSales.OrderDate).ToShortDateString();
}
if (clsdbo_FactInternetSales.DueDate == null)
{
txtDueDate.Text = DateTime.Now.ToString();
}
else
{
txtDueDate.Text = System.Convert.ToDateTime(clsdbo_FactInternetSales.DueDate).ToShortDateString();
}
if (clsdbo_FactInternetSales.ShipDate == null)
{
txtShipDate.Text = DateTime.Now.ToString();
}
else
{
txtShipDate.Text = System.Convert.ToDateTime(clsdbo_FactInternetSales.ShipDate).ToShortDateString();
}
}
catch (Exception ex)
{
ec.ShowMessage(ex.Message, " Dbo. Fact Internet Sales ");
}
}
}
