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 bool UpdateData(string userID, PointOfSaleData data, bool setInvoice) { bool ret = true; if (ValidateData(data)) { OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { _dal = new RequisitionDAL(); DALObj.OnDB = false; DALObj.GetDataByLOID(data.LOID, obj.zTrans); DALObj.REQUISITIONTYPE = Constz.Requisition.RequisitionType.REQ13; DALObj.ACTIVE = data.ACTIVE; DALObj.CASH = data.CASH; DALObj.COUPON = data.COUPON; DALObj.CREDITCARDID = data.CREDITCARDID; DALObj.CREDITCARDPAY = data.CREDITCARDPAY; DALObj.CREDITTYPE = data.CREDITTYPE; DALObj.CUSTOMER = data.CUSTOMER; DALObj.GRANDTOT = data.GRANDTOT; DALObj.REFLOID = data.REFLOID; DALObj.REFNO = data.REFNO; DALObj.REFTABLE = data.REFTABLE; DALObj.STATUS = data.STATUS; DALObj.TOTAL = data.TOTAL; DALObj.TOTDIS = data.TOTDIS; DALObj.TOTVAT = data.TOTVAT; DALObj.VAT = data.VAT; DALObj.WAREHOUSE = data.WAREHOUSE; DALObj.REQDATE = data.REQDATE; if (setInvoice && DALObj.INVCODE != "") DALObj.INVCODE = OracleDB.GetRunningCode("REQUISITION_INVCODE", DALObj.REQUISITIONTYPE.ToString(), obj.zTrans); if (DALObj.OnDB) ret = DALObj.UpdateCurrentData(userID, obj.zTrans); else ret = DALObj.InsertCurrentData(userID, obj.zTrans); _LOID = DALObj.LOID; if (!ret) { throw new ApplicationException(DALObj.ErrorMessage); } RequisitionItemDAL itemDAL = new RequisitionItemDAL(); itemDAL.DeleteDataByRequisition(data.LOID, obj.zTrans); for (Int16 i = 0; i < data.REQUISITIONITEM.Count; ++i) { RequisitionItemData item = (RequisitionItemData)data.REQUISITIONITEM[i]; itemDAL.ACTIVE = item.ACTIVE; itemDAL.DISCOUNT = item.DISCOUNT; itemDAL.DUEDATE = item.DUEDATE; itemDAL.NETPRICE = item.NETPRICE; itemDAL.PRODUCT = item.PRODUCT; itemDAL.QTY = item.QTY; itemDAL.PRICE = item.PRICE; itemDAL.REQUISITION = DALObj.LOID; itemDAL.UNIT = item.UNIT; itemDAL.ISVAT = item.ISVAT; itemDAL.OnDB = false; ret = itemDAL.InsertCurrentData(userID, obj.zTrans); if (!ret) throw new ApplicationException(itemDAL.ErrorMessage); } ret = DALObj.CutStockRequisition(DALObj.LOID, userID, obj.zTrans); if (!ret) throw new ApplicationException(DALObj.ErrorMessage); obj.zTrans.Commit(); obj.CloseConnection(); } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); ret = false; _error = ex.Message; } } else ret = false; return ret; }
public bool ValidateData(PointOfSaleData data) { bool ret = true; if (data.CUSTOMER == 0) { ret = false; _error = "¡ÃسÒÃкØÅÙ¡¤éÒ"; } else if (data.REQUISITIONITEM.Count == 0) { ret = false; _error = "¡ÃسÒÃкØÃÒ¡ÒÃÊÔ¹¤éÒ"; } 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; }