public List <ManageItems> GetAllItems() { List <ManageItems> listOfItems = new List <ManageItems>(); string query = "SELECT * from ManageItems"; dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); while (sdr.Read()) { ManageItems mi = new ManageItems(); mi.ItemId = sdr["ItemId"].ToString(); mi.ItemName = sdr["ItemName"].ToString(); // emp.PhnNumber = sdr["PhnNumber"].ToString(); mi.ItemPrice = Convert.ToDouble(sdr["ItemPrice"].ToString()); //emp.Designation = sdr["Designation"].ToString(); listOfItems.Add(mi); } dcc.CloseConnection(); return(listOfItems); }
public void Delete(int id) { ManageItems mngItem = new ManageItems(); // DELETE: a mngItem.deleteItem(id); }
private void AddProductBtn_Click(object sender, EventArgs e) { ManageItems mi = new ManageItems(); mi.ItemId = this.ProductIdTB.Text; mi.ItemName = this.ProductNameTB.Text; //mi.ItemPrice = Convert.ToString(ProductPriceTB.Text); try { double price = Convert.ToDouble(this.ProductPriceTB.Text); mi.ItemPrice = price; if (mir.InsertProduct(mi)) { MessageBox.Show("Item Added with Id: " + mi.ItemId + " & Price: " + mi.ItemPrice); // this.RefreshBtn_Click(sender, e); //this.ViewAllBtn_Click(sender, e); } else { MessageBox.Show("Can Not Add : " + mi.ItemId); } } catch (Exception exp) { MessageBox.Show("Invalid Data" + exp.StackTrace); } finally { dcc.CloseConnection(); } }
private void LoadBtn_Click(object sender, EventArgs e) { string id = this.ProductIdTB.Text; ManageItems mi = mir.GetItem(id); if (mi == null) { MessageBox.Show("Invalid ID"); } else { this.ProductIdTB.Text = mi.ItemId; this.ProductNameTB.Text = mi.ItemName; double pri = Convert.ToDouble(ProductPriceTB.Text); mi.ItemPrice = pri; // this.ProductPriceTB.Text = mi.ItemPrice ; // this.EmpDesignationTB.Text = emp.Designation; // this.RefreshBtn.Enabled = true; this.LoadBtn.Enabled = false; // this.InsertBtn.Enabled = false; //his.UpdateBtn.Enabled = true; //this.DeleteBtn.Enabled = true; //his.EmpIdTB.Enabled = false; } }
private void DeleteBtn_Click(object sender, EventArgs e) { //Login user = new Login(); // user.Id = this.EmpIdTB.Text; ManageItems mi = new ManageItems(); mi.ItemId = this.ProductIdTB.Text; //if (lr.DeleteUser(user)) //{ try { if (mir.DeleteProduct(mi)) { MessageBox.Show("Item Removed"); // this.RefreshBtn_Click(sender, e); // this.ViewAllBtn_Click(sender, e); } // } else { MessageBox.Show("Can Not Remove"); } } catch (Exception exp) { MessageBox.Show("Invalid Data" + exp.StackTrace); } }
public void DeleteTile(int x, int y) { var id = tilesWorldMap[x, y]; Chunk currentChunk = ManageChunkTile(x, y, 0); currentChunk.SetTile(new Vector3Int(x % chunkSize, y % chunkSize, 0), null); lightService.RecursivDeleteShadow(x, y, tilemapShadow, tilesLightMap, tilemapLight); ManageItems.CreateItemOnMap(x, y, id); RefreshChunkNeightboorTiles(x, y, currentChunk.tilemap); }
public void DeleteItem(int posX, int posY) { if (tilesObjetMap[posX, posY].name == "item_11(Clone)") // toDo changer cette merde { lightService.RecursivDeleteLight(posX, posY, tilemapLight, tilesLightMap); } Destroy(tilesObjetMap[posX, posY]); tilesObjetMap[posX, posY] = null; ManageItems.CreateItemOnMap(posX, posY, 11); }
public void DeleteItem(int posX, int posY) { if (tilesObjetMap[posX, posY].name == "item_11(Clone)") // toDo changer cette merde { lightService.RecursivDeleteLight(posX, posY, true); RefreshLight(CycleDay.GetIntensity()); } tilesObjetMap[posX, posY] = null; Destroy(tilesObjetMap[posX, posY]); ManageItems.CreateItemOnMap(posX, posY, 11); }
private void Start() { inventory = GameObject.FindGameObjectWithTag("Inventory").GetComponent <Inventory>(); inventoryToolbar = GameObject.FindGameObjectWithTag("InventoryToolbar").GetComponent <InventoryToolbar>(); var itemGo = ManageItems.CreateItem(4); inventoryToolbar.AddItem(itemGo); var itemGo2 = ManageItems.CreateItem(11); // TODO a enlever juste pour tester (torche) inventoryToolbar.AddItem(itemGo2); }
public void SaveItemClicked(object sender, EventArgs e) { var itemStatus = ItemStatus.Wow; switch (StatusPicker.SelectedIndex) { case 0: itemStatus = ItemStatus.Wow; break; case 1: itemStatus = ItemStatus.Interesting; break; case 2: itemStatus = ItemStatus.Cool; break; case 3: itemStatus = ItemStatus.ToRemember; break; case 4: itemStatus = ItemStatus.Touching; break; } var purposeItem = new PurposeItem() { Content = ContentText.Text, Notes = NotesText.Text, Status = itemStatus, Type = itemType }; var manageItems = new ManageItems(); if (item == null) { // new item manageItems.AddItem(purposeItem); } else { //edit item purposeItem.Id = item.Id; manageItems.UpdateItem(purposeItem); } RefreshItemsAction?.Invoke(); Navigation.PopAsync(); }
void Awake() { if (Instance == null) { DontDestroyOnLoad(gameObject); Instance = this; itmCfgDict = new Dictionary <int, Item_cfg>(); item = (GameObject)Resources.Load("Prefabs/Item"); } else if (Instance != this) { Destroy(gameObject); } }
public async void OnDeleteItem(object sender, EventArgs e) { var mi = ((MenuItem)sender); var response = await DisplayAlert($"Delete {itemType}", $"Are you sure you want to delete this {itemType}", "Yes", "No"); if (!response) { return; } var mit = new ManageItems(); mit.DeleteItem((int)mi.CommandParameter); RefreshItemsListAction(); }
public bool InsertProduct(ManageItems mi) { string query = "INSERT INTO ManageItems VALUES ('" + mi.ItemId + "','" + mi.ItemName + "','" + mi.ItemPrice + "')"; try { dcc.ConnectWithDB(); int n = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception exp) { return(false); } }
public bool DeleteProduct(ManageItems mi) { string query = "DELETE from ManageItems WHERE ItemId ='" + mi.ItemId + "'"; try { dcc.ConnectWithDB(); int n = dcc.ExecuteSQL(query); dcc.CloseConnection(); return(true); } catch (Exception exp) { return(false); } }
public static ObservableCollection <ItemforInterface> ReturnItemsForInterface(ItemType type) { var itemCollection = new ObservableCollection <ItemforInterface>(); var manageItems = new ManageItems(); var itemsFromDb = manageItems.ReturnTypeItems(type); foreach (var dbItem in itemsFromDb) { var interfaceItem = new ItemforInterface() { Id = dbItem.Id, Content = dbItem.Content, Notes = dbItem.Notes, Status = dbItem.Status.ToString() }; itemCollection.Add(interfaceItem); } return(itemCollection); }
//public bool Load public ManageItems GetItem(string itemId) { ManageItems mi = null; string query = "SELECT * from ManageItems WHERE ItemId = '" + itemId + "'"; dcc.ConnectWithDB(); SqlDataReader sd = dcc.GetData(query); while (sd.Read()) { mi = new ManageItems(); mi.ItemId = sd["ItemId"].ToString(); mi.ItemName = sd["ItemName"].ToString(); //.PhnNumber = sdr["PhnNumber"].ToString(); mi.ItemPrice = Convert.ToDouble(sd["ItemPrice"].ToString()); //emp.Salary = Convert.ToDouble(sdr["Salary"].ToString()); // emp.Designation = sdr["Designation"].ToString(); } dcc.CloseConnection(); return(mi); }
public void Put(int id, [FromBody] Item value) { ManageItems mngItem = new ManageItems(); mngItem.UpdateItem(value, id); }
/// <summary> /// Loads a form to the panel /// </summary> /// <param name="tag">The tag of the button - Here is stored what type of form is supposed to be opened</param> private void LoadForm(string tag) { var yEnd = new YearEnd(); if (yEnd.InventoryRequired(false)) { switch (VisibilitySetting.HandleUnits) { case 1: yEnd.GenerateAutomaticInventory(); break; case 2: yEnd.GenerateAutomaticInventoryByUnit(); break; case 3: yEnd.GenerateAutomaticInventoryByUnit(); break; } } Form frm; switch (tag) { case "Receives": frm = new ReceivingForm(); AddTab("Receiving Form", frm); break; case "Issues": frm = new IssueForm(); AddTab("Issue Form", frm); break; case "AMCs": frm = new AMCView(); AddTab("AMC Report", frm); break; case "menuItemPriceOnlyReport": frm = new ItemPriceOnlyReport(); AddTab("Item Price Only", frm); break; case "Facility Settings": frm = new Hospital(); AddTab("Facility Settings", frm); break; case "Drug List": frm = new ManageItems(); AddTab("Manage Drug List", frm); break; case "Supplies List": //frm = new ManageItems(); frm = new ManageSupplies(); AddTab("Manage Supplies List", frm); break; case "Item Consolidator": //frm = new ManageItems(); frm = new ItemConsolidator(); AddTab("Update Items List From The Directory Service", frm); break; case "Customize Druglist": frm = new CustomDrugList(); AddTab("Customize Drug List", frm); break; case "System Settings": frm = new SystemSetting(); AddTab("System Settings", frm); break; case "Facility Details": frm = new HospitalSettings(); AddTab("Facility Details", frm); break; case "User Accounts": frm = new UserAccounts(); AddTab("Manage Users", frm); break; case "Pipeline": frm = new Pipeline(); AddTab("Pipeline", frm); break; case "Change Password": frm = new ChangePassword(UserId); AddTab("Change Password", frm); break; case "Transfer Log": frm = new LogTransfer(); AddTab("Transfer Log", frm); break; case "VRF Form": frm = new vrfmainForm(); AddTab("Vaccine Requistion and Report Form", frm); break; case "Losses/Adjustment": frm = new LossesAdjustment(); AddTab("Losses and Adjustment", frm); break; case "Receive Log": frm = new LogReceive(); AddTab("Receive Transaction Log", frm); break; case "Issue Log": frm = new LogIssues(); AddTab("Issue Transaction Log", frm); break; case "Adjustment Log": frm = new LogAdjustment(); AddTab("Loss / Adjustment Transaction Log", frm); break; case "Inventory Log": frm = new LogInventory(); AddTab("Inventory Log", frm); break; case "Stock Status": frm = new ItemReport(); AddTab("Stock Status", frm); break; case "Over Stocked": frm = new OtherItemReport("Over Stocked"); AddTab("Over Stock Items", frm); break; case "Transfers": frm = new TransferForm(); AddTab("Transfer Form", frm); break; case "Stock Out": frm = new OtherItemReport("Stock Out"); AddTab("Stocked Out Items", frm); break; case "ConsumptionTrend": frm = new ConsumptionTrendReport(); AddTab("Consumption Trend", frm); break; case "Issues By Receiving Unit": frm = new IssuesByDep(); AddTab("Issues By Receiving Unit", frm); break; case "Expired Products": frm = new ExpiredProducts(); AddTab("Expired Products", frm); break; case "Near Expiry": frm = new NearlyExpired(); AddTab("Near Expiry Products", frm); break; case "SOH Trend": frm = new SOHTrend(); AddTab("SOH Trend", frm); break; case "Receive Trend": frm = new ReceiveTrend(); AddTab("Receive Trend", frm); break; case "Balance": frm = new BalanceReport(); AddTab("Balance", frm); break; case "Summary Report": frm = new GeneralReport(); AddTab("Summary Report", frm); break; case "Cost Summary": frm = new GeneralCostChart(); AddTab("Cost Summary", frm); break; case "Wastage Rate": frm = new WastageRate(); AddTab("Wastage Rate", frm); break; case "Summary Chart": frm = new GeneralChart(); AddTab("General Chart", frm); break; case "Activity Log Reports": frm = new ActivityLogReports(); AddTab("Activity Log", frm); break; case "ECLS": frm = new ECLS(); AddTab("CS Stock Status", frm); break; case "Year End Process": frm = new YearEndProcess(); AddTab("Inventory", frm); break; case "Default Year End Process": frm = new YearEndProcess(true); AddTab("Inventory", frm); break; case "Stock Expiry Status": frm = new GeneralExpiryChart(); AddTab("Stock Status", frm); break; case "DataBase": frm = new DatabaseActions(); AddTab("Database Actions", frm); break; case "PDA": frm = new ItemReport(); AddTab("Stock Status", frm); break; case "Consumables List": frm = new ManageSupplies(); AddTab("Supplies List", frm); break; case "RRF Form": frm = new RRFForm(); AddTab("Report and Requisition Form", frm); break; case "LossReport": frm = new ExpiredProductsReport(); AddTab("Loss / Adjustment Reporting View", frm); break; case "CostReport": frm = new CostReport(); AddTab("Cost Report", frm); break; case "ConsumptionByUnit": frm = new ConsumptionByUnits(); AddTab("Consumption By Dispensary Unit", frm); break; case "About": Program.ShowHCMISVersionInfoMessageBox(); break; } }
public IEnumerable <Item> Get() { ManageItems mngItem = new ManageItems(); return(mngItem.getAllItems()); }
public Item Get(int id) { ManageItems mngItem = new ManageItems(); return(mngItem.GetItemFromId(id)); }
void Awake() { Instance = this; }
public void Post([FromBody] Item value) { ManageItems mngItem = new ManageItems(); mngItem.CreateItem(value); }