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; } }