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