public void InsertStatusMeeting(Activity act){ using (var db = FactoryConn.GetConn ()) { db.CreateTable<StatusMeeting> (); if (db.Table<StatusMeeting> ().Count () == 0) { IEnumerable<String[]> data = GetDataOfFile (ConstantsDb.CONTENT_FOLDER_CATALOG + "/status_meeting.txt", act); List<StatusMeeting> entities = new List<StatusMeeting> (); foreach (String[] line in data) { try { StatusMeeting model = new StatusMeeting (); model.Id = int.Parse (line [0]); model.Status = line [1]; model.Description = line [2]; entities.Add (model); } catch (Exception e) { Console.WriteLine ("StatusMeeting error " + e.Message); } } db.InsertAll (entities); var content = db.Table<StatusMeeting> ().ToList (); Console.WriteLine ("Se inserto en tabla StatusMeeting:"); foreach (StatusMeeting m in content) { Console.WriteLine ("Id: " + m.Id + " Name:" + m.Status); } } db.Close (); } }
public void IndexVerificacion() { StatusMeeting statusMeeting1 = services.statusMeetingfindByCode(Constants.S_MEETING_INCOMPLETE); StatusMeeting statusMeeting2 = services.statusMeetingfindByCode(Constants.S_MEETING_INCOMPLETE_LEGAL); StatusCase sc = services.statusCasefindByCode(Constants.CASE_STATUS_MEETING); using (var db = FactoryConn.GetConn()) { var result = db.Query <MeetingTblDto> ( "SELECT cs.id_case as 'CaseId',cs.id_folder as 'IdFolder',im.name as 'Name',im.lastname_p as 'LastNameP',im.lastname_m as 'LastNameM'," + " im.birth_date as 'DateBirth', im.gender as 'Gender', csm.status as 'StatusCode', csm.description as 'Description'" + " FROM meeting as me " + " left JOIN case_detention as cs ON me.id_case = cs.id_case " + " left JOIN imputed as im ON im.id_meeting = me.id_meeting " + " left JOIN cat_status_meeting as csm ON csm.id_status = me.id_status " + " WHERE me.id_status in (?,?) " // +" and me.id_reviewer = 2 " + " AND cs.id_status = ?; ", statusMeeting1.Id, statusMeeting2.Id, sc.Id); var temp = new MeetingList { Model = result }; var pagestring = "nada que ver"; pagestring = temp.GenerateString(); webView.LoadHtmlString(pagestring); db.Close(); } }
public int?createMeeting(NewMeetingDto imputed) { using (var db = FactoryConn.GetConn()) { int?result = null; try { Case caseDetention = new Case(); Imputed newImputed = new Imputed(); newImputed.Name = imputed.Name.Trim(); newImputed.LastNameP = imputed.LastNameP.Trim(); newImputed.LastNameM = imputed.LastNameM.Trim(); newImputed.FoneticString = services.getFoneticByName(imputed.Name, imputed.LastNameP, imputed.LastNameM); newImputed.Gender = imputed.Gender.GetValueOrDefault(); newImputed.BirthDate = imputed.DateBirth.GetValueOrDefault(); var reincident = db.Table <Imputed> ().Where(impu => impu.LastNameM == newImputed.LastNameM && impu.LastNameP == newImputed.LastNameP && impu.Name == newImputed.Name && impu.BirthDate == newImputed.BirthDate).ToList(); if (reincident != null && reincident.Count > 0) { caseDetention.Recidivist = true; } else { caseDetention.Recidivist = false; } // caseDetention.Status = services.statusCasefindByCode (Constants.CASE_STATUS_MEETING); caseDetention.StatusCaseId = services.statusCasefindByCode(Constants.CASE_STATUS_MEETING).Id; caseDetention.IdFolder = imputed.IdFolder; caseDetention.DateCreate = DateTime.Today; //caseDetention.setChangeArrangementType(false); // se agrega para poder contar si un caso cambia de MC a SCPP en algun formato de audiencia //caseDetention = caseRepository.save(caseDetention); db.Insert(caseDetention); Meeting meeting = new Meeting(); meeting.MeetingType = Constants.MEETING_PROCEDURAL_RISK; meeting.CaseDetentionId = caseDetention.Id; // meeting.CaseDetention = caseDetention; StatusMeeting statusMeeting = services.statusMeetingfindByCode(Constants.S_MEETING_INCOMPLETE); meeting.StatusMeetingId = statusMeeting.Id; // meeting.StatusMeeting = statusMeeting; // meeting.ReviewerId=LoggedUserId(); TODO agrega al usuario asociado al dispositivo meeting.DateCreate = DateTime.Today; db.Insert(meeting); newImputed.MeetingId = meeting.Id; // newImputed.Meeting = meeting; db.Insert(newImputed); db.Update(meeting); db.Update(caseDetention); // imputedRepository.save(imputed); result = caseDetention.Id; } catch (Exception e) { Console.WriteLine("e.Message>" + e.Message + "<< createMeeting"); } db.Close(); return(result); } }
public void Index() { init(); StatusMeeting statusMeeting1 = services.statusMeetingfindByCode(Constants.S_MEETING_INCOMPLETE); StatusMeeting statusMeeting2 = services.statusMeetingfindByCode(Constants.S_MEETING_INCOMPLETE_LEGAL); StatusCase sc = services.statusCasefindByCode(Constants.CASE_STATUS_MEETING); StatusCase sc1 = services.statusCasefindByCode(Constants.ST_CASE_TABLET_ASSIGNED); using (var db = FactoryConn.GetConn()) { db.CreateTable <User> (); var usrList = db.Table <User> ().ToList(); User reviewer = usrList.FirstOrDefault(); int revId = 0; if (reviewer != null && reviewer.Id != 0) { revId = reviewer.Id; } var result = db.Query <MeetingTblDto> ( "SELECT cs.id_case as 'CaseId',cs.id_folder as 'IdFolder',im.name as 'Name',im.lastname_p as 'LastNameP',im.lastname_m as 'LastNameM'," + " im.birth_date as 'DateBirth', im.gender as 'Gender', csm.status as 'StatusCode', csm.description as 'Description'" + " FROM meeting as me " + " left JOIN case_detention as cs ON me.id_case = cs.id_case " + " left JOIN imputed as im ON im.id_meeting = me.id_meeting " + " left JOIN cat_status_meeting as csm ON csm.id_status = me.id_status" + " WHERE me.id_status in (?,?) " + " and me.id_reviewer = ? " + " AND cs.id_status in (?,?); ", statusMeeting1.Id, statusMeeting2.Id, revId, sc.Id, sc1.Id); var temp = new MeetingList { Model = result }; var pagestring = "nada que ver"; pagestring = temp.GenerateString(); webView.LoadHtmlString(pagestring); db.Close(); } }
public int?createCaseConditionalReprieve(NewMeetingDto imputed) { int?result = null; using (var db = FactoryConn.GetConn()) { try { db.CreateTable <User> (); var usrList = db.Table <User> ().ToList(); User reviewer = usrList.FirstOrDefault(); int revId = 0; if (reviewer != null) { revId = reviewer.Id; } Case caseDetention = new Case(); Imputed newImputed = new Imputed(); newImputed.Name = imputed.Name.Trim(); newImputed.LastNameP = imputed.LastNameP.Trim(); newImputed.LastNameM = imputed.LastNameM.Trim(); newImputed.FoneticString = services.getFoneticByName(imputed.Name, imputed.LastNameP, imputed.LastNameM); newImputed.Gender = imputed.Gender.GetValueOrDefault(); newImputed.BirthDate = imputed.DateBirth.GetValueOrDefault(); var reincident = db.Table <Imputed> ().Where(impu => impu.LastNameM == newImputed.LastNameM && impu.LastNameP == newImputed.LastNameP && impu.Name == newImputed.Name && impu.BirthDate == newImputed.BirthDate).ToList(); if (reincident != null && reincident.Count > 0) { caseDetention.Recidivist = true; } else { caseDetention.Recidivist = false; } // caseDetention.Status = services.statusCasefindByCode (Constants.CASE_STATUS_CONDITIONAL_REPRIEVE); caseDetention.StatusCaseId = services.statusCasefindByCode(Constants.CASE_STATUS_CONDITIONAL_REPRIEVE).Id; caseDetention.IdMP = imputed.IdMP; caseDetention.IdFolder = "SIN EVALUACIÓN REGISTRADA"; caseDetention.DateCreate = DateTime.Today; //caseDetention.setChangeArrangementType(false); // se agrega para poder contar si un caso cambia de MC a SCPP en algun formato de audiencia //caseDetention = caseRepository.save(caseDetention); db.Insert(caseDetention); Meeting meeting = new Meeting(); meeting.MeetingType = Constants.MEETING_CONDITIONAL_REPRIEVE; meeting.CaseDetentionId = caseDetention.Id; // meeting.CaseDetention = caseDetention; StatusMeeting statusMeeting = services.statusMeetingfindByCode(Constants.S_MEETING_INCOMPLETE); meeting.StatusMeetingId = statusMeeting.Id; // meeting.StatusMeeting = statusMeeting; meeting.DateCreate = DateTime.Today; db.Insert(meeting); meeting.ReviewerId = revId; // meeting.Reviewer = reviewer; newImputed.MeetingId = meeting.Id; // newImputed.Meeting = meeting; db.Insert(newImputed); db.Update(meeting); db.Update(caseDetention); result = caseDetention.Id; } catch (Exception e) { Console.WriteLine("e.Message>" + e.Message + "<< createMeeting"); } db.Close(); } return(result); }
public void Index() { using (var db = FactoryConn.GetConn()) { db.CreateTable <User> (); var usrList = db.Table <User> ().ToList(); User reviewer = usrList.FirstOrDefault(); int revId = 0; if (reviewer != null && reviewer.Id > 0) { revId = reviewer.Id; } //estatus de meeting terminados StatusMeeting statusMeeting2 = services.statusMeetingfindByCode(Constants.S_MEETING_INCOMPLETE_LEGAL); StatusCase sc = services.statusCasefindByCode(Constants.CASE_STATUS_MEETING); StatusCase sc1 = services.statusCasefindByCode(Constants.ST_CASE_TABLET_ASSIGNED); var result = db.Query <MeetingTblDto> ( "SELECT cs.id_case as 'CaseId',cs.id_folder as 'IdFolder',im.name as 'Name',im.lastname_p as 'LastNameP',im.lastname_m as 'LastNameM'," + " im.birth_date as 'DateBirth', im.gender as 'Gender', csm.status as 'StatusCode', csm.description as 'Description' , me.id_reviewer as 'ReviewerId' " + " FROM meeting as me " + " left JOIN case_detention as cs ON me.id_case = cs.id_case " + " left JOIN imputed as im ON im.id_meeting = me.id_meeting " + " left JOIN cat_status_meeting as csm ON csm.id_status = me.id_status " + " WHERE me.id_status =? " + " and me.id_reviewer = ? " + " AND cs.id_status in (?,?); ", statusMeeting2.Id, revId, sc.Id, sc1.Id); var c1 = 0; if (result != null) { for (c1 = 0; c1 < result.Count; c1++) { result [c1].Action = "meeting"; } } StatusVerification statusVerification1 = services.statusVerificationfindByCode(Constants.VERIFICATION_STATUS_AUTHORIZED); StatusVerification statusVerification2 = services.statusVerificationfindByCode(Constants.VERIFICATION_STATUS_MEETING_COMPLETE); StatusCase scv = services.statusCasefindByCode(Constants.CASE_STATUS_VERIFICATION); StatusCase scv1 = services.statusCasefindByCode(Constants.ST_CASE_TABLET_ASSIGNED); var result2 = db.Query <MeetingTblDto> ( "SELECT cs.id_case as 'CaseId',cs.id_folder as 'IdFolder', " + " csm.description as 'StatusCode', csm.description as 'Description' , me.id_reviewer as 'ReviewerId' " + " , me.id_verification as 'MeetingStatusId' " + " FROM verification as me " + " left JOIN case_detention as cs ON me.id_case = cs.id_case " + " left JOIN cat_status_verification as csm ON csm.id_status = me.id_status_verification " + " WHERE me.id_status_verification in (?,?) " + " and me.id_reviewer = ? " + " AND cs.id_status in (?,?); ", statusVerification1.Id, statusVerification2.Id, revId, scv.Id, scv1.Id); var c2 = 0; try { if (result2 != null) { for (c2 = 0; c2 < result2.Count; c2++) { var id = result2 [c2].MeetingStatusId; var expected = db.Table <SourceVerification> ().Where(sv => sv.VerificationId == id && sv.Visible == true).ToList(); var finished = db.Table <SourceVerification> ().Where(sv => sv.VerificationId == id && sv.DateComplete != null && sv.Visible == true).ToList(); if (expected.Count == finished.Count) { result2 [c2].Action = "verification"; } else { result2 [c2].Action = "verificationIncomplete"; } var caseis = result2 [c2].CaseId; var me = db.Table <Meeting> ().Where(met => met.CaseDetentionId == caseis).FirstOrDefault(); if (me != null) { var imp = db.Table <Imputed> ().Where(iputad => iputad.MeetingId == me.Id).FirstOrDefault(); if (imp != null) { result2 [c2].Name = imp.Name; result2 [c2].LastNameP = imp.LastNameP; result2 [c2].LastNameM = imp.LastNameM; result2 [c2].Gender = imp.Gender; } } } } } catch (Exception e) { Console.WriteLine("excepcion en sincronizacion "); Console.WriteLine(e.Message); } result.AddRange(result2); ///// StatusMeeting statusMeetingNeg = services.statusMeetingfindByCode(Constants.S_MEETING_DECLINE); StatusCase sc2 = services.statusCasefindByCode(Constants.CASE_STATUS_NOT_PROSECUTE); var result3 = db.Query <MeetingTblDto> ( "SELECT cs.id_case as 'CaseId',cs.id_folder as 'IdFolder',im.name as 'Name',im.lastname_p as 'LastNameP',im.lastname_m as 'LastNameM'," + " im.birth_date as 'DateBirth', im.gender as 'Gender', csm.status as 'StatusCode', csm.description as 'Description' , me.id_reviewer as 'ReviewerId' " + " FROM meeting as me " + " left JOIN case_detention as cs ON me.id_case = cs.id_case " + " left JOIN imputed as im ON im.id_meeting = me.id_meeting " + " left JOIN cat_status_meeting as csm ON csm.id_status = me.id_status " + " WHERE me.id_status =? " + " and me.id_reviewer = ? " + " AND cs.id_status = ?; ", statusMeetingNeg.Id, revId, sc2.Id); var c3 = 0; if (result != null) { for (c3 = 0; c3 < result3.Count; c3++) { result3 [c3].Action = "negacion"; } } result.AddRange(result3); ///// var temp = new SyncCaseList { Model = result }; var pagestring = "nada que ver"; pagestring = temp.GenerateString(); webView.LoadHtmlString(pagestring); db.Close(); } }