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 void MeetingIndex()
{
var temp = new MeetingList();
var pagestring = "nada que ver";
pagestring = temp.GenerateString();
webView.LoadHtmlString(pagestring);
}
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();
}
}