public void insert2(date1 a1)
{
string strConn = "Data Source=.;Initial Catalog=TMS;user ID=sa";
string strCmd = "INSERT INTO [PKST].[dbo].[Six months of classes]([id_class],[classmentor],[id_user] ,[startdate] ,[enddate] ,[id_classroom] ,[tms_timesType],[date]) VALUES (@id_class,@classmentor,@id_user,@startdate,@enddate,@id_classroom,@tms_timesType,@date);";
using (SqlConnection conn = new SqlConnection(strConn))
{
using (SqlCommand cmd = new SqlCommand(strCmd, conn))
{
//cmd.Parameters.AddWithValue("@id_class", name1);
cmd.Parameters.AddWithValue("@id_class", a1.id_class);
cmd.Parameters.AddWithValue("@classmentor", a1.classmentor);
cmd.Parameters.AddWithValue("@id_user", a1.id_user);
cmd.Parameters.AddWithValue("@startdate", a1.startdate);
cmd.Parameters.AddWithValue("@enddate", a1.enddate);
cmd.Parameters.AddWithValue("@id_classroom", a1.id_classroom);
cmd.Parameters.AddWithValue("@tms_timesType", a1.tms_timesType);
cmd.Parameters.AddWithValue("@date", a1.date);
conn.Open();
try
{
cmd.ExecuteNonQuery();
}
catch
{
}
conn.Close();
}
}
}
public List<date1> insert1()
{
List<date1> aa = new List<date1>();
string strConn = "Data Source=.;Initial Catalog=TMS;user ID=sa";
string strCmd = "SELECT [ClassIDNo],[StartDate],[EndDate],[Date],[TimesType],[ClassRoom],[ClassMentor],[UserID] FROM [TMS].[dbo].[Class] where StartDate between getdate() and dateadd(month,8,getdate());";
using (SqlConnection conn = new SqlConnection(strConn))
{
using (SqlCommand cmd = new SqlCommand(strCmd, conn))
{
conn.Open();
//cmd.Parameters.AddWithValue("@id_class", name1);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
date1 tea = new date1();
// tea.id = Convert.ToInt32(dr[0]);
// tea.title = dr[1].ToString();
tea.id_class = dr["ClassIDNo"].ToString();
tea.classmentor = dr["ClassMentor"].ToString();
tea.id_user = dr["UserID"].ToString();
tea.startdate = (Convert.ToDateTime(dr["StartDate"].ToString())).ToString("yyyy/MM/dd");
tea.enddate = (Convert.ToDateTime(dr["EndDate"].ToString())).ToString("yyyy/MM/dd");
tea.id_classroom = dr["ClassRoom"].ToString();
tea.tms_timesType = dr["TimesType"].ToString();
tea.date = dr["Date"].ToString();
insert2(tea);
aa.Add(tea);
}
conn.Close();
}
}
return aa;
}
protected List<date1> caclass(string idclass)
{
List<date1> classmanage1 = new List<date1>();
string name1 = idclass;
string strConn = "Data Source=.;Initial Catalog=PKST;user ID=sa";
string strCmd = "select StartDate,EndDate,lab1,lab2,lab3,lab4,lab5,id_classroom from classdetail where id_class=@id_class;";
using (SqlConnection conn = new SqlConnection(strConn))
{
using (SqlCommand cmd = new SqlCommand(strCmd, conn))
{
conn.Open();
cmd.Parameters.AddWithValue("@id_class", name1);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
date1 tea = new date1();
// tea.id = Convert.ToInt32(dr[0]);
// tea.title = dr[1].ToString();
tea.star = (Convert.ToDateTime(dr[0])).ToString("yyyy/MM/dd");
tea.end = (Convert.ToDateTime(dr[1])).ToString("yyyy/MM/dd");
tea.Lab1 = dr[2].ToString();
tea.Lab2 = dr[3].ToString();
tea.Lab3 = dr[4].ToString();
tea.Lab4 = dr[5].ToString();
tea.Lab5 = dr[6].ToString();
tea.idclassroom = dr[7].ToString();
classmanage1.Add(tea);
}
conn.Close();
}
}
return classmanage1;
}
public List<date1> select1(string idclassno)
{
List<date1> aa = new List<date1>();
string strConn = "Data Source=.;Initial Catalog=PKST;user ID=sa";
string strCmd = "SELECT [id_class],[classmentor],[id_user],[startdate] ,[enddate],[id_classroom],[tms_timesType],[date] FROM [PKST].[dbo].[Six months of classes] where id_class=@id_class ;";
using (SqlConnection conn = new SqlConnection(strConn))
{
using (SqlCommand cmd = new SqlCommand(strCmd, conn))
{
conn.Open();
cmd.Parameters.AddWithValue("@id_class", idclassno);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
date1 tea = new date1();
// tea.id = Convert.ToInt32(dr[0]);
// tea.title = dr[1].ToString();
tea.id_class = dr[0].ToString();
tea.classmentor = dr[1].ToString();
tea.id_user = dr[2].ToString();
tea.startdate = dr[3].ToString();
tea.enddate = dr[4].ToString();
tea.id_classroom = dr[5].ToString();
tea.tms_timesType = dr[6].ToString();
tea.date = dr[7].ToString();
aa.Add(tea);
}
conn.Close();
}
}
return aa;
}
