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