private bool ReadDataNomenclatures() { using (ExcelPackage xlPackage = new ExcelPackage(new FileInfo(PathData.Nomenclatures))) { ExcelWorksheet myWorksheet = xlPackage.Workbook.Worksheets.First(); int totalRows = myWorksheet.Dimension.End.Row; int totalColumns = myWorksheet.Dimension.End.Column; for (int row = Nomenclature.StartDataRow; row <= totalRows; row++) { string strId = myWorksheet.GetValue(row, 1).ToString(); string strNomenclature = myWorksheet.GetValue(row, 2).ToString(); if (!CheckId(strId)) { return(false); } int id = int.Parse(strId); string nomenclature = strNomenclature; if (Nomenclatures.Exists((n => n.Id == id))) { return(false); } Nomenclatures.Add(new Nomenclature(id, nomenclature)); } } return(true); }
public void GetNomenctlatures() { ApiHelper.APIRequest(ValuesHelper.API_URL, ValuesHelper.API_NOMENCLATURE, null, t => { var d = JsonConvert.DeserializeObject <Message <Nomenclature> >(t); if (d.status.Contains("success")) { if (d.data != null) { foreach (var nomenclature in d.data) { Nomenclatures.Add((Nomenclature)nomenclature.Clone()); } } } else { MessageBox.Show(d.reason.ToString(), "Ошибка"); } }); }
public void AddOrUpdateNomenclature(Nomenclature nomenclature, Mode mode) { Dictionary <string, string> param = new Dictionary <string, string>(); int pos = 0; if (mode == Mode.Update) { pos = Nomenclatures.IndexOf(SelectedNomenclature); param.Add("id", nomenclature.id_nomenclature.ToString()); } param.Add("name", nomenclature.name); param.Add("price", nomenclature.price.ToString("0.##")); param.Add("from_date", nomenclature.fromDate.ToString("yyyy-MM-dd HH:mm", System.Globalization.CultureInfo.InvariantCulture)); param.Add("to_date", nomenclature.toDate.ToString("yyyy-MM-dd HH:mm", System.Globalization.CultureInfo.InvariantCulture)); ApiHelper.APIRequest(ValuesHelper.API_URL, ValuesHelper.API_NOMENCLATURE, mode == Mode.Add ? ValuesHelper.API_ADD : ValuesHelper.API_UPDATE, t => { var d = JsonConvert.DeserializeObject <Message <Nomenclature> >(t); if (d.status.Contains("success")) { if (mode == Mode.Add) { Nomenclatures.Add((Nomenclature)d.data.FirstOrDefault()?.Clone()); } else { Nomenclatures.RemoveAt(pos); Nomenclatures.Insert(pos, (Nomenclature)d.data.FirstOrDefault()?.Clone()); } } else { MessageBox.Show(d.reason.ToString(), "Ошибка"); } }, param, "post"); }
/// <summary> /// Добавление номенклатуры /// </summary> private void AddNomenclature() { var nomenclature = selectedFolder.AddNomenclature("Новая номенклатура"); Nomenclatures.Add(nomenclature); }