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); } } }