public int createTeacherSchudule(TeacherSchudule StructData)
{
int returnValue = 0;
DataBase Base = new DataBase();
using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
{
try
{
StaffDataBase sDB = new StaffDataBase();
List<string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name);
Sqlconn.Open();
string sql = " DECLARE @TeacherScheduleID int; ";
sql += " insert into TeacherSchudule ( ";
sql += " TeacherID,Date,StartTime,EndTime,CreateDateTime,isDeleted,Unit,ClassID ";
sql += " )values( ";
sql += " @TeacherID,@Date,@StartTime,@EndTime,getdate(),0,@Unit,@ClassID ) ";
sql += " select @TeacherScheduleID = (SELECT @@IDENTITY) ";
int i = 1;
foreach (TeacherSchuduleStudent atom in StructData.TeacherSchuduleStudent)
{
sql += " insert into TeacherSchuduleStudent ( TeacherScheduleID ,StudentID) values ( @TeacherScheduleID , @StudentID" + i.ToString() + " ) ";
i++;
}
sql += " select @TeacherScheduleID as TeacherScheduleID ";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@TeacherID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.TeacherID);
cmd.Parameters.Add("@Date", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.Date);
cmd.Parameters.Add("@StartTime", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.StartTime);
cmd.Parameters.Add("@EndTime", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.EndTime);
cmd.Parameters.Add("@Unit", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.Unit);
cmd.Parameters.Add("@ClassID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.ClassID);
//cmd.Parameters.Add("@TeacherID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.studentID);
i = 1;
foreach (TeacherSchuduleStudent atom in StructData.TeacherSchuduleStudent)
{
cmd.Parameters.Add("@StudentID" + i.ToString() , SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(atom.StudentID);
i++;
}
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
returnValue = Convert.ToInt16(dr["TeacherScheduleID"].ToString());
//returnValue.Add(addValue);
}
Sqlconn.Close();
}
catch (Exception e)
{
string item = e.Message.ToString();
returnValue = -1;
}
}
return returnValue;
}
public int UpdateTeacherSchudule(TeacherSchudule StructData)
{
TeachDataBase tDB = new TeachDataBase();
return tDB.UpdateTeacherSchudule(StructData);
//return 1;
}
