private void itemSetupToolStripMenuItem_Click(object sender, EventArgs e) { this.Hide(); ItemSetup items = new ItemSetup(); items.Show(); }
private void saveButton_Click(object sender, EventArgs e) { try { ItemSetup insGetSet = new ItemSetup(); insGetSet.CatagoryName = categoryComboBox.Text; insGetSet.ComapanyName = companyComboBox.Text; insGetSet.ItemName = itemTextBox.Text; insGetSet.ReorderLavel = reorderTextBox.Text; ItemSetupManager companymanager = new ItemSetupManager(); bool chk = companymanager.Insert(insGetSet); if (chk) { MessageBox.Show("Data Saved", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Try Again"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public List <ItemSetup> GetAllItemsByCompany(int id) { string query = "SELECT * FROM ItemSetup WHERE CompanyId =" + id; Command = new SqlCommand(query, Connection); Connection.Open(); Reader = Command.ExecuteReader(); List <ItemSetup> items = new List <ItemSetup>(); while (Reader.Read()) { ItemSetup itemSetup = new ItemSetup(); itemSetup.Id = Convert.ToInt32(Reader["Id"]); itemSetup.CategoryId = Convert.ToInt32(Reader["CategoryId"]); itemSetup.CompanyId = Convert.ToInt32(Reader["CompanyId"]); itemSetup.ReorderLevel = Convert.ToInt32(Reader["ReorderLevel"]); itemSetup.ItemName = Reader["ItemName"].ToString(); items.Add(itemSetup); } Connection.Close(); return(items); }
internal void Update(string connectionString, ItemSetup objItemSetup) { try { var storedProcedureComandTest = "exec [spUpdatematMaterialSetup] " + objItemSetup.ItemID + "," + objItemSetup.ItemCategoryID + "," + objItemSetup.ItemTypeID + "," + objItemSetup.ItemPropertySetID + "," + objItemSetup.ItemUsageID + ",'" + objItemSetup.ModelNo + "'," + objItemSetup.UnitID + ",'" + objItemSetup.HsCode + "','" + objItemSetup.ItemCode + "','" + objItemSetup.Specification + "'," + objItemSetup.OpenningBalance + ",'" + objItemSetup.SupplierID + "'," + objItemSetup.IsVATAbleItem + "," + objItemSetup.CoaSalesAccNo + "," + objItemSetup.CoaStockAccNo + "," + objItemSetup.CoacgsAccNo + "," + objItemSetup.CoaSalesRetAccNo + ",'" + objItemSetup.EntryUserName + "'," + objItemSetup.BreakUpQuantity + ",'" + objItemSetup.ReOrderLevel + "'," + objItemSetup.BreakUpUnitD + "," + objItemSetup.MinimumQuantity; clsDataManipulation.StoredProcedureExecuteNonQuery(connectionString, storedProcedureComandTest); } catch (Exception msgException) { throw msgException; } }
public List <ItemSetup> SearchItems(string query) { command = new SqlCommand(query, connection); List <ItemSetup> searchItemList = new List <ItemSetup>(); int sl = 1; connection.Open(); reader = command.ExecuteReader(); while (reader.Read()) { ItemSetup aSearchItem = new ItemSetup(); aSearchItem.CatagoryId = sl++; //categoryId = SL aSearchItem.CompanyName = reader["CompanyName"].ToString(); aSearchItem.ItemName = reader["ItemName"].ToString(); aSearchItem.AvailableQuantity = Convert.ToInt32(reader["AvailableQuantity"]); aSearchItem.ReorderLevel = Convert.ToInt32(reader["ReorderLevel"]); searchItemList.Add(aSearchItem); } reader.Close(); connection.Close(); return(searchItemList); }
public string Save(ItemSetup itemSetup) { int check = itemSetupGateway.Save(itemSetup); if (check > 0) { return("Save Successful"); } return("Save Faild"); }
public int SaveGateway(ItemSetup itemSetup) { string query = "INSERT INTO ItemSetup VALUES('" + itemSetup.CategoryId + "','" + itemSetup.CompanyId + "','" + itemSetup.ItemName + "','" + itemSetup.ReorderLevel + "')"; Command = new SqlCommand(query, Connection); Connection.Open(); int rowAffect = Command.ExecuteNonQuery(); Connection.Close(); return(rowAffect); }
protected void TreeViewCategory_SelectedNodeChanged(object sender, EventArgs e) { try { _objItemCategorySetup = new ItemCategorySetup(); _objItemCategorySetup.ItemCategoryID = Convert.ToInt32(TreeViewCategory.SelectedNode.Value); var parentID = TreeViewCategory.SelectedNode.Parent == null ? _objItemCategorySetup.ItemCategoryID : Convert.ToInt32(TreeViewCategory.SelectedNode.Parent.Value); var childID = 0; if (TreeViewCategory.SelectedNode.ChildNodes.Count > 0) { childID = Convert.ToInt32(TreeViewCategory.SelectedNode.ChildNodes[0].Value.ToString()); } int countIDDigit = Convert.ToInt32(_objItemCategorySetup.ItemCategoryID.ToString().Length.ToString()); int countChildIDDigit = Convert.ToInt32(childID.ToString().Length.ToString()); if (countIDDigit == 9) { ddlParentCategory.SelectedValue = _objItemCategorySetup.ItemCategoryID.ToString(); ddlCategory.SelectedValue = _objItemCategorySetup.ItemCategoryID.ToString(); CheckBoxAddItem.Enabled = true; txtCategoryName.Focus(); txtCategoryName.Enabled = true; PanelItemDetails.Visible = false; btnUpdate.Visible = false; if (countChildIDDigit == 8) { txtCategoryName.Enabled = false; } } else { ddlParentCategory.SelectedValue = parentID.ToString(); ddlCategory.SelectedValue = parentID.ToString(); txtCategoryName.Enabled = false; CheckBoxAddItem.Enabled = false; PanelItemDetails.Visible = true; LoadDropDownListData(ddlItemTypeIDUpdate, ddlUnitUpdate, ddlBreakupUnitUpdate, ddlItemUsageIDUpdate, ddlRelatedSupplierUpdate, ddlSalesAccountNoUpdate, ddlStockAccountNoUpdate, ddlCOGSAccountNoUpdate, ddlSalesReturnAccountUpdate); _objItemSetup = new ItemSetup(); _objItemSetup.ItemID = Convert.ToInt32(TreeViewCategory.SelectedNode.Value); Session["itemID"] = _objItemSetup.ItemID; ShowItemDetails(_objItemSetup); btnUpdate.Visible = true; } } catch (Exception msgException) { clsTopMostMessageBox.Show(msgException.Message); } }
internal DataTable GetItemDetails(string connectionString, ItemSetup _objItemSetup) { try { DataTable dtItemDetails = null; var storedProcedureComandTest = "exec [spGetDetailsmatMaterialSetup] " + _objItemSetup.ItemID + ""; dtItemDetails = clsDataManipulation.GetData(connectionString, storedProcedureComandTest); return(dtItemDetails); } catch (Exception msgException) { throw msgException; } }
private bool IsItemExists(ItemSetup itemSetup) { query = "SELECT * FROM itemTable WHERE CompanyId = '" + itemSetup.CompanyId + "' AND ItemName='" + itemSetup.ItemName + "' "; command = new SqlCommand(query, connection); connection.Open(); reader = command.ExecuteReader(); bool check = reader.HasRows; reader.Close(); connection.Close(); return(check); }
public int Save(ItemSetup itemSetup) { if (IsItemExists(itemSetup) == false) { query = "INSERT INTO itemTable VALUES ('" + itemSetup.CatagoryId + "', '" + itemSetup.CompanyId + "', '" + itemSetup.ItemName + "'," + itemSetup.ReorderLevel + ", " + itemSetup.AvailableQuantity + " )"; command = new SqlCommand(query, connection); connection.Open(); int check = command.ExecuteNonQuery(); connection.Close(); return(check); } return(-1); }
internal DataTable GetItemDetails2(string connectionString, ItemSetup _objItemSetup) { DataTable dtItemDetails = null; try { var storedProcedureComandTest = " SELECT * FROM matMaterialSetup where ItemID =" + _objItemSetup.ItemCode + ""; dtItemDetails = clsDataManipulation.GetData(connectionString, storedProcedureComandTest); return(dtItemDetails); } catch { return(dtItemDetails); } }
public string SaveManager(ItemSetup itemSetup) { if (itemSetupGateway.IsItemNameExist(itemSetup.ItemName)) { return("Item Name already exists !"); } else { int row = itemSetupGateway.SaveGateway(itemSetup); if (row > 0) { return("Save Successful !"); } else { return("Saving Failed !"); } } }
private void ShowItemDetails(ItemSetup objItemSetup) { try { DataTable dtItemDetails = null; _objItemSetupController = new ItemSetupController(); dtItemDetails = _objItemSetupController.GetItemDetails(_connectionString, objItemSetup); foreach (DataRow rowNo in dtItemDetails.Rows) { txtItemCodeUpdate.Text = rowNo["ItemCode"].ToString(); txtItemNameUpdate.Text = rowNo["ModelNo"].ToString(); ddlItemTypeIDUpdate.SelectedValue = rowNo["ItemTypeID"].ToString() == null ? "-1" : rowNo["ItemTypeID"].ToString(); ddlItemUsageIDUpdate.SelectedValue = rowNo["ItemUsageID"].ToString() == null ? "-1" : rowNo["ItemUsageID"].ToString(); ddlRelatedSupplierUpdate.SelectedValue = rowNo["SupplierID"].ToString() == "" ? "-1" : rowNo["SupplierID"].ToString(); txtDescriptionUpdate.Text = rowNo["Specification"].ToString(); txtHSCodeUpdate.Text = rowNo["HSCode"].ToString(); txtOpeningBalanceUpdate.Text = rowNo["OpenningBalance"].ToString(); ddlUnitUpdate.SelectedValue = rowNo["UnitID"].ToString() == null ? "-1" : rowNo["UnitID"].ToString(); txtBreakUpQuantityUpdate.Text = rowNo["BreakUpQuantity"].ToString(); ddlBreakupUnitUpdate.SelectedValue = rowNo["BreakUpUnitID"].ToString() == null ? "-1" : rowNo["BreakUpUnitID"].ToString(); txtReOrderLevelUpdate.Text = rowNo["ReOrderLevel"].ToString(); txtMinimumQuantityUpdate.Text = rowNo["MinimumBal"].ToString(); ddlSalesAccountNoUpdate.SelectedValue = rowNo["COASalesAccNo"].ToString() == null ? "-1" : rowNo["COASalesAccNo"].ToString(); ddlStockAccountNoUpdate.SelectedValue = rowNo["COAStockAccNo"].ToString() == null ? "-1" : rowNo["COAStockAccNo"].ToString(); ddlCOGSAccountNoUpdate.SelectedValue = rowNo["COACGSAccNo"].ToString() == null ? "-1" : rowNo["COACGSAccNo"].ToString(); ddlSalesReturnAccountUpdate.SelectedValue = rowNo["COASalesRetAccNo"].ToString() == null ? "-1" : rowNo["COASalesRetAccNo"].ToString(); var vatValue = rowNo["IsVATableItem"].ToString(); if (Convert.ToBoolean(vatValue) == true) { CheckBoxIsVATUpdate.Checked = true; } else { CheckBoxIsVATUpdate.Checked = false; } } } catch (Exception msgException) { throw msgException; } }
void SetupBuildMenu() { foreach (Transform child in BuildItemsHolder.transform) { GameObject.Destroy(child.gameObject); } foreach (UIElement element in UIElements) { if (element.isActive) { var inst = Instantiate(BuildContentItem, BuildItemsHolder.transform); ItemSetup setup = inst.GetComponent <ItemSetup>(); setup.rendTexture = element.prefabIcon; setup.radius = 2; setup.textureHeight = element.prefabIcon.height; setup.textureWidth = element.prefabIcon.width; setup.prefab = element.prefab; setup.SetIcon(); } } }
public bool Insert(ItemSetup it) { string query = @"INSERT ItemSetup (catagoryName,companyName,ItemName,ReorderLavel) Values (@catagoryName,@companyName,@ItemName,@ReorderLavel)"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@catagoryName", it.CatagoryName); cmd.Parameters.AddWithValue("@companyName", it.ComapanyName); cmd.Parameters.AddWithValue("@ItemName", it.ItemName); cmd.Parameters.AddWithValue("@ReorderLavel", it.ReorderLavel); con.Open(); int rowAffect = cmd.ExecuteNonQuery(); con.Close(); if (rowAffect > 0) { return(true); } else { return(false); } }
private void AssignItemValuesForUpdate() { try { _objItemSetup = new ItemSetup(); _objItemSetup.ItemCategoryID = Convert.ToInt32(ddlParentCategory.SelectedValue); _objItemSetup.Specification = txtDescriptionUpdate.Text == string.Empty ? null : txtDescriptionUpdate.Text; _objItemSetup.HsCode = txtHSCodeUpdate.Text == string.Empty ? null : txtHSCodeUpdate.Text; _objItemSetup.IsVATAbleItem = CheckBoxIsVATUpdate.Checked == true ? true : false; _objItemSetup.SupplierID = ddlRelatedSupplierUpdate.SelectedValue == "-1" ? null : ddlRelatedSupplierUpdate.SelectedValue; _objItemSetup.OpenningBalance = txtOpeningBalanceUpdate.Text == string.Empty ? 0 : Convert.ToInt32(txtOpeningBalanceUpdate.Text); _objItemSetup.CoaSalesAccNo = Convert.ToInt32(ddlSalesAccountNoUpdate.SelectedValue); _objItemSetup.CoaStockAccNo = Convert.ToInt32(ddlStockAccountNoUpdate.SelectedValue); _objItemSetup.CoacgsAccNo = Convert.ToInt32(ddlCOGSAccountNoUpdate.SelectedValue); _objItemSetup.CoaSalesRetAccNo = Convert.ToInt32(ddlSalesReturnAccountUpdate.SelectedValue); _objItemSetup.EntryUserName = Session["entryUserCode"].ToString(); _objItemSetup.ItemID = Convert.ToInt32(Session["itemID"].ToString());// _objItemSetup.ModelNo = txtItemNameUpdate.Text == string.Empty ? null : txtItemNameUpdate.Text; _objItemSetup.UnitID = Convert.ToInt32(ddlUnitUpdate.SelectedValue); _objItemSetup.ItemCode = txtItemCodeUpdate.Text == string.Empty ? null : txtItemCodeUpdate.Text; _objItemSetup.ItemTypeID = Convert.ToInt32(ddlItemTypeIDUpdate.SelectedValue); _objItemSetup.ItemPropertySetID = 1; _objItemSetup.ItemUsageID = Convert.ToInt32(ddlItemUsageIDUpdate.SelectedValue); _objItemSetup.BreakUpQuantity = txtBreakUpQuantityUpdate.Text == string.Empty ? 0 : Convert.ToInt32(txtBreakUpQuantityUpdate.Text); _objItemSetup.ReOrderLevel = txtReOrderLevelUpdate.Text == string.Empty ? null : txtReOrderLevelUpdate.Text; _objItemSetup.BreakUpUnitD = Convert.ToInt32(ddlBreakupUnitUpdate.SelectedValue) == -1 ? 0 : Convert.ToInt32(ddlBreakupUnitUpdate.SelectedValue); _objItemSetup.MinimumQuantity = txtMinimumQuantityUpdate.Text == string.Empty ? 0 : Convert.ToInt32(txtMinimumQuantityUpdate.Text); _objItemSetupController = new ItemSetupController(); _objItemSetupController.Update(_connectionString, _objItemSetup); ClearAfterUpdate(); TreeViewCategory.Nodes.Clear(); PopulateRootLevel(); } catch (Exception msgException) { throw msgException; } }
protected void saveButton_Click(object sender, EventArgs e) { if (itemNameTextBox.Text.ToString() != "") { ItemSetup itemSetup = new ItemSetup(); if (CatagoryDropDownList.Text != "0" && CompanyDropDownList.Text != "0") { itemSetup.CatagoryId = Convert.ToInt32(CatagoryDropDownList.SelectedValue); itemSetup.CompanyId = Convert.ToInt32(CompanyDropDownList.SelectedValue); itemSetup.ItemName = itemNameTextBox.Text; if (ReorderLevelTextBox.Text.ToString() == "") { itemSetup.ReorderLevel = 0; } else { itemSetup.ReorderLevel = Convert.ToInt32(ReorderLevelTextBox.Text); } outputLabel.Text = itemSetupManager.Save(itemSetup); itemNameTextBox.Text = ""; ReorderLevelTextBox.Text = "0"; } else { outputLabel.Text = "Please Select an Item"; outputLabel.ForeColor = Color.Orange; } } else { outputLabel.Text = "Please Enter a Item Name"; outputLabel.ForeColor = Color.Orange; } }
public bool Insert(ItemSetup st) { bool chk = rs.Insert(st); return(chk); }
protected void itemSaveButton_Click(object sender, EventArgs e) { ItemSetup itemSetup = new ItemSetup(); string checkCompany = companyDropDownList.SelectedItem.Text; string checkCategory = categoryDropDownList.SelectedItem.Text; if (itemNameTextBox.Text == "" && !(checkCompany.Equals("--Select--") || checkCategory.Equals("--Select--"))) { outputLabel.Text = "Please fill Up Item Name textBox!"; itemNameTextBox.Text = ""; } else if (reorderLevelTextBox.Text == "" && !(checkCompany.Equals("--Select--") || checkCategory.Equals("--Select--"))) { outputLabel.Text = "Please fill Up reorder level textBox!"; itemNameTextBox.Text = ""; reorderLevelTextBox.Text = "0"; } else if (!(checkCompany.Equals("--Select--") || checkCategory.Equals("--Select--"))) { string intCheck = itemNameTextBox.Text; string reorderCheck = reorderLevelTextBox.Text; int count = 0, z = 0; for (int i = 0; i < intCheck.Length; i++) { if (intCheck[i] >= '0' && intCheck[i] <= '9') { count++; } } for (int i = 0; i < reorderCheck.Length; i++) { if ((reorderCheck[i] >= 'a' && reorderCheck[i] <= 'z') || (reorderCheck[i] >= 'A' && reorderCheck[i] <= 'Z') || !(reorderCheck[i] >= '0' && reorderCheck[i] <= '9')) { z++; } } if (count > 0) { outputLabel.Text = "Please enter a string value in item name textbox"; } else if (z > 0) { outputLabel.Text = "Please enter an integer value in reorder level textbox"; } else { itemSetup.CategoryId = Convert.ToInt32(categoryDropDownList.SelectedValue); itemSetup.CompanyId = Convert.ToInt32(companyDropDownList.SelectedValue); itemSetup.ItemName = itemNameTextBox.Text; itemSetup.ReorderLevel = Convert.ToInt32(reorderLevelTextBox.Text); //int r = Convert.ToInt32(reorderLevelTextBox.Text); ////if (r < 5) ////{ //// outputLabelReorder.Text = "Reorder level is under 5 !"; ////} outputLabel.Text = itemSetupManager.SaveManager(itemSetup); } itemNameTextBox.Text = ""; reorderLevelTextBox.Text = ""; } else { outputLabel.Text = "Please select your desired things from dropdown list !"; itemNameTextBox.Text = ""; reorderLevelTextBox.Text = ""; } itemNameTextBox.Text = ""; reorderLevelTextBox.Text = "0"; }