public tblPatientMaster GetPatientbyId(int id)
{
tblPatientMaster obj = null;
try
{
obj = (from tbl in objData.tblPatientMasters
where tbl.IsDelete == false &&
tbl.PKId == id
select tbl).FirstOrDefault();
}
catch (Exception ex)
{
throw ex;
}
return(obj);
}
internal tblPatientMaster GetPatientDetailsByPatientIdForUpdate(int PatientId)
{
tblPatientMaster objPatient = null;
try
{
objPatient = (from tbl in objData.tblPatientMasters
where tbl.PKId == PatientId &&
tbl.IsDelete == false
select tbl).FirstOrDefault();
}
catch (Exception ex)
{
throw ex;
}
return(objPatient);
}
public tblPatientMaster GetPatientbyCode(int id)
{
tblPatientMaster obj = null;
try
{
obj = (from tbl in objData.tblPatientMasters
join tblAdmit in objData.tblPatientAdmitDetails
on tbl.PKId equals tblAdmit.PatientId
where tbl.IsDelete == false &&
tblAdmit.AdmitId == id
select tbl).FirstOrDefault();
}
catch (Exception ex)
{
throw ex;
}
return(obj);
}
public string ExistIPD(string Ipdno)
{
try
{
tblPatientMaster model = (from tbl in objData.tblPatientMasters
where tbl.IsDelete == false &&
tbl.IPDNo == Ipdno
select tbl).FirstOrDefault();
if (model != null)
{
Ipdno = null;
}
return(Ipdno);
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertIPDPatient(EntityPatientMaster entPatientMaster)
{
int cnt = 0;
try
{
tblPatientMaster obj = new tblPatientMaster()
{
Address = entPatientMaster.PatientAddress,
AdminDate = entPatientMaster.PatientAdmitDate,
AdmitTime = entPatientMaster.PatientAdmitTime,
Age = entPatientMaster.Age,
AgeIn = entPatientMaster.AgeIn,
Weight = entPatientMaster.Weight,
BedNo = entPatientMaster.BedNo,
BirthDate = entPatientMaster.BirthDate,
BloodGroup = entPatientMaster.BloodGroup,
Caste = entPatientMaster.Caste.ToString(),
City = entPatientMaster.City,
ComContNo = entPatientMaster.CompanyContact,
CompanyCode = entPatientMaster.CompanyCode,
CompanyAddress = entPatientMaster.CompanyAddress,
ContactNo = entPatientMaster.PatientContactNo,
CompanyId = entPatientMaster.CompanyId,
Country = entPatientMaster.Country,
Dignosys = entPatientMaster.Dignosys,
Gender = Convert.ToChar(entPatientMaster.Gender),
Initial = entPatientMaster.PatientInitial,
InsuranceCompanyId = entPatientMaster.InsuranceCompID,
InsuranceCompName = entPatientMaster.InsuranceCompName,
Occupation = entPatientMaster.Occupation,
//DeptCategory=entPatientMaster.DeptCategory,
//DeptDoctorId=entPatientMaster.DeptDoctorId,
PatientCode = entPatientMaster.PatientCode,
PatientFirstName = entPatientMaster.PatientFirstName,
PatientMiddleName = entPatientMaster.PatientMiddleName,
PatientLastName = entPatientMaster.PatientLastName,
PatientType = entPatientMaster.PatientType,
Religion = entPatientMaster.Religion.ToString(),
State = entPatientMaster.State,
ReferedBy = entPatientMaster.ReferedBy,
PastMedHistory = entPatientMaster.PastMedicalHistory,
OPDRoomNo = "0",
FloorNo = 0,
WardNo = 0,
ConsultingDr = 0,
EntryDate = DateTime.Now.Date,
FamilyHistory = "",
EntryBy = "0",
ChangeBy = "0",
PatientCategory = "0",
IsDelete = false,
IPDNo = entPatientMaster.IPDNo,
OPDNo = entPatientMaster.OPDNo,
CompanyName = entPatientMaster.CompName,
InsuranceName = entPatientMaster.InsuName
//AudiometryFile=entPatientMaster.AudiometryFile,
//EndoscopyFile=entPatientMaster.EndoscopyFile
};
objData.tblPatientMasters.InsertOnSubmit(obj);
objData.SubmitChanges();
cnt++;
}
catch (Exception ex)
{
throw ex;
}
return(cnt);
}
public int UpdatePatient(EntityPatientMaster entPatientMaster)
{
int i = 0;
try
{
tblPatientMaster objPatient = (from tbl in objData.tblPatientMasters
where tbl.IsDelete == false &&
tbl.PKId == entPatientMaster.PKId
select tbl).FirstOrDefault();
if (objPatient != null)
{
objPatient.IPDNo = entPatientMaster.IPDNo;
objPatient.OPDNo = entPatientMaster.OPDNo;
objPatient.Address = entPatientMaster.PatientAddress;
objPatient.Age = entPatientMaster.Age;
objPatient.AgeIn = entPatientMaster.AgeIn;
objPatient.Weight = entPatientMaster.Weight;
objPatient.BirthDate = entPatientMaster.BirthDate;
objPatient.BloodGroup = entPatientMaster.BloodGroup;
objPatient.Caste = Convert.ToString(entPatientMaster.Caste);
objPatient.City = entPatientMaster.City;
objPatient.ComContNo = entPatientMaster.CompanyContact;
objPatient.ContactNo = entPatientMaster.PatientContactNo;
//objPatient.Gender =Convert.ToChar(entPatientMaster.Gender);
objPatient.Initial = entPatientMaster.PatientInitial;
objPatient.PatientFirstName = entPatientMaster.PatientFirstName;
objPatient.PatientMiddleName = entPatientMaster.PatientMiddleName;
objPatient.PatientLastName = entPatientMaster.PatientLastName;
objPatient.Religion = Convert.ToString(entPatientMaster.Religion);
objPatient.State = entPatientMaster.State;
objPatient.ReferedBy = entPatientMaster.ReferedBy;
objPatient.Occupation = entPatientMaster.Occupation;
objPatient.DeptCategory = entPatientMaster.DeptCategory;
objPatient.DeptDoctorId = entPatientMaster.DeptDoctorId;
objPatient.CompanyName = entPatientMaster.CompName;
objPatient.InsuranceName = entPatientMaster.InsuName;
objPatient.CompanyId = entPatientMaster.CompanyId;
objPatient.InsuranceCompanyId = entPatientMaster.InsuranceCompID;
objPatient.InsuranceCompName = entPatientMaster.InsuranceCompName;
List <tblPatientAdmitDetail> lst = (from tbl in objData.tblPatientAdmitDetails
where tbl.IsDelete == false &&
tbl.PatientId == objPatient.PKId
select tbl).ToList();
if (lst.Count > 0)
{
foreach (tblPatientAdmitDetail item in lst)
{
//if (string.IsNullOrEmpty(item.Dignosys))
//{
item.Dignosys = entPatientMaster.Dignosys;
item.Age = entPatientMaster.Age;
item.AgeIn = entPatientMaster.AgeIn;
item.DeptCategory = entPatientMaster.DeptCategory;
item.DeptDoctorId = entPatientMaster.DeptDoctorId;
item.CompanyName = entPatientMaster.CompName;
item.InsuranceName = entPatientMaster.InsuName;
if (entPatientMaster.CompanyId > 0)
{
item.IsCompany = true;
item.CompanyId = entPatientMaster.CompanyId;
}
if (entPatientMaster.InsuranceCompID > 0)
{
item.IsInsured = true;
item.InsuranceComId = entPatientMaster.InsuranceCompID;
}
//}
}
}
objData.SubmitChanges();
i++;
}
}
catch (Exception)
{
i = 0;
}
return(i);
}
