public bool Add(patientsModel patient) { DateTime creationDate = DateTime.Now; connection(); con.Open(); SqlCommand cmd = new SqlCommand("Add", con); cmd.Parameters.Clear(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", patient.ID); cmd.Parameters.AddWithValue("@fname", patient.fname); cmd.Parameters.AddWithValue("@mname", patient.mname); cmd.Parameters.AddWithValue("@lname", patient.lname); cmd.Parameters.AddWithValue("@gender", patient.gender); cmd.Parameters.AddWithValue("@email", patient.email); cmd.Parameters.AddWithValue("@lastCheck", creationDate); cmd.Parameters.AddWithValue("@status", patient.status); cmd.Parameters.AddWithValue("@Active", patient.Active); cmd.Parameters.AddWithValue("@creationDate", creationDate); cmd.Parameters.AddWithValue("@CreatedBy", 1); int i = Convert.ToInt32(cmd.ExecuteNonQuery()); con.Close(); if (i >= 1) { return(true); } else { return(false); } }
public bool update(patientsModel patient) { // DateTime lastCheck = DateTime.MinValue; Nullable <DateTime> lastCheck = null; connection(); SqlCommand cmd = new SqlCommand("Update", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@ID", patient.ID); cmd.Parameters.AddWithValue("@fname", patient.fname); cmd.Parameters.AddWithValue("@mname", patient.mname); cmd.Parameters.AddWithValue("@lname", patient.lname); cmd.Parameters.AddWithValue("@gender", patient.gender); cmd.Parameters.AddWithValue("@email", patient.email); cmd.Parameters.AddWithValue("@lastCheck", lastCheck); cmd.Parameters.AddWithValue("@status", patient.status); cmd.Parameters.AddWithValue("@Active", patient.Active); cmd.Parameters.AddWithValue("@creationDate", patient.creationDate); cmd.Parameters.AddWithValue("@CreatedBy", 1); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); if (i >= 1) { return(true); } else { return(false); } /* * cmd.Parameters.Add("@ID", SqlDbType.Int).Value = patient.ID; * cmd.Parameters.Add("@fname",SqlDbType.VarChar).Value = patient.fname; * cmd.Parameters.Add("@mname", SqlDbType.VarChar).Value = patient.mname; * cmd.Parameters.Add("@lname", SqlDbType.VarChar).Value = patient.lname; * cmd.Parameters.Add("@gender", SqlDbType.Int).Value = patient.gender; * cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = patient.email; * cmd.Parameters.Add("@lastCheck", SqlDbType.DateTime).Value = lastCheck; * cmd.Parameters.Add("@status", SqlDbType.Int).Value = patient.status; * cmd.Parameters.Add("@Active", SqlDbType.Int).Value = patient.Active; * cmd.Parameters.Add("@creationDate", SqlDbType.DateTime).Value = patient.creationDate; * cmd.Parameters.Add("@CreatedBy", SqlDbType.Int).Value = 1; */ }
public patientsModel getById(int id) { patientsModel patient = new patientsModel(); connection(); SqlCommand cmd = new SqlCommand("getById", con); con.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@ID", id); SqlDataReader dtreader = cmd.ExecuteReader(); if (dtreader.HasRows) { while (dtreader.Read()) { patient = new patientsModel(); patient.ID = Convert.ToInt32(dtreader["ID"]); patient.fname = dtreader["fname"].ToString(); patient.mname = dtreader["mname"].ToString(); patient.lname = dtreader["lname"].ToString(); patient.gender = Convert.ToInt32(dtreader["gender"]); patient.email = dtreader["email"].ToString(); patient.status = Convert.ToInt32(dtreader["status"]); patient.lastCheck = Convert.ToDateTime(dtreader["lastCheck"]); patient.Active = Convert.ToInt32(dtreader["Active"]); patient.creationDate = Convert.ToDateTime(dtreader["creationDate"]); try { patient.CreatedBy = Convert.ToInt32(dtreader["CreatedBy"]); } catch (Exception ex) { }; } } return(patient); }
public List <patientsModel> getAll() { /* * List<patientsModel> patientsList = new List<patientsModel>(); * SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString); * string query = "select * from patients"; * SqlCommand cmd = new SqlCommand(query, con); * con.Open(); * SqlDataReader dtreader = cmd.ExecuteReader(); * patientsModel patient = null; * if(dtreader.HasRows) * { * while(dtreader.Read()) * { * patient = new patientsModel(); * patient.ID = Convert.ToInt32(dtreader["ID"]); * patient.fname = dtreader["fname"].ToString(); * patient.mname = dtreader["mname"].ToString(); * patient.lname = dtreader["lname"].ToString(); * patient.gender = Convert.ToInt32(dtreader["gender"]); * patient.email = dtreader["email"].ToString(); * patient.status = Convert.ToInt32(dtreader["status"]); * patient.Active = Convert.ToInt32(dtreader["Active"]); * patient.creationDate = Convert.ToDateTime(dtreader["creationDate"]); * try * { * patient.CreatedBy = Convert.ToInt32(dtreader["CreatedBy"]); * } * catch(Exception ex) { }; * * patientsList.Add(patient); * } * * } * return patientsList; */ connection(); con.Open(); SqlCommand cmd = new SqlCommand("getAll", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader dtreader = cmd.ExecuteReader(); patientsModel patient = null; List <patientsModel> patientsList = new List <patientsModel>(); if (dtreader.HasRows) { while (dtreader.Read()) { patient = new patientsModel(); patient.ID = Convert.ToInt32(dtreader["ID"]); patient.fname = dtreader["fname"].ToString(); patient.mname = dtreader["mname"].ToString(); patient.lname = dtreader["lname"].ToString(); patient.gender = Convert.ToInt32(dtreader["gender"]); patient.email = dtreader["email"].ToString(); patient.lastCheck = Convert.ToDateTime(dtreader["lastCheck"]); patient.status = Convert.ToInt32(dtreader["status"]); patient.Active = Convert.ToInt32(dtreader["Active"]); patient.creationDate = Convert.ToDateTime(dtreader["creationDate"]); try { patient.CreatedBy = Convert.ToInt32(dtreader["CreatedBy"]); } catch (Exception ex) { }; patientsList.Add(patient); } } return(patientsList); }