public BillData GetData(double requisition)
{
BillData data = new BillData();
DataTable dt = SearchObj.GetRequisitionData(requisition);
foreach (DataRow dRow in dt.Rows)
{
data.REQUISITION = Convert.ToDouble(dRow["LOID"]);
data.CODE = dRow["CODE"].ToString();
data.REQDATE = Convert.ToDateTime(dRow["REQDATE"]);
if (!Convert.IsDBNull(dRow["REFCODE"])) data.REFCODE = dRow["REFCODE"].ToString();
if (!Convert.IsDBNull(dRow["CNAME"])) data.CUSTOMERNAME = dRow["CNAME"].ToString();
data.TOTAL = Convert.ToDouble(dRow["TOTAL"]);
data.TOTDIS = Convert.ToDouble(dRow["TOTDIS"]);
data.VAT = Convert.ToDouble(dRow["VAT"]);
data.TOTVAT = Convert.ToDouble(dRow["TOTVAT"]);
data.GRANDTOT = Convert.ToDouble(dRow["GRANDTOT"]);
data.CREATEBY = dRow["CREATEBY"].ToString();
if (!Convert.IsDBNull(dRow["CCODE"])) data.CCODE = dRow["CCODE"].ToString();
if (!Convert.IsDBNull(dRow["CNAME"])) data.CNAME = dRow["CNAME"].ToString();
if (!Convert.IsDBNull(dRow["CADDRESS"])) data.CADDRESS = dRow["CADDRESS"].ToString();
if (!Convert.IsDBNull(dRow["CTEL"])) data.CTEL = dRow["CTEL"].ToString();
if (!Convert.IsDBNull(dRow["CFAX"])) data.CFAX = dRow["CFAX"].ToString();
if (!Convert.IsDBNull(dRow["PAYMENT"])) data.PAYMENT = dRow["PAYMENT"].ToString();
if (!Convert.IsDBNull(dRow["CHEQUE"])) data.CHEQUE = dRow["CHEQUE"].ToString();
if (!Convert.IsDBNull(dRow["CREDITCARDID"])) data.CREDITCARDID= dRow["CREDITCARDID"].ToString();
if (!Convert.IsDBNull(dRow["CHEQUEDATE"])) data.CHEQUEDATE = Convert.ToDateTime(dRow["CHEQUEDATE"]);
if (!Convert.IsDBNull(dRow["BANKNAME"])) data.BANKNAME = dRow["BANKNAME"].ToString();
if (!Convert.IsDBNull(dRow["BANKBRANCH"])) data.BANKBRANCH = dRow["BANKBRANCH"].ToString();
if (!Convert.IsDBNull(dRow["RECEIVEBY"])) data.RECEIVEBY = dRow["RECEIVEBY"].ToString();
if (!Convert.IsDBNull(dRow["RECEIVEDATE"])) data.RECEIVEDATE = Convert.ToDateTime(dRow["RECEIVEDATE"]);
if (!Convert.IsDBNull(dRow["INVCODE"])) data.INVCODE = dRow["INVCODE"].ToString();
}
DataTable dtItem = SearchObj.GetRequisitionItem(requisition);
foreach (DataRow dRow in dtItem.Rows)
{
RequisitionItemData itemData = new RequisitionItemData();
itemData.LOID = Convert.ToDouble(dRow["RANK"]);
itemData.BarCode = dRow["BARCODE"].ToString();
itemData.ProductName = dRow["PRODUCTNAME"].ToString();
itemData.QTY = Convert.ToDouble(dRow["QTY"]);
itemData.UnitName = dRow["UNITNAME"].ToString();
itemData.PRICE = Convert.ToDouble(dRow["PRICE"]);
itemData.DISCOUNT = Convert.ToDouble(dRow["DISCOUNT"]);
itemData.NETPRICE = Convert.ToDouble(dRow["NETPRICE"]);
itemData.ISVAT = dRow["ISVAT"].ToString();
data.ITEM.Add(itemData);
}
return data;
}
private void Load(RequisitionItemData data)
{
Init();
if (data != null)
{
ItemID = data.requisition_item_id;
RequisitionID = data.requisition_id;
Quantity = data.quantity;
Description = data.description;
if (data.date_needed != null)
{
DateNeeded = ( DateTime )data.date_needed;
}
if (data.item_number != null)
{
ItemNumber = data.item_number;
}
CompanyID = data.company_id;
FundID = data.fund_id;
DepartmentID = data.department_id;
AccountID = data.account_id;
ProjectId = data.project_id;
CreatedByUserID = data.created_by;
ModifiedByUserID = data.modified_by;
DateCreated = data.date_created;
DateModified = ( DateTime )data.date_modified;
IsExpeditiedShippingAllowed = data.is_expedited_shipping_allowed;
if (data.fiscal_year_start != null)
{
FYStartDate = ( DateTime )data.fiscal_year_start;
}
if (data.price == null)
{
Price = 0;
}
else
{
Price = ( decimal )data.price;
}
Active = data.active;
}
}
public bool UpdateRequisitionItem(decimal LOID, decimal PRODUCT, decimal PDQTY, decimal QTY, decimal UNIT, decimal PRICE, decimal DISCOUNT, decimal NORMALDISCOUNT, decimal NETPRICE, string BARCODE, string ISVAT, decimal RANK, string PRODUCTNAME, string UNITNAME)
{
RequisitionItemData data = new RequisitionItemData();
data.LOID = Convert.ToDouble(LOID);
data.DISCOUNT = Convert.ToDouble(NORMALDISCOUNT);
data.NETPRICE = Convert.ToDouble(NETPRICE);
data.PRICE = Convert.ToDouble(PRICE);
data.PRODUCT = Convert.ToDouble(PRODUCT);
data.QTY = Convert.ToDouble(QTY);
data.UNIT = Convert.ToDouble(UNIT);
data.BarCode = BARCODE;
data.ISVAT = ISVAT;
data.ProductName = PRODUCTNAME;
data.UnitName = UNITNAME;
bool ret = true;
ret = VerifyData(data);
if (ret)
{
DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
if (dt != null)
{
DataRow[] dRows = dt.Select("LOID = " + data.LOID.ToString());
DataRow dRow = dRows[0];
dRow["PRODUCT"] = data.PRODUCT;
dRow["QTY"] = data.QTY;
dRow["UNIT"] = data.UNIT;
dRow["PRICE"] = data.PRICE;
dRow["NORMALDISCOUNT"] = data.DISCOUNT;
dRow["DISCOUNT"] = data.DISCOUNT;
dRow["NETPRICE"] = Convert.ToDouble(data.NETPRICE);
dRow["BARCODE"] = data.BarCode;
dRow["UNITNAME"] = data.UnitName;
dRow["ISVAT"] = data.ISVAT;
dRow["PRODUCTNAME"] = data.ProductName;
ReOrder(dt);
System.Web.HttpContext.Current.Session[sessionName] = dt;
}
}
else
throw new ApplicationException(_error);
return ret;
}
private bool IsDuplicate(RequisitionItemData data)
{
bool ret = false;
DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
if (dt != null)
{
SaleFlow sFlow = new SaleFlow();
foreach (DataRow dRow in dt.Rows)
{
if (Convert.ToDouble(dRow["PRODUCT"]) == data.PRODUCT && Convert.ToDouble(dRow["LOID"]) != data.LOID)
{
dRow["QTY"] = Convert.ToDouble(dRow["QTY"]) + data.QTY;
dRow["NETPRICE"] = sFlow.CalcucateProductTotalItem(Convert.ToDouble(dRow["PRICE"]), Convert.ToDouble(dRow["QTY"]), 0);
ret = true;
break;
}
}
if (ret)
{
DataRow[] dRow = dt.Select("LOID = " + data.LOID.ToString());
if (dRow != null)
{
if (dRow.Length > 0)
{
dt.Rows.Remove(dRow[0]);
ReOrder(dt);
}
}
System.Web.HttpContext.Current.Session[sessionName] = dt;
}
}
return ret;
}
public bool UpdateRequisitionItem(decimal LOID, decimal PRODUCT, decimal QTY, decimal UNIT, DateTime DUEDATE, string BARCODE, decimal RANK)
{
RequisitionItemData data = new RequisitionItemData();
data.LOID = Convert.ToDouble(LOID);
//data.DISCOUNT = Convert.ToDouble(DISCOUNT);
//data.NETPRICE = Convert.ToDouble(NETPRICE);
//data.PRICE = Convert.ToDouble(PRICE);
data.DUEDATE = DUEDATE;
data.PRODUCT = Convert.ToDouble(PRODUCT);
data.QTY = Convert.ToDouble(QTY);
data.UNIT = Convert.ToDouble(UNIT);
bool ret = true;
ret = VerifyData(data);
if (ret)
{
DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
if (dt != null)
{
DataRow[] dRows = dt.Select("LOID = " + data.LOID.ToString());
DataRow dRow = dRows[0];
dRow["PRODUCT"] = data.PRODUCT;
dRow["QTY"] = data.QTY;
dRow["UNIT"] = data.UNIT;
ProductSearchData product = FlowObj.GetProductBarcode(data.PRODUCT);
//data.PRICE = product.PRICE;
//dRow["PRICE"] = data.PRICE;
//dRow["DISCOUNT"] = data.DISCOUNT;
//dRow["NETPRICE"] = Convert.ToDouble((data.QUANTITY * data.PRICE) - data.DISCOUNT);
dRow["BARCODE"] = product.BARCODE;
//dRow["UNIT"] = FlowObj.GetUnitData(data.UNIT).NAME;
dRow["DUEDATE"] = data.DUEDATE;
//dRow["ISVAT"] = product.ISVAT;
ReOrder(dt);
System.Web.HttpContext.Current.Session[sessionName] = dt;
}
}
else throw new ApplicationException(_error);
return ret;
}
public void Save(string uid)
{
try
{
RequisitionItem Original = null;
Enums.HistoryType ChangeType;
Dictionary <string, string> ValErrors = Validate();
if (ValErrors.Count > 0)
{
throw new RequisitionNotValidException("The requested item is not valid.", ValErrors);
}
using (PurchasingContext Context = ContextHelper.GetDBContext())
{
RequisitionItemData data;
if (ItemID > 0)
{
data = Context.RequisitionItemDatas.FirstOrDefault(x => x.requisition_item_id == ItemID);
ChangeType = HistoryType.UPDATE;
Original = new RequisitionItem(data);
}
else
{
data = new RequisitionItemData();
data.created_by = uid;
data.date_created = DateTime.Now;
ChangeType = HistoryType.ADD;
}
data.date_modified = DateTime.Now;
data.modified_by = uid;
data.requisition_id = RequisitionID;
data.quantity = Quantity;
data.description = Description;
if (DateNeeded != DateTime.MinValue)
{
data.date_needed = DateNeeded;
}
if (!String.IsNullOrEmpty(ItemNumber))
{
data.item_number = ItemNumber;
}
else
{
data.item_number = null;
}
data.company_id = CompanyID;
data.fund_id = FundID;
data.department_id = DepartmentID;
data.account_id = AccountID;
data.active = Active;
data.fiscal_year_start = FYStartDate;
data.is_expedited_shipping_allowed = IsExpeditiedShippingAllowed;
if (Price != 0)
{
data.price = Price;
}
else
{
data.price = null;
}
if (ItemID == 0)
{
Context.RequisitionItemDatas.InsertOnSubmit(data);
}
Context.SubmitChanges();
Load(data);
SaveHistory(ChangeType, Original, uid);
}
}
catch (Exception ex)
{
throw new RequisitionException("An error has occurred while saving requisition item.", ex);
}
}
protected void grvItem_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Insert")
{
DropDownList cmbProduct = (DropDownList)this.grvItem.FooterRow.Cells[3].FindControl("cmbNewProduct");
TextBox txtQty = (TextBox)this.grvItem.FooterRow.Cells[6].FindControl("txtNewQty");
DropDownList cmbUnit = (DropDownList)this.grvItem.FooterRow.Cells[7].FindControl("cmbNewUnit");
DropDownList cmbLot = (DropDownList)this.grvItem.FooterRow.Cells[4].FindControl("cmbNewLot");
TextBox txtPrice = (TextBox)this.grvItem.FooterRow.Cells[8].FindControl("txtNewPrice");
TextBox txtInvNo = (TextBox)this.grvItem.FooterRow.Cells[5].FindControl("txtNewInvNo");
TextBox txtNetPrice = (TextBox)this.grvItem.FooterRow.Cells[9].FindControl("txtNewNetPrice");
RequisitionItemData data = new RequisitionItemData();
data.ACTIVE = Constz.ActiveStatus.Active;
data.DISCOUNT = 0;
data.PRICE = Convert.ToDouble(txtPrice.Text);
data.PRODUCT = Convert.ToDouble(cmbProduct.SelectedItem.Value);
data.INVNO = txtInvNo.Text.Trim();
data.QTY = Convert.ToDouble(txtQty.Text == "" ? "0" : txtQty.Text);
data.UNIT = Convert.ToDouble(cmbUnit.SelectedItem.Value);
data.LOTNO = cmbLot.SelectedItem.Value;
data.NETPRICE = data.QTY * data.PRICE;
if (ItemObj.InsertStockOutItem(data))
{
SetGrvItem(this.txtStatus.Text);
Calculation();
}
else
Appz.ClientAlert(this, ItemObj.ErrorMessage);
}
}
public bool InsertRequisitionItem(string userID, RequisitionItemData data)
{
bool ret = true;
V_SUPPORT_LIST_DAL v_spport_listt_dal = new V_SUPPORT_LIST_DAL();
ret = v_spport_listt_dal.InsertRequsitionItemData(userID.ToString(), data);
if (ret != true)
{
_error = v_spport_listt_dal.ErrorMessage;
return ret;
}
else
return ret;
}
public bool CopyRequisition(string userID, double loidSource)
{
ProductOrderData data = GetData(loidSource);
DataTable itemList = GetRequisitionItem(data.LOID);
ArrayList arr = new ArrayList();
foreach (DataRow dRow in itemList.Rows)
{
RequisitionItemData idata = new RequisitionItemData();
idata.ACTIVE = dRow["ACTIVE"].ToString();
//idata.DISCOUNT = Convert.ToDouble(dRow["DISCOUNT"]);
idata.DUEDATE = Convert.ToDateTime(dRow["DUEDATE"]);
//idata.NETPRICE = Convert.ToDouble(dRow["NETPRICE"]);
//idata.PRICE = Convert.ToDouble(dRow["PRICE"]);
idata.PRODUCT = Convert.ToDouble(dRow["PRODUCT"]);
idata.QTY = Convert.ToDouble(dRow["QTY"]);
idata.UNIT = Convert.ToDouble(dRow["UNIT"]);
arr.Add(idata);
}
data.ITEM = arr;
DALObj.OnDB = false;
data.LOID = 0;
data.CODE = "";
data.REQDATE = DateTime.Today;
data.STATUS = Constz.Requisition.Status.Waiting.Code;
data.ACTIVE = Constz.ActiveStatus.Active;
return UpdateData(userID, data);
}
private bool VerifyData(RequisitionItemData data)
{
bool ret = true;
if (data.PRODUCT == 0)
{
ret = false;
_error = "¡ÃسÒàÅ×Í¡ÊÔ¹¤éÒ";
}
else if (data.QTY == 0)
{
ret = false;
_error = "¡ÃسÒÃкبӹǹ";
}
else if (data.LOTNO == "")
{
ret = false;
_error = "¡ÃسÒÃÐºØ Lot";
}
else if (data.QTY > 0)
{
double STOCK = FlowObj.GetQTYStock(data.LOTNO, data.PRODUCT,warehouse);
if (data.QTY > STOCK)
{
_error = "¨Ó¹Ç¹ÊÔ¹¤éÒ/Çѵ¶Ø´Ôº µéͧäÁèà¡Ô¹¨Ó¹Ç¹·ÕèÁÕã¹ Stock";
ret = false;
}
}
if (data.PRODUCT > 0)
{
DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
foreach (DataRow dRow in dt.Rows)
{
if (Convert.ToDouble(dRow["PRODUCT"]) == data.PRODUCT && Convert.ToDouble(dRow["LOID"]) != data.LOID && dRow["LOTNO"].ToString() == data.LOTNO)
{
_error = "ÃÒ¡ÒÃÊÔ¹¤éÒã¹ Lot ¹ÕéÁÕÍÂÙèã¹ÃÒ¡ÒÃáÅéÇ";
ret = false;
goto ex;
}
}
ex: ;
}
return ret;
}
public ArrayList GetItemList()
{
DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
ArrayList arr = new ArrayList();
if (dt != null)
{
foreach (DataRow dRow in dt.Rows)
{
RequisitionItemData data = new RequisitionItemData();
data.ACTIVE = Constz.ActiveStatus.Active;
data.DISCOUNT = Convert.ToDouble(dRow["DISCOUNT"]);
data.LOID = Convert.ToDouble(dRow["LOID"]);
data.PRICE = Convert.ToDouble(dRow["PRICE"]);
data.PRODUCT = Convert.ToDouble(dRow["PRODUCT"]);
data.QTY = Convert.ToDouble(dRow["QTY"]);
data.NETPRICE = (data.PRICE - data.DISCOUNT) * data.QTY;
data.UNIT = Convert.ToDouble(dRow["UNIT"]);
data.ISVAT = dRow["ISVAT"].ToString();
if (data.QTY >0) arr.Add(data);
}
}
return arr;
}
public bool InsertRequsitionItemData(string userID, RequisitionItemData data)
{
Boolean ret = true;
RequisitionItemDAL oDAL = new RequisitionItemDAL();
oDAL.REQUISITION = Convert.ToDouble(data.REQUISITION);
oDAL.PRODUCT = Convert.ToDouble(data.PRODUCT);
oDAL.UNIT = Convert.ToDouble(data.UNIT);
oDAL.PRICE = Convert.ToDouble(data.PRICE);
oDAL.QTY = Convert.ToDouble(data.QTY);
oDAL.NETPRICE = Convert.ToDouble(data.NETPRICE);
oDAL.DISCOUNT = Convert.ToDouble(data.DISCOUNT);
oDAL.ACTIVE = data.ACTIVE.ToString();
ret = oDAL.InsertCurrentData(userID, null);
if (ret == false)
_error = oDAL.ErrorMessage;
return ret;
}
public PointOfSaleData GetData(double loid)
{
PointOfSaleData data = new PointOfSaleData();
if (DALObj.GetDataByLOID(loid, null))
{
data.INVCODE = DALObj.INVCODE;
data.CODE = DALObj.CODE;
data.ACTIVE = DALObj.ACTIVE;
data.CASH = DALObj.CASH;
data.COUPON = DALObj.COUPON;
data.CREDITCARDID = DALObj.CREDITCARDID;
data.CREDITCARDPAY = DALObj.CREDITCARDPAY;
data.CREDITTYPE = DALObj.CREDITTYPE;
data.CUSTOMER = DALObj.CUSTOMER;
data.GRANDTOT = DALObj.GRANDTOT;
data.REFLOID = DALObj.REFLOID;
data.REFNO = DALObj.REFNO;
data.REFTABLE = DALObj.REFTABLE;
data.STATUS = DALObj.STATUS;
data.TOTAL = DALObj.TOTAL;
data.TOTDIS = DALObj.TOTDIS;
data.TOTVAT = DALObj.TOTVAT;
data.VAT = DALObj.VAT;
data.WAREHOUSE = DALObj.WAREHOUSE;
data.REQDATE = DALObj.REQDATE;
data.CREATEBY = DALObj.CREATEBY;
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
DataTable dt = GetRequisitionItem(loid);
foreach (DataRow dRow in dt.Rows)
{
RequisitionItemData itemData = new RequisitionItemData();
itemData.BarCode = dRow["BARCODE"].ToString();
itemData.DISCOUNT = Convert.ToDouble(dRow["DISCOUNT"]);
itemData.ISVAT = dRow["ISVAT"].ToString();
itemData.NETPRICE = Convert.ToDouble(dRow["NETPRICE"]);
itemData.PRICE = Convert.ToDouble(dRow["PRICE"]);
itemData.PRODUCT = Convert.ToDouble(dRow["PRODUCT"]);
itemData.QTY = Convert.ToDouble(dRow["QTY"]);
itemData.ProductName = dRow["NAME"].ToString();
data.REQUISITIONITEM.Add(itemData);
}
}
return data;
}
public double UpdateRequsitionItemData(string UserID, RequisitionItemData data)
{
Boolean ret = true;
RequisitionItemDAL oDAL = new RequisitionItemDAL();
oDAL.GetDataByLOID(data.LOID, null);
oDAL.QTY = Convert.ToDouble(data.QTY);
oDAL.NETPRICE = Convert.ToDouble(data.NETPRICE);
oDAL.DISCOUNT = Convert.ToDouble(data.DISCOUNT);
ret = oDAL.UpdateCurrentData(UserID, null);
if (ret == false)
{
_error = oDAL.ErrorMessage;
return 0;
}
else
return oDAL.LOID;
}
protected void grvItem_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow gRow = this.grvItem.Rows[e.RowIndex];
DropDownList cmbProduct = (DropDownList)gRow.Cells[indexPRODUCT].FindControl("cmbProduct");
TextBox txtBarcode = (TextBox)gRow.Cells[indexBARCODE].FindControl("txtBarcode");
TextBox txtQty = (TextBox)gRow.Cells[indexQTY].FindControl("txtQty");
Label lblUnit = (Label)gRow.Cells[indexUNIT].FindControl("lblUnit");
TextBox txtUnit = (TextBox)gRow.Cells[indexUNIT].FindControl("txtUnit");
TextBox txtPrice = (TextBox)gRow.Cells[indexPRICE].FindControl("txtPrice");
TextBox txtNetPrice = (TextBox)gRow.Cells[indexNETPRICE].FindControl("txtNetPrice");
Label lblNormalDiscount = (Label)gRow.Cells[indexNORMALDISCOUNT].FindControl("lblNormalDiscount");
Label lblIsVat = (Label)gRow.Cells[indexISVAT].FindControl("lblIsVat");
RequisitionItemData data = new RequisitionItemData();
data.ACTIVE = Constz.ActiveStatus.Active;
data.PRICE = Convert.ToDouble(txtPrice.Text);
data.PRODUCT = Convert.ToDouble(cmbProduct.SelectedItem.Value);
data.ProductName = cmbProduct.SelectedItem.Text;
data.DISCOUNT = Convert.ToDouble(lblNormalDiscount.Text == "" ? "0" : lblNormalDiscount.Text);
data.QTY = Convert.ToDouble(txtQty.Text == "" ? "0" : txtQty.Text);
data.UNIT = Convert.ToDouble(txtUnit.Text == "" ? "0" : txtUnit.Text);
data.UnitName = lblUnit.Text.Trim();
data.NETPRICE = Convert.ToDouble(txtNetPrice.Text == "" ? "0" : txtNetPrice.Text);
data.ISVAT = lblIsVat.Text.Trim();
data.BarCode = txtBarcode.Text.Trim();
e.NewValues["LOID"] = (this.grvItem.Rows[e.RowIndex].Cells[indexLOID].Text == "" ? "0" : this.grvItem.Rows[e.RowIndex].Cells[indexLOID].Text);
e.NewValues["PRODUCT"] = data.PRODUCT.ToString();
e.NewValues["QTY"] = data.QTY.ToString();
e.NewValues["UNIT"] = data.UNIT.ToString();
e.NewValues["PRICE"] = data.PRICE.ToString();
e.NewValues["NORMALDISCOUNT"] = data.DISCOUNT.ToString();
e.NewValues["NETPRICE"] = data.NETPRICE.ToString();
e.NewValues["ISVAT"] = data.ISVAT;
e.NewValues["BARCODE"] = data.BarCode;
e.NewValues["RANK"] = 0;
e.NewValues["PRODUCTNAME"] = data.ProductName;
e.NewValues["UNITNAME"] = data.UnitName;
}
private void InsertData(GridViewRow gRow)
{
DropDownList cmbProduct = (DropDownList)gRow.Cells[indexPRODUCT].FindControl("cmbNewProduct");
TextBox txtBarcode = (TextBox)gRow.Cells[indexBARCODE].FindControl("txtNewBarcode");
TextBox txtQty = (TextBox)gRow.Cells[indexQTY].FindControl("txtNewQty");
Label lblUnit = (Label)gRow.Cells[indexUNIT].FindControl("lblNewUnit");
TextBox txtUnit = (TextBox)gRow.Cells[indexUNIT].FindControl("txtNewUnit");
TextBox txtPrice = (TextBox)gRow.Cells[indexPRICE].FindControl("txtNewPrice");
TextBox txtNetPrice = (TextBox)gRow.Cells[indexNETPRICE].FindControl("txtNewNetPrice");
Label lblNormalDiscount = (Label)gRow.Cells[indexNORMALDISCOUNT].FindControl("lblNewNormalDiscount");
Label lblIsVat = (Label)gRow.Cells[indexISVAT].FindControl("lblNewIsVat");
RequisitionItemData data = new RequisitionItemData();
data.ACTIVE = Constz.ActiveStatus.Active;
data.DISCOUNT = Convert.ToDouble(lblNormalDiscount.Text == "" ? "0" : lblNormalDiscount.Text);
data.PRICE = Convert.ToDouble(txtPrice.Text);
data.PRODUCT = Convert.ToDouble(cmbProduct.SelectedItem.Value);
data.ProductName = cmbProduct.SelectedItem.Text;
data.QTY = Convert.ToDouble(txtQty.Text == "" ? "0" : txtQty.Text);
data.UNIT = Convert.ToDouble(txtUnit.Text == "" ? "0" : txtUnit.Text);
data.UnitName = lblUnit.Text.Trim();
data.NETPRICE = Convert.ToDouble(txtNetPrice.Text); ;
data.BarCode = txtBarcode.Text;
data.ISVAT = lblIsVat.Text;
if (ItemObj.InsertRequisitionItem(data))
{
SetGrvItem(this.txtStatus.Text);
CalculateDiscount();
}
else
Appz.ClientAlert(this, ItemObj.ErrorMessage);
}
private bool VerifyData(RequisitionItemData data)
{
bool ret = true;
if (data.PRODUCT == 0)
{
ret = false;
_error = "¡ÃسÒàÅ×Í¡ÊÔ¹¤éÒ";
}
else if (data.QTY == 0)
{
ret = false;
_error = "¡ÃسÒÃкبӹǹ";
}
else
{
DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
foreach (DataRow dRow in dt.Rows)
{
if (Convert.ToDouble(dRow["PRODUCT"]) == data.PRODUCT && Convert.ToDouble(dRow["LOID"]) != data.LOID)
{
_error = "ÃÒ¡ÒÃÊÔ¹¤éÒ¹ÕéÁÕÍÂÙèã¹ÃÒ¡ÒÃáÅéÇ";
ret = false;
goto ex;
}
}
ex: ;
}
return ret;
}
protected void grvItem_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
DropDownList cmbProduct = (DropDownList)this.grvItem.Rows[e.RowIndex].Cells[3].FindControl("cmbProduct");
TextBox txtQty = (TextBox)this.grvItem.Rows[e.RowIndex].Cells[4].FindControl("txtQty");
DropDownList cmbUnit = (DropDownList)this.grvItem.Rows[e.RowIndex].Cells[5].FindControl("cmbUnit");
Controls_DatePickerControl txtDate = (Controls_DatePickerControl)this.grvItem.Rows[e.RowIndex].Cells[6].FindControl("txtDate");
RequisitionItemData data = new RequisitionItemData();
data.ACTIVE = Constz.ActiveStatus.Active;
data.PRODUCT = Convert.ToDouble(cmbProduct.SelectedItem.Value);
data.QTY = Convert.ToDouble(txtQty.Text == "" ? "0" : txtQty.Text);
data.UNIT = Convert.ToDouble(cmbUnit.SelectedItem.Value);
data.DUEDATE = txtDate.DateValue;
e.NewValues["LOID"] = this.grvItem.Rows[e.RowIndex].Cells[8].Text;
e.NewValues["PRODUCT"] = data.PRODUCT.ToString();
e.NewValues["QTY"] = data.QTY.ToString();
e.NewValues["UNIT"] = data.UNIT.ToString();
e.NewValues["DUEDATE"] = data.DUEDATE;
}
//0 LOID, 0 PRODUCT, 0 QTY, 0 UNIT, 0 PRICE, 0 DISCOUNT, 0 NETPRICE, '" + Constz.ActiveStatus.Active + "' ACTIVE, '' BARCODE, '' UNITNAME, '' ISVAT ";
public bool InsertRequisitionItem(RequisitionItemData data)
{
bool ret = true;
ret = VerifyData(data);
if (ret)
{
DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
if (dt != null)
{
DataRow dRow = dt.NewRow();
dRow["LOID"] = Convert.ToDouble(dt.Rows.Count) + 1;
dRow["RANK"] = Convert.ToDouble(dRow["LOID"]);
dRow["PRODUCT"] = Convert.ToDouble(data.PRODUCT);
dRow["QTY"] = Convert.ToDouble(data.QTY);
dRow["UNIT"] = Convert.ToDouble(data.UNIT);
dRow["PRICE"] = Convert.ToDouble(data.PRICE);
dRow["NORMALDISCOUNT"] = Convert.ToDouble(data.DISCOUNT);
dRow["DISCOUNT"] = Convert.ToDouble(data.DISCOUNT);
dRow["NETPRICE"] = Convert.ToDouble(data.NETPRICE);
//dRow["ACTIVE"] = Constz.ActiveStatus.Active;
dRow["BARCODE"] = data.BarCode;
dRow["UNITNAME"] = data.UnitName;
dRow["ISVAT"] = data.ISVAT;
dRow["PRODUCTNAME"] = data.ProductName;
dt.Rows.Add(dRow);
System.Web.HttpContext.Current.Session[sessionName] = dt;
}
}
return ret;
}
public double UpdateRequisitionItem(string userID, RequisitionItemData data)
{
double ret = 0;
V_SUPPORT_LIST_DAL v_spport_listt_dal = new V_SUPPORT_LIST_DAL();
ret = v_spport_listt_dal.UpdateRequsitionItemData(userID.ToString(), data);
if (ret == 0)
{
_error = v_spport_listt_dal.ErrorMessage;
return 0;
}
else
return ret;
}
private void InsertData(GridViewRow gRow)
{
DropDownList cmbProduct = (DropDownList)gRow.Cells[3].FindControl("cmbNewProduct");
TextBox txtQty = (TextBox)gRow.Cells[4].FindControl("txtNewQty");
DropDownList cmbUnit = (DropDownList)gRow.Cells[5].FindControl("cmbNewUnit");
RequisitionItemData data = new RequisitionItemData();
data.ACTIVE = Constz.ActiveStatus.Active;
data.DISCOUNT = 0;
data.PRICE = 0;
data.PRODUCT = Convert.ToDouble(cmbProduct.SelectedItem.Value);
data.QTY = Convert.ToDouble(txtQty.Text == "" ? "0" : txtQty.Text);
data.UNIT = Convert.ToDouble(cmbUnit.SelectedValue);
data.NETPRICE = data.QTY * data.PRICE;
data.DUEDATE = ((Controls_DatePickerControl)gRow.Cells[6].FindControl("txtNewDate")).DateValue;
if (ItemObj.InsertRequisitionItem(data))
{
SetGrvItem(this.txtStatus.Text);
}
else
Appz.ClientAlert(this, ItemObj.ErrorMessage);
}
public RequisitionData GetData(double loid)
{
RequisitionData data = new RequisitionData();
if (DALObj.GetDataByLOID(loid, null))
{
data.CODE = DALObj.CODE;
data.ACTIVE = DALObj.ACTIVE;
data.CUSTOMER = DALObj.CUSTOMER;
data.GRANDTOT = DALObj.GRANDTOT;
data.STATUS = DALObj.STATUS;
data.TOTAL = DALObj.TOTAL;
data.TOTDIS = DALObj.TOTDIS;
data.TOTVAT = DALObj.TOTVAT;
data.VAT = DALObj.VAT;
data.WAREHOUSE = DALObj.WAREHOUSE;
data.RESERVEDATE = DALObj.RESERVEDATE;
data.CREATEBY = DALObj.CREATEBY;
data.REASON = DALObj.REASON;
data.REMARK = DALObj.REMARK;
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
DataTable dt = GetRequisitionItem(loid);
foreach (DataRow dRow in dt.Rows)
{
RequisitionItemData itemData = new RequisitionItemData();
itemData.BarCode = dRow["BARCODE"].ToString();
itemData.DISCOUNT = Convert.ToDouble(dRow["DISCOUNT"]);
itemData.ISVAT = dRow["ISVAT"].ToString();
itemData.NETPRICE = Convert.ToDouble(dRow["NETPRICE"]);
itemData.PRICE = Convert.ToDouble(dRow["PRICE"]);
itemData.PRODUCT = Convert.ToDouble(dRow["PRODUCT"]);
itemData.QTY = Convert.ToDouble(dRow["QTY"]);
itemData.ProductName = dRow["NAME"].ToString();
itemData.UNIT = Convert.ToDouble(dRow["UNIT"]);
itemData.UnitName = dRow["UNITNAME"].ToString();
data.REQUISITIONITEM.Add(itemData);
}
}
return data;
}
private PointOfSaleData GetData()
{
PointOfSaleData data = new PointOfSaleData();
data.ACTIVE = Constz.ActiveStatus.Active;
data.CASH = Convert.ToDouble(this.txtCash.Text == "" ? "0" : this.txtCash.Text);
data.CODE = this.lblCode.Text.Trim();
data.COUPON = Convert.ToDouble(this.txtCoupon.Text == "" ? "0" : this.txtCoupon.Text);
data.CREDITCARDID = this.txtCreditCardID.Text.Trim();
data.CREDITCARDPAY = Convert.ToDouble(this.txtCreditCardPay.Text == "" ? "0" : this.txtCreditCardPay.Text);
data.CREDITTYPE = Convert.ToDouble(this.txtCreditCardType.Text == "" ? "0" : this.txtCreditCardType.Text);
data.CUSTOMER = Convert.ToDouble(this.txtCustomer.Text == "" ? "0" : this.txtCustomer.Text);
data.GRANDTOT = Convert.ToDouble(this.txtGrandTotal.Text == "" ? "0" : this.txtGrandTotal.Text);
data.INVCODE = data.CODE;
data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text);
data.REFLOID = Convert.ToDouble(this.txtRefLOID.Text == "" ? "0" : this.txtRefLOID.Text);
data.REFNO = this.txtRefCode.Text.Trim();
data.REFTABLE = "REQUISITION";
data.STATUS = Constz.Requisition.Status.Approved.Code;
data.TOTAL = Convert.ToDouble(this.txtTotal.Text == "" ? "0" : this.txtTotal.Text);
data.TOTDIS = Convert.ToDouble(this.txtTotalDiscount.Text == "" ? "0" : this.txtTotalDiscount.Text);
data.TOTVAT = Convert.ToDouble(this.txtTotalVat.Text == "" ? "0" : this.txtTotalVat.Text);
data.VAT = Convert.ToDouble(this.txtVat.Text == "" ? "0" : this.txtVat.Text);
data.WAREHOUSE = Appz.CurrentUserData.Warehouse;
data.REQDATE = DateTime.Now;
data.USEMEMBERDISCOUNT = (chkUseMemberDiscount.Checked ? Constz.UseMemberDiscount.Yes : Constz.UseMemberDiscount.No);
foreach (DataGridViewRow gRow in this.grvSales.Rows)
{
RequisitionItemData itemData = new RequisitionItemData();
if (!gRow.IsNewRow)
{
itemData.ACTIVE = Constz.ActiveStatus.Active;
itemData.DISCOUNT = Convert.ToDouble(gRow.Cells[indexDISCOUNT].Value);
itemData.ISVAT = (Convert.ToBoolean(gRow.Cells[indexISVAT].Value) ? Constz.VAT.Included.Code : Constz.VAT.NotIncluded.Code);
itemData.NETPRICE = Convert.ToDouble(gRow.Cells[indexNETPRICE].Value);
itemData.PRICE = Convert.ToDouble(gRow.Cells[indexPRICE].Value);
itemData.PRODUCT = Convert.ToDouble(gRow.Cells[indexPRODUCT].Value);
itemData.QTY = Convert.ToDouble(gRow.Cells[indexQTY].Value);
itemData.UNIT = Convert.ToDouble(gRow.Cells[indexUNIT].Value);
data.REQUISITIONITEM.Add(itemData);
}
}
return data;
}
public ArrayList GetItemList()
{
DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
ArrayList arr = new ArrayList();
if (dt != null)
{
foreach (DataRow dRow in dt.Rows)
{
RequisitionItemData data = new RequisitionItemData();
data.ACTIVE = Constz.ActiveStatus.Active;
data.DISCOUNT = Convert.ToDouble(dRow["OLDDISCOUNT"]);
data.LOID = Convert.ToDouble(dRow["LOID"]);
data.PRICE = Convert.ToDouble(dRow["PRICE"]);
data.PRODUCT = Convert.ToDouble(dRow["PRODUCT"]);
data.QTY = Convert.ToDouble(dRow["QTY"]);
data.UNIT = Convert.ToDouble(dRow["UNIT"]);
data.REFLOID = Convert.ToDouble(dRow["REFLOID"]);
data.REFTABLE = "REQUISITIONITEM";
data.NETPRICE = data.QTY * (data.PRICE - data.DISCOUNT);
arr.Add(data);
}
}
return arr;
}
public RequisitionItem(RequisitionItemData d)
{
Load(d);
}
private void InsertData(GridViewRow gRow)
{
DropDownList cmbProduct = (DropDownList)gRow.Cells[3].FindControl("cmbNewProduct");
TextBox txtPDQty = (TextBox)gRow.Cells[4].FindControl("txtNewPDQty");
TextBox txtQty = (TextBox)gRow.Cells[5].FindControl("txtNewQty");
TextBox txtUnit = (TextBox)gRow.Cells[6].FindControl("txtNewUnit");
TextBox txtPrice = (TextBox)gRow.Cells[7].FindControl("txtNewPrice");
TextBox txtNetPrice = (TextBox)gRow.Cells[8].FindControl("txtNewNetPrice");
RequisitionItemData data = new RequisitionItemData();
data.ACTIVE = Constz.ActiveStatus.Active;
data.DISCOUNT = 0;
data.PRICE = Convert.ToDouble(txtPrice.Text);
data.PRODUCT = Convert.ToDouble(cmbProduct.SelectedItem.Value);
data.QTY = Convert.ToDouble(txtQty.Text == "" ? "0" : txtQty.Text);
data.PDQTY = Convert.ToDouble(txtPDQty.Text);
data.UnitName = txtUnit.Text;
data.NETPRICE = data.QTY * data.PRICE;
data.UNIT = Convert.ToDouble(gRow.Cells[16].Text);
if (ItemObj.InsertRequisitionItem(data))
{
SetGrvItem(this.txtStatus.Text);
Calculation();
}
else
Appz.ClientAlert(this, ItemObj.ErrorMessage);
}
private RequisitionData GetData()
{
RequisitionData data = new RequisitionData();
data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text);
data.ACTIVE = Constz.ActiveStatus.Active;
data.CODE = this.txtCode.Text.Trim();
data.CUSTOMER = Convert.ToDouble(this.txtCustomer.Text == "" ? "0" : this.txtCustomer.Text);
data.GRANDTOT = Convert.ToDouble(this.txtGrandTotal.Text == "" ? "0" : this.txtGrandTotal.Text);
data.STATUS = this.txtStatus.Text.Trim();
data.TOTAL = Convert.ToDouble(this.txtTotal.Text == "" ? "0" : this.txtTotal.Text);
data.TOTDIS = Convert.ToDouble(this.txtTotalDiscount.Text == "" ? "0" : this.txtTotalDiscount.Text);
data.TOTVAT = Convert.ToDouble(this.txtTotalVat.Text == "" ? "0" : this.txtTotalVat.Text);
data.VAT = Convert.ToDouble(this.txtVat.Text == "" ? "0" : this.txtVat.Text);
data.WAREHOUSE = Appz.CurrentUserData.Warehouse;
data.RESERVEDATE = dtpReserveDate.Value.Date;
data.REASON = this.txtReason.Text.Trim();
data.REMARK = this.txtRemark.Text.Trim();
foreach (DataGridViewRow gRow in this.grvSupport.Rows)
{
RequisitionItemData itemData = new RequisitionItemData();
if (!gRow.IsNewRow)
{
itemData.ACTIVE = Constz.ActiveStatus.Active;
itemData.DISCOUNT = Convert.ToDouble(gRow.Cells[indexDISCOUNT].Value);
itemData.ISVAT = (Convert.ToBoolean(gRow.Cells[indexISVAT].Value) ? Constz.VAT.Included.Code : Constz.VAT.NotIncluded.Code);
itemData.NETPRICE = Convert.ToDouble(gRow.Cells[indexNETPRICE].Value);
itemData.PRICE = Convert.ToDouble(gRow.Cells[indexPRICE].Value);
itemData.PRODUCT = Convert.ToDouble(gRow.Cells[indexPRODUCT].Value);
itemData.QTY = Convert.ToDouble(gRow.Cells[indexQTY].Value);
itemData.UNIT = Convert.ToDouble(gRow.Cells[indexUNIT].Value);
data.REQUISITIONITEM.Add(itemData);
}
}
return data;
}
//0 LOID, 0 PRODUCT, 0 QTY, 0 UNIT, 0 PRICE, 0 DISCOUNT, 0 NETPRICE, '" + Constz.ActiveStatus.Active + "' ACTIVE, '' BARCODE, '' UNITNAME, '' ISVAT ";
public bool InsertRequisitionItem(RequisitionItemData data)
{
bool ret = true;
ret = VerifyData(data);
if (ret)
{
DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
if (dt != null)
{
ReOrder(dt);
DataRow dRow = dt.NewRow();
dRow["LOID"] = Convert.ToDouble(dt.Rows.Count) + 1;
dRow["RANK"] = Convert.ToDouble(dRow["LOID"]);
dRow["PRODUCT"] = Convert.ToDouble(data.PRODUCT);
ProductSearchData product = FlowObj.GetProductBarcode(data.PRODUCT);
//data.PRICE = product.PRICE;
dRow["QTY"] = Convert.ToDouble(data.QTY);
dRow["UNIT"] = Convert.ToDouble(data.UNIT);
//dRow["PRICE"] = Convert.ToDouble(data.PRICE);
//dRow["DISCOUNT"] = Convert.ToDouble(data.DISCOUNT);
//dRow["NETPRICE"] = Convert.ToDouble((data.QUANTITY * data.PRICE) - data.DISCOUNT);
dRow["ACTIVE"] = Constz.ActiveStatus.Active;
dRow["BARCODE"] = product.BARCODE;
//dRow["UNIT"] = FlowObj.GetUnitData(data.UNIT).NAME;
//dRow["ISVAT"] = product.ISVAT;
dRow["DUEDATE"] = data.DUEDATE;
dt.Rows.Add(dRow);
System.Web.HttpContext.Current.Session[sessionName] = dt;
}
}
return ret;
}
protected void grvItem_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
DropDownList cmbProduct = (DropDownList)this.grvItem.Rows[e.RowIndex].Cells[3].FindControl("cmbProduct");
TextBox txtQty = (TextBox)this.grvItem.Rows[e.RowIndex].Cells[6].FindControl("txtQty");
DropDownList cmbUnit = (DropDownList)this.grvItem.Rows[e.RowIndex].Cells[7].FindControl("cmbUnit");
TextBox txtPrice = (TextBox)this.grvItem.Rows[e.RowIndex].Cells[8].FindControl("txtPrice");
DropDownList cmbLot = (DropDownList)this.grvItem.Rows[e.RowIndex].Cells[4].FindControl("cmbLot");
RequisitionItemData data = new RequisitionItemData();
data.ACTIVE = Constz.ActiveStatus.Active;
data.DISCOUNT = 0;
data.PRICE = Convert.ToDouble(txtPrice.Text);
data.PRODUCT = Convert.ToDouble(cmbProduct.SelectedItem.Value);
data.QTY = Convert.ToDouble(txtQty.Text == "" ? "0" : txtQty.Text);
data.UNIT = Convert.ToDouble(cmbUnit.SelectedItem.Value);
data.NETPRICE = data.QTY * data.PRICE;
data.LOTNO = cmbLot.SelectedItem.Value;
e.NewValues["LOID"] = this.grvItem.Rows[e.RowIndex].Cells[8].Text;
e.NewValues["PRODUCT"] = data.PRODUCT.ToString();
e.NewValues["QTY"] = data.QTY.ToString();
e.NewValues["UNIT"] = data.UNIT.ToString();
e.NewValues["PRICE"] = data.PRICE.ToString();
e.NewValues["DISCOUNT"] = "0";
e.NewValues["NETPRICE"] = data.NETPRICE.ToString();
e.NewValues["LOTNO"] = data.LOTNO.ToString();
}
private bool VerifyData(RequisitionItemData data)
{
bool ret = true;
if (data.PRODUCT == 0)
{
ret = false;
_error = "¡ÃسÒàÅ×Í¡ÊÔ¹¤éÒ";
}
else if (data.QTY == 0)
{
ret = false;
_error = "¡ÃسÒÃкبӹǹ";
}
return ret;
}
