void BindSalesOrder()
{
odlSalesOrder = new Store.SalesOrder.BusinessLogic.SalesOrder();
try
{
objSalesOrderList = odlSalesOrder.GetAllSalesOrderList(0, 0, "");
if (objSalesOrderList != null)
{
ddlSalesOrderID.DataSource = objSalesOrderList;
ddlSalesOrderID.DataValueField = "SalesOrderID";
ddlSalesOrderID.DataBind();
}
else
{
ddlSalesOrderID.DataSource = null;
ddlSalesOrderID.DataBind();
}
}
catch (Exception ex)
{
}
finally
{
odlSalesOrder = null;
objSalesOrderList = null;
}
}
void BindSalesOrder()
{
oblSalesOrder = new Store.SalesOrder.BusinessLogic.SalesOrder();
try
{
objSalesList = oblSalesOrder.GetAllSalesOrderList(0, 0, "");
if (objSalesList != null)
{
gvSOrder.DataSource = objSalesList;
gvSOrder.DataBind();
}
else
{
gvSOrder.DataSource = null;
gvSOrder.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
oblSalesOrder = null;
objSalesOrderList = null;
}
}
public string insertSalesOrder(string cpsubtotal, string spsubtotal, string dicpre, string dic, string tax, string shc, string misccost, string ttotal)
{
oblSalesOrder = new Store.SalesOrder.BusinessLogic.SalesOrder();
//oblPurchaseOrder = new Store.PurchaseOrder.BusinessLogic.PurchaseOrder();
objMessageInfo = new MessageInfo();
objSalesOrder = new Store.SalesOrder.BusinessObject.SalesOrder();
//objPurchaseOrder = new Store.PurchaseOrder.BusinessObject.PurchaseOrder();
if (cmdMode == Store.Common.CommandMode.M)
{
objSalesOrder.SalesOrderID = Convert.ToInt32(hfPId.Value);
// objPurchaseOrder.PurchaseOrderID = Convert.ToInt32(hfPId.Value);//PurchaseOrderID which edit from data grid
}
else
{
objSalesOrder.SalesOrderID = 0;
//objPurchaseOrder.PurchaseOrderID = 0;
}
objSalesOrder.SalesOrderID = 0;
objSalesOrder.VendorID = Convert.ToInt32(hfVendor.Value);
objSalesOrder.TotalCostAmount = Convert.ToDecimal(cpsubtotal);
objSalesOrder.TotalSaleAmount = Convert.ToDecimal(spsubtotal);
objSalesOrder.TotalTaxValue = Convert.ToDecimal(tax);
objSalesOrder.ShipingAndHandlingCost = Convert.ToDecimal(shc);
objSalesOrder.MiscSaleAmount = Convert.ToDecimal(misccost);
objSalesOrder.DiscountPer = Convert.ToDecimal(dicpre);
objSalesOrder.Discount = Convert.ToDecimal(dic);
objSalesOrder.IsActive = 1;
objMessageInfo = oblSalesOrder.ManageSaleOrder(objSalesOrder, cmdMode);
return(objMessageInfo.TranID.ToString());
}
void bindSales(int id)
{
oblSales = new Store.SalesOrder.BusinessLogic.SalesOrder();
try
{
objSales = oblSales.GetAllSalesOrder(id, 0, "");
if (objSales != null)
{
txtSubTotal.Text = objSales.TotalSaleAmount.ToString();
txtTax.Text = objSales.TotalTaxValue.ToString();
txtSHC.Text = objSales.ShipingAndHandlingCost.ToString();
txtMiscCost.Text = objSales.MiscSaleAmount.ToString();
}
else
{
txtSubTotal.Text = "";
txtTax.Text = "";
txtSHC.Text = "";
} txtMiscCost.Text = "";
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(SalesRtn).FullName, 1);
}
finally
{
oblSales = null;
objSales = null;
}
}
void ManageSalesOrder()
{
objSalesOrder = new Store.SalesOrder.BusinessObject.SalesOrder();
odlSalesOrder = new Store.SalesOrder.BusinessLogic.SalesOrder();
try
{
if (cmdMode == Store.Common.CommandMode.M)
{
objSalesOrder.SalesOrderID = Convert.ToInt32(txtSalesOrderID.Text);
}
else
{
objSalesOrder.SalesOrderID = 0;
}
objSalesOrder.VendorID = Convert.ToInt16(ddlVendor.SelectedItem.Value);
DateTime date = DateTime.Parse(txtSDate.Text);
objSalesOrder.SaleDate = date;
objSalesOrder.TotalCostAmount = Convert.ToDecimal(txtTotalCostAmount.Text);
objSalesOrder.TotalSaleAmount = Convert.ToDecimal(txtTotalSaleAmount.Text);
objSalesOrder.TotalDiscountAmount = Convert.ToDecimal(txtTotalDiscountAmount.Text);
objSalesOrder.TotalTaxValue = Convert.ToDecimal(txtTaxValue.Text);
objSalesOrder.ShipingAndHandlingCost = Convert.ToDecimal(txtSHCost.Text);
objSalesOrder.MiscSaleAmount = Convert.ToDecimal(txtMiscCost.Text);
if (cbIsActive.Checked)
{
objSalesOrder.IsActive = 1;
}
else
{
objSalesOrder.IsActive = 0;
}
objSalesOrder.CreatedBy = 1;
objMessageInfo = odlSalesOrder.ManageItemMaster(objSalesOrder, cmdMode);
}
catch (Exception ex)
{
}
finally
{
objSalesOrder = null;
//objMessageInfo = null;
odlSalesOrder = null;
}
}
public string insertOrder(string totalc, string totals, string totald, string tax, string shc, string misccost)
{
Store.SalesOrder.BusinessLogic.SalesOrder oblSalesOrder = new Store.SalesOrder.BusinessLogic.SalesOrder();
Store.Common.MessageInfo objMessageInfo = new MessageInfo();
Store.SalesOrder.BusinessObject.SalesOrder objSalesOrder = new Store.SalesOrder.BusinessObject.SalesOrder();
objSalesOrder.SalesOrderID = 0;
objSalesOrder.VendorID = 0;
//objSalesOrder.SaleDate=
objSalesOrder.TotalCostAmount = Convert.ToDecimal(totalc);
objSalesOrder.TotalSaleAmount = Convert.ToDecimal(totals);
objSalesOrder.TotalDiscountAmount = Convert.ToDecimal(totald);
objSalesOrder.TotalTaxValue = Convert.ToDecimal(tax);
objSalesOrder.ShipingAndHandlingCost = Convert.ToDecimal(shc);
objSalesOrder.MiscSaleAmount = Convert.ToDecimal(misccost);
// objMessageInfo = oblSalesOrder.ManageSaleOrder(objSalesOrder,cmdMode);
return(objMessageInfo.TranID.ToString());
}
public string insertItem(string name, string description, string pricec, string prices, string discountper, string discount, string quantity, string transId)
{
Store.SalesOrderItem.BusinessLogic.SalesOrderItem oblSalesOrderItem = new Store.SalesOrderItem.BusinessLogic.SalesOrderItem();
Store.SalesOrderItem.BusinessObject.SalesOrderItem objSalesOrderItem = new Store.SalesOrderItem.BusinessObject.SalesOrderItem();
Store.SalesOrder.BusinessLogic.SalesOrder oblSalesOrder = new Store.SalesOrder.BusinessLogic.SalesOrder();
Store.Common.MessageInfo objMessageInfo = new MessageInfo();
objSalesOrderItem.SaleOrderItemID = 0;
objSalesOrderItem.SalesOrderID = Convert.ToInt32(transId);
objSalesOrderItem.ItemPrefix = name;
objSalesOrderItem.Description = description;
objSalesOrderItem.ItemCostPrice = Convert.ToDecimal(pricec);
objSalesOrderItem.ItemSalePrice = Convert.ToDecimal(prices);
objSalesOrderItem.ItemDiscountPercentage = Convert.ToDecimal(discountper);
objSalesOrderItem.ItemDiscount = Convert.ToDecimal(discount);
objSalesOrderItem.ItemUnit = quantity;
//objMessageInfo = oblSalesOrder.ManageSaleOrderItem(objSalesOrderItem, cmdMode);
return("");
}
protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e)
{
cmdMode = CommandMode.D;
objSalesOrder = new Store.SalesOrder.BusinessObject.SalesOrder();
odlSalesOrder = new Store.SalesOrder.BusinessLogic.SalesOrder();
try
{
ImageButton btndetails = sender as ImageButton;
GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer;
objSalesOrder.SalesOrderID = Convert.ToInt32(dgvSalesOrder.DataKeys[gvrow.RowIndex].Value.ToString());
objSalesOrder.VendorID = 0;
objSalesOrder.SaleDate = DateTime.Now;
objSalesOrder.TotalCostAmount = 0;
objSalesOrder.TotalSaleAmount = 0;
objSalesOrder.TotalTaxValue = 0;
objSalesOrder.TotalDiscountAmount = 0;
objSalesOrder.ShipingAndHandlingCost = 0;
objSalesOrder.MiscSaleAmount = 0;
objSalesOrder.IsActive = 1;
objSalesOrder.ClientID = 0;
objSalesOrder.CreatedBy = 1;
objMessageInfo = odlSalesOrder.ManageItemMaster(objSalesOrder, cmdMode);
BindSalesOrder();
updateSalesOrderBdInfo.Update();
}
catch (Exception ex)
{
throw;
}
finally
{
objSalesOrder = null;
objMessageInfo = null;
odlSalesOrder = null;
}
}
