private void loadXls(string file)
{
numberProps.Clear();
string con= "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + file + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;\"";
using(OleDbConnection connection = new OleDbConnection(con))
{
connection.Open();
OleDbCommand command = new OleDbCommand("select * from [whatsAppShowePermissions3$]", connection);
using(OleDbDataReader dr = command.ExecuteReader())
{
while(dr.Read())
{
string phoneNumber = "";
bool isCanShowText = true;
bool isCanShowImg = true;
int textNumberInSeconde = 0;
int imgNumberInSeconde = 0;
long lastTextMsg = 0;
long lastImgMsg = 0;
if (dr.FieldCount > 0)
{
phoneNumber = dr.GetString(0);
}
if (dr.FieldCount > 1 && !dr.IsDBNull(1))
{
if ("false".Equals(dr.GetString(1), StringComparison.InvariantCultureIgnoreCase))
{
isCanShowText = false;
}
}
if (dr.FieldCount > 2 && !dr.IsDBNull(2))
{
int i = 0;
string s = dr.GetString(2);
bool result = int.TryParse(s, out i);
if (result)
{
textNumberInSeconde = i;
}
}
if (dr.FieldCount > 3 && !dr.IsDBNull(3))
{
int i = 0;
string s = dr.GetString(3);
bool result = int.TryParse(s, out i);
if (result)
{
lastTextMsg = i;
}
}
if (dr.FieldCount > 4 && !dr.IsDBNull(4))
{
if ("false".Equals(dr.GetString(4), StringComparison.InvariantCultureIgnoreCase))
{
isCanShowImg = false;
}
}
if (dr.FieldCount > 6 && !dr.IsDBNull(6))
{
int i = 0;
string s = dr.GetString(4);
bool result = int.TryParse(s, out i);
if (result)
{
lastTextMsg = i;
}
}
if (dr.FieldCount > 5 && !dr.IsDBNull(5))
{
int i = 0;
string s = dr.GetString(6);
bool result = int.TryParse(s, out i);
if (result)
{
imgNumberInSeconde = i;
}
}
NumberProp numberProp = new NumberProp();
numberProp.PhoneNumber = phoneNumber;
numberProp.IsCanShowText = isCanShowText;
numberProp.IsCanShowImg = isCanShowImg;
numberProp.TextNumberIsSeconde = textNumberInSeconde;
numberProp.ImgNumberIsSeconde = imgNumberInSeconde;
numberProp.LastTextMsg = lastTextMsg;
numberProp.LastImgMsg = lastImgMsg;
NumberProps.Add(numberProp);
}
}
}
}
void loadCvs(string fullPathfileName)
{
numberProps.Clear();
var reader = getCvsReader(fullPathfileName);
if (reader == null)
{
return;
}
while (!reader.EndOfStream)
{
var line = reader.ReadLine();
var values = line.Split(',');
if (values != null)
{
string phoneNumber = "";
bool isCanShowText = true;
bool isCanShowImg = true;
int textNumberInSeconde = 0;
int imgNumberInSeconde = 0;
long lastTextMsg = 0;
long lastImgMsg = 0;
if (values.Length > 0)
{
phoneNumber = values[0];
}
if (values.Length > 1)
{
if ("false".Equals(values[1], StringComparison.InvariantCultureIgnoreCase))
{
isCanShowText = false;
}
}
if (values.Length > 2)
{
int i = 0;
string s = values[2];
bool result = int.TryParse(s, out i);
if (result)
{
textNumberInSeconde = i;
}
}
if (values.Length > 3)
{
int i = 0;
string s = values[3];
bool result = int.TryParse(s, out i);
if (result)
{
lastTextMsg = i;
}
}
if (values.Length > 4)
{
if ("false".Equals(values[4], StringComparison.InvariantCultureIgnoreCase))
{
isCanShowImg = false;
}
}
if (values.Length > 6)
{
int i = 0;
string s = values[4];
bool result = int.TryParse(s, out i);
if (result)
{
lastTextMsg = i;
}
}
if (values.Length > 5)
{
int i = 0;
string s = values[6];
bool result = int.TryParse(s, out i);
if (result)
{
imgNumberInSeconde = i;
}
}
NumberProp numberProp = new NumberProp();
numberProp.PhoneNumber = phoneNumber;
numberProp.IsCanShowText = isCanShowText;
numberProp.IsCanShowImg = isCanShowImg;
numberProp.TextNumberIsSeconde = textNumberInSeconde;
numberProp.ImgNumberIsSeconde = imgNumberInSeconde;
numberProp.LastTextMsg = lastTextMsg;
numberProp.LastImgMsg = lastImgMsg;
NumberProps.Add(numberProp);
}
}
}
