protected void btnsubmit_Click(object sender, EventArgs e)
{
string name = txtdoctor.Text;
doctor doc = doctor.show_namedoctor(name);
if (doc != null)
{
int doc_id = doc.Doctor_ID;
DateTime datework = ((DateTime)Calendarbirthday.SelectedDate);
String time_of_work = DropDownList1.SelectedValue;
string date_work = Convert.ToString(datework);
string date = Convert.ToString(datework.Day);
string month = DateTime.Now.ToString("MMMM");
string year = Convert.ToString(datework.Year);
time_work time = new time_work(date_work, time_of_work, date, month, year, doc_id);
time_work.Register_time(time);
Response.Redirect("../page/time_work_table.aspx");
}
}
public static string Register_time(time_work timework)
{
string query = String.Format("SELECT COUNT(*) FROM time_work WHERE Date_of_work = '{0}'", timework.Date_of_work);
try
{
conn.Open();
command.CommandText = query;
int amountOfPatient = (int)command.ExecuteScalar();
if (amountOfPatient < 1)
{
query = String.Format("INSERT INTO time_work (Date_of_work, Time_of_work ,Day," +
"month,Year,Employees_id)" +
" VALUES('{0}', '{1}','{2}', '{3}','{4}','{5}')",
timework.Date_of_work,
timework.Time_of_work,
timework.Day,
timework.month,
timework.Year,
timework.Employees_id
);
command.CommandText = query;
command.ExecuteNonQuery();
return("ทำรายการเสร็จสมบูรณ์");
}
else
{
return("ทำรายการไม่สำเร็จ");
}
}
finally
{
conn.Close();
}
}
public static ArrayList showtimechalender(int employees_ID)
{
ArrayList list = new ArrayList();
string query = string.Format("Select Day,Time_of_work from time_work where Employees_id = {0}", employees_ID);
try
{
conn.Open();
command.CommandText = query;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
string day = reader.GetString(0);
string time_of_work = reader.GetString(1);
time_work time = new time_work(time_of_work, day);
list.Add(time);
}
}
finally
{
conn.Close();
}
return(list);
}
