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);
}
