public bool Add(TeacherTrainingScheduleRecord teacherTrainingScheduleRecord)
{
if (TeacherTrainingScheduleIsNotValid(teacherTrainingScheduleRecord))
return false;
string addTeacherTrainingScheduleString = PrepareAddString(teacherTrainingScheduleRecord);
return databaseManager.ExecuteInsert(addTeacherTrainingScheduleString);
}
private void TeacherTrainingScheduleView_AddTeacherTrainingSchedule(object sender, EventArgs e)
{
TeacherTrainingScheduleRecord teacherTrainingScheduleRecord = new TeacherTrainingScheduleRecord();
List<string> locationList = TeacherTrainingScheduleView.Location;
List<string> teacherList = TeacherTrainingScheduleView.Teacher;
if (teacherList != null && teacherList.Count > 0)
{
string[] teacherInfo = teacherList[0].Split('|');
if (teacherInfo != null && teacherInfo.Length > 1)
{
teacherTrainingScheduleRecord.TeacherID = teacherInfo[0];
teacherTrainingScheduleRecord.TeacherName = teacherInfo[1];
}
}
if (locationList != null && locationList.Count > 0)
teacherTrainingScheduleRecord.Location = locationList[0];
teacherTrainingScheduleRecord.StartTime = TeacherTrainingScheduleView.StartTime;
teacherTrainingScheduleRecord.EndTime = TeacherTrainingScheduleView.EndTime;
teacherTrainingScheduleRecord.DetailAddress = TeacherTrainingScheduleView.DetailAddress;
teacherTrainingScheduleRecord.Expense = TeacherTrainingScheduleView.Expense;
if (TeacherTrainingScheduleModel.Add(teacherTrainingScheduleRecord))
classScheduleHelper.PopMessage("Add teacher training schedule success");
else
classScheduleHelper.PopMessage("Add teacher training schedule failed");
}
private bool TeacherTrainingScheduleIsNotValid(TeacherTrainingScheduleRecord teacherTrainingScheduleRecord)
{
if (string.IsNullOrEmpty(teacherTrainingScheduleRecord.TeacherID) ||
string.IsNullOrEmpty(teacherTrainingScheduleRecord.TeacherName) ||
string.IsNullOrEmpty(teacherTrainingScheduleRecord.Location) ||
string.IsNullOrEmpty(teacherTrainingScheduleRecord.StartTime) ||
string.IsNullOrEmpty(teacherTrainingScheduleRecord.EndTime))
return true;
return false;
}
private string PrepareUpdateString(TeacherTrainingScheduleRecord teacherTrainingScheduleRecord)
{
return string.Format("UPDATE TeacherTrainingScheduleTable " +
"SET TeacherID = \'{0}\' , " +
"TeacherName = \'{1}\' , " +
"Location = \'{2}\' , " +
"DetailAddress = \'{3}\' , " +
"StartTime = \'{4}\' , " +
"EndTime = \'{5}\' , " +
"Expense = \'{6}\'" +
"WHERE ID = {7}",
teacherTrainingScheduleRecord.TeacherID, teacherTrainingScheduleRecord.TeacherName,
teacherTrainingScheduleRecord.Location, teacherTrainingScheduleRecord.DetailAddress,
teacherTrainingScheduleRecord.StartTime, teacherTrainingScheduleRecord.EndTime,
teacherTrainingScheduleRecord.Expense, teacherTrainingScheduleRecord.ID);
}
private string PrepareAddString(TeacherTrainingScheduleRecord teacherTrainingScheduleRecord)
{
return string.Format("INSERT INTO TeacherTrainingScheduleTable " +
"(TeacherID, TeacherName, Location, DetailAddress, StartTime, EndTime, Expense) "+
"VALUES ( \'{0}\',\'{1}\',\'{2}\',\'{3}\',\'{4}\',\'{5}\',\'{6}\' )",
teacherTrainingScheduleRecord.TeacherID, teacherTrainingScheduleRecord.TeacherName,
teacherTrainingScheduleRecord.Location, teacherTrainingScheduleRecord.DetailAddress,
teacherTrainingScheduleRecord.StartTime, teacherTrainingScheduleRecord.EndTime,
teacherTrainingScheduleRecord.Expense);
}
private List<TeacherTrainingScheduleRecord> GetTeacherTrainingScheduleListFromDataTable(DataTable teacherTrainingScheduleTable)
{
var teacherTrainingScheduleList = new List<TeacherTrainingScheduleRecord>();
if (teacherTrainingScheduleTable == null)
return teacherTrainingScheduleList;
foreach (DataRow dataRow in teacherTrainingScheduleTable.Rows)
{
var teacherTrainingScheduleRecord = new TeacherTrainingScheduleRecord();
teacherTrainingScheduleRecord.ID = dataRow[0].ToString();
teacherTrainingScheduleRecord.TeacherID = dataRow[1].ToString();
teacherTrainingScheduleRecord.TeacherName = dataRow[2].ToString();
teacherTrainingScheduleRecord.Location = dataRow[3].ToString();
teacherTrainingScheduleRecord.DetailAddress = dataRow[4].ToString();
teacherTrainingScheduleRecord.StartTime = dataRow[5].ToString();
teacherTrainingScheduleRecord.EndTime = dataRow[6].ToString();
teacherTrainingScheduleRecord.Expense = dataRow[7].ToString();
teacherTrainingScheduleList.Add(teacherTrainingScheduleRecord);
}
return teacherTrainingScheduleList;
}
public bool Update(TeacherTrainingScheduleRecord teacherTrainingScheduleRecord)
{
if (TeacherTrainingScheduleIsNotValid(teacherTrainingScheduleRecord))
return false;
string updateTeacherTrainingScheduleString = PrepareUpdateString(teacherTrainingScheduleRecord);
return databaseManager.ExecuteUpdate(updateTeacherTrainingScheduleString);
}