public List<date12> insert1()
{
List<date12> aa = new List<date12>();
string strConn = "Data Source=.;Initial Catalog=TMS;user ID=sa";
string strCmd = "SELECT [ClassIDNo],[ClassID],[StartDate],[EndDate],[Date],[TimesType],[ClassRoom],[ClassMentor],[UserID],[ClassName],[Length],[Tuition],[TuitionDiscount],[GroupDeptID],[Maintainer] 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())
{
date12 tea = new date12();
// tea.id = Convert.ToInt32(dr[0]);
// tea.title = dr[1].ToString();
tea.id_class = dr["ClassIDNo"].ToString();
tea.id_classNO = dr["ClassID"].ToString();
tea.classmentor = dr["ClassMentor"].ToString();
tea.employeeID = 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();
//[GroupDeptID],[Maintainer]
tea.classname = dr["ClassName"].ToString();
tea.lenght = dr["Length"].ToString();
tea.tuition = dr["Tuition"].ToString();
tea.tuition_discount = dr["TuitionDiscount"].ToString();
tea.groupdeptID = dr["GroupDeptID"].ToString();
tea.maintainer = dr["Maintainer"].ToString();
insertsp(dr["ClassID"].ToString(), dr["ClassRoom"].ToString(), dr["ClassIDNo"].ToString(), dr["ClassMentor"].ToString());
insert2(tea);
aa.Add(tea);
}
conn.Close();
}
}
return aa;
}
public void insert2(date12 a1)
{
string strConn = "Data Source=.;Initial Catalog=PKST;user ID=sa";
string strCmd = "INSERT INTO [PKST].[dbo].[classdetail]([id_class],[id_classNo],[id_classroom],[startdate],[enddate],[date],[tms_timesType],[classmentor],[employeeID],[classname],[lenght],[tuition],[tuition_discount],[groupdeptID],[maintainer]) VALUES (@id_class,@id_classNo,@id_classroom,@startdate,@enddate,@date,@tms_timesType,@classmentor,@employeeID,@classname,@lenght,@tuition,@tuition_discount,@groupdeptID,@maintainer)";
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("@id_classNo", a1.id_classNO);
cmd.Parameters.AddWithValue("@id_classroom", a1.id_classroom);
cmd.Parameters.AddWithValue("@startdate", a1.startdate);
cmd.Parameters.AddWithValue("@enddate", a1.enddate);
cmd.Parameters.AddWithValue("@date", a1.date);
cmd.Parameters.AddWithValue("@tms_timesType", a1.tms_timesType);
cmd.Parameters.AddWithValue("@classmentor", a1.classmentor);
cmd.Parameters.AddWithValue("@employeeID", a1.employeeID);
//[[classname],],[lenght],[tuition],[tuition_discount],[groupdeptID],[maintainer]
cmd.Parameters.AddWithValue("@classname", a1.classname);
cmd.Parameters.AddWithValue("@lenght", a1.lenght);
cmd.Parameters.AddWithValue("@tuition", a1.tuition);
cmd.Parameters.AddWithValue("@tuition_discount", a1.tuition_discount);
cmd.Parameters.AddWithValue("@groupdeptID", a1.groupdeptID);
cmd.Parameters.AddWithValue("@maintainer", a1.maintainer);
conn.Open();
try
{
cmd.ExecuteNonQuery();
}
catch { }
conn.Close();
}
}
}
