public static Inv_ItemTransaction GetInv_ItemTransactionByID(int id) { Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction(); SqlInv_ItemTransactionProvider sqlInv_ItemTransactionProvider = new SqlInv_ItemTransactionProvider(); inv_ItemTransaction = sqlInv_ItemTransactionProvider.GetInv_ItemTransactionByID(id); return inv_ItemTransaction; }
protected void btnAdd_Click(object sender, EventArgs e) { Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction(); inv_ItemTransaction.ItemID = Int32.Parse(ddlItem.SelectedValue); inv_ItemTransaction.Quantity = Decimal.Parse(txtQuantity.Text); inv_ItemTransaction.ItemTrasactionTypeID = Int32.Parse(ddlItemTrasactionType.SelectedValue); inv_ItemTransaction.ReferenceID = Int32.Parse(ddlReference.SelectedValue); inv_ItemTransaction.ExtraField1 = txtExtraField1.Text; inv_ItemTransaction.ExtraField2 = txtExtraField2.Text; inv_ItemTransaction.ExtraField3 = txtExtraField3.Text; inv_ItemTransaction.ExtraField4 = txtExtraField4.Text; inv_ItemTransaction.ExtraField5 = txtExtraField5.Text; inv_ItemTransaction.AddedBy =getLogin().LoginID; inv_ItemTransaction.AddedDate = DateTime.Now; inv_ItemTransaction.UpdatedBy = getLogin().LoginID; inv_ItemTransaction.UpdatedDate = DateTime.Now; inv_ItemTransaction.RowStatusID = 1; int resutl = Inv_ItemTransactionManager.InsertInv_ItemTransaction(inv_ItemTransaction); Response.Redirect("AdminInv_ItemTransactionDisplay.aspx"); }
protected void btnUpdate_Click(object sender, EventArgs e) { Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction(); inv_ItemTransaction = Inv_ItemTransactionManager.GetInv_ItemTransactionByID(Int32.Parse(Request.QueryString["inv_ItemTransactionID"])); Inv_ItemTransaction tempInv_ItemTransaction = new Inv_ItemTransaction(); tempInv_ItemTransaction.Inv_ItemTransactionID = inv_ItemTransaction.Inv_ItemTransactionID; tempInv_ItemTransaction.ItemID = Int32.Parse(ddlItem.SelectedValue); tempInv_ItemTransaction.Quantity = Decimal.Parse(txtQuantity.Text); tempInv_ItemTransaction.ItemTrasactionTypeID = Int32.Parse(ddlItemTrasactionType.SelectedValue); tempInv_ItemTransaction.ReferenceID = Int32.Parse(ddlReference.SelectedValue); tempInv_ItemTransaction.ExtraField1 = txtExtraField1.Text; tempInv_ItemTransaction.ExtraField2 = txtExtraField2.Text; tempInv_ItemTransaction.ExtraField3 = txtExtraField3.Text; tempInv_ItemTransaction.ExtraField4 = txtExtraField4.Text; tempInv_ItemTransaction.ExtraField5 = txtExtraField5.Text; tempInv_ItemTransaction.AddedBy =getLogin().LoginID; tempInv_ItemTransaction.AddedDate = DateTime.Now; tempInv_ItemTransaction.UpdatedBy = getLogin().LoginID; tempInv_ItemTransaction.UpdatedDate = DateTime.Now; tempInv_ItemTransaction.RowStatusID = 1; bool result = Inv_ItemTransactionManager.UpdateInv_ItemTransaction(tempInv_ItemTransaction); Response.Redirect("AdminInv_ItemTransactionDisplay.aspx"); }
public bool UpdateInv_ItemTransaction(Inv_ItemTransaction inv_ItemTransaction) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("GP_UpdateInv_ItemTransaction", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Inv_ItemTransactionID", SqlDbType.Int).Value = inv_ItemTransaction.Inv_ItemTransactionID; cmd.Parameters.Add("@ItemID", SqlDbType.Int).Value = inv_ItemTransaction.ItemID; cmd.Parameters.Add("@Quantity", SqlDbType.Decimal).Value = inv_ItemTransaction.Quantity; cmd.Parameters.Add("@ItemTrasactionTypeID", SqlDbType.Int).Value = inv_ItemTransaction.ItemTrasactionTypeID; cmd.Parameters.Add("@ReferenceID", SqlDbType.Decimal).Value = inv_ItemTransaction.ReferenceID; cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = inv_ItemTransaction.ExtraField1; cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = inv_ItemTransaction.ExtraField2; cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = inv_ItemTransaction.ExtraField3; cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = inv_ItemTransaction.ExtraField4; cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = inv_ItemTransaction.ExtraField5; cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = inv_ItemTransaction.AddedBy; cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = inv_ItemTransaction.AddedDate; cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = inv_ItemTransaction.UpdatedBy; cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = inv_ItemTransaction.UpdatedDate; cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_ItemTransaction.RowStatusID; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public Inv_ItemTransaction GetInv_ItemTransactionFromReader(IDataReader reader) { try { Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction ( (int)reader["Inv_ItemTransactionID"], (int)reader["ItemID"], (decimal)reader["Quantity"], (int)reader["ItemTrasactionTypeID"], (decimal)reader["ReferenceID"], reader["ExtraField1"].ToString(), reader["ExtraField2"].ToString(), reader["ExtraField3"].ToString(), reader["ExtraField4"].ToString(), reader["ExtraField5"].ToString(), (int)reader["AddedBy"], (DateTime)reader["AddedDate"], (int)reader["UpdatedBy"], (DateTime)reader["UpdatedDate"], (int)reader["RowStatusID"] ); return inv_ItemTransaction; } catch(Exception ex) { return null; } }
protected void btnAdd_Click(object sender, EventArgs e) { int purchaseReturnID = 0; Inv_PurchaseReturen inv_PurchaseReturen = new Inv_PurchaseReturen(); inv_PurchaseReturen.PurchseReturenDate = DateTime.Parse(txtPurchaseReturnDate.Text); inv_PurchaseReturen.PurchaseIDs = getPurchaseIDs(true); inv_PurchaseReturen.WorkSatationID = 2; inv_PurchaseReturen.ExtraField1 = ddlSuppier.SelectedValue; inv_PurchaseReturen.ExtraField2 = txtNote.Text; inv_PurchaseReturen.ExtraField3 = ""; inv_PurchaseReturen.ExtraField4 = ""; inv_PurchaseReturen.ExtraField5 = ""; inv_PurchaseReturen.AddedBy = getLogin().LoginID; inv_PurchaseReturen.AddedDate = DateTime.Now; inv_PurchaseReturen.UpdatedBy = getLogin().LoginID; inv_PurchaseReturen.UpdatedDate = DateTime.Now; inv_PurchaseReturen.RowStatusID = 1; int purchaseAdjustmentID = 0; Inv_PurchaseAdjustment inv_PurchaseAdjustment = new Inv_PurchaseAdjustment(); inv_PurchaseAdjustment.PurchseAdjustmentDate = DateTime.Parse(txtPurchaseReturnDate.Text); inv_PurchaseAdjustment.PurchaseIDs = getPurchaseIDs(false); inv_PurchaseAdjustment.WorkSatationID =2; inv_PurchaseAdjustment.ExtraField1 = ddlSuppier.SelectedValue; inv_PurchaseAdjustment.ExtraField2 = txtNote.Text; inv_PurchaseAdjustment.ExtraField3 = ""; inv_PurchaseAdjustment.ExtraField4 = ""; inv_PurchaseAdjustment.ExtraField5 = ""; inv_PurchaseAdjustment.AddedBy = getLogin().LoginID; inv_PurchaseAdjustment.AddedDate = DateTime.Now; inv_PurchaseAdjustment.UpdatedBy = getLogin().LoginID; inv_PurchaseAdjustment.UpdatedDate = DateTime.Now; inv_PurchaseAdjustment.RowStatusID = 1; foreach (GridViewRow gvr in gvInv_Item.Rows) { HiddenField hfInv_ItemID = (HiddenField)gvr.FindControl("hfInv_ItemID"); Label lblPurchaseID = (Label)gvr.FindControl("lblPurchaseID"); TextBox txtReturnQuantity = (TextBox)gvr.FindControl("txtReturnQuantity"); TextBox txtAdjustmentQuantity = (TextBox)gvr.FindControl("txtAdjustmentQuantity"); if (txtReturnQuantity.Text != "0") { if (purchaseReturnID == 0) { purchaseReturnID = Inv_PurchaseReturenManager.InsertInv_PurchaseReturen(inv_PurchaseReturen); } Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction(); inv_ItemTransaction.ItemID = Int32.Parse(hfInv_ItemID.Value); inv_ItemTransaction.Quantity = Decimal.Parse(txtReturnQuantity.Text); inv_ItemTransaction.ItemTrasactionTypeID = 1;//purchase return inv_ItemTransaction.ReferenceID = purchaseReturnID; inv_ItemTransaction.ExtraField1 =""; inv_ItemTransaction.ExtraField2 = ""; inv_ItemTransaction.ExtraField3 = ""; inv_ItemTransaction.ExtraField4 = ""; inv_ItemTransaction.ExtraField5 = ""; inv_ItemTransaction.AddedBy = getLogin().LoginID; inv_ItemTransaction.AddedDate = DateTime.Now; inv_ItemTransaction.UpdatedBy = getLogin().LoginID; inv_ItemTransaction.UpdatedDate = DateTime.Parse(txtPurchaseReturnDate.Text); inv_ItemTransaction.RowStatusID = 1; int resutl = Inv_ItemTransactionManager.InsertInv_ItemTransaction(inv_ItemTransaction); } if (txtAdjustmentQuantity.Text != "0") { if (purchaseAdjustmentID == 0) { purchaseAdjustmentID = Inv_PurchaseAdjustmentManager.InsertInv_PurchaseAdjustment(inv_PurchaseAdjustment); } Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction(); inv_ItemTransaction.ItemID = Int32.Parse(hfInv_ItemID.Value); inv_ItemTransaction.Quantity = Decimal.Parse(txtAdjustmentQuantity.Text); inv_ItemTransaction.ItemTrasactionTypeID =7;//Adjustment inv_ItemTransaction.ReferenceID = purchaseAdjustmentID; inv_ItemTransaction.ExtraField1 = ""; inv_ItemTransaction.ExtraField2 = ""; inv_ItemTransaction.ExtraField3 = ""; inv_ItemTransaction.ExtraField4 = ""; inv_ItemTransaction.ExtraField5 = ""; inv_ItemTransaction.AddedBy = getLogin().LoginID; inv_ItemTransaction.AddedDate = DateTime.Now; inv_ItemTransaction.UpdatedBy = getLogin().LoginID; inv_ItemTransaction.UpdatedDate = DateTime.Parse(txtPurchaseReturnDate.Text); inv_ItemTransaction.RowStatusID = 1; int resutl = Inv_ItemTransactionManager.InsertInv_ItemTransaction(inv_ItemTransaction); } } if (purchaseReturnID != 0) { hlnkPurchasePrint.NavigateUrl = "PurchaseReturnPrint.aspx?ReturnID=" + purchaseReturnID.ToString(); hlnkPurchasePrint.Visible = true; } if (purchaseAdjustmentID != 0) { hlnkAdjustmentPrint.NavigateUrl = "AdjustmentPrint.aspx?AdjustmentID=" + purchaseAdjustmentID.ToString(); hlnkAdjustmentPrint.Visible = true; } showInv_IssueDetailGrid(); }
private void showInv_ItemTransactionData() { Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction(); inv_ItemTransaction = Inv_ItemTransactionManager.GetInv_ItemTransactionByID(Int32.Parse(Request.QueryString["inv_ItemTransactionID"])); ddlItem.SelectedValue = inv_ItemTransaction.ItemID.ToString(); txtQuantity.Text = inv_ItemTransaction.Quantity.ToString(); ddlItemTrasactionType.SelectedValue = inv_ItemTransaction.ItemTrasactionTypeID.ToString(); ddlReference.SelectedValue = inv_ItemTransaction.ReferenceID.ToString(); txtExtraField1.Text = inv_ItemTransaction.ExtraField1; txtExtraField2.Text = inv_ItemTransaction.ExtraField2; txtExtraField3.Text = inv_ItemTransaction.ExtraField3; txtExtraField4.Text = inv_ItemTransaction.ExtraField4; txtExtraField5.Text = inv_ItemTransaction.ExtraField5; txtAddedBy.Text = inv_ItemTransaction.AddedBy.ToString(); txtUpdatedBy.Text = inv_ItemTransaction.UpdatedBy.ToString(); txtUpdatedDate.Text = inv_ItemTransaction.UpdatedDate; ddlRowStatus.SelectedValue = inv_ItemTransaction.RowStatusID.ToString(); }
public static bool UpdateInv_ItemTransaction(Inv_ItemTransaction inv_ItemTransaction) { SqlInv_ItemTransactionProvider sqlInv_ItemTransactionProvider = new SqlInv_ItemTransactionProvider(); return sqlInv_ItemTransactionProvider.UpdateInv_ItemTransaction(inv_ItemTransaction); }
public static int InsertInv_ItemTransaction(Inv_ItemTransaction inv_ItemTransaction) { SqlInv_ItemTransactionProvider sqlInv_ItemTransactionProvider = new SqlInv_ItemTransactionProvider(); return sqlInv_ItemTransactionProvider.InsertInv_ItemTransaction(inv_ItemTransaction); }
protected void btnIssueReturn_Click(object sender, EventArgs e) { bool hasReturnItem = false; foreach (GridViewRow gvr in gvInv_IssueDetail.Rows) { TextBox txtIssueReturn = (TextBox)gvr.FindControl("txtIssueReturn"); if (txtIssueReturn.Text != "0" || txtIssueReturn.Text != "") { hasReturnItem = true; break; } } if (hasReturnItem) { Inv_IssueMasterReturn inv_IssueMasterReturn = new Inv_IssueMasterReturn(); inv_IssueMasterReturn.IssueReturnName = ""; inv_IssueMasterReturn.IssueReturnDate = DateTime.Parse(txtDate.Text); inv_IssueMasterReturn.EmployeeID = Int32.Parse(ddlEmployee.SelectedValue); inv_IssueMasterReturn.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue); inv_IssueMasterReturn.Particulars = txtParticulars.Text; inv_IssueMasterReturn.IsIssue = ddlProduct.SelectedValue =="0"?false:true; inv_IssueMasterReturn.ExtraField1 = ""; inv_IssueMasterReturn.ExtraField2 = ""; inv_IssueMasterReturn.ExtraField3 = ""; inv_IssueMasterReturn.ExtraField4 = ""; inv_IssueMasterReturn.ExtraField5 = ""; inv_IssueMasterReturn.AddedBy = getLogin().LoginID; inv_IssueMasterReturn.AddedDate = DateTime.Now; inv_IssueMasterReturn.UpdatedBy = getLogin().LoginID; inv_IssueMasterReturn.UpdatedDate = DateTime.Now; inv_IssueMasterReturn.RowStatusID = 1; inv_IssueMasterReturn.Inv_IssueMasterReturnID = Inv_IssueMasterReturnManager.InsertInv_IssueMasterReturn(inv_IssueMasterReturn); foreach (GridViewRow gvr in gvInv_IssueDetail.Rows) { TextBox txtIssueReturn = (TextBox)gvr.FindControl("txtIssueReturn"); HiddenField hfItemID = (HiddenField)gvr.FindControl("hfItemID"); HiddenField hfInv_IssueDetailID = (HiddenField)gvr.FindControl("hfInv_IssueDetailID"); if (txtIssueReturn.Text != "0" && txtIssueReturn.Text != "") { Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction(); inv_ItemTransaction.ItemID = Int32.Parse(hfItemID.Value); inv_ItemTransaction.Quantity = Decimal.Parse(txtIssueReturn.Text); inv_ItemTransaction.ItemTrasactionTypeID = 3;//issue return inv_ItemTransaction.ReferenceID = inv_IssueMasterReturn.Inv_IssueMasterReturnID; inv_ItemTransaction.ExtraField1 = hfInv_IssueDetailID.Value; inv_ItemTransaction.ExtraField2 = ""; inv_ItemTransaction.ExtraField3 = ""; inv_ItemTransaction.ExtraField4 = ""; inv_ItemTransaction.ExtraField5 = inv_IssueMasterReturn.Inv_IssueMasterReturnID.ToString(); inv_ItemTransaction.AddedBy = getLogin().LoginID; inv_ItemTransaction.AddedDate = DateTime.Now; inv_ItemTransaction.UpdatedBy = getLogin().LoginID; inv_ItemTransaction.UpdatedDate = DateTime.Parse(txtDate.Text); inv_ItemTransaction.RowStatusID = 1; int resutl = Inv_ItemTransactionManager.InsertInv_ItemTransaction(inv_ItemTransaction); } } hlnkIssueReturnPrint.NavigateUrl = "IssueReturnPrint.aspx?IssueReturnID=" + inv_IssueMasterReturn.Inv_IssueMasterReturnID; hlnkIssueReturnPrint.Visible = true; } }
public static bool UpdateInv_ItemTransaction(Inv_ItemTransaction inv_ItemTransaction) { SqlInv_ItemTransactionProvider sqlInv_ItemTransactionProvider = new SqlInv_ItemTransactionProvider(); return(sqlInv_ItemTransactionProvider.UpdateInv_ItemTransaction(inv_ItemTransaction)); }
public static int InsertInv_ItemTransaction(Inv_ItemTransaction inv_ItemTransaction) { SqlInv_ItemTransactionProvider sqlInv_ItemTransactionProvider = new SqlInv_ItemTransactionProvider(); return(sqlInv_ItemTransactionProvider.InsertInv_ItemTransaction(inv_ItemTransaction)); }
protected void btnAdd_Click(object sender, EventArgs e) { Inv_PurchaseReturen inv_PurchaseReturen = new Inv_PurchaseReturen(); inv_PurchaseReturen.PurchseReturenDate = DateTime.Parse(txtPurchaseReturnDate.Text); inv_PurchaseReturen.PurchaseIDs = getPurchaseIDs(); inv_PurchaseReturen.WorkSatationID = 2; inv_PurchaseReturen.ExtraField1 = ddlSuppier.SelectedValue; inv_PurchaseReturen.ExtraField2 = txtNote.Text; inv_PurchaseReturen.ExtraField3 = ""; inv_PurchaseReturen.ExtraField4 = ""; inv_PurchaseReturen.ExtraField5 = ""; inv_PurchaseReturen.AddedBy = getLogin().LoginID; inv_PurchaseReturen.AddedDate = DateTime.Now; inv_PurchaseReturen.UpdatedBy = getLogin().LoginID; inv_PurchaseReturen.UpdatedDate = DateTime.Now; inv_PurchaseReturen.RowStatusID = 1; int purchaseReturnID = 0; foreach (GridViewRow gvr in gvInv_Item.Rows) { HiddenField hfInv_ItemID = (HiddenField)gvr.FindControl("hfInv_ItemID"); Label lblPurchaseID = (Label)gvr.FindControl("lblPurchaseID"); TextBox txtReturnQuantity = (TextBox)gvr.FindControl("txtReturnQuantity"); TextBox txtAdjustmentQuantity = (TextBox)gvr.FindControl("txtAdjustmentQuantity"); if (txtReturnQuantity.Text != "0") { if (purchaseReturnID == 0) { purchaseReturnID = Inv_PurchaseReturenManager.InsertInv_PurchaseReturen(inv_PurchaseReturen); } Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction(); inv_ItemTransaction.ItemID = Int32.Parse(hfInv_ItemID.Value); inv_ItemTransaction.Quantity = Decimal.Parse(txtReturnQuantity.Text); inv_ItemTransaction.ItemTrasactionTypeID = 1;//purchase return inv_ItemTransaction.ReferenceID = purchaseReturnID; inv_ItemTransaction.ExtraField1 = ""; inv_ItemTransaction.ExtraField2 = ""; inv_ItemTransaction.ExtraField3 = ""; inv_ItemTransaction.ExtraField4 = ""; inv_ItemTransaction.ExtraField5 = ""; inv_ItemTransaction.AddedBy = getLogin().LoginID; inv_ItemTransaction.AddedDate = DateTime.Now; inv_ItemTransaction.UpdatedBy = getLogin().LoginID; inv_ItemTransaction.UpdatedDate = DateTime.Now; inv_ItemTransaction.RowStatusID = 1; int resutl = Inv_ItemTransactionManager.InsertInv_ItemTransaction(inv_ItemTransaction); } if (txtAdjustmentQuantity.Text != "0") { Inv_ItemTransaction inv_ItemTransaction = new Inv_ItemTransaction(); inv_ItemTransaction.ItemID = Int32.Parse(hfInv_ItemID.Value); inv_ItemTransaction.Quantity = Decimal.Parse(txtAdjustmentQuantity.Text); inv_ItemTransaction.ItemTrasactionTypeID = 7;//purchase return inv_ItemTransaction.ReferenceID = purchaseReturnID; inv_ItemTransaction.ExtraField1 = ""; inv_ItemTransaction.ExtraField2 = ""; inv_ItemTransaction.ExtraField3 = ""; inv_ItemTransaction.ExtraField4 = ""; inv_ItemTransaction.ExtraField5 = ""; inv_ItemTransaction.AddedBy = getLogin().LoginID; inv_ItemTransaction.AddedDate = DateTime.Now; inv_ItemTransaction.UpdatedBy = getLogin().LoginID; inv_ItemTransaction.UpdatedDate = DateTime.Now; inv_ItemTransaction.RowStatusID = 1; int resutl = Inv_ItemTransactionManager.InsertInv_ItemTransaction(inv_ItemTransaction); } } if (purchaseReturnID != 0) { hlnkPurchasePrint.NavigateUrl = "PurchaseReturnPrint.aspx?ReturnID=" + purchaseReturnID.ToString(); hlnkPurchasePrint.Visible = true; } }