public async void Execute(object parameter)
{
paudob00 observ = new paudob00
{
fregis = DateTime.Now,
clinea = VariableGlobal.cblobs,
dobser = VariableGlobal.dobser,
cusuar = VariableGlobal.cusuar,
senvio = "N",
};
dataService.InsertObservacionAuditoria(observ);
await dialogService.ShowMessage("Aviso", "La observación se guardo de manera satisfactoria.");
}
public Response InsertObservacionAuditoria(paudob00 observ)
{
try
{
//using (var da = new DataAccess())
//{
App.baseDatos.Insert(observ);
//}
return(new Response
{
IsSuccess = true,
Message = "Observación Insertada OK",
Result = observ,
});
}
catch (Exception ex)
{
return(new Response
{
IsSuccess = false,
Message = ex.Message,
});
}
}
async void GrabaAuditoriaDB()
{
try
{
var ultregis = 0;
using (var client = new HttpClient())
{
var listobs = App.baseDatos.GetList <paudob00>(false).Where(x => x.senvio == "N").ToList();
foreach (var recordobs in listobs)
{
var regobs = new paudob00
{
fregis = recordobs.fregis,
clinea = recordobs.clinea,
dobser = recordobs.dobser,
cusuar = recordobs.cusuar,
};
var jsondef = JsonConvert.SerializeObject(regobs);
var contentdef = new StringContent(jsondef, System.Text.Encoding.UTF8, "application/json");
var uriobs = "http://192.168.2.9:7030/api/paudob00";
var resultobs = await client.PostAsync(uriobs, contentdef);
if (!resultobs.IsSuccessStatusCode)
{
await DisplayAlert("Error", "Hubo un error con el Servicio Web, Por favor reintente guardar 4. " + resultobs.RequestMessage.ToString(), "OK");
return;
}
var resultStringdef = await resultobs.Content.ReadAsStringAsync();
var postdef = JsonConvert.DeserializeObject <pdefec01>(resultStringdef);
paudob00 updobs = new paudob00
{
idobse = recordobs.idobse,
fregis = recordobs.fregis,
clinea = recordobs.clinea,
dobser = recordobs.dobser,
cusuar = recordobs.cusuar,
senvio = "S",
};
App.baseDatos.Update(updobs);
}
//using (var data = new DataAccess())
//{
var listickets = App.baseDatos.GetList <paudit01>(false).Where(x => x.senvio == "N" && x.careas == taudit01).OrderBy(x => x.nsecue).ToList();
int qlistau = listickets.Count();
if (qlistau == 0)
{
await DisplayAlert("Aviso", "No existen auditorias pendientes para sincronizar", "OK");
}
int xqaudi = 0;
using (IProgressDialog fooDialog = UserDialogs.Instance.Progress("Sincronizando...", null, null, true, MaskType.Black))
{
foreach (var record in listickets)
{
if (taudit01 == "16")
{
var responseur = await apiService.GetUltRegistroCorte(record.careas, record.faudit.Date.ToString("yyyy-MM-dd"));
if (!responseur.IsSuccess)
{
ultregis = 0;
}
else
{
var dataultreg = (paudit02)responseur.Result;
if (dataultreg.clinea != null || dataultreg.ultreg > 0)
{
ultregis = dataultreg.ultreg;
}
}
}
else
{
var responseur = await apiService.GetUltRegistro(record.careas, record.faudit.Date.ToString("yyyy-MM-dd"), record.clinea);
if (!responseur.IsSuccess)
{
ultregis = 0;
}
else
{
var dataultreg = (paudit02)responseur.Result;
if (dataultreg.clinea != null || dataultreg.ultreg > 0)
{
ultregis = dataultreg.ultreg;
}
}
}
if (record.flgrau == "S")
{
var listnsecueref = App.baseDatos.GetList <paudit01>(false).Where(x => x.careas == taudit01 && x.clinea == record.clinea && x.copera == record.copera && x.ctraba == record.ctraba && x.ccarub == record.ccarub && x.nordpr == record.nordpr && x.nordct == record.nordct && x.status == "D").FirstOrDefault();
if (listnsecueref != null)
{
newnsecue = listnsecueref.nseref;
}
else
{
newnsecue = 0;
}
}
else
{
newnsecue = 0;
}
var novoPost = new paudit01
{
careas = record.careas,
faudit = DateTime.Parse(record.faudit.ToShortDateString()),
nsecue = ultregis + 1, //record.nsecue,
clinea = record.clinea,
ctpord = record.ctpord,
nordpr = record.nordpr,
nordct = record.nordct,
cmarbe = record.cmarbe,
ccarub = record.ccarub.Trim(),
npieza = record.npieza,
cencog = record.cencog.Trim(),
citems = record.citems.Trim(),
ccolor = record.ccolor.Trim(),
npanos = record.npanos,
dtalla = record.dtalla.Trim(),
qtotal = record.qtotal,
dlotes = record.dlotes,
ctraba = record.ctraba,
copera = record.copera,
cprove = record.cprove,
cmaqui = record.cmaqui,
cturno = record.cturno,
cparti = record.cparti,
nordco = record.nordco,
npacki = record.npacki,
nlotes = record.nlotes,
nmuest = record.nmuest,
pcierr = record.pcierr,
nrecup = record.nrecup,
nsegun = record.nsegun,
porcen = record.porcen,
flgcie = record.flgcie,
ndefec = record.ndefec,
status = record.status,
dobser = record.dobser.Trim(),
flgrau = record.flgrau,
nreaud = record.nreaud,
caudit = record.caudit,
flgext = record.flgext,
cliref = record.cliref,
fauref = DateTime.Parse(record.fauref.ToShortDateString()),
nseref = newnsecue, //record.nseref,
cusuar = record.cusuar,
fcreac = DateTime.Now,
fmodif = DateTime.Parse(record.fmodif.ToShortDateString()),
nordpo = record.nordpo,
fprogr = DateTime.Parse(record.fprogr.ToShortDateString()),
caudpr = record.caudpr,
drefpr = record.drefpr,
ctpaud = record.ctpaud,
csuppl = record.csuppl,
flgenv = record.flgenv,
sanula = record.sanula,
ndesap = record.ndesap,
sautab = record.sautab,
};
var json = JsonConvert.SerializeObject(novoPost);
var content = new StringContent(json, System.Text.Encoding.UTF8, "application/json");
var uri = "http://192.168.2.9:7030/api/paudit01";
var result = await client.PostAsync(uri, content);
if (!result.IsSuccessStatusCode)
{
await DisplayAlert("Error", "Hubo un error con el Servicio Web, Por favor reintente guardar 1. " + result.RequestMessage.ToString() + " " + result.StatusCode + " " + result.Content, "OK");
return;
}
var resultString = await result.Content.ReadAsStringAsync();
var post = JsonConvert.DeserializeObject <paudit01>(resultString);
//using (var datadef = new DataAccess())
//{
int qdefec = App.baseDatos.GetList <pdefec01>(false).Where(x => x.senvio == "N" && x.faudit == record.faudit && x.clinea == record.clinea && x.nsecue == record.nsecue && x.careas == taudit01).Count();
if (qdefec > 0)
{
var lisdef = App.baseDatos.GetList <pdefec01>(false).Where(x => x.senvio == "N" && x.faudit == record.faudit && x.clinea == record.clinea && x.nsecue == record.nsecue && x.careas == taudit01).ToList();
foreach (var recorddef in lisdef)
{
var lisdefimg = App.baseDatos.GetList <pdefec10>(false).Where(x => x.faudit == recorddef.faudit && x.clinea == recorddef.clinea && x.nsecue == recorddef.nsecue && x.careas == taudit01 && x.coddef == recorddef.coddef).ToList();
foreach (var recorddefimg in lisdefimg)
{
dimgdef = recorddefimg.defjpg;
}
var novoPostdef = new pdefec01
{
careas = recorddef.careas,
faudit = DateTime.Parse(recorddef.faudit.ToShortDateString()),
nsecue = ultregis + 1, //recorddef.nsecue,
clinea = recorddef.clinea,
codigo = recorddef.codigo,
coddef = recorddef.coddef,
qcanti = recorddef.qcanti,
dobser = recorddef.dobser,
cgrupo = recorddef.cgrupo,
cardef = recorddef.cardef,
imgdef = dimgdef,
};
var jsondef = JsonConvert.SerializeObject(novoPostdef);
var contentdef = new StringContent(jsondef, System.Text.Encoding.UTF8, "application/json");
var uridef = "http://192.168.2.9:7030/api/pdefec01";
var resultdef = await client.PostAsync(uridef, contentdef);
if (!result.IsSuccessStatusCode)
{
await DisplayAlert("Error", "Hubo un error con el Servicio Web, Por favor reintente guardar 2. " + resultdef.RequestMessage.ToString(), "OK");
return;
}
var resultStringdef = await result.Content.ReadAsStringAsync();
var postdef = JsonConvert.DeserializeObject <pdefec01>(resultStringdef);
//using (var dataimg = new DataAccess())
//{
int qimgde = App.baseDatos.GetList <pdefec10>(false).Where(x => x.careas == taudit01 && x.faudit == recorddef.faudit && x.clinea == recorddef.clinea && x.nsecue == recorddef.nsecue && x.vimage == true && x.iddefe == recorddef.iddefe).Count();
if (qimgde > 0)
{
var ldefecimg = App.baseDatos.GetList <pdefec10>(false).Where(x => x.careas == taudit01 && x.faudit == recorddef.faudit && x.clinea == recorddef.clinea && x.nsecue == recorddef.nsecue && x.iddefe == recorddef.iddefe).ToList();
foreach (var recordimg in ldefecimg)
{
var contentimg = new MultipartFormDataContent();
var path = "/storage/emulated/0/Pictures/Test/" + recordimg.defjpg;
contentimg.Add(new ByteArrayContent(File.ReadAllBytes(path)), "file", recordimg.defjpg);
var httpClient = new HttpClient();
var uploadServiceBaseAddress = "http://192.168.2.9:7030/api/Upload";
var httpResponseMessage = await httpClient.PostAsync(uploadServiceBaseAddress, contentimg);
await httpResponseMessage.Content.ReadAsStringAsync();
}
}
//}
pdefec01 ndefec = new pdefec01
{
iddefe = recorddef.iddefe,
careas = recorddef.careas,
faudit = DateTime.Parse(recorddef.faudit.ToShortDateString()),
nsecue = recorddef.nsecue,
clinea = recorddef.clinea,
codigo = recorddef.codigo,
coddef = recorddef.coddef,
qcanti = recorddef.qcanti,
dobser = recorddef.dobser,
cgrupo = recorddef.cgrupo,
cardef = recorddef.cardef,
senvio = "S",
imgdef = recorddef.imgdef,
};
App.baseDatos.Update(ndefec);
}
}
paudit01 nauditoria = new paudit01
{
idaudi = record.idaudi,
careas = record.careas,
faudit = record.faudit,
nsecue = record.nsecue,
clinea = record.clinea,
ctpord = record.ctpord,
nordpr = record.nordpr,
nordct = record.nordct,
cmarbe = record.cmarbe,
ccarub = record.ccarub,
npieza = record.npieza,
cencog = record.cencog,
citems = record.citems,
ccolor = record.ccolor,
npanos = record.npanos,
dtalla = record.dtalla,
qtotal = record.qtotal,
dlotes = record.dlotes,
ctraba = record.ctraba,
copera = record.copera,
cprove = record.cprove,
cmaqui = record.cmaqui,
cturno = record.cturno,
cparti = record.cparti,
nordco = record.nordco,
npacki = record.npacki,
nlotes = record.nlotes,
nmuest = record.nmuest,
pcierr = record.pcierr,
nrecup = record.nrecup,
nsegun = record.nsegun,
porcen = record.porcen,
flgcie = record.flgcie,
ndefec = record.ndefec,
status = record.status,
dobser = record.dobser,
flgrau = record.flgrau,
nreaud = record.nreaud,
caudit = record.caudit,
flgext = record.flgext,
cliref = record.cliref,
fauref = record.fauref,
nseref = ultregis + 1,
cusuar = record.cusuar,
fcreac = record.fcreac,
fmodif = record.fmodif,
nordpo = record.nordpo,
fprogr = record.fprogr,
caudpr = record.caudpr,
drefpr = record.drefpr,
ctpaud = record.ctpaud,
csuppl = record.csuppl,
flgenv = record.flgenv,
sanula = record.sanula,
ndesap = record.ndesap,
sautab = record.sautab,
senvio = "S",
};
App.baseDatos.Update(nauditoria);
xqaudi = xqaudi + 1;
fooDialog.PercentComplete = xqaudi;
fooDialog.Title = xqaudi + " de " + qlistau;
await Task.Delay(10);
}
}
//}
}
}
catch (Exception ex)
{
await DisplayAlert("Error", "Hubo un error con el Servicio Web, Por favor reintente guardar 3. " + ex.Message, "OK");
}
}
