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