/// <summary> /// this is a function to make a Group List from database /// </summary> /// <returns>list of DescriptionDetail</returns> public List <GroupDetail> makeGroupList() { groupList.Clear(); List <GroupDetail> tempGroupList = new List <GroupDetail>(); int retVal = 0; DataSet ds = Sqlite.ExecuteSQLStatement(Query.getGroupList(), ref retVal); for (int i = 0; i < retVal; i++) { GroupDetail gpTemp = new GroupDetail(); //Group ID if (int.TryParse(ds.Tables[0].Rows[i].ItemArray[4].ToString(), out int id)) { gpTemp.groupID = id; } //Group name gpTemp.groupName = ds.Tables[0].Rows[i].ItemArray[0].ToString(); //start date // gpTemp.groupStartDate.Equals(ds.Tables[0].Rows[i].ItemArray[2]); gpTemp.groupSStartDate = ds.Tables[0].Rows[i].ItemArray[1].ToString(); //start time gpTemp.groupStartTime = ds.Tables[0].Rows[i].ItemArray[2].ToString(); //description gpTemp.groupDesc = ds.Tables[0].Rows[i].ItemArray[3].ToString(); //add to list groupList.Add(gpTemp); } return(groupList); }
/// <summary> /// on click "save" button /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, RoutedEventArgs e) { GroupList = new GroupDetail(); GroupList.groupName = txtGroupName.Text; GroupList.groupStartDate = dteDate.SelectedDate.Value; if (GroupList.groupStartDate.Month < 10) { GroupList.groupSStartDate = GroupList.groupStartDate.Year.ToString() + "-0" + GroupList.groupStartDate.Month.ToString(); } else { GroupList.groupSStartDate = GroupList.groupStartDate.Year.ToString() + "-" + GroupList.groupStartDate.Month.ToString(); } if (GroupList.groupStartDate.Day < 10) { GroupList.groupSStartDate += "-0" + GroupList.groupStartDate.Day.ToString(); } else { GroupList.groupSStartDate += "-" + GroupList.groupStartDate.Day.ToString(); } GroupList.groupDesc = txtSubject.Text; GroupList.groupStartTime = scheduleHours + ":" + scheduleMins; Sqlite.ExecuteNonQuery(Query.insertGroup(GroupList)); Close(); }
public void addGroupList(GroupDetail gp) { groupList.Add(gp); }
public string UpdateGroup(GroupDetail group) { return("UPDATE ClassGroup SET Name = '" + group.groupName + "', StartDate ='" + group.groupSStartDate + "'," + "ScheduledTimeStart ='" + group.groupStartTime + "', Description = '" + group.groupDesc + "' WHERE (_id = " + group.groupID + ");"); }
public string insertGroup(GroupDetail group) { return("INSERT INTO ClassGroup (Name,StartDate,ScheduledTimeStart,Description)" + "VALUES ('" + group.groupName + "', '" + group.groupSStartDate + "','" + group.groupStartTime + "', '" + group.groupDesc + "');"); }