public Class_Patient Find(int id)
{
Class_Patient p = new Class_Patient();
if (isMySqlOnline())
{
using (var db = new MySQLBase.MySQL_Model())
{
try
{
var query = from p1 in db.patients
where p1.patientNo.Equals(id)
select p1;
foreach (var item in query)
{
p.patientNo = item.patientNo;
p.patientName = item.PatientName;
p.Paddress = item.address;
p.Psex = item.sex;
p.PregDate = item.regDate;
p.PdisDate = item.disDate;
p.PempID = item.empID;
p.Page = Convert.ToInt32(item.age);
}
}
catch (Exception)
{
//MessageBox.Show("NO DATA FOUND");
}
}
}
else if (isSql2008Online())
{
using (var db = new SQL2008.hospitalEntities())
{
try
{
var query = from p1 in db.DBpatients
where p1.patientNo.Equals(id)
select p1;
foreach (var item in query)
{
p.patientNo = item.patientNo;
p.patientName = item.PatientName;
p.Paddress = item.address;
p.Psex = item.sex;
p.PregDate = item.regDate;
p.PdisDate = item.disDate;
p.PempID = item.empID;
p.Page = Convert.ToInt32(item.age);
}
}
catch (Exception)
{
//MessageBox.Show("NO DATA FOUND");
}
}
}
else
{
}
return p;
}
public string UpdatePatient(Class_Patient pa)
{
checkDB();
try
{
if (mysql == true)
{
using (var db = new MySQLBase.MySQL_Model())
{
var original = db.patients.Find(pa.patientNo);
if (original != null)
{
original.PatientName = pa.patientName;
original.remarks = pa.Premarks;
original.regDate = pa.PregDate;
original.age = pa.Page;
original.disDate = pa.PdisDate;
original.empID = pa.PempID;
original.sex = pa.Psex;
original.address = pa.Paddress;
}
db.SaveChanges();
}
}
else
{
string sFilePath1 = @"C:\Users\Pratik\Desktop\MySQL.txt";
string sDateTime = GetLogFor(pa);
sDateTime.Remove((sDateTime.Length - 2), 1);
System.IO.StreamWriter oFileWriter = new System.IO.StreamWriter(sFilePath1, true);
oFileWriter.WriteLine("Insert");
oFileWriter.WriteLine(sDateTime);
oFileWriter.Close();
}
if (sql2008 == true)
{
using (var db = new SQL2008.hospitalEntities())
{
var original = db.DBpatients.Find(pa.patientNo);
if (original != null)
{
original.PatientName = pa.patientName;
original.remarks = pa.Premarks;
original.regDate = pa.PregDate;
original.age = pa.Page;
original.disDate = pa.PdisDate;
original.empID = pa.PempID;
original.sex = pa.Psex;
original.address = pa.Paddress;
}
db.SaveChanges();
}
}
else
{
string sFilePath1 = @"C:\Users\Pratik\Desktop\SQL2008.txt";
string sDateTime = GetLogFor(pa);
sDateTime.Remove((sDateTime.Length - 2), 1);
System.IO.StreamWriter oFileWriter = new System.IO.StreamWriter(sFilePath1, true);
oFileWriter.WriteLine("Insert");
oFileWriter.WriteLine(sDateTime);
oFileWriter.Close();
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
return "Property: " + validationError.PropertyName + "Error: " + validationError.ErrorMessage;
}
}
}
catch (Exception e)
{
return "not done" + e.Message;
}
return "hell";
}
public string InsertNewPatients(Class_Patient pa)
{
checkDB();
try
{
if (mysql == true)
{
using (MySQLBase.MySQL_Model db = new MySQLBase.MySQL_Model())
{
var p = new MySQLBase.patient
{
patientNo = pa.patientNo,
PatientName = pa.patientName,
age = pa.Page,
sex = pa.Psex,
address = pa.Paddress,
regDate = pa.PregDate.Date,
disDate = pa.PdisDate.Date,
remarks = pa.Premarks,
empID = pa.PempID,
};
db.patients.Add(p);
db.SaveChanges();
}
}
else
{
string sFilePath1 = @"C:\Users\Pratik\Desktop\MySQL.txt";
string sDateTime = GetLogFor(pa);
sDateTime.Remove((sDateTime.Length - 2), 1);
System.IO.StreamWriter oFileWriter = new System.IO.StreamWriter(sFilePath1, true);
oFileWriter.WriteLine("Insert");
oFileWriter.WriteLine(sDateTime);
oFileWriter.Close();
}
if (sql2008 == true)
{
using (SQL2008.hospitalEntities db = new SQL2008.hospitalEntities())
{
var p = new SQL2008.DBpatient
{
patientNo = pa.patientNo,
PatientName = pa.patientName,
age = pa.Page,
sex = pa.Psex,
address = pa.Paddress,
regDate = pa.PregDate,
disDate = pa.PdisDate,
remarks = pa.Premarks,
empID = pa.PempID,
};
db.DBpatients.Add(p);
db.SaveChanges();
}
}
else
{
string sFilePath1 = @"C:\Users\Pratik\Desktop\SQL2008.txt";
string sDateTime = GetLogFor(pa);
sDateTime.Remove((sDateTime.Length - 2), 1);
System.IO.StreamWriter oFileWriter = new System.IO.StreamWriter(sFilePath1, true);
oFileWriter.WriteLine("Insert");
oFileWriter.WriteLine(sDateTime);
oFileWriter.Close();
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
return "Property: " + validationError.PropertyName + "Error: " + validationError.ErrorMessage;
}
}
}
catch (Exception ex)
{
return "not done" + ex.Message;
}
return "hell";
}