public void MeetingDomicilio(int idMeeting)
{
using (var db = FactoryConn.GetConn()) {
var MeetingId = int.Parse(idMeeting.ToString());
var dto = new ModelContainer();
dto.Reference = db.Table <Meeting> ().Where(s => s.Id == MeetingId).FirstOrDefault().CaseDetentionId.ToString() ?? "";
ImputedHome mdl = new ImputedHome();
mdl.MeetingId = idMeeting;
dto.JsonModel = JsonConvert.SerializeObject(mdl);
var temp = new AddressUpsert {
Model = dto
};
var pagestring = "nada que ver";
pagestring = temp.GenerateString();
webView.LoadHtmlString(pagestring);
db.Close();
}
}
public void AddVerificationSource(int idCase)
{
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 && reviewer.Id > 0)
{
revId = reviewer.Id;
}
var casoId = int.Parse(idCase.ToString());
var caso = db.Table <Case> ().Where(cs => cs.Id == casoId).FirstOrDefault();
// var usuario = db.Table<User>().FirstOrDefault();
var verificacion = db.Table <Verification> ().Where(s => s.CaseDetentionId == casoId &&
s.ReviewerId == revId).FirstOrDefault();
var dto = new ModelContainer();
dto.Reference = idCase.ToString();
SourceVerification mdl = new SourceVerification();
mdl.IdCase = casoId;
mdl.IsAuthorized = false;
mdl.Visible = true;
mdl.VerificationId = verificacion.Id;
dto.JsonModel = JsonConvert.SerializeObject(mdl);
var temp = new NewVerificationSource {
Model = dto
};
var pagestring = "nada que ver";
pagestring = temp.GenerateString();
webView.LoadHtmlString(pagestring);
} catch (Exception e) {
db.Rollback();
Console.WriteLine("catched exception in MeetingController method PersonSocialNetwork");
Console.WriteLine("Exception message :::>" + e.Message);
} finally {
db.Commit();
}
db.Close();
}
}
public void EditMeetingDomicilio(int idHome)
{
var HomeId = int.Parse(idHome.ToString());
var dto = new ModelContainer();
using (var db = FactoryConn.GetConn()) {
ImputedHome mdl = db.Table <ImputedHome> ().Where(lv => lv.Id == HomeId).FirstOrDefault();
if (mdl != null)
{
var schedule = db.Table <Schedule> ().Where(sc => sc.ImputedHomeId == mdl.Id).ToList();
if (schedule != null)
{
mdl.Schedule = JsonConvert.SerializeObject(schedule);
}
}
if (mdl != null)
{
dto.JsonModel = JsonConvert.SerializeObject(mdl);
dto.Reference = db.Table <Meeting> ().Where(s => s.Id == mdl.MeetingId).FirstOrDefault().CaseDetentionId.ToString() ?? "";
}
else
{
mdl = new ImputedHome();
mdl.MeetingId = idHome;
dto.JsonModel = JsonConvert.SerializeObject(mdl);
}
db.Close();
}
var temp = new AddressUpsert {
Model = dto
};
// var temp = new NewMeeting{Model = new EntrevistaTabla{Name="nombre" , DateBirthString=DateTime.Today.ToString("yyyy/mm/dd")} };
var pagestring = "nada que ver";
pagestring = temp.GenerateString();
webView.LoadHtmlString(pagestring);
}