public IEnumerable <Timings> doctorTimings([FromForm] int ID)
{
List <Timings> timing = new List <Timings>();
try {
string sql = "SELECT * FROM DOCTORS_TIME_SCHEDULE " +
"WHERE DOCTORS_ID='" + ID + "'";
connection.Open();
MySqlCommand cmd = new MySqlCommand(sql, connection);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Timings model = new Timings();
model.ID = reader.GetInt32("ID");
model.START_TIME = reader.GetString("START_TIME");
model.END_TIME = reader.GetString("END_TIME");
model.ADDRESS = reader.GetString("ADDRESS");
model.AMOUNT = reader.GetInt32("AMOUNT");
model.DAYS = reader.GetString("DAYS");
model.DISTRICT_ID = reader.GetInt32("DISTRICT_ID");
model.DOCTOR_ID = reader.GetInt32("DOCTORS_ID");
timing.Add(model);
}
connection.Close();
return(timing);
}
catch (Exception ex) {
return(timing);
}
}
public string NewTiming([FromForm] Timings model)
{
int res = 0;
try
{
string sql = "INSERT INTO `DOCTORS_TIME_SCHEDULE` ( `START_TIME`, `END_TIME`, `DISTRICT_ID`, `ADDRESS`, `DOCTORS_ID`, `AMOUNT`, `DAYS`) " +
"VALUES ('" + model.START_TIME + "', '" + model.END_TIME + "', '" + model.DISTRICT_ID + "', '" + model.ADDRESS + "', '" + model.DOCTOR_ID + "', '" + model.AMOUNT + "', '" + model.DAYS + "')";
connection.Open();
MySqlCommand cmd = new MySqlCommand(sql, connection);
res = cmd.ExecuteNonQuery();
connection.Close();
return(cmd.LastInsertedId.ToString());
}
catch (Exception ex)
{
return(ex.ToString());
}
}
