void Save() { EpisodeC eps = new EpisodeC(); if (/*batchNum.Text.Equals("") ||medAmount.Text =="" || comboType.Text.Equals("")||*/ comboYear.Text.Equals("") || comboMonth.Text.Equals("")) { } // else if(comboType.Text=="others" && textboxOther.Text=="") // { // textboxOther.Select(); // } else { // Thread prgThead = new Thread(StarProg); // prgThead.Start(); Database a = new Database(); int amount = f.AddInt(medAmount.Text); string typeSelect = null; string dateType = null; if (dayNumber.Text == "0" || dayNumber.Enabled == false) { dateType = comboYear.Text + "-" + comboMonth.Text + "-" + f.getLastDayOfMonth(comboMonth.Text); } else { string addZero = dayNumber.Text; if (dayNumber.Value < 10) { addZero = "0" + dayNumber.Text; } else { } dateType = comboYear.Text + "-" + comboMonth.Text + "-" + addZero; } // a.Ccon(); eps.Insert(new Episode() { Stoke_id = GetStoreId(cbstore.Text), Item_id = GetItemId(cbitem.Text), Amount = amount, AmountType = cbamountype.Text, Notes = note.Text, Expdate = f.CheckDateBeforeAdd(dateType), Batch = batchNum.Text }); forms.getAll(""); forms.DisableSelect(); this.Activate(); } }
void GetQuery(int id) { EpisodeC episodes = new EpisodeC(); ItemC item = new ItemC(); StoreC store = new StoreC(); Episode eps = episodes.GetOneEpisode(new Episode() { Id = id }); Item it = item.GetOneItem(eps.Item_id.ToString()); Store st = store.GetOneStore(new Store() { Id = eps.Stoke_id }); cbitem.Text = it.Name + "," + it.Size + "," + it.Type; cbstore.Text = st.Name; batchNum.Text = eps.Batch; medAmount.Text = eps.Amount.ToString(); _notes.Text = eps.Notes; cbamountype.Text = eps.AmountType; string[] x = eps.Expdate.Split('-'); intYear = Convert.ToInt32(x[0]); comboYear.Items.AddRange(new object[] { intYear - 3, intYear - 2, intYear - 1, intYear, intYear + 1, intYear + 2, intYear + 3, intYear + 4, intYear + 5, }); comboYear.Text = x[0]; comboMonth.Text = x[1]; dayNumber.Text = x[2]; }
void UpdateSaveClick(object sender, EventArgs e) { // if( /*batchNum.Text.Equals("") || comboType.Text.Equals("")||comboYear.Text.Equals("")||comboMonth.Text.Equals("")/*|| medName.Text.Equals("") || medAmount.Text.Equals("") */) // {} // else if(comboType.Text=="others" && textboxOther.Text=="") // { // textboxOther.Select(); // } // else{ // // int amo = f.AddInt(medAmount.Text); // // string typeSelect=null; // if(comboType.Text=="others"){ // typeSelect= textboxOther.Text; // }else{ // // typeSelect=comboType.Text; // } // string dateType=null; // if (dayNumber.Text == "0") { dayNumber.Text = f.getLastDayOfMonth(comboMonth.Text); } else { // string addZero=dayNumber.Text; if (dayNumber.Value < 10) { dayNumber.Text = "0" + dayNumber.Text; } else { int last = int.Parse(f.getLastDayOfMonth(comboMonth.Text)); int day = int.Parse(dayNumber.Value.ToString()); if (day > last) { dayNumber.Text = f.getLastDayOfMonth(comboMonth.Text); } Debug.WriteLine(dayNumber.Value); } } EpisodeC eps = new EpisodeC(); eps.Update(new Episode() { Id = id, Stoke_id = new StoreC().GetStoreId(cbstore.Text), Item_id = new ItemC().GetItemId(cbitem.Text), Amount = int.Parse(medAmount.Text), Expdate = comboYear.Text + "-" + comboMonth.Text + "-" + dayNumber.Text, AmountType = cbamountype.Text, Batch = batchNum.Text, Notes = _notes.Text }); forms.checkGet(); this.Close(); }
public void getAll(string sort) { lsv.Items.Clear(); EpisodeC episodes = new EpisodeC(); int c = 1; int lx = 0; foreach (Episode eps in episodes.GetEpisodeWithLimitStore(_query, sort)) { StoreC stores = new StoreC(); ListViewItem t = new ListViewItem(eps.Id.ToString()); t.SubItems.Add(c.ToString()); t.SubItems.Add(eps.Batch); try { ItemC items = new ItemC(); Item item = items.GetOneItem(eps.Item_id.ToString()); t.SubItems.Add(item.Name + "," + item.Size); t.SubItems.Add(item.Type.ToUpper()); } catch (Exception) { t.SubItems.Add("NULL"); Debug.WriteLine("Item table is null getall method in mainform.class"); } LimitC setdate = new LimitC(); t.SubItems.Add(setdate.SetDateWithoutDay(eps.Expdate)); t.SubItems.Add(stores.GetOneStore(new Store() { Id = eps.Stoke_id }).Name); t.SubItems.Add(eps.Amount.ToString() + eps.AmountType); // // notes for medicine string itemNote = ""; if (eps.Notes.Equals("")) { itemNote = getTimeline(eps.Expdate); } else { itemNote = getTimeline(eps.Expdate) + " *"; } t.SubItems.Add(itemNote); lsv.Items.Add(t); lsv.Items[lx].UseItemStyleForSubItems = false; if (setColor == Dates.EXP) { lsv.Items[lx].SubItems[8].BackColor = Color.Red; } if (setColor == Dates.NEAR) { lsv.Items[lx].SubItems[8].BackColor = Color.Orange; } if (setColor == Dates.ATTENTION) { lsv.Items[lx].SubItems[8].BackColor = Color.LightGreen; } if (setColor == Dates.SAFF) { lsv.Items[lx].SubItems[8].BackColor = Color.LightSalmon; } if (setColor == Dates.LONG) { lsv.Items[lx].SubItems[8].BackColor = Color.White; } c++; lx++; } c = 1; }