protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e)
{
cmdMode = CommandMode.D;
objPurchaseOrderItem = new Store.PurchaseOrderItem.BusinessObject.PurchaseOrderItem();
oblPurchaseOrderItem = new Store.PurchaseOrderItem.BusinessLogic.PurchaseOrderItem();
try
{
ImageButton btndetails = sender as ImageButton;
GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer;
objPurchaseOrderItem.PurchaseOrderItemID = Convert.ToInt32(dgvPurchaseItemOrder.DataKeys[gvrow.RowIndex].Value.ToString());
objPurchaseOrderItem.PurchaseOrderID = 0;
objPurchaseOrderItem.PurchaseOrderID = 0;
objPurchaseOrderItem.ItemID = 0;
objPurchaseOrderItem.ItemUnit = "";
objPurchaseOrderItem.Description = "";
objPurchaseOrderItem.ItemPrice = 0;
objPurchaseOrderItem.ClientID = 0;
objPurchaseOrderItem.CreatedBy = 1;
objMessageInfo = oblPurchaseOrderItem.ManageItemMaster(objPurchaseOrderItem, cmdMode);
BindPurchaseOrderItem();
updatePurchasedItemOrderBdInfo.Update();
}
catch (Exception ex)
{
throw;
}
finally
{
objPurchaseOrderItem = null;
objMessageInfo = null;
oblPurchaseOrderItem = null;
}
}
protected void imgbtn_Click(object sender, ImageClickEventArgs e)
{
ResetForm();
objPurchaseOrderItem = new Store.PurchaseOrderItem.BusinessObject.PurchaseOrderItem();
ImageButton btndetails = sender as ImageButton;
GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer;
txtPurchaseItemOrderID.Text = dgvPurchaseItemOrder.DataKeys[gvrow.RowIndex].Value.ToString();
ddlPurchaseOrderId.SelectedItem.Selected = false;
ddlPurchaseOrderId.Items.FindByText(gvrow.Cells[0].Text.ToString()).Selected = true;
ddlItemId.SelectedItem.Selected = false;
ddlItemId.Items.FindByText(gvrow.Cells[1].Text.ToString()).Selected = true;
txtItemUnit.Text = gvrow.Cells[2].Text;
txtDescription.Text = gvrow.Cells[3].Text;
txtItemPrice.Text = gvrow.Cells[4].Text;
int i = Convert.ToInt32(gvrow.Cells[5].Text);
if (i == 1)
{
chkBoxIsActive.Checked = true;
}
else
{
chkBoxIsActive.Checked = false;
}
updatePurchasedItemOrderBdInfo.Update();
this.ModalPopupExtender1.Show();
cmdMode = CommandMode.M;
}
public Store.PurchaseOrderItem.BusinessObject.PurchaseOrderItemList GetAllPurchaseOrderItemList(int PurchaseOrderItemID, int Flag, string FlagValue)
{
Store.PurchaseOrderItem.BusinessObject.PurchaseOrderItem objPurchaseOrderItem = null;
Store.PurchaseOrderItem.BusinessObject.PurchaseOrderItemList objPurchaseOrderItemList = null;
string SQL = string.Empty;
ParameterList paramList = new ParameterList();
DataTableReader dr;
try
{
objPurchaseOrderItemList = new BusinessObject.PurchaseOrderItemList();
SQL = "proc_PurchaseOrderItem";
paramList.Add(new SQLParameter("@PurchaseOrderItemID", PurchaseOrderItemID));
paramList.Add(new SQLParameter("@Flag", Flag));
paramList.Add(new SQLParameter("@FlagValue", FlagValue));
dr = ExecuteQuery.ExecuteReader(SQL, paramList);
while (dr.Read())
{
objPurchaseOrderItem = new BusinessObject.PurchaseOrderItem();
if (dr.IsDBNull(dr.GetOrdinal("ItemID")) == false)
{
objPurchaseOrderItem.ItemID = dr.GetInt32(dr.GetOrdinal("ItemID"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemPrefix")) == false)
{
objPurchaseOrderItem.ItemPrefix = dr.GetString(dr.GetOrdinal("ItemPrefix"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemUnit")) == false)
{
objPurchaseOrderItem.ItemUnit = dr.GetString(dr.GetOrdinal("ItemUnit"));
}
if (dr.IsDBNull(dr.GetOrdinal("Description")) == false)
{
objPurchaseOrderItem.Description = dr.GetString(dr.GetOrdinal("Description"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemPrice")) == false)
{
objPurchaseOrderItem.ItemPrice = dr.GetDecimal(dr.GetOrdinal("ItemPrice"));
}
if (dr.IsDBNull(dr.GetOrdinal("TotalPrice")) == false)
{
objPurchaseOrderItem.TotalPrice = dr.GetDecimal(dr.GetOrdinal("TotalPrice"));
}
objPurchaseOrderItemList.Add(objPurchaseOrderItem);
}
dr.Close();
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(PurchaseOrderItem).FullName, 1);
}
return(objPurchaseOrderItemList);
}
void ManagePurchaseItemRecived()
{
objPurchaseOrderItem = new Store.PurchaseOrderItem.BusinessObject.PurchaseOrderItem();
oblPurchaseOrderItem = new Store.PurchaseOrderItem.BusinessLogic.PurchaseOrderItem();
try
{
if (cmdMode == Store.Common.CommandMode.M)
{
objPurchaseOrderItem.PurchaseOrderItemID = Convert.ToInt32(txtPurchaseItemOrderID.Text);
}
else
{
objPurchaseOrderItem.PurchaseOrderItemID = 0;
}
objPurchaseOrderItem.PurchaseOrderID = Convert.ToInt16(ddlPurchaseOrderId.SelectedItem.Value);
objPurchaseOrderItem.PurchaseOrderID = Convert.ToInt16(ddlPurchaseOrderId.SelectedItem.Value);
objPurchaseOrderItem.ItemID = Convert.ToInt16(ddlItemId.SelectedItem.Value);
objPurchaseOrderItem.ItemUnit = Convert.ToString(txtItemUnit.Text);
objPurchaseOrderItem.Description = Convert.ToString(txtDescription.Text);
objPurchaseOrderItem.ItemPrice = Convert.ToDecimal(txtItemPrice.Text);
if (chkBoxIsActive.Checked)
{
objPurchaseOrderItem.IsActive = 1;
}
else
{
objPurchaseOrderItem.IsActive = 0;
}
objPurchaseOrderItem.CreatedBy = 1;
objMessageInfo = oblPurchaseOrderItem.ManageItemMaster(objPurchaseOrderItem, cmdMode);
}
catch (Exception ex)
{
}
finally
{
objPurchaseOrderItem = null;
objMessageInfo = null;
oblPurchaseOrderItem = null;
}
}
public string insertItem(string name, string description, string unitprice, string discountper, string discount, string quantity, string total, string transId)
{
Store.PurchaseOrderItem.BusinessObject.PurchaseOrderItem objPurchaseOrderItem = new Store.PurchaseOrderItem.BusinessObject.PurchaseOrderItem();
Store.Common.MessageInfo objMessageInfo = new MessageInfo();
Store.PurchaseOrder.BusinessLogic.PurchaseOrder oblPurchaseOrder = new Store.PurchaseOrder.BusinessLogic.PurchaseOrder();
objPurchaseOrderItem.PurchaseOrderItemID = 0;
objPurchaseOrderItem.PurchaseOrderID = Convert.ToInt32(transId);
objPurchaseOrderItem.ItemID = 0;
objPurchaseOrderItem.ItemPrefix = name;
objPurchaseOrderItem.ItemUnit = quantity;
objPurchaseOrderItem.Description = description;
objPurchaseOrderItem.ItemPrice = Convert.ToDecimal(unitprice);
objPurchaseOrderItem.TotalPrice = Convert.ToDecimal(total);
objPurchaseOrderItem.DiscountPre = Convert.ToDecimal(discountper);
objPurchaseOrderItem.Discount = Convert.ToDecimal(discount);
objMessageInfo = oblPurchaseOrder.ManagePurchaseOrderMaster(objPurchaseOrderItem, 1);
return("");
}
protected void btnCheckOut_Click(object sender, EventArgs e)
{
try
{
string transid = "";
transid = insertOrder(txtSubTotal.Text, txtDicPre.Text, txtDic.Text, txtTax.Text, txtSHC.Text, txtMiscCost.Text, txttotal.Text);
objPurchaseOrderItemList = new Store.PurchaseOrderItem.BusinessObject.PurchaseOrderItemList();
for (int i = 0; i < Gridview1.Rows.Count - 1; i++)
{
objPurchaseOrderItem = new Store.PurchaseOrderItem.BusinessObject.PurchaseOrderItem();
TextBox txtItemNames = (TextBox)Gridview1.Rows[i].FindControl("txtItemName");
if (txtItemNames.Text == "")
break;
TextBox txtDecs = (TextBox)Gridview1.Rows[i].FindControl("txtDec");
TextBox txtPrices = (TextBox)Gridview1.Rows[i].FindControl("txtPrice");
TextBox txtDisPres = (TextBox)Gridview1.Rows[i].FindControl("txtDisPre");
TextBox txtDiss = (TextBox)Gridview1.Rows[i].FindControl("txtDis");
TextBox txtQuts = (TextBox)Gridview1.Rows[i].FindControl("txtQut");
TextBox txtTotals = (TextBox)Gridview1.Rows[i].FindControl("txtTotal");
objPurchaseOrderItem.ItemPrefix = txtItemNames.Text;
objPurchaseOrderItem.Description = txtDecs.Text;
objPurchaseOrderItem.ItemPrice = Convert.ToDecimal(txtPrices.Text);
objPurchaseOrderItem.DiscountPre = Convert.ToDecimal(txtDisPres.Text);
objPurchaseOrderItem.Discount = Convert.ToDecimal(txtDiss.Text);
objPurchaseOrderItem.ItemUnit = txtQuts.Text;
objPurchaseOrderItem.TotalPrice = Convert.ToDecimal(txtTotals.Text);
objPurchaseOrderItem.PurchaseOrderID = Convert.ToInt32(transid);
objPurchaseOrderItemList.Add(objPurchaseOrderItem);
}
oblPurchaseOrderItem = new Store.PurchaseOrderItem.BusinessLogic.PurchaseOrderItem();
objMessageInfo = oblPurchaseOrderItem.ManageItemMaster(objPurchaseOrderItemList, cmdMode);
reset();
}
catch (Exception ex)
{ Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(POrder).FullName, 1); }
}
