public void UpdateReceiveStatus(long TransferOutItemID, TransferOutItemReceivedStatus TransferOutItemReceivedStatus, decimal ReceivedQuantity) { try { string SQL = "UPDATE tblTransferOutItems SET " + "TransferOutItemReceivedStatus = @TransferOutItemReceivedStatus, " + "OriginalQuantity = Quantity, " + "Quantity = @ReceivedQuantity " + "WHERE TransferOutItemID = @TransferOutItemID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmTransferOutItemReceivedStatus = new MySqlParameter("@TransferOutItemReceivedStatus", MySqlDbType.Int16); prmTransferOutItemReceivedStatus.Value = TransferOutItemReceivedStatus.ToString("d"); cmd.Parameters.Add(prmTransferOutItemReceivedStatus); MySqlParameter prmReceivedQuantity = new MySqlParameter("@ReceivedQuantity", MySqlDbType.Decimal); prmReceivedQuantity.Value = ReceivedQuantity; cmd.Parameters.Add(prmReceivedQuantity); MySqlParameter prmTransferOutItemID = new MySqlParameter("@TransferOutItemID", MySqlDbType.Int64); prmTransferOutItemID.Value = TransferOutItemID; cmd.Parameters.Add(prmTransferOutItemID); base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
private void lstItemFixCssClass() { foreach (DataListItem item in lstItem.Items) { Label lblitemTransferOutItemReceivedStatus = (Label)item.FindControl("lblTransferOutItemReceivedStatus"); TransferOutItemReceivedStatus itemTransferOutItemReceivedStatus = (TransferOutItemReceivedStatus)Enum.Parse(typeof(TransferOutItemReceivedStatus), lblitemTransferOutItemReceivedStatus.Text); if (itemTransferOutItemReceivedStatus == TransferOutItemReceivedStatus.Received) { item.CssClass = "ms-item-received-det"; } else if (item.ItemType == ListItemType.Item) { item.CssClass = ""; } else if (item.ItemType == ListItemType.AlternatingItem) { item.CssClass = "ms-alternating"; } } }
protected void lstItem_ItemDataBound(object sender, DataListItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataRowView dr = (DataRowView)e.Item.DataItem; HtmlInputCheckBox chkList = (HtmlInputCheckBox)e.Item.FindControl("chkList"); chkList.Value = dr["TransferOutItemID"].ToString(); HyperLink lnkDescription = (HyperLink)e.Item.FindControl("lnkDescription"); lnkDescription.Text = dr["Description"].ToString(); lnkDescription.NavigateUrl = Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/Default.aspx?task=" + Common.Encrypt("det", Session.SessionID) + "&id=" + Common.Encrypt(dr["ProductID"].ToString(), Session.SessionID); HyperLink lnkMatrixDescription = (HyperLink)e.Item.FindControl("lnkMatrixDescription"); if (dr["MatrixDescription"].ToString() == string.Empty || dr["MatrixDescription"].ToString() == null) { lnkMatrixDescription.Text = "_"; } else { lnkMatrixDescription.Text = dr["MatrixDescription"].ToString(); lnkMatrixDescription.NavigateUrl = Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_VariationsMatrix/Default.aspx?task=" + Common.Encrypt("det", Session.SessionID) + "&prodid=" + Common.Encrypt(dr["ProductID"].ToString(), Session.SessionID) + "&id=" + Common.Encrypt(dr["VariationMatrixID"].ToString(), Session.SessionID); } Label lblQuantity = (Label)e.Item.FindControl("lblQuantity"); lblQuantity.Text = Convert.ToDecimal(dr["Quantity"].ToString()).ToString("#,##0.#0"); Label lblProductUnitID = (Label)e.Item.FindControl("lblProductUnitID"); lblProductUnitID.Text = dr["ProductUnitID"].ToString(); Label lblProductUnitCode = (Label)e.Item.FindControl("lblProductUnitCode"); lblProductUnitCode.Text = dr["ProductUnitCode"].ToString(); Label lblUnitCost = (Label)e.Item.FindControl("lblUnitCost"); lblUnitCost.Text = Convert.ToDecimal(dr["UnitCost"].ToString()).ToString("#,##0.#0"); Label lblDiscountApplied = (Label)e.Item.FindControl("lblDiscountApplied"); lblDiscountApplied.Text = Convert.ToDecimal(dr["DiscountApplied"].ToString()).ToString("#,##0.#0"); DiscountTypes DiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), dr["DiscountType"].ToString()); if (DiscountType == DiscountTypes.Percentage) { Label lblPercent = (Label)e.Item.FindControl("lblPercent"); lblPercent.Visible = true; } Label lblAmount = (Label)e.Item.FindControl("lblAmount"); lblAmount.Text = Convert.ToDecimal(dr["Amount"].ToString()).ToString("#,##0.#0"); Label lblVAT = (Label)e.Item.FindControl("lblVAT"); lblVAT.Text = Convert.ToDecimal(dr["VAT"].ToString()).ToString("#,##0.#0"); Label lblEVAT = (Label)e.Item.FindControl("lblEVAT"); lblEVAT.Text = Convert.ToDecimal(dr["EVAT"].ToString()).ToString("#,##0.#0"); Label lblisVATInclusive = (Label)e.Item.FindControl("lblisVATInclusive"); lblisVATInclusive.Text = Convert.ToBoolean(Convert.ToInt16(dr["isVATInclusive"].ToString())).ToString(); Label lblLocalTax = (Label)e.Item.FindControl("lblLocalTax"); lblLocalTax.Text = Convert.ToDecimal(dr["LocalTax"].ToString()).ToString("#,##0.#0"); Label lblRemarks = (Label)e.Item.FindControl("lblRemarks"); lblRemarks.Text = dr["Remarks"].ToString(); Label lblTransferOutItemReceivedStatus = (Label)e.Item.FindControl("lblTransferOutItemReceivedStatus"); TransferOutItemReceivedStatus clsTransferOutItemReceivedStatus = (TransferOutItemReceivedStatus)Enum.Parse(typeof(TransferOutItemReceivedStatus), dr["TransferOutItemReceivedStatus"].ToString()); lblTransferOutItemReceivedStatus.Text = clsTransferOutItemReceivedStatus.ToString("d"); //For anchor HtmlGenericControl divExpCollAsst = (HtmlGenericControl)e.Item.FindControl("divExpCollAsst"); HtmlAnchor anchorDown = (HtmlAnchor)e.Item.FindControl("anchorDown"); anchorDown.HRef = "javascript:ToggleDiv('" + divExpCollAsst.ClientID + "')"; } }
public void UpdateReceiveStatus(long TransferOutItemID, TransferOutItemReceivedStatus TransferOutItemReceivedStatus, decimal ReceivedQuantity) { try { string SQL = "UPDATE tblTransferOutItems SET " + "TransferOutItemReceivedStatus = @TransferOutItemReceivedStatus, " + "OriginalQuantity = Quantity, " + "Quantity = @ReceivedQuantity " + "WHERE TransferOutItemID = @TransferOutItemID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmTransferOutItemReceivedStatus = new MySqlParameter("@TransferOutItemReceivedStatus",MySqlDbType.Int16); prmTransferOutItemReceivedStatus.Value = TransferOutItemReceivedStatus.ToString("d"); cmd.Parameters.Add(prmTransferOutItemReceivedStatus); MySqlParameter prmReceivedQuantity = new MySqlParameter("@ReceivedQuantity",MySqlDbType.Decimal); prmReceivedQuantity.Value = ReceivedQuantity; cmd.Parameters.Add(prmReceivedQuantity); MySqlParameter prmTransferOutItemID = new MySqlParameter("@TransferOutItemID",MySqlDbType.Int64); prmTransferOutItemID.Value = TransferOutItemID; cmd.Parameters.Add(prmTransferOutItemID); base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
private void UpdateItemReceiveStatus(long TransferOutItemID, TransferOutItemReceivedStatus clsTransferOutItemReceivedStatus, decimal ReceivedQuantity) { TransferOutItem clsTransferOutItem = new TransferOutItem(); clsTransferOutItem.UpdateReceiveStatus(TransferOutItemID, clsTransferOutItemReceivedStatus, ReceivedQuantity); clsTransferOutItem.CommitAndDispose(); }