public void UpdateReceiveStatus(long DebitMemoItemID, DebitMemoItemReceivedStatus DebitMemoItemReceivedStatus, decimal ReceivedQuantity)
{
try
{
string SQL = "UPDATE tblPODebitMemoItems SET " +
"DebitMemoItemReceivedStatus = @DebitMemoItemReceivedStatus, " +
"OriginalQuantity = Quantity, " +
"Quantity = @ReceivedQuantity " +
"WHERE DebitMemoItemID = @DebitMemoItemID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmDebitMemoItemReceivedStatus = new MySqlParameter("@DebitMemoItemReceivedStatus", MySqlDbType.Int16);
prmDebitMemoItemReceivedStatus.Value = DebitMemoItemReceivedStatus.ToString("d");
cmd.Parameters.Add(prmDebitMemoItemReceivedStatus);
MySqlParameter prmReceivedQuantity = new MySqlParameter("@ReceivedQuantity", MySqlDbType.Decimal);
prmReceivedQuantity.Value = ReceivedQuantity;
cmd.Parameters.Add(prmReceivedQuantity);
MySqlParameter prmDebitMemoItemID = new MySqlParameter("@DebitMemoItemID", MySqlDbType.Int64);
prmDebitMemoItemID.Value = DebitMemoItemID;
cmd.Parameters.Add(prmDebitMemoItemID);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void UpdateReceiveStatus(long DebitMemoItemID, DebitMemoItemReceivedStatus DebitMemoItemReceivedStatus, decimal ReceivedQuantity)
{
try
{
string SQL = "UPDATE tblPODebitMemoItems SET " +
"DebitMemoItemReceivedStatus = @DebitMemoItemReceivedStatus, " +
"OriginalQuantity = Quantity, " +
"Quantity = @ReceivedQuantity " +
"WHERE DebitMemoItemID = @DebitMemoItemID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmDebitMemoItemReceivedStatus = new MySqlParameter("@DebitMemoItemReceivedStatus",MySqlDbType.Int16);
prmDebitMemoItemReceivedStatus.Value = DebitMemoItemReceivedStatus.ToString("d");
cmd.Parameters.Add(prmDebitMemoItemReceivedStatus);
MySqlParameter prmReceivedQuantity = new MySqlParameter("@ReceivedQuantity",MySqlDbType.Decimal);
prmReceivedQuantity.Value = ReceivedQuantity;
cmd.Parameters.Add(prmReceivedQuantity);
MySqlParameter prmDebitMemoItemID = new MySqlParameter("@DebitMemoItemID",MySqlDbType.Int64);
prmDebitMemoItemID.Value = DebitMemoItemID;
cmd.Parameters.Add(prmDebitMemoItemID);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
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["DebitMemoItemID"].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 lblPODebitItemReceivedStatus = (Label)e.Item.FindControl("lblPODebitItemReceivedStatus");
DebitMemoItemReceivedStatus clsDebitMemoItemReceivedStatus = (DebitMemoItemReceivedStatus)Enum.Parse(typeof(DebitMemoItemReceivedStatus), dr["DebitMemoItemReceivedStatus"].ToString());
lblPODebitItemReceivedStatus.Text = clsDebitMemoItemReceivedStatus.ToString("d");
//For anchor
HtmlGenericControl divExpCollAsst = (HtmlGenericControl)e.Item.FindControl("divExpCollAsst");
HtmlAnchor anchorDown = (HtmlAnchor)e.Item.FindControl("anchorDown");
anchorDown.HRef = "javascript:ToggleDiv('" + divExpCollAsst.ClientID + "')";
}
}