static void GetConnectionString() { try { string dbpath = ConfigurationSettings.AppSettings["db"].ToString(); string strConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + dbpath + ";Persist Security Info=False;"; oConn = new OleDbConnection(strConnectionString); } catch (Exception ex) { logger.Log(((System.Data.OleDb.OleDbException)(ex)).Message, MessageType.Error); } finally { oConn.Close(); } }
void GetImageTempate() { try { string LogoPath = ConfigurationSettings.AppSettings["SchoolLogo"].ToString(); LogoPath = LogoPath + Common.ClientLogo; this.ImageSource = BitmapFrame.Create(new Uri(LogoPath), BitmapCreateOptions.None, BitmapCacheOption.OnLoad); } catch (Exception ex) { logger.Log(ex.StackTrace, MessageType.Error); } }
public MainViewModel(string userid) { TabItemSource = new ObservableCollection <TabDataModel>(); logger = Helpers.Logger.IntializeLogger(); //string sql = "select m.application_id,a.applicationname,m.user_id,a.imagepath,u.Name from applicationmapping m, applications a, users u"; //sql += " where m.application_id=a.id"; //sql += " and m.user_id=u.id and u.id=" + userid + " order by SortOrder"; string sql = "exec ims.imsUserAppMapping " + userid + "," + 25; DataTable dtResult = DataAccess.DAL.Select(sql); if (dtResult != null && dtResult.Rows.Count > 0) { UserName = "******" + dtResult.Rows[0]["Name"].ToString(); Common.LoggedInUserID = dtResult.Rows[0]["User_ID"].ToString(); foreach (DataRow dr in dtResult.Rows) { ButtonDataModel obj = new ButtonDataModel(dr["ApplicationName"].ToString(), new DelegateCommand(OnRenderForm), new string[] { dr["ApplicationName"].ToString() }, dr["ImagePath"].ToString()); MyData.Add(obj); } } this.ClientNAme = Common.ClientName; this.AcademicYear = Common.AcademicYear; this.ConnectedTo = "Connected To " + DataAccess.DAL.oConn.DataSource; // string[] arr = new string[] { "Letter" }; OnRenderForm(null); try { download(); } catch (Exception ex) { logger.Log(ex.StackTrace, MessageType.Error); } }
static void GetConnectionString() { try { // string dbpath = ConfigurationSettings.AppSettings["db"].ToString(); //string strConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + dbpath + ";Persist Security Info=False;"; //string strConnectionString= "Data Source = moskit.database.windows.net; Initial Catalog = moskitdb; Persist Security Info = True; User ID=moskitadmin@moskit;Password=pwdsql@4712;"; //string strConnectionString = @"Data Source=DELL\SQLEXPRESS;Initial Catalog=moskitdb;Integrated Security=True;"; string strConnectionString = ConfigurationSettings.AppSettings["ConnectionString"].ToString(); //string strConnectionString = "Server=tcp:moskit.database.windows.net,1433;Database=moskitdb;User ID=moskitadmin@moskit;Password=pwdsql@4712;Encrypt=True;TrustServerCertificate=true;Connection Timeout=30;"; oConn = new SqlConnection(strConnectionString); logger.Log("Connecting Server :" + oConn.DataSource, MessageType.Debug); logger.Log("Connecting Database :" + oConn.Database, MessageType.Debug); } catch (Exception ex) { logger.Log(((SqlException)(ex)).Message, MessageType.Error); } finally { //oConn.Close(); } }