private void btSave_Click(object sender, RoutedEventArgs e)
{
FundCollect fundCollect = new FundCollect();
fundCollect.Title = txtTitle.Text;
fundCollect.Fund = Convert.ToDouble(txtMoney.Text);
fundCollect.StartDate = dpStartDate.SelectedDate.Value;
fundCollect.OutDate = dpOutDate.SelectedDate.Value;
fundCollect.Status = cbStartus.Text;
fundCollect.Count = count;
fundCollect.TotalCount();
DataBase dataBase = new DataBase();
dataBase.Connection();
if (GlobalVariables.isEdit == true)
{
fundCollect.ID = GlobalVariables.TmpFundCollect.ID;
dataBase.EditFundCollect(fundCollect);
for (int i = 0; i < lvNotCollected.SelectedItems.Count; i++)
{
FundOwe fundOwe = (FundOwe)lvNotCollected.SelectedItems[i];
dataBase.DelOwe(fundOwe);
}
GlobalVariables.isEdit = false;
}
else
{
dataBase.AddFundCollect(fundCollect);
DataRow row = dataBase.FundCollectTable().Rows[dataBase.FundCollectTable().Rows.Count - 1];
for (int i = 0; i < lvNotCollected.SelectedItems.Count; i++)
{
lvNotCollected.Items.Remove(lvNotCollected.SelectedItems[i]);
}
for (int i = 0; i < lvNotCollected.Items.Count; i++)
{
FundOwe tmp = new FundOwe();
Student student = (Student)lvNotCollected.Items[i];
tmp.ID = student.ID;
tmp.FundID = Convert.ToInt32(row[0]);
dataBase.AddOwe(tmp);
}
}
this.Close();
}
private FundCollect TableToFundCollect(DataTable table, int location)
{
DataRow row = table.Rows[location];
FundCollect fundCollect = new FundCollect();
fundCollect.ID = Convert.ToInt32(row[0]);
fundCollect.Title = (string)row[1];
fundCollect.Count = Convert.ToInt32(row[2]);
fundCollect.StartDate = Convert.ToDateTime(row[3]);
fundCollect.OutDate = Convert.ToDateTime(row[4]);
fundCollect.Fund = Convert.ToDouble(row[5]);
if (Convert.ToInt32(row[6]) == 1)
{
fundCollect.Status = "Mở";
}
else
{
fundCollect.Status = "Đóng";
}
fundCollect.TotalCount();
return(fundCollect);
}
