public bool IsRecordExists(string Pat_id, string Empid, DateTime App_Date)
{
bool flag1 = false;
try
{
tblPatientAllocToDoc objPat = (from tbl in objData.tblPatientAllocToDocs
where tbl.PatientId.Equals(Pat_id) &&
tbl.AppDate.CompareTo(App_Date) == 0 &&
tbl.DocId.Equals(Empid)
select tbl).FirstOrDefault();
if (objPat != null)
{
flag1 = true;
}
else
{
flag1 = false;
}
}
catch (Exception ex)
{
throw ex;
}
return(flag1);
}
public int Update(EntityPatAllocDoc objT)
{
try
{
tblPatientAllocToDoc test = (from tbl in objData.tblPatientAllocToDocs
where tbl.IsDelete == false &&
tbl.PateintAllocId == objT.PKId
select tbl).FirstOrDefault();
test.DocId = objT.Emp_Id;
test.AppDate = objT.AppointDate;
test.Charges = objT.Charges;
objData.SubmitChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertAllocPat(EntityPatientAlloc entPat)
{
try
{
tblPatientAllocToDoc obj = new tblPatientAllocToDoc()
{
PatientId = entPat.PatientId,
DocId = entPat.DocId,
AppDate = entPat.AppDate,
Charges = entPat.Charges
};
objData.tblPatientAllocToDocs.InsertOnSubmit(obj);
objData.SubmitChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
