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