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; }