public Models.workBreakModel searchWorkBreak(int id)
{
Models.workBreakModel workModel = new Models.workBreakModel();
try
{
using (SqlConnection connection = new SqlConnection(DBConnection.stringConnection))
{
SqlCommand command = new SqlCommand(null, connection);
command.Connection.Open();
command.CommandText = "SELECT * FROM work_breaks WHERE break_id = " + id;
SqlDataReader dr = command.ExecuteReader();
if (dr.Read())
{
workModel.Id = dr.GetInt32(0);
workModel.Doc_status = dr.GetString(1);
workModel.Diagnostic = dr.GetString(2);
workModel.Date_pmi = dr.GetDateTime(3).ToString("yyyy-MM-dd");
workModel.Start_date = dr.GetDateTime(4).ToString("yyyy-MM-dd");
workModel.End_date = dr.GetDateTime(5).ToString("yyyy-MM-dd");
workModel.Situation = dr.GetString(6);
workModel.Unit = dr.GetInt32(7);
workModel.User_id = dr.GetInt32(8);
workModel.Patient_id = dr.GetInt32(9);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(workModel);
}
public Boolean EditWorkBreak(Models.workBreakModel workModel)
{
bool success = false;
try
{
using (SqlConnection connection = new SqlConnection(DBConnection.stringConnection))
{
SqlCommand command = new SqlCommand(null, connection);
command.Connection.Open();
String sql = "UPDATE work_breaks SET [doc_status] ='" + workModel.Doc_status + "', [diagnostic] = '" + workModel.Diagnostic + "', [date_pmi] ='" + workModel.Date_pmi + "',[start_date]= '" + workModel.Start_date + "' , [end_date] ='" + workModel.End_date + "', [situation] ='" + workModel.Situation + "', [unit] ='" + workModel.Unit + "', [user_id] ='" + workModel.User_id + "', [patient_id] ='" + workModel.Patient_id + "' WHERE break_id = '" + workModel.Id + "';";
Console.WriteLine(sql);
command.CommandText = sql;
command.Prepare();
command.ExecuteNonQuery();
success = true;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(success);
}
public Boolean CreateWorkBreak(Models.workBreakModel workModel)
{
bool register = false;
try
{
using (SqlConnection connection = new SqlConnection(DBConnection.stringConnection))
{
SqlCommand command = new SqlCommand(null, connection);
command.Connection.Open();
String sql = "INSERT INTO work_breaks VALUES ('" + workModel.Doc_status + "','" + workModel.Diagnostic + "','" + workModel.Date_pmi + "','" + workModel.Start_date + "','" + workModel.End_date + "','" + workModel.Situation + "','" + workModel.Unit + "','" + workModel.User_id + "','" + workModel.Patient_id + "' )";
Console.WriteLine(sql);
command.CommandText = sql;
command.Prepare();
command.ExecuteNonQuery();
register = true;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(register);
}
