public IActionResult SubmitTracking(TrackingForm sub) { Guid ident = Guid.NewGuid(); string id = "'" + ident + "'"; SqlConnection cnn = new SqlConnection(connectionString); SqlCommand command; SqlDataAdapter adapter = new SqlDataAdapter(); cnn.Open(); //Again, makes me vomit. A list of every sql command needed to 😒 //insert a full tracking form into the database //Took me two weeks List <string> qs = new List <String> { "INSERT INTO dbo.demographics VALUES (" + id + ")", "INSERT INTO dbo.accomodations VALUES (" + sub.accomGained + "," + sub.compService + ",'" + filterSqlCommand(sub.ifWhatServices) + "'," + sub.addServicesGained + "," + id + ")", "INSERT INTO dbo.client VALUES ('" + filterSqlCommand(sub.clientLastName) + "','" + filterSqlCommand(sub.clientFirstName) + "','" + sub.adopted + "','" + sub.clientGender + "','" + sub.clientEthnicity + "','" + sub.clientDOB + "'," + id + ",'" + sub.carePhone + "')", "INSERT INTO dbo.advocacy VALUES (" + sub.rearrestAdvocacy + "," + sub.courtAdvocacy + "," + sub.staffAdvocacy + "," + sub.legalAdvocacy + ",'" + filterSqlCommand(sub.legalAdvoTaken) + "'," + id + ")", "INSERT INTO dbo.altSchool VALUES (" + sub.altSchool + ",'" + filterSqlCommand(sub.altSchoolName) + "','" + sub.dateOfAlt + "'," + sub.timesInAlt + "," + sub.daysOwed + "," + sub.daysSinceIntake + "," + id + ")", "INSERT INTO dbo.bully VALUES (" + sub.bullied + "," + sub.bullyReport + ",'" + sub.dateofBully + "'," + id + ")", "INSERT INTO dbo.caregiver VALUES ('" + filterSqlCommand(sub.careFirstName) + "','" + filterSqlCommand(sub.careLastName) + "','" + sub.careGender + "','" + sub.careEthnicity + "'," + "'careRelationship'" + "," + id + ")", "INSERT dbo.ccr VALUES ('" + sub.levelOfServiceProvided + "'," + sub.caseStatus + ",'" + filterSqlCommand(sub.nonEngagementReason) + "'," + sub.remedyResolution + "," + sub.rearrestWhileRepresented + ",'" + filterSqlCommand(sub.schoolAtClosure) + "'," + id + "," + sub.intakeDate + ")", "INSERT INTO dbo.comp VALUES (" + sub.compService + ",'" + filterSqlCommand(sub.ifWhatServices) + "','" + sub.compTime + "'," + id + ")", "INSERT INTO dbo.currentStatus VALUES (" + sub.readingLevel + "," + sub.mathLevel + ",'" + "currentServices?" + "'," + sub.inPride + "," + sub.newFBA + "," + 0 + ",'" + "servicesGained" + "'," + id + ")", "INSERT INTO dbo.failed VALUES (" + sub.failedGrade + "," + sub.whichGradeFailed + "," + sub.failCount + "," + id + ")", "INSERT INTO dbo.health VALUES (" + sub.baker + "," + sub.marchman + "," + sub.asthma + "," + sub.pregnantparenting + "," + id + ")", "INSERT INTO dbo.household VALUES (" + sub.femHouse + "," + sub.domVio + "," + sub.adopted + "," + sub.evicted + "," + sub.incarParent + "," + sub.publicAssistance + "," + id + ")", "INSERT INTO dbo.iep VALUES (" + sub.iep + ",'" + filterSqlCommand(sub.iepplan1) + "','" + filterSqlCommand(sub.iepplan2) + "'," + "0" + "," + id + ")", "INSERT INTO dbo.legal VALUES ('" + sub.firstLegal + "','" + filterSqlCommand(sub.secondLegal) + "','" + filterSqlCommand(sub.justiceOutcome) + "'," + id + ")", "INSERT INTO dbo.refinfo VALUES ('" + filterSqlCommand(sub.reffname) + "','" + filterSqlCommand(sub.reflname) + "','" + sub.referralDate + "'," + id + ",'" + sub.emailOfFirstReferralSource + "')", "INSERT INTO dbo.school VALUES (" + id + "," + sub.currentGrade + ",'" + filterSqlCommand(sub.school) + "','" + filterSqlCommand(sub.schoolRef) + "'," + sub.reenrolled + ")", "UPDATE refform SET assignRef = 1 WHERE clientCode = '" + sub.refCode + "';", "INSERT INTO dbo.referral VALUES ('" + sub.refCode + "'," + id + ")" }; //Um, this needs to be outside of that for some reason int totalSus = sub.iss + sub.oss; qs.Add("INSERT INTO dbo.suspension VALUES(" + sub.suspended + "," + sub.suspendCount + "," + totalSus + "," + sub.iss + "," + sub.oss + "," + 0 + "," + 0 + "," + id + ")"); //We now just run through every string in the list, running it as a sql command foreach (string query in qs) { command = new SqlCommand(query, cnn); SqlDataReader reader = command.ExecuteReader(); reader.Close(); } cnn.Close(); //TODO: Submitting the tracking form changes the related Referral form to closed (In the currStatus field) return(RedirectToAction("TrackingList")); }
public ViewResult TrackingForm(Guid clientCode) { TrackingForm newF = new TrackingForm(); var relRef = new referralBrandi(); SqlConnection cnn; cnn = new SqlConnection(connectionString); SqlCommand command; SqlDataAdapter adapter = new SqlDataAdapter(); cnn.Open(); newF.ClientID = clientCode; string query = "select * from dbo.refform where clientCode = '" + clientCode + "'"; command = new SqlCommand(query, cnn); SqlDataReader reader = command.ExecuteReader(); //I hate this. This is just vile 😒 //We are basically just putting a referral in the tracking model so we //can autopopulate values in the tracking form while (reader.Read()) { relRef.address = reader.GetString(reader.GetOrdinal("strAddress")); if (!reader.IsDBNull(reader.GetOrdinal("moreInfo"))) { relRef.moreInfo = reader.GetString(reader.GetOrdinal("moreInfo")); } if (!reader.IsDBNull(reader.GetOrdinal("arrest"))) { relRef.arrest = reader.GetInt32(reader.GetOrdinal("arrest")); } if (!reader.IsDBNull(reader.GetOrdinal("currentSchool"))) { relRef.currentSchool = reader.GetString(reader.GetOrdinal("currentSchool")); } if (!reader.IsDBNull(reader.GetOrdinal("dob"))) { relRef.dOB = reader.GetDateTime(reader.GetOrdinal("dob")); } if (!reader.IsDBNull(reader.GetOrdinal("email"))) { relRef.email = reader.GetString(reader.GetOrdinal("email")); } if (!reader.IsDBNull(reader.GetOrdinal("fname"))) { relRef.fName = reader.GetString(reader.GetOrdinal("fname")); } if (!reader.IsDBNull(reader.GetOrdinal("gender"))) { relRef.gender = reader.GetString(reader.GetOrdinal("gender")); } if (!reader.IsDBNull(reader.GetOrdinal("grade"))) { relRef.guardianEmail = reader.GetString(reader.GetOrdinal("grade")); } if (!reader.IsDBNull(reader.GetOrdinal("guardianEmail"))) { relRef.guardianEmail = reader.GetString(reader.GetOrdinal("guardianEmail")); } if (!reader.IsDBNull(reader.GetOrdinal("guardianName"))) { relRef.guardianName = reader.GetString(reader.GetOrdinal("guardianName")); } if (!reader.IsDBNull(reader.GetOrdinal("guardianPhone"))) { relRef.guardianPhone = reader.GetString(reader.GetOrdinal("guardianPhone")); } if (!reader.IsDBNull(reader.GetOrdinal("dateInput"))) { relRef.dateInput = reader.GetDateTime(reader.GetOrdinal("dateInput")); } if (!reader.IsDBNull(reader.GetOrdinal("guardianRelationship"))) { relRef.guardianRelationship = reader.GetString(reader.GetOrdinal("guardianRelationship")); } if (!reader.IsDBNull(reader.GetOrdinal("issues"))) { relRef.issues = reader.GetString(reader.GetOrdinal("issues")); } if (!reader.IsDBNull(reader.GetOrdinal("lname"))) { relRef.lName = reader.GetString(reader.GetOrdinal("lname")); } if (!reader.IsDBNull(reader.GetOrdinal("meeting"))) { relRef.meeting = reader.GetInt32(reader.GetOrdinal("meeting")); } if (!reader.IsDBNull(reader.GetOrdinal("Reach"))) { relRef.reason = reader.GetString(reader.GetOrdinal("Reach")); } if (!reader.IsDBNull(reader.GetOrdinal("reason"))) { relRef.reason = reader.GetString(reader.GetOrdinal("reason")); } if (!reader.IsDBNull(reader.GetOrdinal("referralfname"))) { relRef.referralfname = reader.GetString(reader.GetOrdinal("referralfname")); } if (!reader.IsDBNull(reader.GetOrdinal("referrallname"))) { relRef.referrallname = reader.GetString(reader.GetOrdinal("referrallname")); } if (!reader.IsDBNull(reader.GetOrdinal("school"))) { relRef.school = reader.GetString(reader.GetOrdinal("school")); } if (!reader.IsDBNull(reader.GetOrdinal("currStatus"))) { relRef.status = reader.GetString(reader.GetOrdinal("currStatus")); } if (!reader.IsDBNull(reader.GetOrdinal("youthInDuvalSchool"))) { relRef.youthInDuvalSchool = reader.GetInt32(reader.GetOrdinal("youthInDuvalSchool")); } if (!reader.IsDBNull(reader.GetOrdinal("youthInSchool"))) { relRef.youthInSchool = reader.GetInt32(reader.GetOrdinal("youthInSchool")); } if (!reader.IsDBNull(reader.GetOrdinal("zip"))) { relRef.zip = reader.GetString(reader.GetOrdinal("zip")); } } reader.Close(); cnn.Close(); //We push it into the model that gets sent to the view newF.referralBrandi = relRef; return(View(newF)); }
private async Task Search(bool isFirst) { if (Form.HasError || mIsSeaching) { return; } if (isFirst != true && mIsLoadedAllData) { return; } IsPageDataLoading = !isFirst; mIsSeaching = true; if (isFirst) { mIsLoadedAllData = false; mCacheSearchForm = Form.Clone() as TrackingForm; Logs.Clear(); } try { var jubenTypes = mCacheSearchForm.JubenTypes.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries) .Select(a => (JubenType)Enum.Parse(typeof(JubenType), a)).ToArray(); var errorTypes = mCacheSearchForm.JubenErrorTypes.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries) .Select(a => (JubenErrorType)Enum.Parse(typeof(JubenErrorType), a)).ToArray(); var rv = await Task.Run<CombinationJubenErrorLogData>(() => { return mLogService.SearchLogsByMgmt(jubenTypes, errorTypes, mCacheSearchForm.StartDate, mCacheSearchForm.EndDate, mCacheSearchForm.IsTimeRangeRequired, isFirst ? 0 : mLastId); }); foreach(var item in rv.Items) { this.Logs.Add(new UILog() { Id = item.Id, CreateTime = item.CreateTime, JubenType = item.JubenType, JubenErrorType = item.JubenErrorType, JubenName = item.JubenName, Logs = item.Logs, Xiake = item.Xiake, XiakeId = item.XiakeId }); } if (rv.Items.Count > 0) { mLastId = rv.Items[rv.Items.Count - 1].Id; } mIsLoadedAllData = rv.IsLoadedAllData; if (isFirst) { LogView.View.MoveCurrentToFirst(); TotalCount = rv.TotalCount; } } catch (Exception e) { e.Show(); } finally { mIsSeaching = false; IsPageDataLoading = false; } }