//public static int getrightnumber() //{ // string username = Utils.getusername(); // string connection_string = Utils.getConnectionstr(); // LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); // var rs = (from tbl_Temp in dc.tbl_Temps // where tbl_Temp.username == username // select tbl_Temp.userright).FirstOrDefault(); // if (rs == null) // { // return 0; // } // else // { // return rs.Value; // } //} public static string getConnectionstr() { String current = System.IO.Directory.GetCurrentDirectory(); string fileName = current + "\\Connectstring.txt"; string connection_string = ""; const Int32 BufferSize = 128; string line; Model.SercurityFucntion bm2 = new Model.SercurityFucntion(); line = bm2.Readtextfromfile(fileName); string line2 = bm2.Decryption(line); string[] parts = line2.Split(';'); string st1 = parts[0].Trim(); string st2 = parts[1].Trim(); string st3 = parts[2].Trim(); string st4 = parts[3].Trim(); connection_string = ("Data Source =" + st1 + "; Initial Catalog = " + st4 + "; User Id =" + st2 + "; Password ="******"Data Source =" + st1 + "; Initial Catalog = ARconfirmationletter; User Id =" + st2 + "; Password =" + st3).Trim(); return(connection_string); }
public static string getDatalocate() { String current = System.IO.Directory.GetCurrentDirectory(); string fileName = current + "\\Connectstring.txt"; const Int32 BufferSize = 128; using (var fileStream = File.OpenRead(fileName)) using (var streamReader = new StreamReader(fileStream, Encoding.UTF8, true, BufferSize)) { string line; string st5; while ((line = streamReader.ReadLine()) != null) { Model.SercurityFucntion bm2 = new Model.SercurityFucntion(); // line = bm2.Readtextfromfile(fileName); string line2 = bm2.Decryption(line); // string s1 = st1 + ";" + st2 + ";" + st3 + ";" + st4 + ";" + txtusername.Text; string[] parts = line2.Split(';'); if (parts.Count() >= 5) { st5 = parts[3].Trim(); } else { st5 = ""; } // string st1 = parts[0].Trim(); // string st2 = parts[1].Trim(); // string st3 = parts[2].Trim(); string datalocate = st5.ToUpper(); return(datalocate); } return(""); } }