protected void btnGenerate_Click(object sender, EventArgs e)
{
InterfazDAL_tticol074 idal074 = new InterfazDAL_tticol074();
InterfazDAL_tticol075 idal075 = new InterfazDAL_tticol075();
List <Ent_tticol074> parametrosIn074 = new List <Ent_tticol074>();
List <Ent_tticol075> parametrosIn075 = new List <Ent_tticol075>();
Dictionary <string, bool> dcArchivos = new Dictionary <string, bool>();
if (!DateTime.TryParseExact(Request.Form[txtStartDate.UniqueID], "MM/dd/yyyy HH:mm", CultureInfo.InvariantCulture, DateTimeStyles.None, out dtStart))
{
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = "Start date is invalid";
return;
}
if (!DateTime.TryParseExact(Request.Form[txtEndDate.UniqueID], "MM/dd/yyyy HH:mm", CultureInfo.InvariantCulture, DateTimeStyles.None, out dtEnd))
{
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = "Start end is invalid";
return;
}
if (dtStart >= dtEnd)
{
lblMessage.Text = ("Start date cannot be greater than or equal to end date");
lblMessage.ForeColor = System.Drawing.Color.Red;
return;
}
else if (dtStart > DateTime.Now)
{
lblMessage.Text = ("Start date can not be greater than today's date");
lblMessage.ForeColor = System.Drawing.Color.Red;
return;
}
if (!System.IO.File.Exists(Page.ResolveUrl(file)))
{
recursos.createMachines(path);
}
string userImpersonation = string.Empty, passImpersonation = string.Empty, domaImpersonation = string.Empty;
try
{
userImpersonation = ConfigurationManager.AppSettings["userImpersonation"].ToString();
passImpersonation = ConfigurationManager.AppSettings["passImpersonation"].ToString();
domaImpersonation = ConfigurationManager.AppSettings["domaImpersonation"].ToString();
System.Xml.XmlTextReader reader = new System.Xml.XmlTextReader(file);
DataTable machineSel = new DataTable();
machineSel.ReadXml(reader);
string sRows = GetSelectedRecords(ref strError);
if (string.IsNullOrEmpty(strError) && !string.IsNullOrEmpty(sRows))
{
whusa.Utilidades.ImpersonateManager.ImpersonateUser(domaImpersonation, userImpersonation, passImpersonation);
foreach (DataRow row in machineSel.Select("Id = 'USA' AND MachineId IN (" + sRows + ")"))
{
string machineID = row["MachineID"].ToString();
string sURL = string.Format(urlShopLogix, machineID, dtStart.ToString("yyyyMMdd"), dtEnd.AddDays(1).ToString("yyyyMMdd"));
recursos.DownloadFile(sURL, machineID, extension, ref dcArchivos, ref strError);
}
whusa.Utilidades.ImpersonateManager.StopImpersonation();
}
else
{
lblMessage.Text = ("No machine selected");
lblMessage.ForeColor = System.Drawing.Color.Red;
return;
}
DataTable dtTticol075 = new DataTable();
dtTticol075.Columns.Add("orden", typeof(string));
dtTticol075.Columns.Add("numOperacion", typeof(int));
dtTticol075.Columns.Add("tarifaHoraria", typeof(string));
dtTticol075.Columns.Add("horas", typeof(decimal));
dtTticol075.Columns.Add("comentario", typeof(string));
dtTticol075.Columns.Add("usuario", typeof(string));
dtTticol075.Columns.Add("fecha", typeof(DateTime));
dtTticol075.Columns.Add("chequeado", typeof(int));
dtTticol075.Columns.Add("procesado", typeof(int));
dtTticol075.Columns.Add("mensaje", typeof(string));
dtTticol075.Columns.Add("refcntd", typeof(int));
dtTticol075.Columns.Add("refcntu", typeof(int));
foreach (var dc in dcArchivos)
{
if (dc.Value)
{
ReadXML(dc.Key, ref parametrosIn074, ref strError);
}
else
{
lstMensajesError.Add("Error processing file: " + dc.Value + ".");
}
}
List <Ent_tticol074> filterParametrosIn074 = parametrosIn074.Where(p => p.fecha >= dtStart.AddHours(5) && p.fecha <= dtEnd.AddHours(5)).ToList();
var lstOrdenes = from u in filterParametrosIn074
group u by u.orden into g
orderby g.Count() descending
select "'" + g.Key + "'";
string nOrdenes = string.Join(",", lstOrdenes.ToList());
if (!string.IsNullOrEmpty(nOrdenes))
{
idal074.eliminarRegistro(nOrdenes, dtStart.AddHours(5), dtEnd.AddHours(5), ref strError);
idal075.eliminarRegistro(nOrdenes, dtStart.AddHours(5), dtEnd.AddHours(5), ref strError);
if (!validarRetorno(idal074.insertarRegistro(ref filterParametrosIn074, ref strError)))
{
lblMessage.Text = strError;
lblMessage.ForeColor = System.Drawing.Color.Red;
return;
}
dtTticol075 = idal074.ObtenerConsolidado(nOrdenes, dtStart.AddHours(5), dtEnd.AddHours(5), ref strError);
foreach (DataRow row in dtTticol075.Rows)
{
parametrosIn075.Add(new Ent_tticol075()
{
orden = row[0].ToString(),
numOperacion = Convert.ToInt32(row[1].ToString()),
tarifaHoraria = row[2].ToString(),
horas = Math.Round(Convert.ToDecimal(row[3].ToString()), 1),
comentario = row[4].ToString(),
usuario = row[5].ToString(),
fecha = Convert.ToDateTime(row[6].ToString()),
chequeado = Convert.ToInt32(row[7].ToString()),
procesado = Convert.ToInt32(row[8].ToString()),
mensaje = row[9].ToString(),
refcntd = Convert.ToInt32(row[10].ToString()),
refcntu = Convert.ToInt32(row[11].ToString())
});
}
if (!validarRetorno(idal075.insertarRegistro(ref parametrosIn075, ref strError)))
{
lblMessage.Text = strError;
lblMessage.ForeColor = System.Drawing.Color.Red;
return;
}
strError = "Upload successfully";
lblMessage.Text = strError;
lblMessage.ForeColor = System.Drawing.Color.Black;
}
else
{
strError = "Upload unsuccessfully";
lblMessage.Text = strError;
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
catch (Exception ex)
{
lblMessage.Text = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException.Message + ")" :
ex.Message;
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}