public static Data_PushBBVA.Status<string> ArchNitification()
{
Data_PushBBVA.Status<string> status = new Data_PushBBVA.Status<string>();
List<string> reads = new List<string>();
StreamReader read;
read = new StreamReader("Z://Notification.txt");
while (!read.EndOfStream)
{
reads.Add(Convert.ToString(read.ReadLine()));
}
read.Close();
status.status = "Success";
return status;
}
public static Data_PushBBVA.Status <string> ArchNitification()
{
Data_PushBBVA.Status <string> status = new Data_PushBBVA.Status <string>();
List <string> reads = new List <string>();
StreamReader read;
read = new StreamReader("Z://Notification.txt");
while (!read.EndOfStream)
{
reads.Add(Convert.ToString(read.ReadLine()));
}
read.Close();
status.status = "Success";
return(status);
}
public static Data_PushBBVA.Status<string> ArchUserSetting()
{
Data_PushBBVA.Status<string> status = new Data_PushBBVA.Status<string>();
string Users = "";
int i = 0;
List<string> User = new List<string>();
string users = @"Select rut FROM dbo.Users WHERE status = 1";
try
{
using (SqlConnection conn = new SqlConnection(connectionString: conex))
{
SqlCommand command = new SqlCommand(users, conn);
conn.Open();
SqlDataAdapter daAdaptador = new SqlDataAdapter(command);
DataSet dtDatos = new DataSet();
daAdaptador.Fill(dtDatos);
foreach (DataRow _dr in dtDatos.Tables[0].Rows)
{
string user = _dr[0].ToString();
Users = user + ";";
try
{
string Types = @"SELECT * FROM dbo.NotificationType_Users NTU, dbo.Users U WHERE NTU.idUsers = U.idUsers AND U.rut = @rut";
using (SqlConnection conn2 = new SqlConnection(connectionString: conex))
{
SqlCommand command2 = new SqlCommand(Types, conn2);
command2.Parameters.AddWithValue("@rut", user);
conn2.Open();
SqlDataAdapter daAdaptador2 = new SqlDataAdapter(command2);
DataSet dtDatos2 = new DataSet();
daAdaptador2.Fill(dtDatos2);
foreach (DataRow _dr2 in dtDatos2.Tables[0].Rows)
{
if (_dr2[2].ToString() == "True")
{
Users += 1 + ";";
}
else
{
Users += 0 + ";";
}
}
}
}
catch(Exception ex)
{
status.status = "Error";
status.description = ex.Message;
}
User.Add(Users);
}
try
{
//i = 0;
List<string> reads = new List<string>();
//string[] reads = new string[i];
//StreamReader read;
StreamWriter write;
// read = new StreamReader("Z://setting.txt");
//
// while (!read.EndOfStream)
// {
// reads.Add(Convert.ToString(read.ReadLine()));
// // i++;
// }
// read.Close();
//
write = new StreamWriter("Z://setting.txt");
for (i = 0; i < User.Count - 1; i++)
{
write.WriteLine(User[i]);
}
write.Close();
}
catch (Exception ex)
{
status.status = "Error";
status.description = ex.Message;
}
}
status.status = "Success";
}
catch (Exception ex)
{
status.status = "Error";
status.description = ex.Message;
}
return status;
}
public static Data_PushBBVA.Status <string> ArchUserSetting()
{
Data_PushBBVA.Status <string> status = new Data_PushBBVA.Status <string>();
string Users = "";
int i = 0;
List <string> User = new List <string>();
string users = @"Select rut FROM dbo.Users WHERE status = 1";
try
{
using (SqlConnection conn = new SqlConnection(connectionString: conex))
{
SqlCommand command = new SqlCommand(users, conn);
conn.Open();
SqlDataAdapter daAdaptador = new SqlDataAdapter(command);
DataSet dtDatos = new DataSet();
daAdaptador.Fill(dtDatos);
foreach (DataRow _dr in dtDatos.Tables[0].Rows)
{
string user = _dr[0].ToString();
Users = user + ";";
try
{
string Types = @"SELECT * FROM dbo.NotificationType_Users NTU, dbo.Users U WHERE NTU.idUsers = U.idUsers AND U.rut = @rut";
using (SqlConnection conn2 = new SqlConnection(connectionString: conex))
{
SqlCommand command2 = new SqlCommand(Types, conn2);
command2.Parameters.AddWithValue("@rut", user);
conn2.Open();
SqlDataAdapter daAdaptador2 = new SqlDataAdapter(command2);
DataSet dtDatos2 = new DataSet();
daAdaptador2.Fill(dtDatos2);
foreach (DataRow _dr2 in dtDatos2.Tables[0].Rows)
{
if (_dr2[2].ToString() == "True")
{
Users += 1 + ";";
}
else
{
Users += 0 + ";";
}
}
}
}
catch (Exception ex)
{
status.status = "Error";
status.description = ex.Message;
}
User.Add(Users);
}
try
{
//i = 0;
List <string> reads = new List <string>();
//string[] reads = new string[i];
//StreamReader read;
StreamWriter write;
// read = new StreamReader("Z://setting.txt");
//
// while (!read.EndOfStream)
// {
// reads.Add(Convert.ToString(read.ReadLine()));
// // i++;
// }
// read.Close();
//
write = new StreamWriter("Z://setting.txt");
for (i = 0; i < User.Count - 1; i++)
{
write.WriteLine(User[i]);
}
write.Close();
}
catch (Exception ex)
{
status.status = "Error";
status.description = ex.Message;
}
}
status.status = "Success";
}
catch (Exception ex)
{
status.status = "Error";
status.description = ex.Message;
}
return(status);
}
