void LoadData(int Type) { clsSiteProductParts obj = new clsSiteProductParts(); if (Type == 2) { obj.Op = 11; if (ddlMachine.SelectedIndex != 0) { obj.SiteMachineID = Convert.ToInt32(ddlMachine.SelectedValue); DataTable dt = obj.SiteProductParts(obj).Tables[0]; LoadDataMachineWise(dt); } } else if (Type == 3) { obj.Op = 12; obj.SiteID = Convert.ToInt32(Request.Cookies["SiteID"].Value); obj.BillRef = txtPartNo.Text.Trim(); DataTable dt = obj.SiteProductParts(obj).Tables[0]; LoadDataPartWise(dt); } else { pnlDetail.Controls.Clear(); } }
protected void btnSave_Click(object sender, EventArgs e) { foreach (GridViewRow dr in grd.Rows) { TextBox txtPartNo = dr.FindControl("txtPartNo") as TextBox; HiddenField hdPartID = dr.FindControl("hdPartID") as HiddenField; Label lblPartName = dr.FindControl("lblPartName") as Label; TextBox txtReference = dr.FindControl("txtReference") as TextBox; DropDownList ddlTransactionType = dr.FindControl("ddlTransactionType") as DropDownList; TextBox txtRate = dr.FindControl("txtRate") as TextBox; TextBox txtQuantity = dr.FindControl("txtQuantity") as TextBox; Label lblTotal = dr.FindControl("lblTotal") as Label; TextBox txtRemarks = dr.FindControl("txtRemarks") as TextBox; clsSiteProductParts obj = new clsSiteProductParts(); //ID, SiteID,SiteMachineID,PartID,EntryDate1,EntryDate2,BillRef,TransactionType,Quantity,Rate,Total,Remarks,Op if (hdPartID.Value != "" && Convert.ToInt32(txtQuantity.Text) != 0) { obj.SiteID = Convert.ToInt32(Request.Cookies["SiteID"].Value); obj.SiteMachineID = Convert.ToInt32(ddlMachines.SelectedValue); obj.PartID = Convert.ToInt32(hdPartID.Value); try { obj.EntryDate1 = Convert.ToDateTime(txtDate.Text).ToShortDateString(); } catch { } obj.BillRef = txtReference.Text; obj.TransactionType = Convert.ToInt32(ddlTransactionType.SelectedValue); obj.Quantity = Convert.ToInt32(txtQuantity.Text); obj.Rate = Convert.ToDouble(txtRate.Text); obj.Total = Convert.ToDouble(lblTotal.Text); obj.Remarks = txtRemarks.Text; obj.Op = 1; obj.SiteProductParts(obj); } } }
protected void grd_RowDeleting(object sender, GridViewDeleteEventArgs e) { clsIndentItems obj = new clsIndentItems(); obj.ID = Convert.ToInt32(grd.DataKeys[e.RowIndex].Value); obj.Op = 5; obj.IndentItemMaster(obj); /*Add to items*/ TextBox txtLogNo = grd.Rows[e.RowIndex].FindControl("txtLogNo") as TextBox; TextBox txtPartNo = grd.Rows[e.RowIndex].FindControl("txtPartNo") as TextBox; HiddenField hdPartID = grd.Rows[e.RowIndex].FindControl("hdPartID") as HiddenField; TextBox txtItem = grd.Rows[e.RowIndex].FindControl("txtItem") as TextBox; TextBox txtCurrentStock = grd.Rows[e.RowIndex].FindControl("txtCurrentStock") as TextBox; TextBox txtQuantity = grd.Rows[e.RowIndex].FindControl("txtQuantity") as TextBox; HiddenField hdPrevQuantity = grd.Rows[e.RowIndex].FindControl("hdPrevQuantity") as HiddenField; TextBox txtUOM = grd.Rows[e.RowIndex].FindControl("txtUOM") as TextBox; TextBox txtRemark = grd.Rows[e.RowIndex].FindControl("txtRemark") as TextBox; LinkButton lnkDelete = grd.Rows[e.RowIndex].FindControl("lnkDelete") as LinkButton; clsSiteProductParts obSPP = new clsSiteProductParts(); obSPP.SiteID = Convert.ToInt32(Request.QueryString["SiteID"]); obSPP.SiteMachineID = Convert.ToInt32(Request.QueryString["SiteMachineID"]); obSPP.PartID = Convert.ToInt32(hdPartID.Value); obSPP.Quantity = Convert.ToInt32(txtCurrentStock.Text) - Convert.ToInt32(txtQuantity.Text); obSPP.Op = 1; obSPP.TransactionType = 1; obSPP.Remarks = "Insert against Indent edit"; obSPP.SiteProductParts(obSPP); }
void LoadAllData() { clsSiteProductParts obj = new clsSiteProductParts(); obj.SiteID = Convert.ToInt32(Request.Cookies["SiteID"].Value); obj.Op = 4; DataTable dt = obj.SiteProductParts(obj).Tables[0]; grdParts.DataSource = dt; grdParts.DataBind(); int Quantity = 0; for (int i = 0; i < dt.Rows.Count; i++) { Quantity = Quantity + Convert.ToInt32(dt.Rows[i]["Quantity"]); } grdParts.FooterRow.Cells[5].Text = Quantity.ToString(); grdParts.FooterRow.Cells[4].Text = "Total"; if (grdParts.Rows.Count > 0) { lblError.Text = ""; } else { lblError.Text = "No Records found"; } }
void SaveIssueList(int IndentID) { clsIndent obj = new clsIndent(); obj.ID = IndentID; obj.Op = 4; DataTable dt = obj.IndentMaster(obj).Tables[0]; clsIndentItems obII = new clsIndentItems(); obII.IndentID = IndentID; obII.Op = 3; DataTable dtItems = obII.IndentItemMaster(obII).Tables[0]; if (dtItems.Rows.Count > 0) { /*Add To Issue*/ clsSitePartIssue obSPI = new clsSitePartIssue(); obSPI.SiteID = Convert.ToInt32(dt.Rows[0]["SiteID"]); obSPI.SiteMachineID = Convert.ToInt32(dt.Rows[0]["SiteMachineID"]); obSPI.IndentRef = dt.Rows[0]["RefNo"].ToString(); obSPI.Op = 1; /*Stock Management Entry*/ clsSiteProductParts obSPP = new clsSiteProductParts(); obSPP.SiteID = Convert.ToInt32(dt.Rows[0]["SiteID"]); obSPP.SiteMachineID = Convert.ToInt32(dt.Rows[0]["SiteMachineID"]); obSPP.BillRef = dt.Rows[0]["RefNo"].ToString(); obSPP.Remarks = "Issued Against Indent"; obSPP.Op = 1; obSPP.TransactionType = 2; foreach (DataRow dr in dtItems.Rows) { try { obSPI.PartID = Convert.ToInt32(dr["PartID"]); obSPI.PartNo = dr["PartNo"].ToString(); obSPI.PartName = dr["PartName"].ToString(); obSPI.Price = Convert.ToDouble(dr["Price"]); if (Convert.ToInt32(dr["Quantity"]) > Convert.ToInt32(dr["CurrentStock"])) { obSPI.Quantity = Convert.ToInt32(dr["CurrentStock"]); obSPP.Quantity = Convert.ToInt32(dr["CurrentStock"]); } else { obSPI.Quantity = Convert.ToInt32(dr["Quantity"]); obSPP.Quantity = Convert.ToInt32(dr["Quantity"]); } obSPI.SitePartIssue(obSPI); obSPP.PartID = Convert.ToInt32(dr["PartID"]); try { obSPP.Rate = Convert.ToDouble(dr["Price"]); } catch { } obSPP.Total = obSPP.Rate * obSPP.Quantity; obSPP.SiteProductParts(obSPP); } catch { } } } }
protected void btnSave_Click(object sender, EventArgs e) { clsIndentItems obj = new clsIndentItems(); obj.IndentID = Convert.ToInt32(Request.QueryString["IndentID"]); foreach (GridViewRow dr in grd.Rows) { TextBox txtLogNo = dr.FindControl("txtLogNo") as TextBox; TextBox txtPartNo = dr.FindControl("txtPartNo") as TextBox; HiddenField hdPartID = dr.FindControl("hdPartID") as HiddenField; TextBox txtItem = dr.FindControl("txtItem") as TextBox; TextBox txtCurrentStock = dr.FindControl("txtCurrentStock") as TextBox; TextBox txtQuantity = dr.FindControl("txtQuantity") as TextBox; HiddenField hdPrevQuantity = dr.FindControl("hdPrevQuantity") as HiddenField; TextBox txtUOM = dr.FindControl("txtUOM") as TextBox; TextBox txtRemark = dr.FindControl("txtRemark") as TextBox; LinkButton lnkDelete = dr.FindControl("lnkDelete") as LinkButton; if (hdPartID.Value == "-1") { if (txtPartNo.Text != "" && txtItem.Text != "" && Convert.ToInt32(txtQuantity.Text) != 0) { obj.Op = 1; obj.LogNo = txtLogNo.Text; obj.PartNo = txtPartNo.Text; obj.Particular = txtItem.Text; obj.CurrentStock = Convert.ToInt32(txtCurrentStock.Text); obj.Quantity = Convert.ToInt32(txtQuantity.Text); obj.UOM = txtUOM.Text; obj.Remarks = txtRemark.Text; obj.IndentItemMaster(obj); } } else { if (Convert.ToInt32(Request.QueryString["Status"]) == 1) { if (txtQuantity.Text != hdPrevQuantity.Value) { obj.Op = 4; obj.ID = Convert.ToInt32(grd.DataKeys[dr.RowIndex].Value); obj.Quantity = Convert.ToInt32(txtQuantity.Text); obj.IndentItemMaster(obj); if (Convert.ToInt32(txtCurrentStock.Text) > Convert.ToInt32(txtQuantity.Text)) { clsSiteProductParts obSPP = new clsSiteProductParts(); obSPP.SiteID = Convert.ToInt32(Request.QueryString["SiteID"]); obSPP.SiteMachineID = Convert.ToInt32(Request.QueryString["SiteMachineID"]); obSPP.PartID = Convert.ToInt32(hdPartID.Value); obSPP.Quantity = Convert.ToInt32(txtCurrentStock.Text) - Convert.ToInt32(txtQuantity.Text); obSPP.Op = 1; obSPP.TransactionType = 1; obSPP.Remarks = "Insert against Indent edit"; obSPP.SiteProductParts(obSPP); } } } } } }
protected void btnApprove_Click(object sender, EventArgs e) { clsIndent obj = new clsIndent(); obj.Op = 10; obj.ID = Convert.ToInt32(Request.QueryString["ID"]); obj.Status = 1; obj.ApprovedBy = Convert.ToInt32(hdApprovedBy.Value); obj.IndentMaster(obj); obj.Op = 4; DataTable dt = obj.IndentMaster(obj).Tables[0]; clsIndentItems obII = new clsIndentItems(); obII.IndentID = Convert.ToInt32(Request.QueryString["ID"]); obII.Op = 3; DataTable dtItems = obII.IndentItemMaster(obII).Tables[0]; if (dtItems.Rows.Count > 0) { /*Add To Issue*/ clsSitePartIssue obSPI = new clsSitePartIssue(); obSPI.SiteID = Convert.ToInt32(dt.Rows[0]["SiteID"]); obSPI.SiteMachineID = Convert.ToInt32(dt.Rows[0]["SiteMachineID"]); obSPI.IndentRef = dt.Rows[0]["RefNo"].ToString(); obSPI.Op = 1; /*Stock Management Entry*/ clsSiteProductParts obSPP = new clsSiteProductParts(); obSPP.SiteID = Convert.ToInt32(dt.Rows[0]["SiteID"]); obSPP.SiteMachineID = Convert.ToInt32(dt.Rows[0]["SiteMachineID"]); obSPP.BillRef = dt.Rows[0]["RefNo"].ToString(); obSPP.Remarks = "Issued Against Indent"; obSPP.Op = 1; obSPP.TransactionType = 2; foreach (DataRow dr in dtItems.Rows) { obSPI.PartID = Convert.ToInt32(dr["PartID"]); obSPI.PartNo = dr["PartNo"].ToString(); obSPI.PartName = dr["PartName"].ToString(); obSPI.Price = Convert.ToDouble(dr["Price"]); if (Convert.ToInt32(dr["Quantity"]) > Convert.ToInt32(dr["CurrentStock"])) { obSPI.Quantity = Convert.ToInt32(dr["CurrentStock"]); obSPP.Quantity = Convert.ToInt32(dr["CurrentStock"]); } else { obSPI.Quantity = Convert.ToInt32(dr["Quantity"]); obSPP.Quantity = Convert.ToInt32(dr["Quantity"]); } obSPI.SitePartIssue(obSPI); obSPP.PartID = Convert.ToInt32(dr["PartID"]); try { obSPP.Rate = Convert.ToDouble(dr["Price"]); } catch { } obSPP.Total = obSPP.Rate * obSPP.Quantity; obSPP.SiteProductParts(obSPP); } } LoadOrder(); }
protected void grdParts_RowDeleting(object sender, GridViewDeleteEventArgs e) { clsSiteProductParts obj = new clsSiteProductParts(); obj.Op = 3; obj.ID = Convert.ToInt32(grdParts.DataKeys[e.RowIndex].Value); obj.SiteProductParts(obj); LoadAllData(); }
public void GetCurrentStockByProductAndSite(int SiteID, string PartNo) { clsSiteProductParts obj = new clsSiteProductParts(); obj.BillRef = PartNo; obj.SiteID = SiteID; obj.Op = 7; DataTable dt = obj.SiteProductParts(obj).Tables[0]; Context.Response.Write(JsonConvert.SerializeObject(dt)); }
void LoadAllData() { clsSiteProductParts obj = new clsSiteProductParts(); obj.SiteID = Convert.ToInt32(Request.Cookies["SiteID"].Value); obj.Op = 9; DataTable dt = obj.SiteProductParts(obj).Tables[0]; grdAllStock.DataSource = dt; grdAllStock.DataBind(); }
protected void grdParts_RowUpdating(object sender, GridViewUpdateEventArgs e) { TextBox txtEBillRef = (TextBox)grdParts.Rows[e.RowIndex].FindControl("txtEBillRef"); TextBox txtEQuantity = (TextBox)grdParts.Rows[e.RowIndex].FindControl("txtEQuantity"); clsSiteProductParts obj = new clsSiteProductParts(); obj.Op = 2; obj.Quantity = Convert.ToInt32(txtEQuantity.Text); obj.BillRef = txtEBillRef.Text; obj.SiteProductParts(obj); LoadAllData(); }
protected void txtPartNo1_TextChanged(object sender, EventArgs e) { TextBox txtPartNo = (TextBox)sender; GridViewRow row = txtPartNo.NamingContainer as GridViewRow; TextBox txtPartName = grd.Rows[row.RowIndex].FindControl("txtPartName1") as TextBox; Label lblCurrentStock = grd.Rows[row.RowIndex].FindControl("lblCurrentStock1") as Label; HiddenField hdPartID = grd.Rows[row.RowIndex].FindControl("hdPartID") as HiddenField; clsPart obj = new clsPart(); obj.PartName = txtPartNo.Text.Trim(); obj.Op = 8; DataTable dt = obj.PartMaster(obj).Tables[0]; if (dt.Rows.Count > 0) { txtPartName.Text = dt.Rows[0]["PartName"].ToString(); hdPartID.Value = dt.Rows[0]["ID"].ToString(); } else { hdPartID.Value = ""; } clsSiteProductParts obParts = new clsSiteProductParts(); obParts.SiteID = Convert.ToInt32(ddlSite.SelectedValue); try { obParts.PartID = Convert.ToInt32(dt.Rows[0]["ID"]); } catch { obParts.PartID = 0; } obParts.Op = 8; DataTable dtStock = obParts.SiteProductParts(obParts).Tables[0]; if (dtStock.Rows.Count > 0) { try { lblCurrentStock.Text = dtStock.Rows[0]["Quantity"].ToString(); } catch { lblCurrentStock.Text = "0"; } } else { lblCurrentStock.Text = "0"; } }
void LoadSelectedData(int Index) { clsSiteProductParts obj = new clsSiteProductParts(); obj.Op = 10; HiddenField hdSiteMachineID = grdAllStock.Rows[Index].FindControl("hdSiteMachineID") as HiddenField; HiddenField hdPartID = grdAllStock.Rows[Index].FindControl("hdPartID") as HiddenField; obj.SiteMachineID = Convert.ToInt32(hdSiteMachineID.Value); obj.PartID = Convert.ToInt32(hdPartID.Value); DataTable dt = obj.SiteProductParts(obj).Tables[0]; grdParts.DataSource = dt; grdParts.DataBind(); }
protected void txtPartNo_TextChanged(object sender, EventArgs e) { TextBox txtPartNo = sender as TextBox; txtPartNo.Text = txtPartNo.Text.Trim(); GridViewRow row = txtPartNo.NamingContainer as GridViewRow; TextBox txtItem = row.FindControl("txtItem") as TextBox; TextBox txtCurrentStock = row.FindControl("txtCurrentStock") as TextBox; TextBox txtQuantity = row.FindControl("txtQuantity") as TextBox; HiddenField hdPartID = row.FindControl("hdPartID") as HiddenField; clsPart obj = new clsPart(); obj.PartName = txtPartNo.Text.Trim(); obj.Op = 8; DataTable dt = obj.PartMaster(obj).Tables[0]; if (dt.Rows.Count > 0) { txtItem.Text = dt.Rows[0]["PartName"].ToString(); hdPartID.Value = dt.Rows[0]["ID"].ToString(); clsSiteProductParts obParts = new clsSiteProductParts(); obParts.SiteID = Convert.ToInt32(Convert.ToInt32(Request.Cookies["SiteID"].Value)); obParts.PartID = Convert.ToInt32(dt.Rows[0]["ID"]); obParts.Op = 8; DataTable dtStock = obParts.SiteProductParts(obParts).Tables[0]; if (dtStock.Rows.Count > 0) { try { txtCurrentStock.Text = dtStock.Rows[0]["Quantity"].ToString(); } catch { txtCurrentStock.Text = "0"; } } else { txtCurrentStock.Text = "0"; } txtQuantity.Focus(); } else { ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('New Item Will Be Added')", true); hdPartID.Value = "0"; } }
protected void txtPartNo_TextChanged(object sender, EventArgs e) { TextBox txtPartNo = sender as TextBox; txtPartNo.Text = txtPartNo.Text.Trim(); GridViewRow row = txtPartNo.NamingContainer as GridViewRow; TextBox txtItem = row.FindControl("txtItem") as TextBox; TextBox txtCurrentStock = row.FindControl("txtCurrentStock") as TextBox; TextBox txtQuantity = row.FindControl("txtQuantity") as TextBox; clsPart obj = new clsPart(); obj.PartName = txtPartNo.Text.Trim(); obj.Op = 8; DataTable dt = obj.PartMaster(obj).Tables[0]; if (dt.Rows.Count > 0) { txtItem.Text = dt.Rows[0]["PartName"].ToString(); clsSiteProductParts obParts = new clsSiteProductParts(); obParts.SiteID = Convert.ToInt32(Convert.ToInt32(Request.QueryString["SiteID"])); obParts.PartID = Convert.ToInt32(dt.Rows[0]["ID"]); obParts.Op = 8; DataTable dtStock = obParts.SiteProductParts(obParts).Tables[0]; if (dtStock.Rows.Count > 0) { try { txtCurrentStock.Text = dtStock.Rows[0]["Quantity"].ToString(); } catch { txtCurrentStock.Text = "0"; } } else { txtCurrentStock.Text = "0"; } txtQuantity.Focus(); } else { txtPartNo.Focus(); } }
protected void btnSave_Click(object sender, EventArgs e) { if (hdMachineID.Value != "" && hdPartID.Value != "") { clsSiteProductParts obj = new clsSiteProductParts(); //ID,SiteID,MachineID, PartID, EntryDate, BillRef, TransactionType, Quantity obj.SiteID = Convert.ToInt32(Request.Cookies["SiteID"].Value); obj.SiteMachineID = Convert.ToInt32(hdMachineID.Value); obj.PartID = Convert.ToInt32(hdPartID.Value); obj.EntryDate1 = txtEntryDate.Text; obj.BillRef = txtBillRef.Text; obj.TransactionType = Convert.ToInt32(ddlTransactionType.SelectedValue); obj.Quantity = Convert.ToInt32(txtQuantity.Text); obj.Op = 1; obj.SiteProductParts(obj); LoadAllData(); } }
public void SaveProductStock(int SiteID, int SiteMachineID, int PartID, string EntryDate, string BillRef, int TransactionType, int Quantity, double Rate, double Total, string Remarks) { clsSiteProductParts obj = new clsSiteProductParts(); obj.SiteID = SiteID; obj.SiteMachineID = SiteMachineID; obj.PartID = PartID; obj.EntryDate1 = EntryDate; obj.BillRef = BillRef; obj.TransactionType = TransactionType; obj.Quantity = Quantity; obj.Rate = Rate; obj.Total = Total; obj.Remarks = Remarks; obj.Op = 1; obj.SiteProductParts(obj); Context.Response.Write(JsonConvert.SerializeObject("Saved")); }
protected void grdParts_RowUpdating(object sender, GridViewUpdateEventArgs e) { TextBox txtEBillRef = (TextBox)grdParts.Rows[e.RowIndex].FindControl("txtEBillRef"); TextBox txtEQuantity = (TextBox)grdParts.Rows[e.RowIndex].FindControl("txtEQuantity"); Label lblTotalPrice = (Label)grdParts.Rows[e.RowIndex].FindControl("lblTotalPrice"); TextBox txtERate = (TextBox)grdParts.Rows[e.RowIndex].FindControl("txtERate"); clsSiteProductParts obj = new clsSiteProductParts(); obj.ID = Convert.ToInt32(grdParts.DataKeys[e.RowIndex].Value); obj.Op = 2; obj.Quantity = Convert.ToInt32(txtEQuantity.Text); obj.BillRef = txtEBillRef.Text; try { obj.Rate = Convert.ToDouble(txtERate.Text); } catch { } try { obj.Total = (Convert.ToDouble(txtERate.Text) * Convert.ToInt32(txtEQuantity.Text)); } catch { } obj.SiteProductParts(obj); LoadSelectedData(grdAllStock.SelectedIndex); }
protected void txtPartNo_TextChanged(object sender, EventArgs e) { clsPart obj = new clsPart(); obj.PartName = txtPartNo.Text.Trim(); obj.Op = 8; DataTable dt = obj.PartMaster(obj).Tables[0]; if (dt.Rows.Count > 0) { lblPartNo.Text = dt.Rows[0]["SerialNo"].ToString(); lblPartName.Text = dt.Rows[0]["PartName"].ToString(); //txtPartName.Text = dt.Rows[0]["PartName"].ToString(); txtDetail.Text = "Machine Model/Name: " + dt.Rows[0]["ModelNo"].ToString() + "\n Manufacturer/Supplier: " + dt.Rows[0]["Manufacturer"].ToString() + "\n Part No:" + dt.Rows[0]["SerialNo"].ToString() + "\n Part Name:" + dt.Rows[0]["PartName"].ToString(); clsSiteProductParts obParts = new clsSiteProductParts(); obParts.SiteID = Convert.ToInt32(Request.Cookies["SiteID"].Value); obParts.PartID = Convert.ToInt32(dt.Rows[0]["ID"]); obParts.Op = 8; DataTable dtStock = obParts.SiteProductParts(obParts).Tables[0]; if (dtStock.Rows.Count > 0) { try { txtCurrentStock.Text = dtStock.Rows[0]["Quantity"].ToString(); } catch { txtCurrentStock.Text = "0"; } } else { txtCurrentStock.Text = "0"; } } else { txtPartNo.Focus(); } }