public FileStreamResult GetUasCsv() { string paramFileId = Request["fileId"] as string; Debug.WriteLine("* * * ExportController GetUasCsv fileId: " + paramFileId); int fileId = 0; try { fileId = Convert.ToInt32(paramFileId); } catch (Exception exptn) { Debug.WriteLine("* * * ExportController GetUasCsv Exception: " + exptn.Message); } Debug.WriteLine("* * * ExportController GetUasCsv fileId: " + fileId.ToString()); IUasSql uasSql = new UasSql(); string tableName = uasSql.GetUasTableName(fileId); if (String.IsNullOrEmpty(tableName)) { string errMsg = "Error: Invalid fileId: " + paramFileId; return(ProcessError(errMsg)); } Debug.WriteLine(" Connection: " + uasSql.GetConnectionString()); string sqlQuery = getUASQuery(tableName); return(CreateCsvStream(uasSql.GetConnectionString(), sqlQuery)); }
//private static void AddHiddenField(IFormsRepository formsRepo, def_FormResults formResult, string fieldName, string value) //{ // int itemId = formsRepo.GetItemByIdentifier(SIS_HIDDEN).itemId; // def_ItemResults itemResult = formsRepo.GetItemResultByFormResItem(formResult.formResultId, itemId); // def_ResponseVariables relatedFormResultRV = null; // try // { // relatedFormResultRV = formsRepo.GetResponseVariablesByFormResultIdentifier(formResult.formResultId, fieldName); // } // catch (Exception ex) // { // Console.WriteLine(ex.Message); // } // def_ItemVariables itemVariableRelated = formsRepo.GetItemVariableByIdentifier(fieldName); // if (itemVariableRelated != null) // { // if (relatedFormResultRV != null) // { // relatedFormResultRV.rspValue = value; // formsRepo.ConvertValueToNativeType(itemVariableRelated, relatedFormResultRV); // } // else // { // relatedFormResultRV = new def_ResponseVariables(); // relatedFormResultRV.itemResultId = itemResult.itemResultId; // relatedFormResultRV.itemVariableId = itemVariableRelated.itemVariableId; // relatedFormResultRV.rspValue = value; // formsRepo.ConvertValueToNativeType(itemVariableRelated, relatedFormResultRV); // formsRepo.AddResponseVariableNoSave(relatedFormResultRV); // } // } // formsRepo.Save(); //} private static void CopyAssessmentData(IFormsRepository formsRepo, int oldFormResultId, def_FormResults copyFormResult) { try { IUasSql uasSql = new UasSql(); using (DbConnection connection = new SqlConnection(uasSql.GetConnectionString())) { connection.Open(); using (DbCommand command = connection.CreateCommand()) { command.CommandText = "SELECT IR.itemId, RV.itemVariableId, RV.rspValue from def_ItemResults IR JOIN def_FormResults FR on FR.formResultId = IR.formResultId JOIN def_ResponseVariables RV on RV.itemResultId = IR.itemResultId WHERE FR.formResultId = " + oldFormResultId + " ORDER BY itemId"; command.CommandType = CommandType.Text; DataTable dt = new DataTable(); dt.Load(command.ExecuteReader()); if (dt != null) { SaveAssessmentFromDataTable(formsRepo, copyFormResult, dt); } } } } catch (Exception ex) { Debug.WriteLine("* * * CreateFormResultJSON exception: " + ex.Message); } }
public static void UpdateUserDob(int?userId, string dob) { // Update the UAS User DOB. if (userId != null) { IUasSql uasSql = new UasSql(); uasSql.SaveDOB(userId.Value, dob); } }
private List <def_LookupDetail> getDetails(int masterId, int ent = 0, int grp = 0) { IUasSql uasSql = new UasSql(); string enterpriseName = uasSql.getEnterpriseName(ent); string groupName = uasSql.getGroupName(grp); List <def_LookupDetail> lookupDetails = new List <def_LookupDetail>(); lookupDetails.AddRange(formsRepo.GetLookupDetails(masterId, ent, grp)); return(lookupDetails); }
public ActionResult Select() { IUasSql uasSql = new UasSql(); if (SessionHelper.LoginStatus.EnterpriseID == 0) { lookupModel.enterprises = uasSql.getEnterprises(); } else { lookupModel.enterprises = new Dictionary <int, string>(); lookupModel.enterprises.Add(SessionHelper.LoginStatus.EnterpriseID, uasSql.getEnterpriseName(SessionHelper.LoginStatus.EnterpriseID)); } return(PartialView("_Select", lookupModel)); }
/// <summary> /// Loads the page to create a new Team to an Enterprise. /// </summary> /// <param name="lookupDetailId">Identifier for the selected Team.</param> /// <param name="enterpriseId">Identifier for the current Enterprise.</param> /// <returns>Redirects the user to the Save Detail page.</returns> public ActionResult AddDetail(int lookupMasterId, int enterpriseId = 0) { AdapAdmin model = new AdapAdmin(); model.ActiveUserName = SessionHelper.LoginStatus.FirstName + " " + SessionHelper.LoginStatus.LastName; IUasSql uasSql = new UasSql(); Dictionary<int, string> groups = uasSql.getGroups(enterpriseId); //groups.Add(0, "Enterprise Wide"); model.groups = (new SelectList(groups.OrderBy(x => x.Key), "key", "value")).ToList(); model.enterpriseId = enterpriseId; model.groupId = 0; model.lookupMasterId = lookupMasterId; model.statusFlag = true; return View("~/Views/COADAP/ListItems/SaveDetail.cshtml", model); }
public ActionResult EditDetail(int lookupDetailId) { AdapAdmin model = new AdapAdmin(); model.ActiveUserName = SessionHelper.LoginStatus.FirstName + " " + SessionHelper.LoginStatus.LastName; def_LookupDetail detail = formsRepo.GetLookupDetailById(lookupDetailId); if (detail != null) { IUasSql uasSql = new UasSql(); if (detail.EnterpriseID != null) { Dictionary<int, string> groups = uasSql.getGroups(detail.EnterpriseID.Value); groups.Add(0, "Enterprise Wide"); model.groups = (new SelectList(groups.OrderBy(x => x.Key), "key", "value")).ToList(); } model.lookupDetailId = lookupDetailId; model.lookupMasterId = detail.lookupMasterId; model.enterpriseId = detail.EnterpriseID; model.groupId = detail.GroupID; model.dataValue = detail.dataValue; model.displayOrder = detail.displayOrder; model.statusFlag = (detail.StatusFlag == "A") ? true : false; def_LookupText text = formsRepo.GetLookupTextsByLookupDetail(lookupDetailId).FirstOrDefault(); if (text != null) { model.displayText = text.displayText; } } return View("~/Views/COADAP/ListItems/SaveDetail.cshtml", model); }
/// <summary> /// Web Service to process requests from the ADAP Clinic Admin DataTable /// </summary> /// <param name="draw">Automatically posted by JQuery DataTables: count of the number of times this table has been drawn.</param> /// <param name="start">Automatically posted by JQuery DataTables: the starting index of the current result set.</param> /// <param name="length">Automatically posted by JQuery DataTables: the number of rows displayed by the table.</param> /// <param name="searchValue">Automatically posted by JQuery DataTables: </param> /// <param name="searchRegex">Automatically posted by JQuery DataTables: </param> /// <param name="order">Automatically posted by JQuery DataTables: </param> /// <returns>String formatted for JQuery DataTables.</returns> public string DataTableClinicList(int draw, int start, int length, string searchValue, string searchRegex, string order) { string result = String.Empty; Debug.WriteLine("Adap Controller ClinicList draw:" + draw.ToString()); Debug.WriteLine("Adap Controller ClinicList start:" + start.ToString()); Debug.WriteLine("Adap Controller ClinicList searchValue:" + searchValue); Debug.WriteLine("Adap Controller ClinicList searchRegex:" + searchRegex); Debug.WriteLine("Adap Controller ClinicList order:" + order); // Lists all the Request parameters foreach (string s in Request.Params.Keys) { Debug.WriteLine(s.ToString() + ":" + Request.Params[s]); } try { // Initialize the DataTable response (later transformed to JSON) DataTableResult dtr = new DataTableResult() { draw = draw, recordsTotal = 1, recordsFiltered = 1, data = new List <string[]>(), error = String.Empty }; // How to find Enterprise ID and Form ID? Values currently hardcoded to populate Data Table. //IQueryable<def_LookupMaster> query = formsRepo.GetLookupMaster(74); var sSort = Request.Params["columns[1][search][value]"]; var sTeam = Request.Params["columns[2][search][value]"]; int teamId = -1; if (!String.IsNullOrEmpty(sTeam) && !sTeam.Equals("-1")) { try { teamId = Convert.ToInt32(sTeam); } catch (Exception excptn) { Debug.WriteLine("Adap Controller ClinicList Integer Conversion:" + excptn.Message); } } // rename to avoid language/library conflicts int iniIndex = start; int noDsplyRecs = length; int entId = SessionHelper.LoginStatus.EnterpriseID; Debug.WriteLine("Adap Controller ClinicList SelectedEnterprise:" + entId.ToString()); IEnumerable <def_LookupDetail> detail = formsRepo.GetLookupMastersByLookupCode("ADAP_CLINIC").def_LookupDetail .Where(f => (teamId > -1) ? f.GroupID == teamId : true) .Where(f => (entId > 0) ? f.EnterpriseID == entId : true); if (String.IsNullOrEmpty(sSort) || sSort.Equals("false")) { detail = detail.OrderBy(f => f.displayOrder); } else { detail = detail.OrderBy(f => (f.def_LookupText.FirstOrDefault() != null) ? f.def_LookupText.FirstOrDefault().displayText : "zzzzz"); } IUasSql uasSql = new UasSql(); dtr.recordsTotal = dtr.recordsFiltered = detail.Count(); foreach (var d in detail.Skip(iniIndex).Take(noDsplyRecs)) { string[] data = new string[] { "<button type=\"button\" class=\"btn btn-primary btn-xs text-center\" onclick=\"window.location='/Adap/EditDetail?lookupDetailId=" + d.lookupDetailId.ToString() + "'\">Edit</button>", (formsRepo.GetLookupTextsByLookupDetail(d.lookupDetailId).FirstOrDefault() != null) ? formsRepo.GetLookupTextsByLookupDetail(d.lookupDetailId).FirstOrDefault().displayText : String.Empty, d.dataValue, (d.GroupID == null) ? "" : uasSql.getGroupName(d.GroupID.Value), d.displayOrder.ToString(), d.StatusFlag }; dtr.data.Add(data); } Debug.WriteLine("Adap Controller ClinicList data populated."); // Output the JSON in DataTable format fastJSON.JSONParameters param = new fastJSON.JSONParameters(); param.EnableAnonymousTypes = true; result = fastJSON.JSON.ToJSON(dtr, param); Debug.WriteLine("DataTable Clinic result:" + result); } catch (Exception excptn) { Debug.WriteLine("Adap Controller ClinicList exception:" + excptn.Message); result = excptn.Message + " - " + excptn.Message; } return(result); }
public string DownloadUasTables(CookieContainer cc) { // fileIds and filters // 0 - Config - All recs // 1 - Enterprise - a single record - the Enterprise of the User (from Session) // 2 and 3 - GroupTypes / Groups for the Enterprise // 4 - User - just the user logged in (from Session) IUasSql uas = new UasSql(); string msg = String.Empty; for (int i = 0; i < uas.GetNumberTables(); i++) { try { HttpWebRequest httpRequest = null; httpRequest = (HttpWebRequest)WebRequest.Create(sisOnlineURL + "Export/GetUasCsv?fileId=" + i.ToString()); httpRequest.CookieContainer = cc; httpRequest.Method = WebRequestMethods.Http.Get; // Get back the HTTP response for web server using (HttpWebResponse httpResponse = (HttpWebResponse)httpRequest.GetResponse()) { using (Stream httpResponseStream = httpResponse.GetResponseStream()) { DataTable csvData = new DataTable(); csvData.TableName = uas.GetUasTableName(i); Debug.WriteLine("DataSync DownloadUasTables CvsReader on table: " + csvData.TableName); // Debug.WriteLine(" httpResponseStream.Length: " + httpResponseStream.Length.ToString()); using (var reader = new CsvReader(httpResponseStream)) { // the CSV file has a header record, so we read that first reader.ReadHeaderRecord(); csvData.Fill(reader); } Debug.WriteLine(" cvsData Table {0} contains {1} rows.", csvData.TableName, csvData.Rows.Count); msg = csvData.Rows.Count.ToString(); csvData = RemoveNullString(csvData); Debug.WriteLine(" Modify csvData: " + csvData.TableName); if (csvData == null) { Debug.WriteLine(" uh-oh csvData is Null!!!"); } using (DbConnection connection = UasAdo.GetUasAdoConnection()) { if (csvData.TableName == "uas_Group") { SetParentGroupToSelf(ref csvData); } SetCreatedByAndModifiedByToOne(ref csvData); MarkDuplicates(ref csvData); FillDatabaseTable(csvData, connection); } } } } catch (Exception ex) { Debug.WriteLine("* * * DataSync exception: " + ex.Message); if (ex.InnerException != null && ex.InnerException.Message != null) { Debug.WriteLine("Inner exception: " + ex.InnerException.Message); } msg = ex.Message; } } return(msg); }