public clsPatientDetailsModel GetByPatientId(int patientId)
{
clsPatientDetailsModel result = new clsPatientDetailsModel();
DataTable dataTable = new DataTable();
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.GetPatientDetailsByPatientId;
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@patient", patientId));
connect.dta = new System.Data.OleDb.OleDbDataAdapter(connect.cmd);
connect.dta.Fill(dataTable);
connect.con.Close();
if (dataTable != null || dataTable.Rows.Count > 0)
{
result = new clsPatientDetailsModel()
{
Name = dataTable.Rows[0][1].ToString(),
Surname = dataTable.Rows[0][2].ToString(),
Tel = dataTable.Rows[0][3].ToString(),
Mobile1 = dataTable.Rows[0][4].ToString(),
Mobile2 = dataTable.Rows[0][5].ToString(),
DOB = string.IsNullOrWhiteSpace(dataTable.Rows[0][6].ToString())? DateTime.Now: Convert.ToDateTime(dataTable.Rows[0][6].ToString()),
Age = string.IsNullOrWhiteSpace(dataTable.Rows[0][7].ToString())? 0: Convert.ToInt32(dataTable.Rows[0][7].ToString()),
Occupation = dataTable.Rows[0][8].ToString()
};
}
return(result);
}
public int Save(clsPatientDetailsModel patientDetails)
{
int patientId = 0;
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.InsertPatientDetails;
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@na", patientDetails.Name));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@sur", patientDetails.Surname));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@tel", patientDetails.Tel));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@mob1", patientDetails.Mobile1));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@mob2", patientDetails.Mobile2));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@dob", patientDetails.DOB));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@age", patientDetails.Age));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@occup", patientDetails.Occupation));
connect.cmd.ExecuteNonQuery();
connect.con.Close();
patientId = GetMaxPatientId();
if (patientId == 0)
{
throw new Exception("Unable to save patient Id");
}
return(patientId);
}
public void Update(int patientId, clsPatientDetailsModel patientDetails)
{
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = string.Format(clsQuery.UpdatePatientDetails, patientId);
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@na", patientDetails.Name));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@sur", patientDetails.Surname));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@tel", patientDetails.Tel));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@mob1", patientDetails.Mobile1));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@mob2", patientDetails.Mobile2));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@dob", patientDetails.DOB));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@age", patientDetails.Age));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@occup", patientDetails.Occupation));
connect.cmd.ExecuteNonQuery();
connect.con.Close();
}
