public async Task <ActionResult <Interventions> > PostInterventions(Interventions interventions)
{
_context.Interventions.Add(interventions);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetInterventions", new { id = interventions.Id }, interventions));
}
public async Task <ActionResult> CreateInterventions(InterventionModel model)
{
Interventions interv = new Interventions
{
Reports = model.Reports,
Author = model.Author,
CustomerId = model.CustomerId,
BuildingId = long.Parse(model.BuildingId),
BatteryId = long.Parse(model.BatteryId),
ColumnId = long.Parse(model.ColumnId),
ElevatorId = long.Parse(model.ElevatorId)
};
try
{
var httpClient = new HttpClient();
ServicePointManager.ServerCertificateValidationCallback = delegate { return(true); };
var response = await httpClient.PostAsync($"{url}/Interventions",
new StringContent(JsonConvert.SerializeObject(interv), Encoding.UTF8, "application/json"));
if (response.IsSuccessStatusCode)
{
return(View("SuccessMessage"));
}
}
catch (Exception e)
{
int i = 0;
}
return(View("Index"));
}
/// <summary>
/// Get a list of interventions based on it's creator
/// </summary>
/// <param name="userId">The guid of an user</param>
/// <returns>A list of intervention</returns>
public IEnumerable <Intervention> getInterventionListByCreator(Guid userId)
{
var interventions = Interventions.fetchInterventionsByCreator(userId).Select(c => new Intervention(c)).ToList();
interventions.RemoveAll(i => i.InterventionState == InterventionState.Cancelled);
return(interventions);
}
public async Task <IActionResult> PutInterventions(long id, Interventions interventions)
{
if (id != interventions.Id)
{
return(BadRequest());
}
_context.Entry(interventions).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!InterventionsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
/// <summary>
/// Approve an intervention
/// </summary>
/// <param name="interventionId">The guid of an intervention</param>
/// <returns>True if success, false if fail</returns>
public bool approveAnIntervention(Guid interventionId)
{
var intervention = getInterventionById(interventionId);
var interventionType = InterventionTypes.fetchInterventionTypesById(intervention.InterventionTypeId.Value);
var client = getClientById(intervention.ClientId.Value);
var user = getDetail();
//if meets approve criteria,approve it by engineer self and update approve by
if (client.DistrictId == user.DistrictId && user.AuthorisedHours >= intervention.Hours && user.AuthorisedCosts >= intervention.Costs && user.AuthorisedCosts >= interventionType.Costs && user.AuthorisedHours >= interventionType.Hours)
{
if (interventionService.updateInterventionState(interventionId, InterventionState.Approved, user.Id))
{
return(Interventions.ApproveIntervention(intervention));
}
else
{
return(false);
}
//return Interventions.ApproveIntervention(intervention);
}
else
{
return(false);
}
}
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
try
{
Interventions interventions = new Interventions();
Domain domain = new Domain();
int DomainIOD = domain.GetDomainOIDByDomainName(DropDownListDomain.SelectedItem.ToString());
interventions.DomainOID = DomainIOD;
//int strInterventionOID = interventions.GetInterventionOIDByInterventionName(DropDownListIntervention .SelectedItem .ToString ());
interventions.InterventionName = txtIntervention .Text;
if (DomainIOD != null && txtIntervention.Text != null&&txtIntervention.Text !="")
{
interventions.AddDomainInterventions();
Label1.Text = "Successfuly Saved";
}
else
{
Label1.Text = "Not Saved";
}
}
catch (Exception ex)
{
}
}
/// <summary>
/// Update the recent visit date of an intervention
/// </summary>
/// <param name="interventionId">The guid of an intervention</param>
/// <param name="lastVisitDate">The date update to</param>
/// <returns>True if success, false if fail</returns>
public bool updateInterventionLastVisitDate(Guid interventionId, DateTime lastVisitDate)
{
Intervention intervention = getInterventionsById(interventionId);
intervention.DateRecentVisit = lastVisitDate;
return(Interventions.update(intervention));
}
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
try
{
Interventions interventions = new Interventions();
// Domain domain = new Domain();
//int strInterventionOID = interventions.GetInterventionOIDByInterventionName(DropDownListIntervention .SelectedItem .ToString ());
// interventions.DomainName = txtIntervention.Text;
if (txtIntervention.Text != null && txtIntervention .Text!="")
{
interventions.AddDomain(txtIntervention .Text);
Label1.Text = "Successfuly Saved";
Response.Redirect("AddDomainIntervention.aspx");
}
else
{
Label1.ForeColor = Color.Red;
Label1.Text = "Not Saved !! Please Enter Domain Name ";
txtIntervention.Focus();
}
}
catch (Exception ex)
{
}
}
/// <summary>
/// Update the approve by property of an intervention
/// </summary>
/// <param name="interventionId">The guid of an intervention </param>
/// <param name="user">The user instance which updated the intervention</param>s
/// <returns></returns>
public bool updateIntervetionApprovedBy(Guid interventionId, User user)
{
Intervention intervention = getInterventionsById(interventionId);
intervention.ApprovedBy = user.Id;
return(Interventions.update(intervention));
}
public async Task <IActionResult> PostNewStudent([FromBody] Interventions student)
{
try{
if (student == null)
{
return(BadRequest());
}
;
using (var ctx = new emmanueltshibanguContext())
{
ctx.Interventions.Add(new Interventions()
{
Reports = student.Reports,
Author = student.Author,
CustomerId = student.CustomerId,
BuildingId = student.BuildingId,
BatteryId = student.BatteryId,
ColumnId = student.ColumnId,
ElevatorId = student.ElevatorId,
});
ctx.SaveChanges();
await _context.SaveChangesAsync();
}
}
catch (Exception e) {
int i = 0;
}
return(Ok());
}
private void butIntervention_Click(object sender, EventArgs e)
{
if (comboInterventionCode.SelectedIndex < 0)
{
MsgBox.Show(this, "You must select an intervention code.");
return;
}
EhrCode iCodeCur = _listInterventionCodes[comboInterventionCode.SelectedIndex];
DateTime dateCur = PIn.Date(textDateIntervention.Text);
if (iCodeCur.CodeSystem == "RXNORM" && !checkPatientDeclined.Checked) //if patient declines the medication, enter as a declined intervention
//codeVal will be RxCui of medication, see if it already exists in Medication table
{
Medication medCur = Medications.GetMedicationFromDbByRxCui(PIn.Long(iCodeCur.CodeValue));
if (medCur == null) //no med with this RxCui, create one
{
medCur = new Medication();
Medications.Insert(medCur); //so that we will have the primary key
medCur.GenericNum = medCur.MedicationNum;
medCur.RxCui = PIn.Long(iCodeCur.CodeValue);
medCur.MedName = RxNorms.GetDescByRxCui(iCodeCur.CodeValue);
Medications.Update(medCur);
Medications.RefreshCache(); //refresh cache to include new medication
}
MedicationPat medPatCur = new MedicationPat();
medPatCur.PatNum = PatCur.PatNum;
medPatCur.ProvNum = PatCur.PriProv;
medPatCur.MedicationNum = medCur.MedicationNum;
medPatCur.RxCui = medCur.RxCui;
medPatCur.DateStart = dateCur;
FormMedPat FormMP = new FormMedPat();
FormMP.MedicationPatCur = medPatCur;
FormMP.IsNew = true;
FormMP.ShowDialog();
if (FormMP.DialogResult != DialogResult.OK)
{
return;
}
if (FormMP.MedicationPatCur.DateStart.Date < dateCur.AddMonths(-6).Date || FormMP.MedicationPatCur.DateStart.Date > dateCur.Date)
{
MsgBox.Show(this, "The medication order just entered is not within the 6 months prior to the date of this intervention. You can modify the "
+ "date of the medication order in the patient's medical history section.");
}
}
else
{
Intervention iCur = new Intervention();
iCur.PatNum = PatCur.PatNum;
iCur.ProvNum = PatCur.PriProv;
iCur.DateEntry = dateCur;
iCur.CodeValue = iCodeCur.CodeValue;
iCur.CodeSystem = iCodeCur.CodeSystem;
iCur.CodeSet = InterventionCodeSet.TobaccoCessation;
iCur.IsPatDeclined = checkPatientDeclined.Checked;
Interventions.Insert(iCur);
}
comboInterventionCode.SelectedIndex = -1;
FillGridInterventions();
}
public async Task <IActionResult> ChangeInterventionStatus(long id, [FromBody] Interventions Intervention)
{
var findIntervention = await _context.Interventions.FindAsync(id);
if (Intervention == null)
{
return(BadRequest());
}
if (findIntervention == null)
{
return(NotFound());
}
if (Intervention.Status == findIntervention.Status)
{
ModelState.AddModelError("Status", "Looks like you didn't change the status.");
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
findIntervention.Status = Intervention.Status;
if (Intervention.Start_date == findIntervention.Start_date)
{
ModelState.AddModelError("Start date", "Looks like you didn't change the start date.");
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
findIntervention.Start_date = Intervention.Start_date;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!InterventionExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <Interventions> > PostIntervention(Interventions intervention)
{
intervention.created_at = DateTime.Now;
intervention.updated_at = DateTime.Now;
_context.interventions.Add(intervention);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetInterventions", new { id = intervention.Id }, intervention));
}
/// <summary>
/// Create an intervention
/// </summary>
/// <param name="intervention">An intervention instance</param>
/// <returns>An instance of Intervention created</returns>
public bool createIntervention(Intervention intervention)
{
var newIntervention = new Intervention(Interventions.create(intervention));
newIntervention.InterventionType = new InterventionType(InterventionTypes.fetchInterventionTypesById(intervention.InterventionTypeId.Value));
newIntervention.Client = new Client(Clients.fetchClientById((Guid)newIntervention.ClientId)); ///new InterventionType(InterventionTypes.fetchInterventionTypesById(intervention.InterventionTypeId.Value));
newIntervention.District = new District(Districts.fetchDistrictById(newIntervention.Client.DistrictId)); //new InterventionType(InterventionTypes.fetchInterventionTypesById(intervention.InterventionTypeId.Value));
return(approveAnIntervention(newIntervention.Id));
}
public void RemoveIntervention(InterventionDetails removedIntervention)
{
NumarInterventii -= 1;
TotalIncasari -= removedIntervention.Revenue;
TotalProcent -= removedIntervention.Percent;
Parent.TotalIncasari -= removedIntervention.LocalIntervention.Revenue;
Parent.TotalProfit -= removedIntervention.LocalIntervention.Percent;
Parent.NumarInterventii -= 1;
Interventions.Remove(removedIntervention);
}
/// <summary>
/// Update intervention quality information
/// </summary>
/// <param name="interventionId">The guid of an intervention</param>
/// <param name="comments">The comments for an intervention</param>
/// <param name="remainLife">The remaining life of an intervention</param>
/// <param name="lastVisitDate">The recent visit date of an intervention</param>
/// <returns>True if success, False if fail</returns>
public bool updateInterventionDetail(Guid interventionId, string comments, int remainLife, DateTime lastVisitDate)
{
Intervention intervention = getInterventionsById(interventionId);
intervention.Comments = comments;
intervention.LifeRemaining = remainLife;
intervention.DateRecentVisit = lastVisitDate;
return(Interventions.update(intervention));
}
public async Task <ActionResult <IEnumerable <Interventions> > > PostInterventions(Interventions intervention)
{
Interventions interventionForm = intervention;
interventionForm.Author = 1;
interventionForm.Result = "Incomplete";
interventionForm.Status = "Pending";
_context.Interventions.Add(interventionForm);
await _context.SaveChangesAsync();
return(CreatedAtAction(nameof(GetInterventions), new { id = intervention.Id }, intervention));
}
/// <summary>
/// Get an non-guid intervention form it's id
/// </summary>
/// <param name="interventionId">The guid of an intervention</param>
/// <returns>The intervention instance</returns>
public Intervention getNonGuidInterventionById(Guid interventionId)
{
Intervention intervention = new Intervention(Interventions.fetchInterventionsById(interventionId));
// intervention.LifeRemaining=
intervention.InterventionType = new InterventionType(InterventionTypes.fetchInterventionTypesById(intervention.InterventionTypeId.Value));
intervention.Client = new Client(Clients.fetchClientById(intervention.ClientId.Value));
intervention.District = new District(Districts.fetchDistrictById(intervention.Client.DistrictId));
return(intervention);
}
public static void GetInterventions(Action <ObservableCollection <Interv>, Exception> completed)
{
try
{
ObservableCollection <Interv> intervs = Interventions.GetInterv();
completed(intervs, null);
}
catch (Exception e)
{
completed(null, e);
}
}
public static void Flush(ObservableCollection <Interv> list, Action <Exception> completed)
{
try
{
Interventions.Flush(list);
completed(null);
}
catch (Exception e)
{
completed(e);
}
}
public async Task <ActionResult <Interventions> > PostIntervention(Interventions newIntervention)
{
newIntervention.StartDateIntervention = DateTime.Now;
newIntervention.UpdatedAt = DateTime.Now;
newIntervention.Status = "InProgress";
newIntervention.Result = "Incomplete";
newIntervention.EmployeeId = null;
_context.Interventions.Add(newIntervention);
await _context.SaveChangesAsync();
return(newIntervention);
}
/// <summary>
/// Update the intervention state
/// </summary>
/// <param name="interventionId">The guid of the intervention</param>
/// <param name="state">The state which update to</param>
/// <param name="userId">The user guid who update the intervention</param>
/// <returns>True if successfully updated the intervention state, false if fail</returns>
public bool updateInterventionState(Guid interventionId, InterventionState state, Guid userId)
{
if (updateInterventionState(interventionId, state))
{
var intervention = getInterventionsById(interventionId);
intervention.ApprovedBy = userId;
return(Interventions.update(intervention));
}
else
{
return(false);
}
}
public async Task <IActionResult> PostNewStudent([FromBody] Interventions student)
{
var gh = await _context.Interventions.FirstOrDefaultAsync();
gh.Reports = student.Reports;
gh.Author = student.Author;
gh.CustomerId = student.CustomerId;
gh.BuildingId = student.BuildingId;
gh.BatteryId = student.BatteryId;
gh.ColumnId = student.ColumnId;
gh.ElevatorId = student.ElevatorId;
try
{
var kp = gh;
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (1 == 1)
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
// using (var ctx = new emmanueltshibanguContext())
// {
// ctx.Interventions.Add(new Interventions()
// {
// .Reports = student.Reports,
// Author = student.Author,
// CustomerId = student.CustomerId,
// BuildingId = student.BuildingId,
// BatteryId = student.BatteryId,
// ColumnId = student.ColumnId,
// ElevatorId = student.ElevatorId,
// });
// ctx.SaveChanges();
// }
}
private void butDelete_Click(object sender, EventArgs e)
{
if (InterventionCur.IsNew)
{
DialogResult = DialogResult.Cancel;
return;
}
if (!MsgBox.Show(this, MsgBoxButtons.OKCancel, "Delete?"))
{
return;
}
Interventions.Delete(InterventionCur.InterventionNum);
DialogResult = DialogResult.Cancel;
}
/// <summary>
/// Get all the interventions for a client
/// </summary>
/// <param name="clientId">The guid of a client</param>
/// <returns>A list of interventions</returns>
public IEnumerable <Intervention> getInterventionsByClient(Guid clientId)
{
var interventions = Interventions.fetchInterventionsByClientId(clientId).Select(c => new Intervention(c)).ToList();
foreach (var intervention in interventions)
{
intervention.InterventionType = new InterventionType(InterventionTypes.fetchInterventionTypesById(intervention.InterventionTypeId.Value));
intervention.Client = new Client(Clients.fetchClientById(intervention.ClientId.Value));
intervention.District = new District(Districts.fetchDistrictById(intervention.Client.DistrictId));
}
interventions.RemoveAll(i => i.InterventionState == InterventionState.Cancelled);
return(interventions);
}
public void AddIntervention(InterventionDetails newlyAddedIntervention)
{
//SeenInterventions.Add(newlyAddedIntervention);
SelectedIntervention = newlyAddedIntervention;
Interventions.Add(newlyAddedIntervention);
NumarInterventii += 1;
TotalIncasari += newlyAddedIntervention.Revenue;
TotalProcent += newlyAddedIntervention.Percent;
if (newlyAddedIntervention.NewlyAdded && !IsSelected)
{
this.OnSelected(this);
}
// SelectedIntervention = newlyAddedIntervention;
}
/// <summary>
/// Update approve by property of an intervention
/// </summary>
/// <param name="interventionId">The guid of an intervention</param>
/// <param name="userId">The guid of an user</param>
/// <returns>True if success, false if fail</returns>
public bool updateInterventionApproveBy(Guid interventionId, Guid userId)
{
Intervention intervention = getInterventionById(interventionId);
if (intervention.CreatedBy == getDetail().Id)
{
User user = new User(Users.fetchUserById(userId));
return(Interventions.ApproveIntervention(intervention));
// return interventionService.updateIntervetionApprovedBy(interventionId, user);
}
else
{
return(false);
}
}
//Change the status of a intervention
public void ChangeStatus(string intId, string oldStatusText, string newStatusNumber)
{
intervention.InterventionId = Convert.ToInt32(intId);
var intRepo = new InterventionsRepository(context);
intervention = intRepo.GetInterventionWithInterventionId(intervention.InterventionId);
var oldStatus = (int)Enum.Parse(typeof(Status), oldStatusText);
var newStatus = Convert.ToInt32(newStatusNumber);
validateUserRole();
validateUserDistrict();
validateHoursCost();
validateOldStatus(oldStatus);
var repo = new InterventionsRepository(context);
var row = repo.UpdateInterventionStatus(intervention.InterventionId, oldStatus, newStatus);
}
public async Task <ActionResult <CustomerPortalInterventionDTO> > CreateCustomerPortalInvervention(CustomerPortalInterventionDTO customerPortalInterventionsDTO)
{
Users user = await _context.Users.Where(u => u.Email == customerPortalInterventionsDTO.CustomerEmail).SingleAsync();
if (user == null)
{
return(Unauthorized());
}
Customers customer = await _context.Customers.Where(c => c.UserId == user.Id).SingleAsync();
var intervention = new Interventions
{
CustomerId = (int)customer.Id,
AuthorId = (int)customer.Id,
BuildingId = (int)customerPortalInterventionsDTO.BuildingId,
CreatedAt = DateTime.UtcNow,
EmployeeId = 1377,
Status = "Pending"
};
if (customerPortalInterventionsDTO.BatteryId != null)
{
intervention.BatteryId = (int)customerPortalInterventionsDTO.BatteryId;
}
if (customerPortalInterventionsDTO.ColumnId != null)
{
intervention.ColumnId = (int)customerPortalInterventionsDTO.ColumnId;
}
if (customerPortalInterventionsDTO.ElevatorId != null)
{
intervention.ElevatorId = (int)customerPortalInterventionsDTO.ElevatorId;
}
if (customerPortalInterventionsDTO.Report != null)
{
intervention.Report = customerPortalInterventionsDTO.Report;
}
intervention.CustomerId = (int)customer.Id;
intervention.AuthorId = (int)customer.Id;
_context.Interventions.Add(intervention);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetInterventions", new { id = intervention.Id }, intervention));
}
public async Task <IActionResult> UpdateStatus([FromRoute] long id, Interventions current)
{
if (id != current.Id)
{
return(BadRequest());
}
if (current.Status == "Active" || current.Status == "Inactive" || current.Status == "Intervention")
{
_context.Entry(current).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(Content("Interventions: " + current.Id + ", status as been change to: " + current.Status));
}
return(Content("Please insert a valid status : Intervention, Inactive, Active, Tray again ! "));
}
/// <summary>
/// Get approved Interventions of the current Manager
/// </summary>
/// <returns>A list of Intervention with interventionType, client, district property</returns>
public IEnumerable <Intervention> GetApprovedInterventions()
{
//get intervention by state approved and complete
var interventions = Interventions.fetchInterventionsByState((int)InterventionState.Approved).Select(c => new Intervention(c)).ToList();
interventions.AddRange(Interventions.fetchInterventionsByState((int)InterventionState.Completed).Select(c => new Intervention(c)).ToList());
//only select interventions approved by this manager
interventions = interventions.Where(x => x.ApprovedBy == managerId).ToList();
foreach (var intervention in interventions)
{
intervention.InterventionType = new InterventionType(InterventionTypes.fetchInterventionTypesById(intervention.InterventionTypeId.Value));
intervention.Client = new Client(Clients.fetchClientById(intervention.ClientId.Value));
intervention.District = new District(Districts.fetchDistrictById(intervention.Client.DistrictId));
}
return(interventions);
}
/// <summary>
/// Get a list of interventions from the state they are in
/// </summary>
/// <param name="state">The state of an intervention</param>
/// <returns>A list of intervention</returns>
public IEnumerable <Intervention> GetInterventionsByState(InterventionState state)
{
var interventions = Interventions.fetchInterventionsByState((int)state).Select(c => new Intervention(c)).ToList();
List <Intervention> managerInterventions = new List <Intervention>();
User manager = GetDetail();
foreach (var intervention in interventions)
{
intervention.Client = new Client(Clients.fetchClientById(intervention.ClientId.Value));
intervention.InterventionType = new InterventionType(InterventionTypes.fetchInterventionTypesById(intervention.InterventionTypeId.Value));
intervention.District = new District(Districts.fetchDistrictById(intervention.Client.DistrictId));
if (manager.DistrictId == intervention.District.Id)
{
managerInterventions.Add(intervention);
}
}
return(managerInterventions);
}
protected void Page_Load(object sender, EventArgs e)
{
int AssessmentOID = 0;
if (!Page.IsPostBack)
{
if (Request.QueryString["poid"] != null && Request.QueryString["poid"] != "")
{
string SOID = "";
SOID = Request.QueryString["soid"];
string riskoid = Request.QueryString["riskOID"];
Interventions inter=new Interventions ();
AssessmentOID = inter.GetAssessmentOIDByPrescriptionOID(Request.QueryString["poid"]);
if (SOID != null && SOID != null)
{
//PopulateAssessment(SOID, AssessmentOID);
PopulateAssessment(AssessmentOID);
}
PrintIntervention(Convert.ToInt32(Request.QueryString["poid"]), Convert.ToInt32(riskoid), SOID, AssessmentOID);
PrintWindow();
}
}
}
public Collection<Interventions> SearchIntervention(string numberOfRows, string pageIndex, string sortColumnName, string sortOrderBy, out int totalRecords, DateTime datestamp, string bannerId, string participating, DateTime actionDate, string sponsor, string criteriaType, string outcomeType, string urgent, string Internal, string prescribed, string completed, string email, string telephone, string inPerson, string handoff, DateTime contactDate, string comment)
{
datestamp = ((datestamp == null) || (datestamp == Convert.ToDateTime("1/1/0001"))) ? Convert.ToDateTime("1/1/1900") : datestamp;
bannerId = (bannerId == null) ? "" : bannerId;
if (participating == null) participating = "-1";
else if (participating.ToLower() == "no") participating = "0";
else if (participating.ToLower() == "yes") participating = "1";
else participating = "-1";
actionDate = ((actionDate == null) || (actionDate == Convert.ToDateTime("1/1/0001"))) ? Convert.ToDateTime("1/1/1900") : actionDate;
sponsor = (sponsor == null) ? "" : sponsor;
criteriaType = (criteriaType == null) ? "" : criteriaType;
outcomeType = (outcomeType == null) ? "" : outcomeType;
if (urgent == null) urgent = "-1";
else if (urgent.ToLower() == "no") urgent = "0";
else if (urgent.ToLower() == "yes") urgent = "1";
else urgent = "-1";
if (Internal == null) Internal = "-1";
else if (Internal.ToLower() == "no") Internal = "0";
else if (Internal.ToLower() == "yes") Internal = "1";
else Internal = "-1";
if (prescribed == null) prescribed = "-1";
else if (prescribed.ToLower() == "no") prescribed = "0";
else if (prescribed.ToLower() == "yes") prescribed = "1";
else prescribed = "-1";
if (completed == null) completed = "-1";
else if (completed.ToLower() == "no") completed = "0";
else if (completed.ToLower() == "yes") completed = "1";
else completed = "-1";
if (email == null) email = "-1";
else if (email.ToLower() == "no") email = "0";
else if (email.ToLower() == "yes") email = "1";
else email = "-1";
if (telephone == null) telephone = "-1";
else if (telephone.ToLower() == "no") telephone = "0";
else if (telephone.ToLower() == "yes") telephone = "1";
else telephone = "-1";
if (inPerson == null) inPerson = "-1";
else if (inPerson.ToLower() == "no") inPerson = "0";
else if (inPerson.ToLower() == "yes") inPerson = "1";
else inPerson = "-1";
if (handoff == null) handoff = "-1";
else if (handoff.ToLower() == "no") handoff = "0";
else if (handoff.ToLower() == "yes") handoff = "1";
else handoff = "-1";
contactDate = ((contactDate == null) || (contactDate == Convert.ToDateTime("1/1/0001"))) ? Convert.ToDateTime("1/1/1900") : contactDate;
comment = (comment == null) ? "" : comment;
Collection<Interventions> invList = new Collection<Interventions>();
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
using (OdbcCommand command = new OdbcCommand())
{
command.Connection = connection;
command.CommandText = "{CALL Intervention_Search_Param(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}";
command.CommandType = CommandType.StoredProcedure;
OdbcParameter paramPageIndex = new OdbcParameter("@PageIndex", OdbcType.Int);
paramPageIndex.Value = Convert.ToInt32(pageIndex);
command.Parameters.Add(paramPageIndex);
OdbcParameter paramColumnName = new OdbcParameter("@SortColumnName", OdbcType.VarChar, 50);
paramColumnName.Value = sortColumnName;
command.Parameters.Add(paramColumnName);
OdbcParameter paramSortorderBy = new OdbcParameter("@SortOrderBy", OdbcType.VarChar, 4);
paramSortorderBy.Value = sortOrderBy;
command.Parameters.Add(paramSortorderBy);
OdbcParameter paramNumberOfRows = new OdbcParameter("@NumberOfRows", OdbcType.Int);
paramNumberOfRows.Value = Convert.ToInt32(numberOfRows);
command.Parameters.Add(paramNumberOfRows);
OdbcParameter paramTotalRecords = new OdbcParameter("@TotalRecords", OdbcType.Int);
totalRecords = 0;
paramTotalRecords.Value = totalRecords;
paramTotalRecords.Direction = ParameterDirection.Output;
command.Parameters.Add(paramTotalRecords);
OdbcParameter paramDatestamp = new OdbcParameter("@Datestamp", OdbcType.DateTime);
paramDatestamp.Value = datestamp;
command.Parameters.Add(paramDatestamp);
OdbcParameter paramBannerId = new OdbcParameter("@BannerId", OdbcType.VarChar, 12);
paramBannerId.Value = bannerId;
command.Parameters.Add(paramBannerId);
OdbcParameter paramParticipating = new OdbcParameter("@Participating", OdbcType.Int);
paramParticipating.Value = Convert.ToInt32(participating);
command.Parameters.Add(paramParticipating);
OdbcParameter paramActionDate = new OdbcParameter("@ActionDate", OdbcType.DateTime);
paramActionDate.Value = actionDate;
command.Parameters.Add(paramActionDate);
OdbcParameter paramSponsor = new OdbcParameter("@Sponsor", OdbcType.VarChar, 12);
paramSponsor.Value = sponsor;
command.Parameters.Add(paramSponsor);
OdbcParameter paramCriteriaType = new OdbcParameter("@CriteriaType", OdbcType.VarChar, 12);
paramCriteriaType.Value = criteriaType;
command.Parameters.Add(paramCriteriaType);
OdbcParameter paramOutcomeType = new OdbcParameter("@OutcomeType", OdbcType.VarChar, 12);
paramOutcomeType.Value = outcomeType;
command.Parameters.Add(paramOutcomeType);
OdbcParameter paramUrgent = new OdbcParameter("@Urgent", OdbcType.Int);
paramUrgent.Value = Convert.ToInt32(urgent);
command.Parameters.Add(paramUrgent);
OdbcParameter paramInternal = new OdbcParameter("@Internal", OdbcType.Int);
paramInternal.Value = Convert.ToInt32(Internal);
command.Parameters.Add(paramInternal);
OdbcParameter paramPrescribed = new OdbcParameter("@Prescribed", OdbcType.Int);
paramPrescribed.Value = Convert.ToInt32(prescribed);
command.Parameters.Add(paramPrescribed);
OdbcParameter paramCompleted = new OdbcParameter("@Completed", OdbcType.Int);
paramCompleted.Value = Convert.ToInt32(completed);
command.Parameters.Add(paramCompleted);
OdbcParameter paramEmail = new OdbcParameter("@Email", OdbcType.Int);
paramEmail.Value = Convert.ToInt32(email);
command.Parameters.Add(paramEmail);
OdbcParameter paramTelephone = new OdbcParameter("@Telephone", OdbcType.Int);
paramTelephone.Value = Convert.ToInt32(telephone);
command.Parameters.Add(paramTelephone);
OdbcParameter paramInPerson = new OdbcParameter("@InPerson", OdbcType.Int);
paramInPerson.Value = Convert.ToInt32(inPerson);
command.Parameters.Add(paramInPerson);
OdbcParameter paramHandoff = new OdbcParameter("@Handoff", OdbcType.Int);
paramHandoff.Value = Convert.ToInt32(handoff);
command.Parameters.Add(paramHandoff);
OdbcParameter paramContactDate = new OdbcParameter("@ContactDate", OdbcType.DateTime);
paramContactDate.Value = contactDate;
command.Parameters.Add(paramContactDate);
OdbcParameter paramComment = new OdbcParameter("@Comment", OdbcType.VarChar, 100);
paramComment.Value = comment;
command.Parameters.Add(paramComment);
connection.Open();
using (OdbcDataReader dataReader = command.ExecuteReader())
{
Interventions u;
while (dataReader.Read())
{
u = new Interventions();
u.PrescriptionOID = (int)dataReader["PrescriptionOID"];
u.StudentOID = (int)dataReader["StudentOID"];
u.UserOID = (int)dataReader["UserOID"];
u.UserName = (string)dataReader["UserName"];
u.DomainOID = (int)dataReader["DomainOID"];
u.DomainName = (string)dataReader["DomainName"];
u.InterventionOID = (int)dataReader["InterventionOID"];
u.InterventionName = (string)dataReader["InterventionName"];
if (dataReader["LatestActionDate"] != null)
{
u.LatestActionDate = Convert.ToDateTime(dataReader["LatestActionDate"]).ToShortDateString();
}
if (dataReader["LatestContact"] != null)
{
u.LatestContact = Convert.ToDateTime(dataReader["LatestContact"]).ToShortDateString();
}
u.Internal = (int)dataReader["Internal"];
u.Prescribed = (int)dataReader["Prescribed"];
u.Completed = (int)dataReader["Completed"];
u.Email = (int)dataReader["Email"];
u.Telephone = (int)dataReader["Telephone"];
u.InPerson = (int)dataReader["InPerson"];
u.HandOff = (int)dataReader["HandOff"];
if (dataReader["CreatedDate"] != null)
{
u.CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]).ToShortDateString();
}
u.CreatedBy = (int)dataReader["CreatedBy"];
if (dataReader["LastModifiedDate"] != null)
{
u.LastModifiedDate = Convert.ToDateTime(dataReader["LastModifiedDate"]).ToShortDateString();
}
u.LastModifiedBy = (int)dataReader["LastModifiedBy"];
u.Comment = (string)dataReader["Comment"];
if (dataReader["BannerID"] != DBNull.Value || dataReader["BannerID"] != null || dataReader["BannerID"] != "")
{
u.BannerID = Convert.ToString(dataReader["BannerID"]);
}
if (dataReader["BannerStudentName"] != DBNull.Value || dataReader["BannerStudentName"] != null || dataReader["BannerStudentName"] != "")
{
u.StudentName = Convert.ToString(dataReader["BannerStudentName"]);
}
invList.Add(u);
}
}
totalRecords = (int)paramTotalRecords.Value;
}
}
return invList;
}
public Collection<Interventions> GetInterventionByStudentOID(int SOID, string pageIndex, string numberOfRows,int UserOID)
{
//Interventions u = null;
Collection<Interventions> invList = new Collection<Interventions>();
// string connectionString = @"Data Source=.\SQLEXPRESS; Initial Catalog=cvtc; User ID=cvtcuser; Password=cvtcuser";
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
using (OdbcCommand command = new OdbcCommand())
{
command.Connection = connection;
command.CommandText = "{CALL Intervations_ByStudentOID(?,?,?)}";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@SOID", SOID);
OdbcParameter paramPageIndex = new OdbcParameter("@PageIndex", OdbcType.Int);
paramPageIndex.Value = Convert.ToInt32(pageIndex);
command.Parameters.Add(paramPageIndex);
OdbcParameter paramNumberOfRows = new OdbcParameter("@NumberOfRows", OdbcType.Int);
paramNumberOfRows.Value = Convert.ToInt32(numberOfRows);
command.Parameters.Add(paramNumberOfRows);
connection.Open();
using (OdbcDataReader dataReader = command.ExecuteReader())
{
Interventions u;
while (dataReader.Read())
{
u = new Interventions();
u.PrescriptionOID = (int)dataReader["PrescriptionOID"];
u.StudentOID = (int)dataReader["StudentOID"];
u.UserOID = (int)dataReader["UserOID"];
u.UserName = (string )dataReader["UserName"];
u.DomainOID = (int)dataReader["DomainOID"];
u.DomainName = (string)dataReader["DomainName"];
u.InterventionOID = (int)dataReader["InterventionOID"];
u.InterventionName = (string )dataReader["InterventionName"];
u.Participating = (int)dataReader["Participating"];
if (dataReader["LatestActionDate"] != null)
{
u.LatestActionDate = Convert.ToDateTime(dataReader["LatestActionDate"]).ToShortDateString();
}
if (dataReader["LatestContact"] != null)
{
u.LatestContact = Convert.ToDateTime(dataReader["LatestContact"]).ToShortDateString();
}
u.Internal = (int)dataReader["Internal"];
u.Prescribed = (int)dataReader["Prescribed"];
u.Completed = (int)dataReader["Completed"];
u.Email = (int)dataReader["Email"];
u.Telephone = (int)dataReader["Telephone"];
u.InPerson = (int)dataReader["InPerson"];
u.HandOff = (int)dataReader["HandOff"];
if (dataReader["CreatedDate"] != null)
{
u.CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]).ToShortDateString();
}
u.CreatedBy = (int)dataReader["CreatedBy"];
if (dataReader["LastModifiedDate"] != null)
{
u.LastModifiedDate = Convert.ToDateTime(dataReader["LastModifiedDate"]).ToShortDateString();
}
u.LastModifiedBy = (int)dataReader["LastModifiedBy"];
u.Comment = (string)dataReader["Comment"];
u.BannerID = (string)dataReader["BannerID"];
u.PrescribedULR = (u.Prescribed == 1) ? "~/images/Actions-dialog-ok-icon.png" : "~/images/X-Au-Blu-icon.png";
u.CompletedURL = (u.Completed == 1) ? "~/images/Actions-dialog-ok-icon.png" : "~/images/X-Au-Blu-icon.png";
u.HandOffURL = (u.HandOff == 1) ? "~/images/Actions-dialog-ok-icon.png" : "~/images/X-Au-Blu-icon.png";
u.EmailURL = (u.Email == 1) ? "~/images/Actions-dialog-ok-icon.png" : "~/images/X-Au-Blu-icon.png";
u.TelephoneURL = (u.Telephone == 1) ? "~/images/Actions-dialog-ok-icon.png" : "~/images/X-Au-Blu-icon.png";
u.InPersonURL = (u.InPerson == 1) ? "~/images/Actions-dialog-ok-icon.png" : "~/images/X-Au-Blu-icon.png";
u.ParticipatingURL = (u.Participating == 1) ? "~/images/Actions-dialog-ok-icon.png" : "~/images/X-Au-Blu-icon.png";
u.Unread =dataReader ["Unread"].ToString ();
if (u.HandOff == 1 && !CheckUser(u.PrescriptionOID ,UserOID ))
{
u.FlagURL = "~/images/flag.png";
}
else if (u.HandOff == 0 && !CheckUser(u.PrescriptionOID, UserOID))
{
u.FlagURL = "~/images/flag.png";
}
else
{
u.FlagURL = "~/images/blank.png";
}
//u.PrescribedULR = (u.Prescribed == 1) ? "~/images/Actions-dialog-ok-icon.pngs" : "~/images/X-Au-Blu-icon.png";
//u.PrescribedULR = (u.Prescribed == 1) ? "~/images/Actions-dialog-ok-icon.pngs" : "~/images/X-Au-Blu-icon.png";
invList.Add(u );
}
}
}
}
return invList;
}
private void Initialize()
{
try
{
int roid = Convert.ToInt32(ViewState["riskOID"].ToString());
Interventions interventions = new Interventions();
interventions = interventions.GetInterventionByRiskOID(roid);
if (interventions != null)
{
CheckBoxListLeft.Items[0].Selected = (interventions.Urgent == 1) ? true : false;
CheckBoxListLeft.Items[1].Selected = (interventions.Internal == 1) ? true : false;
CheckBoxListLeft.Items[2].Selected = (interventions.Prescribed == 1) ? true : false;
CheckBoxListLeft.Items[3].Selected = (interventions.Participating == 1) ? true : false;
CheckBoxListLeft.Items[4].Selected = (interventions.Completed == 1) ? true : false;
//Right CheckboxList
CheckBoxListRight.Items[0].Selected = (interventions.Email == 1) ? true : false;
CheckBoxListRight.Items[1].Selected = (interventions.Telephone == 1) ? true : false;
CheckBoxListRight.Items[2].Selected = (interventions.InPerson == 1) ? true : false;
CheckBoxListRight.Items[3].Selected = (interventions.HandOff == 1) ? true : false;
CheckBoxTesting.Checked = (interventions.Testing == 1) ? true : false;
TextBoxContactNotes.Text=interventions.Comment ;
TextBoxLatestAction.Value = interventions.LatestActionDate.ToString();
TextBoxLatestContact.Value = interventions.LatestContact.ToString();
DropDownListDomain.Text=interventions.DomainName;
DropDownListIntervention.Text = interventions.InterventionName;
DropDownListAdvocate.Text = interventions.UserName;
}
}
catch (Exception ex)
{ }
}
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
try
{
if((string.IsNullOrEmpty(TextBoxLatestAction.Value)) || (string.IsNullOrEmpty(TextBoxLatestContact.Value)))
{
LabelStatus.Text = "Please Enter Action and Contact Date";
return;
}
int studentid = 0;
bool isNew = false;
int roid = Convert.ToInt32(ViewState["riskOID"].ToString());
RiskCalculation rcal = new RiskCalculation();
Interventions interventions = new Interventions();
interventions = interventions.GetInterventionByRiskOID(roid);
rcal = rcal.GetAssessmentOIDByRiskOID(roid);
if (interventions == null)
{
isNew = true;
interventions = new Interventions();
}
int aoid = rcal.AssessmentOID;
interventions.AssessmentOID = aoid;
int strInterventionOID = interventions.GetInterventionOIDByInterventionName(DropDownListIntervention.SelectedItem.ToString());
interventions.InterventionOID = strInterventionOID;
Domain domain = new Domain();
int DomainIOD = domain.GetDomainOIDByDomainName(DropDownListDomain.SelectedItem.ToString());
interventions.DomainOID = DomainIOD;
User user = new User();
int UserIOD = user.GetUserOIDByUserName(DropDownListAdvocate.SelectedItem.ToString());
//int UserIOD = 1;
interventions.UserOID = UserIOD;
interventions.RiskOID = roid;
//Student student = new Student();
//int StudentOID = student.GetStudentOIDByStudentBannerID(studentid);
interventions.StudentOID = studentid;
interventions.LatestActionDate = TextBoxLatestAction.Value.ToString();
interventions.LatestContact = TextBoxLatestContact.Value.ToString();
interventions.CreatedBy = (Session["CurrentUser"] != null) ? ((User)Session["CurrentUser"]).UserOID : 0;
if (CheckBoxListLeft.Items[0].Selected)
{
interventions.Urgent = 1;
}
else
{
interventions.Urgent = 0;
}
if (CheckBoxListLeft.Items[1].Selected)
{
interventions.Internal = 1;
}
else
{
interventions.Internal = 0;
}
if (CheckBoxListLeft.Items[2].Selected)
{
interventions.Prescribed = 1;
}
else
{
interventions.Prescribed = 0;
}
if (CheckBoxListLeft.Items[3].Selected)
{
interventions.Participating = 1;
}
else
{
interventions.Participating = 0;
}
if (CheckBoxListLeft.Items[4].Selected)
{
interventions.Completed = 1;
}
else
{
interventions.Completed = 0;
}
if (CheckBoxListRight.Items[0].Selected)
{
interventions.Email = 1;
}
else
{
interventions.Email = 0;
}
if (CheckBoxListRight.Items[1].Selected)
{
interventions.Telephone = 1;
}
else
{
interventions.Telephone = 0;
}
if (CheckBoxListRight.Items[2].Selected)
{
interventions.InPerson = 1;
}
else
{
interventions.InPerson = 0;
}
if (CheckBoxListRight.Items[3].Selected)
{
interventions.HandOff = 1;
}
else
{
interventions.HandOff = 0;
}
if (CheckBoxTesting.Checked == true)
{
interventions.Testing = 1;
}
else
{
interventions.Testing = 0;
}
interventions.Comment = TextBoxContactNotes.Text.Trim();
if (isNew)
{
if (interventions.AddInterventions() > 0)
{
LabelStatus.Text = "Saved Successfully.";
}
else
{
LabelStatus.Text = "Save Failed.";
}
}
else
{
if (interventions.UpdateInterventions())
{
LabelStatus.Text = "Update Successfully.";
}
else
{
LabelStatus.Text = "Update Failed.";
}
}
}
catch (Exception ex)
{
LabelStatus.Text = "Not Saved";
}
}
public Interventions GetInterventionByRiskOID(int ROID)
{
Interventions intervention = null;
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
using (OdbcCommand command = new OdbcCommand())
{
command.Connection = connection;
command.CommandText = "{CALL Prescription_GetByRiskOID(?)}";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@roid", ROID);
connection.Open();
using (OdbcDataReader dataReader = command.ExecuteReader())
{
if (dataReader.Read())
{
intervention = new Interventions();
intervention.PrescriptionOID = (int)dataReader["PrescriptionOID"];
intervention.RiskOID = (int)dataReader["RiskOID"];
intervention.StudentOID = (int)dataReader["StudentOID"];
intervention.UserOID = (int)dataReader["UserOID"];
intervention.UserName = (string)dataReader["UserName"];
intervention.Comment = (string)dataReader["Comment"];
intervention.DomainOID = (int)dataReader["DomainOID"];
intervention.DomainName = (string)dataReader["DomainName"];
intervention.InterventionOID = (int)dataReader["InterventionOID"];
intervention.InterventionName = (string)dataReader["InterventionName"];
if (dataReader["LatestActionDate"] != null)
{
intervention.LatestActionDate = Convert.ToDateTime(dataReader["LatestActionDate"]).ToShortDateString();
}
if (dataReader["LatestContact"] != null)
{
intervention.LatestContact = Convert.ToDateTime(dataReader["LatestContact"]).ToShortDateString();
}
intervention.Urgent = (int)dataReader["Urgent"];
intervention.Participating = (int)dataReader["Participating"];
intervention.Testing = (int)dataReader["Testing"];
intervention.Internal = (int)dataReader["Internal"];
intervention.Prescribed = (int)dataReader["Prescribed"];
intervention.Completed = (int)dataReader["Completed"];
intervention.Email = (int)dataReader["Email"];
intervention.Telephone = (int)dataReader["Telephone"];
intervention.InPerson = (int)dataReader["InPerson"];
intervention.HandOff = (int)dataReader["HandOff"];
if (dataReader["CreatedDate"] != null)
{
intervention.CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]).ToShortDateString();
}
intervention.CreatedBy = (int)dataReader["CreatedBy"];
if (dataReader["LastModifiedDate"] != null)
{
intervention.LastModifiedDate = Convert.ToDateTime(dataReader["LastModifiedDate"]).ToShortDateString();
}
intervention.LastModifiedBy = (int)dataReader["LastModifiedBy"];
}
}
}
}
return intervention;
}
public Collection<Interventions> GetInterventionByDomainName(string DomainName)
{
//Collection<Student> studentList = new Collection<Student>();
//Student student = null;
Collection<Interventions> invList = new Collection<Interventions>();
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
using (OdbcCommand command = new OdbcCommand())
{
command.Connection = connection;
command.CommandText = "{CALL Intervention_ByDomainName(?)}";
command.CommandType = CommandType.StoredProcedure;
//Set Parameter Value
command.Parameters.AddWithValue("@Name", DomainName);
//Open connection
connection.Open();
//Read using reader
using (OdbcDataReader dataReader = command.ExecuteReader())
{
Interventions u;
//Question q = new Question();
//dataReader.Read();
invList.Clear();
while (dataReader.Read())
{
//student = new Student();
u = new Interventions();
u.InterventionName = Convert.ToString(dataReader["InterventionName"]);
invList.Add(u);
}
}
}
}
return invList;
}
private void Initialize( int POID)
{
try
{
Interventions inter = new Interventions();
inter=inter.GetInterventionByOID(POID);
if (inter != null)
{
TextBoxContactNotes.Text = inter.Comment;
if (inter.Urgent == 1) CheckBoxListLeft.Items[0].Selected = true;
if (inter.Internal == 1) CheckBoxListLeft.Items[1].Selected = true;
if (inter.Prescribed == 1) CheckBoxListLeft.Items[2].Selected = true;
if (inter.Participating == 1) CheckBoxListLeft.Items[3].Selected = true;
if (inter.Completed == 1) CheckBoxListLeft.Items[4].Selected = true;
if (inter.Email == 1) CheckBoxListRight.Items[0].Selected = true;
if (inter.Telephone == 1) CheckBoxListRight.Items[1].Selected = true;
if (inter.InPerson == 1) CheckBoxListRight.Items[2].Selected = true;
if (inter.HandOff == 1) CheckBoxListRight.Items[3].Selected = true;
if (inter.Testing == 1) CheckBoxTesting.Checked = true;
//DropDownListDomain.Text = inter.DomainName;
//DropDownListDomain.DataValueField = inter.DomainName;
DropDownListDomain.Items.Add(inter.DomainName);
Assessment assment = new Assessment();
assment = assment.GetAssessmentByOID(inter.AssessmentOID);
if (assment != null)
{
ddlAssessment.Items.Add(assment.AssessmentName);
}
//DropDownListDomain.selectedte = inter.DomainName;
//DropDownListIntervention.Text = inter.InterventionName;
//DropDownListIntervention.DataValueField = inter.InterventionName;
DropDownListIntervention.Items.Add(inter.InterventionName);
//DropDownListIntervention.SelectedItem = inter.InterventionName;
//DropDownListAdvocate.SelectedItem = inter.UserName;
DropDownListAdvocate.Text = inter.UserName;
TextBoxLatestAction.Value = inter.LatestActionDate;
TextBoxLatestContact.Value = inter.LatestContact;
ViewState["studentID"] = inter.StudentOID;
}
}
catch(Exception ex)
{
}
}
private void PopulateGridIntervention(int RISKOID)
{
int UserOID = 0;
User user = new User();
user = Session["CurrentUser"] as User;
if (user != null)
{
UserOID = user.UserOID;
}
Interventions inv = null;// new Interventions();
Student stu = new Student();
Collection<Interventions> IntListStd = new Collection<Interventions>();
Collection<Interventions> IntListRisk = new Collection<Interventions>();
int i = stu.GetStudentOIDByStudentBannerID(lblID.Text.ToString());
if (i > 0)
{
inv = new Interventions();
IntListStd = inv.GetInterventionByStudentOID(i, "1", "10", UserOID);
//GridViewIntervention.DataSource = inv.GetInterventionByStudentOID(i, "1", "10");
}
if (RISKOID > 0)
{
inv = new Interventions();
inv = inv.GetInterventionByRiskOID(RISKOID, lblID.Text.ToString(), "1", "10", UserOID);
if (inv != null)
{
IntListStd.Add(inv);
}
}
GridViewIntervention.DataSource = IntListStd;
GridViewIntervention.DataBind();
}
private void PrintInterventionAll(int SOID)
{
try
{
string html = "";
Interventions inter = new Interventions();
Collection<Interventions> _list = new Collection<Interventions>();
_list = inter.GetInterventionByStudentOID(SOID);
//if (inter != null)
if (_list.Count != 0)
{
foreach (Interventions iv in _list)
{
Student stdnt = new Student();
// stdnt = stdnt.GetStudentByOID(inter.StudentOID);
stdnt = stdnt.GetStudentByOID(SOID);
if (stdnt != null)
{
//Create Html
html += "<table width='100%' ><tr><td><img alt='Logo' src='../../images/chippewavtc_logo.jpg' /></td><td style='text-align:center;'><span style='font-size:medium;font-weight:bold;'> Steps to Success: CVTC's commitment to helping YOU succeed!</span><br/><span style='text-align:center;'> Inventory of Student Success: Personalized Success Plan </span></td></tr></table>";
html += "<table width='100%'><tr><td style='width:45%;'>Success Steps For:<br />First:" + stdnt.FirstName + " Last: " + stdnt.LastName + "</td><td> <div style='background-color: #C0C0C0;float:left;width:20%;'>Program </div><div style='padding-left:10px;border:solid 1px black;width:75%; float:left;'>" + stdnt.MajorProgramEnrollment + "</div></td></tr></table>";
// html += "<table width='100%'><tr><td>Success Steps For:<br />First: Abdul Last: Karim</td><td> <div style=' background-color: #C0C0C0;float:left;width:20%; '>Program </div><div style='padding-left:10px;border:solid 1px black;width:78%; float:left;'>Information Technology </div></td></tr></table>";
html += "<table width='100%'><tr><td style='border:solid 1px black;'>Inventory of Student Success results provide comparsions of your attitudes and confidence with other<br /> entering CVTC students in key focus areas that could affect your academic performance and program<br /> persistance: </td></tr></table>";
html += "<table style='width: 100%;'>";
//Get Sectionwise Student Rank
StudentRank studentRank = new StudentRank();
//Collection<StudentRank> srLIST = studentRank.GetStudentRankBySOIDandAOID(SOID,22);
Collection<StudentRank> srLIST = studentRank.GetStudentRankByOID(SOID);
//if
//for (int i = 0; i < 5; i++)
foreach (StudentRank stRank in srLIST)
{
html += "<tr>";
html += "<td style='border:solid 1px black;background-color:#727272;width:200px;'>" + stRank.SectionName + "</td>";
html += "<td style='border:solid 1px black;width:50px;text-align:center;'>" + stRank.Rank.ToString() + "</td>";
html += "<td style='border:solid 1px black;'>" + stRank.Comment + "</td>";
html += "</tr>";
}
html += "</table>";
html += "<table style='width: 100%; border:solid 1px black;'> <tr > <td>COMPASS test scores measure your academic readiness for college coursework in four broad areas:</td> </tr> </table>";
html += " <table style='width: 60%; '> <tr><td style='background-color:#727272;width:200px;'>COMPASS Pre-Algebra</td><td style='width:100px; border:solid 1px black;'>" + stdnt.PrealgebraTestScore + "</td><td style='background-color:#727272;width:200px;'>COMPASS Writing</td><td style='width:100px; border:solid 1px black;'>" + stdnt.CompassWrittingTestScore + "</td></tr> <tr><td style='background-color:#727272;width:200px;'>COMPASS Algebra</td><td style='width:100px; border:solid 1px black;'>" + stdnt.CompassalgebraTestScore + "</td><td style='background-color:#727272;width:200px;'>COMPASS Reading</td><td style='width:100px; border:solid 1px black;'>" + stdnt.CompassReadingTestScore + "</td></tr> </table>";
html += "<br/>";
//Last Part Intervention
html += "<table style='width: 100%; '>";
html += "<tr><td style='width:60px;font-size:medium;font-weight:bold;'>Step 1</td><td style='background-color:#727272;width:100px;'> Plan Target</td><td>" + inter.DomainName + "</td><td></td></tr>";
html += "<tr><td > </td><td style='background-color:#727272;width:100px;'> Intervention</td><td>" + inter.InterventionName + "</td><td></td></tr>";
html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:150px;'>CVTC Advocate </td><td>" + inter.UserName + "</td></tr>";
html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:100px;'>Action Date </td><td>" + inter.LatestActionDate;
html += " Prescribed ";
if (inter.Prescribed == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
html += " Participating ";
if (inter.Participating == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
html += " Internal ";
if (inter.Internal == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
html += " Urgent ";
if (inter.Urgent == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
html += " Completed ";
if (inter.Completed == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
html += "</td></tr>";
html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:100px;'>Contact Date </td><td>" + inter.LatestContact;
html += " Email ";
if (inter.Email == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
html += " Telephone ";
if (inter.Telephone == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
html += " In Person ";
if (inter.InPerson == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
html += " Hand-Off ";
if (inter.HandOff == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
html += " Testing ";
if (inter.Testing == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
html += "</td></tr>";
html += "</table>";
}
}
html += "<script type =\"text/javascript\">";
html += "printDiv();";
html += "</script>";
print_div1.InnerHtml = html;
}
}
catch (Exception ex)
{ }
}
public Collection<Interventions> GetAllIntervention(string numberOfRows, string pageIndex, string sortColumnName, string sortOrderBy, out int totalRecords)
{
//Interventions u = null;
Collection<Interventions> invList = new Collection<Interventions>();
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
using (OdbcCommand command = new OdbcCommand())
{
command.Connection = connection;
command.CommandText = "{CALL Intervention_Search(?,?,?,?,?)}";
command.CommandType = CommandType.StoredProcedure;
OdbcParameter paramPageIndex = new OdbcParameter("@PageIndex", OdbcType.Int);
paramPageIndex.Value = Convert.ToInt32(pageIndex);
command.Parameters.Add(paramPageIndex);
OdbcParameter paramColumnName = new OdbcParameter("@SortColumnName", OdbcType.VarChar, 50);
paramColumnName.Value = sortColumnName;
command.Parameters.Add(paramColumnName);
OdbcParameter paramSortorderBy = new OdbcParameter("@SortOrderBy", OdbcType.VarChar, 4);
paramSortorderBy.Value = sortOrderBy;
command.Parameters.Add(paramSortorderBy);
OdbcParameter paramNumberOfRows = new OdbcParameter("@NumberOfRows", OdbcType.Int);
paramNumberOfRows.Value = Convert.ToInt32(numberOfRows);
command.Parameters.Add(paramNumberOfRows);
OdbcParameter paramTotalRecords = new OdbcParameter("@TotalRecords", OdbcType.Int);
totalRecords = 0;
paramTotalRecords.Value = totalRecords;
paramTotalRecords.Direction = ParameterDirection.Output;
command.Parameters.Add(paramTotalRecords);
connection.Open();
using (OdbcDataReader dataReader = command.ExecuteReader())
{
Interventions u;
while (dataReader.Read())
{
u = new Interventions();
u.PrescriptionOID = (int)dataReader["PrescriptionOID"];
u.StudentOID = (int)dataReader["StudentOID"];
u.UserOID = (int)dataReader["UserOID"];
u.UserName = (string)dataReader["UserName"];
u.DomainOID = (int)dataReader["DomainOID"];
u.DomainName = (string)dataReader["DomainName"];
u.InterventionOID = (int)dataReader["InterventionOID"];
u.InterventionName = (string)dataReader["InterventionName"];
if (dataReader["LatestActionDate"] != null)
{
u.LatestActionDate = Convert.ToDateTime(dataReader["LatestActionDate"]).ToShortDateString();
}
if (dataReader["LatestContact"] != null)
{
u.LatestContact = Convert.ToDateTime(dataReader["LatestContact"]).ToShortDateString();
}
u.Internal = (int)dataReader["Internal"];
u.Prescribed = (int)dataReader["Prescribed"];
u.Completed = (int)dataReader["Completed"];
u.Email = (int)dataReader["Email"];
u.Telephone = (int)dataReader["Telephone"];
u.InPerson = (int)dataReader["InPerson"];
u.HandOff = (int)dataReader["HandOff"];
if (dataReader["CreatedDate"] != null)
{
u.CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]).ToShortDateString();
}
u.CreatedBy = (int)dataReader["CreatedBy"];
if (dataReader["LastModifiedDate"] != null)
{
u.LastModifiedDate = Convert.ToDateTime(dataReader["LastModifiedDate"]).ToShortDateString();
}
u.LastModifiedBy = (int)dataReader["LastModifiedBy"];
if (dataReader["Comment"] != DBNull.Value || dataReader["Comment"] != null || dataReader["Comment"] != "")
{
u.Comment = (string)dataReader["Comment"];
}
if (dataReader["BannerID"] != DBNull.Value || dataReader["BannerID"] != null || dataReader["BannerID"] != "")
{
u.BannerID = Convert .ToString (dataReader["BannerID"]);
}
if (dataReader["BannerStudentName"] != DBNull.Value || dataReader["BannerStudentName"] != null || dataReader["BannerStudentName"] != "")
{
u.StudentName = Convert.ToString(dataReader["BannerStudentName"]);
}
invList.Add(u);
}
}
totalRecords = (int)paramTotalRecords.Value;
}
}
return invList;
}
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
try
{
if ((string.IsNullOrEmpty(TextBoxLatestAction.Value)) || (string.IsNullOrEmpty(TextBoxLatestContact.Value)))
{
LabelStatus.Text = "Please Enter Action and Contact Date";
return;
}
Interventions interventions = new Interventions();
//Changed by Babul 20111103
//int strInterventionOID = interventions.GetInterventionOIDByInterventionName(DropDownListIntervention.SelectedItem.ToString());
int strInterventionOID = 0;
if (DropDownListIntervention.SelectedIndex == -1)
{
strInterventionOID = 1;
}
else
{
strInterventionOID = interventions.GetInterventionOIDByInterventionName(DropDownListIntervention.SelectedItem.ToString());
}
//
interventions.InterventionOID = strInterventionOID;
Domain domain=new Domain ();
int DomainIOD = domain.GetDomainOIDByDomainName(DropDownListDomain.SelectedItem.ToString());
interventions.DomainOID = DomainIOD;
User user = new User();
int UserIOD = user.GetUserOIDByUserName(DropDownListAdvocate.SelectedItem.ToString());
interventions.UserOID = UserIOD;
if (ViewState["POID"] == null)
{
studentid = Session["StudentID"].ToString();
Student student = new Student();
int StudentOID = student.GetStudentOIDByStudentBannerID(studentid);
interventions.StudentOID = StudentOID;
ViewState["studentID"]=studentid;
}
else
{
interventions.StudentOID = Convert.ToInt32(ViewState["studentID"]);
}
//interventions.LatestActionDate = TextBoxLatestAction.Text.ToString();
//interventions.LatestContact = TextBoxLatestContact.Text.ToString();
interventions.LatestActionDate = TextBoxLatestAction.Value.ToString();
interventions.LatestContact = TextBoxLatestContact.Value.ToString();
interventions.CreatedBy = (Session["CurrentUser"] != null) ? ((User)Session["CurrentUser"]).UserOID : 0;
if (CheckBoxListLeft.Items[0].Selected)
{
interventions.Urgent = 1;
}
else
{
interventions.Urgent = 0;
}
if (CheckBoxListLeft.Items[1].Selected)
{
interventions.Internal = 1;
}
else
{
interventions.Internal = 0;
}
if (CheckBoxListLeft.Items[2].Selected)
{
interventions.Prescribed = 1;
}
else
{
interventions.Prescribed = 0;
}
if (CheckBoxListLeft.Items[3].Selected)
{
interventions.Participating = 1;
}
else
{
interventions.Participating = 0;
}
if (CheckBoxListLeft.Items[4].Selected)
{
interventions.Completed = 1;
}
else
{
interventions.Completed = 0;
}
if (CheckBoxListRight.Items[0].Selected)
{
interventions.Email = 1;
}
else
{
interventions.Email = 0;
}
if (CheckBoxListRight.Items[1].Selected)
{
interventions.Telephone = 1;
}
else
{
interventions.Telephone = 0;
}
if (CheckBoxListRight.Items[2].Selected)
{
interventions.InPerson = 1;
}
else
{
interventions.InPerson = 0;
}
if (CheckBoxListRight.Items[3].Selected)
{
interventions.HandOff = 1;
}
else
{
interventions.HandOff = 0;
}
if (CheckBoxTesting.Checked == true)
{
interventions.Testing = 1;
}
else
{
interventions.Testing = 0;
}
interventions.Comment = TextBoxContactNotes.Text.Trim();
interventions.RiskOID = 0;
Assessment assment=new Assessment ();
interventions.AssessmentOID = assment.GetAssessmentOIDByAssessmentName(ddlAssessment.SelectedItem.Text);
if (ViewState["POID"] == null)
{
if (interventions.AddInterventions() > 0)
{
LabelStatus.Text = "Saved Successfully.";
}
else
{
LabelStatus.Text = "Save Failed.";
}
ViewState["POID"] = interventions.PrescriptionOID;
}
else
{
interventions.PrescriptionOID=Convert.ToInt32(ViewState["POID"].ToString());
if (interventions.UpdateInterventions())
{
LabelStatus.Text = "Update Successfully.";
}
else
{
LabelStatus.Text = "Update Failed.";
}
}
//Sending Email For Hand Off
try
{
if (interventions.HandOff == 1)
{
string toEmail = null;
if (ConfigurationManager.AppSettings["productionMode"].ToString() == "OFF")
{
toEmail = ConfigurationManager.AppSettings["toEmail"].ToString();
}
else
{
//Get Student Email Address By ID
studentid = Session["StudentID"].ToString();
Student stu = new Student();
stu = stu.GetStudentByStudentOID(studentid);
if (stu != null)
{
if (stu.EmailAddress != null)
{
toEmail = stu.EmailAddress;
}
}
//toEmail = ConfigurationManager.AppSettings["toEmail"].ToString();
}
#region Handoff Body
string html = null ;
html += "<table style='width: 100%; '>";
html += "<tr><td colspan='4'> <h3>Handoff Details of " + DropDownListIntervention.SelectedItem.ToString() + " Intervention</h3></td></tr>";
html += "<tr><td > </td><td style='background-color:#727272;width:100px;'> Assessment</td><td>" + ddlAssessment.Text + "</td><td></td></tr>";
html += "<tr><td > </td><td style='background-color:#727272;width:100px;'> Domain</td><td>" + DropDownListDomain.SelectedItem.ToString() + "</td><td></td></tr>";
html += "<tr><td > </td><td style='background-color:#727272;width:100px;'> Intervention</td><td>" + DropDownListIntervention.SelectedItem.ToString() + "</td><td></td></tr>";
html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:150px;'>User Name </td><td>" + DropDownListAdvocate.SelectedItem.ToString() + "</td></tr>";
html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:100px;'>Action Date </td><td>" + TextBoxLatestAction.Value.ToString();
html += " Prescribed ";
if (interventions.Prescribed == 1)
{
html += "<img alt='yes' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='no' src='../../images/nonetic-pic.png' />";
}
html += " Participating ";
if (interventions.Participating == 1)
{
html += "<img alt='yes' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='no' src='../../images/nonetic-pic.png' />";
}
html += " Internal ";
if (interventions.Internal == 1)
{
html += "<img alt='yes' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='no' src='../../images/nonetic-pic.png' />";
}
html += " Urgent ";
if (interventions.Urgent == 1)
{
html += "<img alt='yes' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='no' src='../../images/nonetic-pic.png' />";
}
html += " Completed ";
if (interventions.Completed == 1)
{
html += "<img alt='yes' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='no' src='../../images/nonetic-pic.png' />";
}
html += "</td></tr>";
html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:100px;'>Contact Date </td><td>" + TextBoxLatestContact.Value.ToString();
html += " Email ";
if (interventions.Email == 1)
{
html += "<img alt='yes' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='no' src='../../images/nonetic-pic.png' />";
}
html += " Telephone ";
if (interventions.Telephone == 1)
{
html += "<img alt='yes' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='no' src='../../images/nonetic-pic.png' />";
}
html += " In Person ";
if (interventions.InPerson == 1)
{
html += "<img alt='yes' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='no' src='../../images/nonetic-pic.png' />";
}
html += " Hand-Off ";
if (interventions.HandOff == 1)
{
html += "<img alt='yes' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='no' src='../../images/nonetic-pic.png' />";
}
html += " Testing ";
if (interventions.Testing == 1)
{
html += "<img alt='yes' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='no' src='../../images/nonetic-pic.png' />";
}
html += "</td></tr>";
html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:100px;'>Comments: </td><td>" + TextBoxContactNotes.Text;
html += "</table>";
#endregion
if (SendMail(toEmail, "You have got a Handoff", html))
{
LabelStatus.Text = "Eamil Sent .. Successfully";
}
else
{
LabelStatus.Text = "Eamil Not Sent .. Please contact with admin ";
}
}
}
catch (Exception ae)
{
LabelStatus.Text = "Eamil Not Sent .. Please contact with admin ";
}
//End Sending Mail For Hand Off
}
catch (Exception ex)
{
}
}
public Collection<Interventions> GetInterventionByAssOID(int SOID, int riskOid,int aoid)
{
Collection<Interventions> _list = new Collection<Interventions>();
Interventions intervention = null;
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
using (OdbcCommand command = new OdbcCommand())
{
command.Connection = connection;
command.CommandText = "{CALL Prescription_GetByAssNamePrint(?,?,?)}";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@soid", SOID);
command.Parameters.AddWithValue("@riskoid", riskOid);
command.Parameters.AddWithValue("@aoid", aoid);
connection.Open();
using (OdbcDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
intervention = new Interventions();
intervention.PrescriptionOID = (int)dataReader["PrescriptionOID"];
intervention.StudentOID = (int)dataReader["StudentOID"];
intervention.UserOID = (int)dataReader["UserOID"];
intervention.UserName = (string)dataReader["UserName"];
intervention.DomainOID = (int)dataReader["DomainOID"];
intervention.DomainName = (string)dataReader["DomainName"];
intervention.InterventionOID = (int)dataReader["InterventionOID"];
intervention.InterventionName = (string)dataReader["InterventionName"];
if (dataReader["LatestActionDate"] != null)
{
intervention.LatestActionDate = Convert.ToDateTime(dataReader["LatestActionDate"]).ToShortDateString();
}
if (dataReader["LatestContact"] != null)
{
intervention.LatestContact = Convert.ToDateTime(dataReader["LatestContact"]).ToShortDateString();
}
intervention.Internal = (int)dataReader["Internal"];
intervention.Prescribed = (int)dataReader["Prescribed"];
intervention.Completed = (int)dataReader["Completed"];
intervention.Email = (int)dataReader["Email"];
intervention.Telephone = (int)dataReader["Telephone"];
intervention.InPerson = (int)dataReader["InPerson"];
intervention.HandOff = (int)dataReader["HandOff"];
if (dataReader["CreatedDate"] != null)
{
intervention.CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]).ToShortDateString();
}
intervention.CreatedBy = (int)dataReader["CreatedBy"];
if (dataReader["LastModifiedDate"] != null)
{
intervention.LastModifiedDate = Convert.ToDateTime(dataReader["LastModifiedDate"]).ToShortDateString();
}
intervention.LastModifiedBy = (int)dataReader["LastModifiedBy"];
intervention.Comment = (string)dataReader["Comment"];
intervention.Urgent = (int)dataReader["Urgent"];
intervention.Testing = (int)dataReader["Testing"];
intervention.Participating = (int)dataReader["Participating"];
intervention.AssessmentName = (string)dataReader["AssessmentName"];
_list.Add(intervention);
}
}
}
}
return _list;
}
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
try
{
//CheckValueNonScore();
//CheckValueForScore();
bool ChNonScore = CheckValueNonScore();
if (!ChNonScore)
{
Alert.Show("Please Answer All Non Score Questions");
// Label1.Text = "<b>Check All Non Score</b>";
return ;
}
bool ChScore = CheckValueForScore();
if (!ChScore)
{
Alert.Show("Please Answer All Score Questions");
// Label1.Text = "<b>Check All Score Question</b>";
return ;
}
else
{
int answerOID = GetValueNonScore();
GetValueForScore(answerOID);
Student student = (Student)(Session["currentStd"]);
int aoid = Convert.ToInt32(Session["aoid"].ToString());
try
{
if (student != null)
{
RiskCalculation riskCalculation = new RiskCalculation().GetRiskCalculationByAOIDAndSOID(aoid, student.StudentOID);
if (riskCalculation != null)
{
Interventions intervention = new Interventions().GetInterventionByRiskOID(riskCalculation.RiskOID);
if (intervention != null)
{
intervention.StudentOID = student.StudentOID;
intervention.AddInterventions();
}
}
}
}
catch (Exception ex)
{ }
try
{
PrintIntervention(aoid, student.StudentID,student .EmailAddress);
UpdateTestingDate(lblStudentID.Text);
//Response.Redirect("FinishExam.aspx?aoid=" + aoid + "");
Response.Redirect("../../FinishExam.aspx");
}
catch (Exception ex)
{
lblValidation.Text = ex.ToString();
}
// Response.Redirect("FinishExam.aspx?aoid=" + aoid + "&bannerid='" + lblStudentID.Text + "'");
}
}
catch (Exception )
{
}
}
public Interventions GetInterventionByRiskOID(int ROID, string StudentBannerID, string pageIndex, string numberOfRows,int UserOID)
{
Interventions u = null;
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
using (OdbcCommand command = new OdbcCommand())
{
command.Connection = connection;
command.CommandText = "{CALL Intervations_ByRiskOID(?,?,?,?)}";
command.CommandType = CommandType.StoredProcedure;
//command.Parameters.AddWithValue("@ROID", ROID);
OdbcParameter paramROID = new OdbcParameter("@ROID", OdbcType.Int);
paramROID.Value = Convert.ToInt32(ROID);
command.Parameters.Add(paramROID);
// command.Parameters.AddWithValue("@StudentBannerID", StudentBannerID);
OdbcParameter paramStudentBannerID = new OdbcParameter("@StudentBannerID", OdbcType.VarChar, 20);
paramStudentBannerID.Value = StudentBannerID;
command.Parameters.Add(paramStudentBannerID);
OdbcParameter paramPageIndex = new OdbcParameter("@PageIndex", OdbcType.Int);
paramPageIndex.Value = Convert.ToInt32(pageIndex);
command.Parameters.Add(paramPageIndex);
OdbcParameter paramNumberOfRows = new OdbcParameter("@NumberOfRows", OdbcType.Int);
paramNumberOfRows.Value = Convert.ToInt32(numberOfRows);
command.Parameters.Add(paramNumberOfRows);
connection.Open();
using (OdbcDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
u = new Interventions();
u.RiskOID = (int)dataReader["RiskOID"];
u.PrescriptionOID = (int)dataReader["PrescriptionOID"];
u.StudentOID = (int)dataReader["StudentOID"];
u.UserOID = (int)dataReader["UserOID"];
u.UserName = (string)dataReader["UserName"];
u.DomainOID = (int)dataReader["DomainOID"];
u.DomainName = (string)dataReader["DomainName"];
u.InterventionOID = (int)dataReader["InterventionOID"];
u.InterventionName = (string)dataReader["InterventionName"];
if (dataReader["LatestActionDate"] != null)
{
u.LatestActionDate = Convert.ToDateTime(dataReader["LatestActionDate"]).ToShortDateString();
}
if (dataReader["LatestContact"] != null)
{
u.LatestContact = Convert.ToDateTime(dataReader["LatestContact"]).ToShortDateString();
}
u.Internal = (int)dataReader["Internal"];
u.Prescribed = (int)dataReader["Prescribed"];
u.Completed = (int)dataReader["Completed"];
u.Email = (int)dataReader["Email"];
u.Telephone = (int)dataReader["Telephone"];
u.InPerson = (int)dataReader["InPerson"];
u.HandOff = (int)dataReader["HandOff"];
u.Participating = (int)dataReader["Participating"];
if (dataReader["CreatedDate"] != null)
{
u.CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]).ToShortDateString();
}
u.CreatedBy = (int)dataReader["CreatedBy"];
if (dataReader["LastModifiedDate"] != null)
{
u.LastModifiedDate = Convert.ToDateTime(dataReader["LastModifiedDate"]).ToShortDateString();
}
u.LastModifiedBy = (int)dataReader["LastModifiedBy"];
u.Comment = (string)dataReader["Comment"];
if (dataReader["BannerID"] != null && dataReader["BannerID"] != "" && dataReader["BannerID"]!=DBNull .Value )
{
u.BannerID = (string)dataReader["BannerID"];
}
u.PrescribedULR = (u.Prescribed == 1) ? "~/images/Actions-dialog-ok-icon.png" : "~/images/X-Au-Blu-icon.png";
u.CompletedURL = (u.Completed == 1) ? "~/images/Actions-dialog-ok-icon.png" : "~/images/X-Au-Blu-icon.png";
u.HandOffURL = (u.HandOff == 1) ? "~/images/Actions-dialog-ok-icon.png" : "~/images/X-Au-Blu-icon.png";
u.EmailURL = (u.Email == 1) ? "~/images/Actions-dialog-ok-icon.png" : "~/images/X-Au-Blu-icon.png";
u.TelephoneURL = (u.Telephone == 1) ? "~/images/Actions-dialog-ok-icon.png" : "~/images/X-Au-Blu-icon.png";
u.InPersonURL = (u.InPerson == 1) ? "~/images/Actions-dialog-ok-icon.png" : "~/images/X-Au-Blu-icon.png";
u.ParticipatingURL = (u.Participating == 1) ? "~/images/Actions-dialog-ok-icon.png" : "~/images/X-Au-Blu-icon.png";
u.Unread = dataReader["Unread"].ToString();
//u.FlagURL = (u.HandOff == 1 && u.Unread == "yes") ? "~/images/flag.png" : "";
if (u.HandOff == 1 && !CheckUser(u.PrescriptionOID, UserOID))
{
u.FlagURL = "~/images/flag.png";
}
else if (u.HandOff == 0 && !CheckUser(u.PrescriptionOID, UserOID))
{
u.FlagURL = "~/images/flag.png";
}
else
{
u.FlagURL = "";
}
//u.PrescribedULR = (u.Prescribed == 1) ? "~/images/Actions-dialog-ok-icon.pngs" : "~/images/X-Au-Blu-icon.png";
//u.PrescribedULR = (u.Prescribed == 1) ? "~/images/Actions-dialog-ok-icon.pngs" : "~/images/X-Au-Blu-icon.png";
//invList.Add(u);
}
}
}
}
return u;
}
protected void DropDownListDomain_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownListIntervention.Items.Clear();
Interventions iv;
if (DropDownListDomain.Text != null)
{
iv = new Interventions();
Collection<Interventions> inList = new Collection<Interventions>();
inList = iv.GetInterventionByDomainName(DropDownListDomain.Text);
//DropDownListIntervention.Items.Clear();
foreach (Interventions inter in inList)
{
DropDownListIntervention.Items.Add(inter.InterventionName);
}
}
}
public ArchimedesResponseHelper sendArchimedesDataFull(ArchimedesPostHelper ArchObj)
{
//Remember that ArchimedesHelper helper classes default many fields. Handle the way you want to handle nulls and defaults before passing through to Full.
var url = "https://demo-indigo4health.archimedesmodel.com/IndiGO4Health/IndiGO4Health";
var postdata =
"age=" + ArchObj.age +
"&gender=" + ArchObj.gender + "&height= " + ArchObj.height +
"&weight=" + ArchObj.weight + "&smoker=" + ArchObj.smoker +
"&mi=" + ArchObj.mi + "&stroke=" + ArchObj.stroke +
"&diabetes=" + ArchObj.diabetes + "&systolic=" + ArchObj.systolic +
"&diastolic=" + ArchObj.diastolic + "&cholesterol=" + ArchObj.cholesterol +
"&hdl=" + ArchObj.hdl + "&ldl=" + ArchObj.ldl +
"&triglycerides=" + ArchObj.triglycerides + "&hba1c=" + ArchObj.hba1c +
"&cholesterolmeds=" + ArchObj.cholesterolmeds + "&bloodpressuremeds=" + ArchObj.bloodpressuremeds +
"&bloodpressuremedcount=" + ArchObj.bloodpressuremedcount + "&aspirin=" + ArchObj.aspirin +
"&moderateexercise=" + ArchObj.moderateexercise + "&vigorousexercise=" + ArchObj.vigorousexercise +
"&familyhistory=" + ArchObj.familymihistory;
try
{
//Create the Request
var request = WebRequest.Create(url);
request.Method = "POST";
request.ContentType = "application/x-www-form-urlencoded; charset=UTF-8";
byte[] byteArray = Encoding.UTF8.GetBytes(postdata);
request.ContentLength = byteArray.Length;
Stream dataStream = request.GetRequestStream();
dataStream.Write(byteArray, 0, byteArray.Length);
dataStream.Close();
var response = (HttpWebResponse)request.GetResponse();
if (response.StatusCode == HttpStatusCode.OK)
{
//Write the Request to a string
var mem = new MemoryStream();
var responseStream = response.GetResponseStream();
var buffer = new Byte[2048];
int count = responseStream.Read(buffer, 0, buffer.Length);
while (count > 0)
{
mem.Write(buffer, 0, count);
count = responseStream.Read(buffer, 0, buffer.Length);
}
responseStream.Close();
mem.Close();
var responseArray = mem.ToArray();
var encoding = new System.Text.UTF8Encoding();
//Write to a variable
var json = encoding.GetString(responseArray);
//Parse into JSON
JObject obj = JObject.Parse(json);
var archRisk = new Interventions((float)obj["Interventions"]["IncreaseInRisk"], (float)obj["Interventions"]["PercentReductionInRiskWithAdditionalModerateExercise"], (float)obj["Interventions"]["PercentReductionInRiskWithAdditionalVigorousExercise"], (float)obj["Interventions"]["PercentReductionInRiskWithWeightLoss"], (float)obj["Interventions"]["PercentReductionInRiskWithMedication"], (float)obj["Interventions"]["PercentReductionWithSmokingCessation"], (float)obj["Interventions"]["PercentReductionWithAllInterventions"], (float)obj["Interventions"]["PoundsOfWeightLossRequired"]);
//From the API Documentation, it seems that the API in production mode will either return Risk comparisons or not. Non-production API doesn't do this, but let's build for this future.
if (obj["Risk"] != null)
{
var CRisk = new CVDRisk((float)obj["Risk"][0]["comparisonRisk"], (float)obj["Risk"][0]["rating"], (float)obj["Risk"][0]["ratingForAge"], (float)obj["Risk"][0]["risk"], (float)obj["Risk"][0]["riskPercentile"]);
var HRisk = new HighCVDRisk((float)obj["Risk"][1]["comparisonRisk"], (float)obj["Risk"][1]["rating"], (float)obj["Risk"][1]["ratingForAge"], (float)obj["Risk"][1]["risk"], (float)obj["Risk"][1]["riskPercentile"]);
var LRisk = new LowCVDRisk((float)obj["Risk"][2]["comparisonRisk"], (float)obj["Risk"][2]["rating"], (float)obj["Risk"][2]["ratingForAge"], (float)obj["Risk"][2]["risk"], (float)obj["Risk"][2]["riskPercentile"]);
var other = new OtherArchInfo((Boolean)obj["ElevatedBloodPressure"], (Boolean)obj["ElevatedCholesterol"], (float)obj["WarningCode"], (float)obj["Recommendation"], (float)obj["DoctorRecommendation"]);
var archResponse = new ArchimedesResponseHelper(archRisk, CRisk, HRisk, LRisk, other);
return archResponse;
}
else
{
var other = new OtherArchInfo((Boolean)obj["ElevatedBloodPressure"], (Boolean)obj["ElevatedCholesterol"], (float)obj["WarningCode"], (float)obj["Recommendation"], (float)obj["DoctorRecommendation"]);
var archResponse = new ArchimedesResponseHelper(archRisk, other);
return archResponse;
}
}
else
{
throw new Exception(String.Format(
"Server error (HTTP {0}: {1}).",
response.StatusCode,
response.StatusDescription));
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return null;
}
}
private void PrintIntervention(int POID, int RiskOID, string BannerID,int AOID)
{
try
{
Interventions intervention = new Interventions();
intervention = intervention.GetInterventionByOID(POID);
if (intervention != null)
{
Student stdnt = new Student();
int StdOID = stdnt.GetStudentOIDByStudentBannerID(Request.QueryString["soid"]);
stdnt = stdnt.GetStudentByOID(StdOID);
if (stdnt != null)
{
string html = "";
Assessment ass = new Assessment();
//Create Html
html += "<table width='100%' ><tr><td><img alt='Logo' src='../../images/chippewavtc_logo.jpg' /></td><td style='text-align:center;'><span style='font-size:medium;font-weight:bold;'> Steps to Success: CVTC's commitment to helping YOU succeed!</span><br/><span style='text-align:center;'> Inventory of Student Success: Personalized Success Plan </span></td></tr></table>";
html += "<table width='100%'><tr><td style='width:45%;'>Success Steps For:<br /><b>First Name :</b>" + stdnt.FirstName + " <b>Last Name :</b> " + stdnt.LastName + "</td><td> <div style='background-color: #C0C0C0;float:left;width:20%;'>Program </div><div style='padding-left:10px;border:solid 1px black;width:75%; float:left;'>" + stdnt.MajorProgramEnrollment + "</div></td></tr></table>";
//ass.GetAssessmentByAssessmentOID(AOID);
//if (ass != null)
//{
//html += "<table width='100%'><tr><td style='width:45%;'><b>Assessment Name : </b><b>" + ass.AssessmentName + "</b></td><td> </td></tr></table>";
//}
html += "<table width='100%'><tr><td style='border:solid 1px black;'>Inventory of Student Success results provide comparsions of your attitudes and confidence with other<br /> entering CVTC students in key focus areas that could affect your academic performance and program<br /> persistance: </td></tr></table>";
//Collection<Interventions> interventions = intervention.GetInterventionByStudentOID(intervention.StudentOID);
Collection<Interventions> interventions = new Collection<Interventions>();
interventions = intervention.GetInterventionByAssOID(StdOID, RiskOID,AOID);
foreach (Interventions inter in interventions)
{
//Start
html += "<table style='width: 100%;'>";
//Get Sectionwise Student Rank
StudentRank studentRank = new StudentRank();
// Collection<StudentRank> _list = studentRank.GetStudentRankByOID(stdnt.StudentOID);
int AssessmentOID = 0;
//Assessment ass = new Assessment();
// AssessmentOID = ass.GetAssessmentOIDByAssessmentName(ddlAssessment.SelectedItem.Text);
// Collection<Assessment> assList = new Collection<Assessment>();
//assList = ass.GetAssessmentBySOID(BannerID);
ass.GetAssessmentByAssessmentOID(AOID);
if (ass != null)
{
//foreach (Assessment assessment in assList)
//{
Collection<StudentRank> _list = studentRank.GetStudentRankBySOIDandAOID(StdOID, ass.AssessmentOID);
//if
//for (int i = 0; i < 5; i++)
foreach (StudentRank stRank in _list)
{
html += "<tr>";
html += "<td style='border:solid 1px black;background-color:#727272;width:200px;'>" + stRank.SectionName + "</td>";
html += "<td style='border:solid 1px black;width:50px;text-align:center;'>" + stRank.Rank.ToString() + "</td>";
html += "<td style='border:solid 1px black;'>" + stRank.Comment + "</td>";
html += "</tr>";
//break;
} break;
//}
}
html += "</table>";
//End
}
html += "<table style='width: 100%; border:solid 1px black;'> <tr > <td>COMPASS test scores measure your academic readiness for college coursework in four broad areas:</td> </tr> </table>";
html += " <table style='width: 60%; '> <tr><td style='background-color:#727272;width:200px;'>COMPASS Pre-Algebra</td><td style='width:100px; border:solid 1px black;'>" + stdnt.PrealgebraTestScore + "</td><td style='background-color:#727272;width:200px;'>COMPASS Writing</td><td style='width:100px; border:solid 1px black;'>" + stdnt.CompassWrittingTestScore + "</td></tr> <tr><td style='background-color:#727272;width:200px;'>COMPASS Algebra</td><td style='width:100px; border:solid 1px black;'>" + stdnt.CompassalgebraTestScore + "</td><td style='background-color:#727272;width:200px;'>COMPASS Reading</td><td style='width:100px; border:solid 1px black;'>" + stdnt.CompassReadingTestScore + "</td></tr> </table>";
html += "<br/>";
int counter = 0;
//Collection<Interventions> interventionsList = intervention.GetInterventionByStudentOID(StdOID,RiskOID);
foreach (Interventions inter in interventions)
{
counter++;
#region Printing Checkboxes
html += "<table style='width: 100%; '>";
html += "<tr><td style='width:60px;font-size:medium;font-weight:bold;'></td><td style='background-color:#727272;width:100px;'> Assessment Name : </td><td>" + inter .AssessmentName + "</td><td></td></tr>";
html += "<tr><td style='width:60px;font-size:medium;font-weight:bold;'>Step " + counter.ToString() + "</td><td style='background-color:#727272;width:100px;'> Plan Target</td><td>" + inter.DomainName + "</td><td></td></tr>";
html += "<tr><td > </td><td style='background-color:#727272;width:100px;'> Intervention</td><td>" + inter.InterventionName + "</td><td></td></tr>";
html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:150px;'>CVTC Advocate </td><td>" + inter.UserName + "</td></tr>";
html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:100px;'>Action Date </td><td>" + inter.LatestActionDate;
html += " Prescribed ";
if (inter.Prescribed == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
html += " Participating ";
if (inter.Participating == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
html += " Internal ";
if (inter.Internal == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
html += " Urgent ";
if (inter.Urgent == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
html += " Completed ";
if (inter.Completed == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
html += "</td></tr>";
html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:100px;'>Contact Date </td><td>" + inter.LatestContact;
html += " Email ";
if (inter.Email == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
html += " Telephone ";
if (inter.Telephone == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
html += " In Person ";
if (inter.InPerson == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
html += " Hand-Off ";
if (inter.HandOff == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
html += " Testing ";
if (inter.Testing == 1)
{
html += "<img alt='' src='../../images/tic-pic.png' />";
}
else
{
html += "<img alt='' src='../../images/nonetic-pic.png' />";
}
#endregion
html += "</td></tr>";
html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:150px;'>Comments : </td><td>" + inter.Comment + "</td></tr>";
html += "</table>";
html += "<br /><br />";
//End
}//foreach
//html += "<script type =\"text/javascript\">";
//html += "printDiv();";
//html += "</script>";
Response.Write(html.ToString());
//print_div1.InnerHtml = html;
}//std
}
}
catch (Exception ex)
{ }
}
