protected void LBPurr_Click(object sender, CommandEventArgs e)
{
try
{
LinkButton lb = (LinkButton)sender;
GridViewRow gvRow = (GridViewRow)lb.NamingContainer;
int rowID = gvRow.RowIndex;
if (ViewState["CurrentPurData"] != null)
{
DataTable dt = (DataTable)ViewState["CurrentPurData"];
if (dt.Rows.Count > 0)
{
dt.Rows.RemoveAt(rowID);
}
ViewState["CurrentPurData"] = dt;
GVPur.DataSource = dt;
GVPur.DataBind();
if (GVPur.Rows.Count == 0)
{
pnlAction.Visible = false;
}
AddPayable();
}
}
catch (Exception ex)
{
Show(ex.Message);
}
}
private void ClearPaymentMode()
{
pnlAction.Visible = false;
GvUpdate.DataSource = null;
GvUpdate.DataBind();
GvUpdate.Visible = false;
txtDate.Text = "";
txtInvoiceNo.Text = "";
this.ViewState["CurrentPurData"] = null;
DataTable dt = new DataTable();
GVPur.DataSource = dt;
GVPur.DataBind();
txtCustomerName.Text = "";
txtMobileNo.Text = "";
txtContactAdd.Text = "";
txtRemarks.Text = "";
txtApprCode.Text = "";
txtBankName.Text = "";
txtCardNo.Text = "";
txtDicountAfterpercentage.Text = "0";
txtDicountpercentage.Text = "";
txtDueAmount.Text = "0";
txtHolderName.Text = "";
txtPaidAmount.Text = "";
txtTotalPayable.Text = "0";
txtVatAfterpercentage.Text = "0";
txtVatPercentage.Text = "";
txtNetTotalPayable.Text = "";
txtNote.Text = "";
}
void SearchPagload()
{
string memno, memname, contactno;
if (txtSMemberNo.Text == "Member No.")
{
memno = "";
}
else
{
memno = txtSMemberNo.Text;
}
if (txtMemberName.Text == "Member Name")
{
memname = "";
}
else
{
memname = txtMemberName.Text;
}
if (txtContactNo.Text == "Contact No.")
{
contactno = "";
}
else
{
contactno = txtContactNo.Text;
}
GVPur.DataSource = memBLL.GetMember(memno, memname, contactno, ddlSMemType.SelectedValue, 0);
GVPur.DataBind();
}
protected void btnPost_Click(object sender, EventArgs e)
{
var reqprolist = ReqBLL.GetRequisitionInfo(0, Convert.ToInt32(GVCOA.DataKeys[GVCOA.SelectedIndex].Values["RequisitionNo"].ToString()));
GVPur.DataSource = reqprolist;
GVPur.DataBind();
pnlAction.Visible = true;
}
protected void btnPost_Click(object sender, EventArgs e)
{
var reqprolist = PurOrBLL.GetPurchaseOrderInfo(0, Convert.ToInt32(GVCOA.DataKeys[GVCOA.SelectedIndex].Values["PurOrderNO"].ToString()));
GVPur.DataSource = reqprolist;
GVPur.DataBind();
pnlAction.Visible = true;
AddPayable();
}
private void BindGrid(int rowcount)
{
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add(new System.Data.DataColumn("SalePaymentId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("DueAmount", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("PaidAmount", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("DueDate", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("ReturnAmount", typeof(String)));
if (ViewState["CurrentPurData"] != null)
{
for (int i = 0; i < rowcount + 1; i++)
{
dt = (DataTable)ViewState["CurrentPurData"];
if (dt.Rows.Count > 0)
{
dr = dt.NewRow();
dr[0] = dt.Rows[0][0].ToString();
}
}
dr = dt.NewRow();
dr[0] = HFPaymentId.Value;
dr[1] = txtDueAmount.Text;
dr[2] = txtPaidAmount.Text;
dr[3] = txtDueDate.Text;
dr[4] = txtReturn.Text;
dt.Rows.Add(dr);
}
else
{
dr = dt.NewRow();
// dr[0] = ddlPName.SelectedValue.ToString();
// dr[1] = ddlPName.SelectedItem.ToString();
dr[0] = HFPaymentId.Value;
dr[1] = txtDueAmount.Text;
dr[2] = txtPaidAmount.Text;
dr[3] = txtDueDate.Text;
dr[4] = txtReturn.Text;
dt.Rows.Add(dr);
}
if (ViewState["CurrentPurData"] != null)
{
GVPur.DataSource = (DataTable)ViewState["CurrentPurData"];
GVPur.DataBind();
}
else
{
GVPur.DataSource = dt;
GVPur.DataBind();
}
ViewState["CurrentPurData"] = dt;
pnlAction.Visible = true;
ControlClear();
}
protected void GVPur_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GVPur.PageIndex = e.NewPageIndex;
if (ViewState["CurrentPurData"] != null)
{
GVPur.DataSource = (DataTable)ViewState["CurrentPurData"];
GVPur.DataBind();
}
GVPur.DataBind();
}
public void CancelControl()
{
this.ViewState["CurrentPurData"] = null;
DataTable dt = new DataTable();
GVPur.DataSource = dt;
GVPur.DataBind();
Clear();
pnlAction.Visible = false;
}
private void ClearControl()
{
Clear();
GVPur.Visible = false;
pnlSave.Visible = false;
this.ViewState["CurrentPurData"] = null;
DataTable dt = new DataTable();
GVPur.DataSource = dt;
GVPur.DataBind();
}
public void PurCancel()
{
LoadPurReqGridView();
this.ViewState["CurrentPurData"] = null;
DataTable dt = new DataTable();
GVPur.DataSource = dt;
GVPur.DataBind();
pnlAction.Visible = false;
PnlLoadRequsionDatalist.Visible = false;
GVCOA.SelectedIndex = -1;
}
public void PurCancel()
{
LoadPurReqGridView();
this.ViewState["CurrentPurData"] = null;
DataTable dt = new DataTable();
GVPur.DataSource = dt;
GVPur.DataBind();
pnlAction.Visible = false;
// PnlLoadRequsionDatalist.Visible = false;
// GVCOA.SelectedIndex = -1;
txtSalesmanName.Text = "";
txtTotalPayable.Text = "";
}
private void SearchPagload()
{
var data = memBLL.GetActiveMemeberList(txtContactAdd.Text, txtCustomerName.Text, txtMobileNo.Text, ddlSMemType.SelectedValue);
if (data.Count > 0)
{
GVPur.DataSource = data;
GVPur.DataBind();
}
else
{
Show("No data found!");
}
}
private void ClearPaymentMode()
{
rbSubCategory.Items.Clear();
txtAddBeka.Text = "";
txtAddCate.Text = "";
txtAddGuest.Text = "200";
txtAddRes.Text = "";
txtPaid.Text = "";
txtPayable.Text = "";
this.ViewState["CurrentPurData"] = null;
DataTable dt = new DataTable();
GVPur.DataSource = dt;
GVPur.DataBind();
GVPur.Visible = false;
}
public void PurCancel()
{
LoadListRequisitonNo();
this.ViewState["CurrentPurData"] = null;
DataTable dt = new DataTable();
GVPur.DataSource = dt;
GVPur.DataBind();
this.ViewState["CurrentInfoData"] = null;
DataTable dt1 = new DataTable();
GvUpdate.DataSource = dt1;
GvUpdate.DataBind();
LoadListRequisitonNo();
pnlAction.Visible = false;
pnlAction.Visible = false;
GVCOA.SelectedIndex = -1;
txtNote.Text = "";
txtTotalPayable.Text = "";
PnlInfoProduct.Visible = false;
}
private void BindGrid(int rowcount, double price)
{
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add(new System.Data.DataColumn("ProductId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("ProductName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CompId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CompName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CategoryName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CategoryId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("Quantity", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("UnitPrice", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("UnitName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("SaleType", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("MemberId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("TempId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("TotalPrize", typeof(String)));
var data = tempBLL.LoadTempId();
if (ViewState["CurrentPurData"] != null)
{
for (int i = 0; i < rowcount + 1; i++)
{
dt = (DataTable)ViewState["CurrentPurData"];
if (dt.Rows.Count > 0)
{
dr = dt.NewRow();
dr[0] = dt.Rows[0][0].ToString();
}
}
dr = dt.NewRow();
dr[0] = rbSubCategory.SelectedValue.ToString();
// dr[1] = ddlPName.SelectedItem.ToString();
dr[2] = rbSubCategory.SelectedValue.ToString();
dr[3] = rbSubCategory.SelectedItem.ToString();
dr[4] = rbCategory.SelectedItem.ToString();
dr[5] = rbCategory.SelectedValue.ToString();
dr[6] = rbtPegSize.SelectedItem.ToString();
dr[7] = price;
dr[8] = rbtPegSize.SelectedItem.ToString();
dr[9] = rbtSaleType.SelectedItem;
dr[10] = HFMemberId.Value;
dr[11] = data.First().TempId;
dr[12] = (double.Parse(rbtPegSize.SelectedItem.ToString()) * price);
dt.Rows.Add(dr);
}
else
{
dr = dt.NewRow();
// dr[0] = ddlPName.SelectedValue.ToString();
// dr[1] = ddlPName.SelectedItem.ToString();
dr[0] = rbSubCategory.SelectedValue.ToString();
// dr[1] = ddlPName.SelectedItem.ToString();
dr[2] = rbSubCategory.SelectedValue.ToString();
dr[3] = rbSubCategory.SelectedItem.ToString();
dr[4] = rbCategory.SelectedItem.ToString();
dr[5] = rbCategory.SelectedValue.ToString();
dr[6] = rbtPegSize.SelectedItem.ToString();
dr[7] = price;
dr[8] = rbtPegSize.SelectedItem.ToString();
dr[9] = rbtSaleType.SelectedItem;
dr[10] = HFMemberId.Value;
dr[11] = data.First().TempId;
dr[12] = (double.Parse(rbtPegSize.SelectedItem.ToString()) * price);
dt.Rows.Add(dr);
}
if (ViewState["CurrentPurData"] != null)
{
GVPur.DataSource = (DataTable)ViewState["CurrentPurData"];
GVPur.DataBind();
}
else
{
GVPur.DataSource = dt;
GVPur.DataBind();
}
ViewState["CurrentPurData"] = dt;
GVPur.Visible = true;
AddPayable();
// pnlAction.Visible = true;
}
private void BindGrid(int rowcount)
{
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add(new System.Data.DataColumn("ProductId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("ProductName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CompId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CompName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CategoryName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CategoryId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("Quantity", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("UnitPrice", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("UnitName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("SaleDtlId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("TransectionType", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("Caused", typeof(string)));
if (ViewState["CurrentPurData"] != null)
{
for (int i = 0; i < rowcount + 1; i++)
{
dt = (DataTable)ViewState["CurrentPurData"];
if (dt.Rows.Count > 0)
{
dr = dt.NewRow();
dr[0] = dt.Rows[0][0].ToString();
}
}
dr = dt.NewRow();
dr[0] = ddlPName.SelectedValue.ToString();
dr[1] = ddlPName.SelectedItem.ToString();
dr[2] = ddlCName.SelectedValue.ToString();
dr[3] = ddlCName.SelectedItem.ToString();
dr[4] = ddlCateName.SelectedItem.ToString();
dr[5] = ddlCateName.SelectedValue.ToString();
dr[6] = txtPQuality.Text;
dr[7] = txtPurPrice.Text;
dr[8] = ddlUnit.SelectedItem.ToString();
dr[9] = HFSalDtlId.Value;
// dr[10] = RbtTransectionType.SelectedItem.ToString();
//dr[11] = RbtChangeCause.SelectedItem.ToString();
dt.Rows.Add(dr);
}
else
{
dr = dt.NewRow();
dr[0] = ddlPName.SelectedValue.ToString();
dr[1] = ddlPName.SelectedItem.ToString();
dr[2] = ddlCName.SelectedValue.ToString();
dr[3] = ddlCName.SelectedItem.ToString();
dr[4] = ddlCateName.SelectedItem.ToString();
dr[5] = ddlCateName.SelectedValue.ToString();
dr[6] = txtPQuality.Text;
dr[7] = txtPurPrice.Text;
dr[8] = ddlUnit.SelectedItem.ToString();
dr[9] = HFSalDtlId.Value;
// dr[10] = RbtTransectionType.SelectedItem.ToString();
// dr[11] = RbtChangeCause.SelectedItem.ToString();
dt.Rows.Add(dr);
}
if (ViewState["CurrentPurData"] != null)
{
GVPur.DataSource = (DataTable)ViewState["CurrentPurData"];
GVPur.DataBind();
}
else
{
GVPur.DataSource = dt;
GVPur.DataBind();
}
ViewState["CurrentPurData"] = dt;
pnlAction.Visible = true;
}
private void BindGrid(int rowcount)
{
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add(new System.Data.DataColumn("ProductId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("ProductName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CompId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CompName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CategoryName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CategoryId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("Priority", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("Quantity", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("UnitPrice", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("UnitName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CenPurReqId", typeof(String)));
//dt.Columns.Add(new System.Data.DataColumn("BrProId", typeof(String)));
if (ViewState["CurrentPurData"] != null)
{
for (int i = 0; i < rowcount; i++)
{
dt = (DataTable)ViewState["CurrentPurData"];
if (Convert.ToInt32(dt.Rows[i][7].ToString()) == 0)
{
Show("Product Purchase Qty Must Greater than 0 !");
return;
}
else
{
if (dt.Rows.Count > 0)
{
dr = dt.NewRow();
dr[0] = dt.Rows[0][0].ToString();
}
}
}
dr = dt.NewRow();
dr[1] = ddlPName.SelectedItem.ToString();
dr[0] = ddlPName.SelectedValue.ToString();
dr[3] = ddlCName.SelectedItem.ToString();
dr[2] = ddlCName.SelectedValue.ToString();
dr[4] = ddlCateName.SelectedItem.ToString();
dr[5] = ddlCateName.SelectedValue.ToString();
dr[6] = RbPriority.SelectedItem.ToString();
dr[7] = txtPQuality.Text;
dr[8] = txtPurPrice.Text;
dr[9] = ddlUnit.SelectedItem.ToString();
dr[10] = HFPurReqId.Value;
// dr[11] = HFBrProId.Value;
dt.Rows.Add(dr);
}
else
{
dr = dt.NewRow();
dr[1] = ddlPName.SelectedItem.ToString();
dr[0] = ddlPName.SelectedValue.ToString();
dr[3] = ddlCName.SelectedItem.ToString();
dr[2] = ddlCName.SelectedValue.ToString();
dr[4] = ddlCateName.SelectedItem.ToString();
dr[5] = ddlCateName.SelectedValue.ToString();
dr[6] = RbPriority.SelectedItem.ToString();
dr[7] = txtPQuality.Text;
dr[8] = txtPurPrice.Text;
dr[9] = ddlUnit.SelectedValue.ToString();
dr[10] = HFPurReqId.Value;
//dr[11] = HFBrProId.Value;
dt.Rows.Add(dr);
}
if (ViewState["CurrentPurData"] != null)
{
GVPur.DataSource = (DataTable)ViewState["CurrentPurData"];
GVPur.DataBind();
}
else
{
GVPur.DataSource = dt;
GVPur.DataBind();
}
ViewState["CurrentPurData"] = dt;
pnlAction.Visible = true;
}
private void BindGrid(int rowcount)
{
try
{
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add(new System.Data.DataColumn("ProductId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("ProductName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CompId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CompName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CategoryName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CategoryId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("Priority", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("Quantity", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("UnitPrice", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("UnitName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CentralPurOrderId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("Total", typeof(String)));
//dt.Columns.Add(new System.Data.DataColumn("BrProId", typeof(String)));
if (ViewState["CurrentPurData"] != null)
{
for (int i = 0; i < rowcount + 1; i++)
{
dt = (DataTable)ViewState["CurrentPurData"];
if (dt.Rows.Count > 0)
{
dr = dt.NewRow();
dr[0] = dt.Rows[0][0].ToString();
}
}
dr = dt.NewRow();
dr[0] = HFProductId.Value;
dr[1] = "";
dr[3] = ddlCName.SelectedItem.ToString();
dr[2] = ddlCName.SelectedValue.ToString();
dr[4] = ddlCateName.SelectedItem.ToString();
dr[5] = ddlCateName.SelectedValue.ToString();
dr[6] = "";
dr[7] = txtPQuality.Text;
dr[8] = txtPurPrice.Text;
dr[9] = "";
dr[10] = HFPurOrderId.Value;
dr[11] = double.Parse(txtPQuality.Text) * double.Parse(txtPurPrice.Text);
// dr[11] = HFBrProId.Value;
dt.Rows.Add(dr);
}
else
{
dr = dt.NewRow();
dr[0] = HFProductId.Value;
dr[1] = "";
dr[3] = ddlCName.SelectedItem.ToString();
dr[2] = ddlCName.SelectedValue.ToString();
dr[4] = ddlCateName.SelectedItem.ToString();
dr[5] = ddlCateName.SelectedValue.ToString();
dr[6] = "";
dr[7] = txtPQuality.Text;
dr[8] = txtPurPrice.Text;
dr[9] = "";
dr[10] = HFPurOrderId.Value;
dr[11] = double.Parse(txtPQuality.Text) * double.Parse(txtPurPrice.Text);
dt.Rows.Add(dr);
}
if (ViewState["CurrentPurData"] != null)
{
GVPur.DataSource = (DataTable)ViewState["CurrentPurData"];
GVPur.DataBind();
}
else
{
GVPur.DataSource = dt;
GVPur.DataBind();
}
ViewState["CurrentPurData"] = dt;
pnlAction.Visible = true;
}
catch (Exception ex)
{
Show(ex.Message);
}
}
private void BindGrid(int rowcount)
{
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add(new System.Data.DataColumn("ProductId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CategoryName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CompName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("ItemProductId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("ItemCategoryName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("ItemSubCategoryName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("Quantity", typeof(String)));
if (ViewState["CurrentPurData"] != null)
{
for (int i = 0; i < rowcount + 1; i++)
{
dt = (DataTable)ViewState["CurrentPurData"];
if (dt.Rows.Count > 0)
{
dr = dt.NewRow();
dr[0] = dt.Rows[0][0].ToString();
}
}
dr = dt.NewRow();
dr[0] = ddlSubCategory.SelectedValue.ToString();
dr[1] = ddlCategory.SelectedItem.ToString();
dr[2] = ddlSubCategory.SelectedItem.ToString();
dr[3] = ddlItemSubCategory.SelectedValue.ToString();
dr[4] = ddlItemCategory.SelectedItem.ToString();
dr[5] = ddlItemSubCategory.SelectedItem.ToString();
dr[6] = ddlQuantity.SelectedItem.ToString();
dt.Rows.Add(dr);
}
else
{
dr = dt.NewRow();
dr[0] = ddlSubCategory.SelectedValue.ToString();
dr[1] = ddlCategory.SelectedItem.ToString();
dr[2] = ddlSubCategory.SelectedItem.ToString();
dr[3] = ddlItemSubCategory.SelectedValue.ToString();
dr[4] = ddlItemCategory.SelectedItem.ToString();
dr[5] = ddlItemSubCategory.SelectedItem.ToString();
dr[6] = ddlQuantity.SelectedItem.ToString();
dt.Rows.Add(dr);
}
if (ViewState["CurrentPurData"] != null)
{
GVPur.DataSource = (DataTable)ViewState["CurrentPurData"];
GVPur.DataBind();
}
else
{
GVPur.DataSource = dt;
GVPur.DataBind();
}
GVPur.Visible = true;
pnlSave.Visible = true;
ViewState["CurrentPurData"] = dt;
// pnlAction.Visible = true;
}
protected void btnPost_Click(object sender, EventArgs e)
{
try
{
DataTable dt1 = (DataTable)ViewState["CurrentInfoData"];
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add(new System.Data.DataColumn("ProductId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("ProductName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CompId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CompName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("Priority", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("Quantity", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("UnitPrice", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CategoryName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CatId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("PurReqId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("UnitName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("ReqPurOrderId", typeof(String)));
for (int j = 0; j < dt1.Rows.Count; j++)
{
int iii = Convert.ToInt32(Convert.ToInt32(dt1.Rows[j][0]));
var Quantity = SBLL.LoadCentralStockStatus(iii);
int qu = Convert.ToInt32(dt1.Rows[j][4]);
if (Quantity.Count != 0)
{
double?quantity = Quantity.First().QuantityStore;
if (quantity >= Convert.ToInt32(dt1.Rows[j][4]))
{
DataTable dt2 = (DataTable)ViewState["CurrentPurData"];
if (ViewState["CurrentPurData"] != null)
{
for (int i = 0; i < dt2.Rows.Count + 1; i++)
{
dt = (DataTable)ViewState["CurrentPurData"];
if (dt.Rows.Count > 0)
{
dr = dt.NewRow();
dr[0] = dt.Rows[0][0].ToString();
}
}
int flag = 0;
for (int k = 0; k < dt2.Rows.Count; k++)
{
if (Convert.ToInt32(dt2.Rows[k][0]) == Convert.ToInt32(dt1.Rows[j][0]) || Convert.ToInt32(dt2.Rows[k][2]) != Convert.ToInt32(dt1.Rows[j][2]))
{
flag = 1;
break;
}
}
if (flag == 0)
{
dr = dt.NewRow();
dr[0] = dt1.Rows[j][0];
dr[1] = dt1.Rows[j][1];
dr[2] = dt1.Rows[j][2];
dr[3] = dt1.Rows[j][3];
dr[4] = dt1.Rows[j][6];
dr[5] = dt1.Rows[j][4];
dr[6] = dt1.Rows[j][5];
dr[7] = dt1.Rows[j][10];
dr[8] = dt1.Rows[j][11];
dr[9] = dt1.Rows[j][12];
dr[10] = dt1.Rows[j][13];
dr[11] = GVCOA.Rows[GVCOA.SelectedIndex].Cells[5].Text;
dt.Rows.Add(dr);
}
}
else
{
dr = dt.NewRow();
dr[0] = dt1.Rows[j][0];
dr[1] = dt1.Rows[j][1];
dr[2] = dt1.Rows[j][2];
dr[3] = dt1.Rows[j][3];
dr[4] = dt1.Rows[j][6];
dr[5] = dt1.Rows[j][4];
dr[6] = dt1.Rows[j][5];
dr[7] = dt1.Rows[j][10];
dr[8] = dt1.Rows[j][12];
dr[9] = dt1.Rows[j][12];
dr[10] = dt1.Rows[j][13];
dr[11] = GVCOA.Rows[GVCOA.SelectedIndex].Cells[5].Text;
dt.Rows.Add(dr);
}
}
}
else
{
}
if (ViewState["CurrentPurData"] != null)
{
GVPur.DataSource = (DataTable)ViewState["CurrentPurData"];
GVPur.DataBind();
}
else
{
GVPur.DataSource = dt;
GVPur.DataBind();
}
ViewState["CurrentPurData"] = dt;
}
pnlAction.Visible = true;
AddPayable();
if (dt1.Rows.Count != dt.Rows.Count)
{
Show("Some Product Not Inserted Directly Cause Greater than Store Quantity!");
return;
}
}
catch (Exception ex)
{
Show(ex.Message);
}
}
protected void LBPurr_Click(object sender, CommandEventArgs e)
{
LinkButton lb = (LinkButton)sender;
GridViewRow gvRow = (GridViewRow)lb.NamingContainer;
int rowID = gvRow.RowIndex;
if (ViewState["CurrentPurData"] != null)
{
DataTable dt = (DataTable)ViewState["CurrentPurData"];
var tempdata = tempBLL.GetAllByTempId(int.Parse(dt.Rows[rowID][11].ToString()));
var cocktail = cockBLL.GetCocktail(int.Parse(tempdata.First().ProductId.ToString()), 0);
if (cocktail.Count > 0)
{
for (int j = 0; j < cocktail.Count; j++)
{
var Quantity = SBLL.LoadCentralStockStatus(int.Parse(tempdata.First().ProductId.ToString()));
SDTO.CentralStoreId = Quantity.First().CentralStoreId;
SDTO.ProductId = Convert.ToInt32(cocktail[j].ItemProId.ToString());
SDTO.QuantityStore = Convert.ToDouble(Quantity.First().QuantityStore + (Convert.ToDouble(cocktail[j].Quantity) * double.Parse(tempdata.First().PegSize.ToString())));
// DetailDTO.ProductId = Convert.ToInt32(c**k[j].ItemProId.ToString());
var detail = DetailBLL.GetdtlId(Convert.ToInt32(cocktail[j].ItemProId.ToString()), DateTime.Now.ToShortDateString());
if (detail.Count > 0)
{
DetailDTO.DtlId = detail.First().DtlId;
DetailDTO.ProductId = detail.First().ProductId;
DetailDTO.UsedQuantity = detail.First().UsedQuantity - (Convert.ToDouble(cocktail[j].Quantity) * double.Parse(tempdata.First().PegSize.ToString()));
DetailDTO.RemainingQuantity = Convert.ToDouble(Quantity.First().QuantityStore + (Convert.ToDouble(cocktail[j].Quantity) * double.Parse(tempdata.First().PegSize.ToString())));
DetailBLL.Edit(DetailDTO);
}
SBLL.EditStoreQty(SDTO);
}
}
else if (!tempdata.First().Category.ToString().ToLower().Contains("extra"))
{
var Quantity = SBLL.LoadCentralStockStatus(int.Parse(tempdata.First().ProductId.ToString()));
SDTO.CentralStoreId = Quantity.First().CentralStoreId;
SDTO.ProductId = int.Parse(tempdata.First().ProductId.ToString());
SDTO.QuantityStore = Convert.ToDouble(Quantity.First().QuantityStore + double.Parse(tempdata.First().PegSize.ToString()));
var detail = DetailBLL.GetdtlId(int.Parse(tempdata.First().ProductId.ToString()), DateTime.Now.ToShortDateString());
if (detail.Count > 0)
{
DetailDTO.DtlId = detail.First().DtlId;
DetailDTO.ProductId = detail.First().ProductId;
DetailDTO.UsedQuantity = detail.First().UsedQuantity - double.Parse(tempdata.First().PegSize.ToString());
DetailDTO.RemainingQuantity = Convert.ToDouble(Quantity.First().QuantityStore + double.Parse(tempdata.First().PegSize.ToString()));
DetailBLL.Edit(DetailDTO);
}
SBLL.EditStoreQty(SDTO);
}
tempBLL.DeleteTempId(int.Parse(dt.Rows[rowID][11].ToString()));
if (dt.Rows.Count > 0)
{
dt.Rows.RemoveAt(rowID);
}
ViewState["CurrentPurData"] = dt;
GVPur.DataSource = dt;
GVPur.DataBind();
// tempBLL.Delete(int.Parse(HFMemberId.Value), int.Parse(e.CommandArgument.ToString()));
if (GVPur.Rows.Count == 0)
{
GVPur.Visible = false;
}
}
AddPayable();
}
private void BindMember(int MemId)
{
var data = tempBLL.GetAllInfo(MemId);
if (data.Count > 0)
{
for (int i = 0; i < data.Count; i++)
{
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add(new System.Data.DataColumn("ProductId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("ProductName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CompId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CompName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CategoryName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CategoryId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("Quantity", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("UnitPrice", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("UnitName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("SaleType", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("MemberId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("TempId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("TotalPrize", typeof(String)));
if (ViewState["CurrentPurData"] != null)
{
DataTable dt1 = (DataTable)ViewState["CurrentPurData"];
for (int j = 0; j < dt1.Rows.Count + 1; j++)
{
dt = (DataTable)ViewState["CurrentPurData"];
if (dt.Rows.Count > 0)
{
dr = dt.NewRow();
dr[0] = dt.Rows[0][0].ToString();
}
}
dr = dt.NewRow();
dr[0] = data[i].ProductId;
// dr[1] = ddlPName.SelectedItem.ToString();
dr[2] = data[i].ProductId;
dr[3] = data[i].SubCategory;
dr[4] = data[i].Category;
dr[5] = data[i].Category;
dr[6] = data[i].PegSize;
dr[7] = data[i].UnitPrize;
dr[8] = data[i].Unit;
dr[9] = data[i].SaleType;
dr[10] = data[i].MemberId;
dr[11] = data[i].TempId;
dr[12] = (data[i].PegSize * data[i].UnitPrize).ToString();
dt.Rows.Add(dr);
}
else
{
dr = dt.NewRow();
dr[0] = data[i].ProductId;
// dr[1] = ddlPName.SelectedItem.ToString();
dr[2] = data[i].ProductId;
dr[3] = data[i].SubCategory;
dr[4] = data[i].Category;
dr[5] = data[i].Category;
dr[6] = data[i].PegSize;
dr[7] = data[i].UnitPrize;
dr[8] = data[i].Unit;
dr[9] = data[i].SaleType;
dr[10] = data[i].MemberId;
dr[11] = data[i].TempId;
dr[12] = (data[i].PegSize * data[i].UnitPrize).ToString();
dt.Rows.Add(dr);
}
if (ViewState["CurrentPurData"] != null)
{
GVPur.DataSource = (DataTable)ViewState["CurrentPurData"];
GVPur.DataBind();
}
else
{
GVPur.DataSource = dt;
GVPur.DataBind();
}
ViewState["CurrentPurData"] = dt;
GVPur.Visible = true;
//pnlAction.Visible = true;
}
AddPayable();
}
}
private void BindGrid(int rowcount)
{
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add(new System.Data.DataColumn("ProductId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("ProductName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CompId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CompName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("Priority", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("Quantity", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("UnitPrice", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CategoryName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("CatId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("PurReqId", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("UnitName", typeof(String)));
dt.Columns.Add(new System.Data.DataColumn("ReqPurOrderId", typeof(String)));
if (ViewState["CurrentPurData"] != null)
{
for (int i = 0; i < rowcount + 1; i++)
{
dt = (DataTable)ViewState["CurrentPurData"];
if (dt.Rows.Count > 0)
{
dr = dt.NewRow();
dr[0] = dt.Rows[0][0].ToString();
}
}
dr = dt.NewRow();
dr[0] = ddlPName.SelectedValue.ToString();
dr[1] = ddlPName.SelectedItem;
dr[2] = ddlCName.SelectedValue.ToString();
dr[3] = ddlCName.SelectedItem.ToString();
dr[4] = RbPriority.SelectedItem.ToString();
dr[5] = txtPQuality.Text;
dr[6] = txtPurPrice.Text;
dr[7] = ddlCateName.SelectedItem.ToString();
dr[8] = ddlCateName.SelectedValue.ToString();
dr[9] = HFReqId.Value.ToString();
dr[10] = ddlUnit.SelectedItem.ToString();
dr[11] = GVCOA.Rows[GVCOA.SelectedIndex].Cells[5].Text;
dt.Rows.Add(dr);
}
else
{
dr = dt.NewRow();
dr = dt.NewRow();
dr[0] = ddlPName.SelectedValue.ToString();
dr[1] = ddlPName.SelectedItem;
dr[2] = ddlCName.SelectedValue.ToString();
dr[3] = ddlCName.SelectedItem.ToString();
dr[4] = RbPriority.SelectedItem.ToString();
dr[5] = txtPQuality.Text;
dr[6] = txtPurPrice.Text;
dr[7] = ddlCateName.SelectedItem.ToString();
dr[8] = ddlCateName.SelectedValue.ToString();
dr[9] = HFReqId.Value.ToString();
dr[10] = ddlUnit.SelectedItem.ToString();
dr[11] = GVCOA.Rows[GVCOA.SelectedIndex].Cells[5].Text;
dt.Rows.Add(dr);
}
if (ViewState["CurrentPurData"] != null)
{
GVPur.DataSource = (DataTable)ViewState["CurrentPurData"];
GVPur.DataBind();
}
else
{
GVPur.DataSource = dt;
GVPur.DataBind();
}
ViewState["CurrentPurData"] = dt;
}
