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