public List <SheetAndSheetField> GetSheets(string RegistrationKey) { List <SheetAndSheetField> sAndsfList = new List <SheetAndSheetField>(); long DentalOfficeID = util.GetDentalOfficeID(RegistrationKey); try { if (DentalOfficeID == 0) { return(sAndsfList); } ODWebServiceEntities db = new ODWebServiceEntities(); var wsRes = from wsf in db.webforms_sheet where wsf.webforms_preference.DentalOfficeID == DentalOfficeID select wsf; for (int i = 0; i < wsRes.Count(); i++) { //Only download 20 sheets at a time. This an attempt to fix DeleteSheetData from timing out after all sheets have been imported. if (i > 19) { break; } var wsobj = wsRes.ToList()[i]; wsobj.webforms_sheetfield.Load(); var sheetfieldList = wsobj.webforms_sheetfield; SheetAndSheetField sAnds = new SheetAndSheetField(wsobj, sheetfieldList.ToList()); sAndsfList.Add(sAnds); } Logger.Information("In GetSheetData IpAddress=" + HttpContext.Current.Request.UserHostAddress + " DentalOfficeID=" + DentalOfficeID + " Sheets sent to Client=" + wsRes.Count()); return(sAndsfList); } catch (Exception ex) { Logger.LogError("IpAddress=" + HttpContext.Current.Request.UserHostAddress + " DentalOfficeID=" + DentalOfficeID, ex); return(sAndsfList); } }
public List<SheetAndSheetField> GetSheets(string RegistrationKey) { List<SheetAndSheetField> sAndsfList=new List<SheetAndSheetField>(); long DentalOfficeID=util.GetDentalOfficeID(RegistrationKey); try { if(DentalOfficeID==0) { return sAndsfList; } ODWebServiceEntities db=new ODWebServiceEntities(); var wsRes=from wsf in db.webforms_sheet where wsf.webforms_preference.DentalOfficeID==DentalOfficeID select wsf; for(int i=0;i<wsRes.Count();i++) { var wsobj=wsRes.ToList()[i]; wsobj.webforms_sheetfield.Load(); var sheetfieldList=wsobj.webforms_sheetfield; SheetAndSheetField sAnds=new SheetAndSheetField(wsobj,sheetfieldList.ToList()); sAndsfList.Add(sAnds); } Logger.Information("In GetSheetData IpAddress="+HttpContext.Current.Request.UserHostAddress+" DentalOfficeID="+DentalOfficeID+" Sheets sent to Client="+wsRes.Count()); return sAndsfList; } catch(Exception ex) { Logger.LogError("IpAddress="+HttpContext.Current.Request.UserHostAddress+" DentalOfficeID="+DentalOfficeID,ex); return sAndsfList; } }
public FormPatientPickWebForm(SheetAndSheetField sheetAndSheetField) { InitializeComponent(); Lan.F(this); _sheetAndSheetField = sheetAndSheetField; }