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