public bool Process(string fileName, int adminClientId, int schedulingId, int custClientId)
 {
     _FileName                 = fileName;
     _SchedulingId             = schedulingId;
     _AdminClientId            = adminClientId;
     _CustClientId             = custClientId;
     _SupportedSheetCollection = SchedulingTemplateLoader.GetSchedulingDataSheetCollection(_SchedulingId);
     LoadFileIntoDataTable();
     SchedulingDataSet.SchedulingImportsDataTable convertedTable = ConvertUploadedDataTable();
     if (convertedTable == null)
     {
         return(false);
     }
     PrepareConvertedTableForDatabaseUpdate(convertedTable);
     UploadDatabaseRecords(convertedTable);
     if (convertedTable.Rows.Count == 0)
     {
         return(false);
     }
     return(true);
 }
        public static DataSheetCollection GetSchedulingDataSheetCollection(int schedulingId)
        {
            SchedulingTemplateLoader loader = new SchedulingTemplateLoader();

            return(loader.GetDataSheetCollection(schedulingId));
        }
        public static XmlDocument GetSchedulingTemplateDocument(int schedulingId)
        {
            SchedulingTemplateLoader loader = new SchedulingTemplateLoader();

            return(loader.GetTemplateDocument(schedulingId));
        }