public OrdersPage(Window owner, DatabaseLayer db) { _owner = owner; _db = db; InitializeComponent(); clientSelect.ItemsSource = db.GetClients().ToList(); }
public ObservableCollection <Account> GetAccountsLog(int start, int itemCount, bool ascending, out int totalItems) { List <Account> accountsLogList = DatabaseLayer.GetAccountLog(); ObservableCollection <Account> sortedAccountsLogList = new ObservableCollection <Account>(); sortedAccountsLogList = new ObservableCollection <Account> ( from p in accountsLogList orderby p.EntryDate descending select p ); totalItems = sortedAccountsLogList.Count; sortedAccountsLogList = ascending ? sortedAccountsLogList : new ObservableCollection <Account>(sortedAccountsLogList.Reverse()); ObservableCollection <Account> filteredProducts = new ObservableCollection <Account>(); for (int i = start; i < start + itemCount && i < totalItems; i++) { filteredProducts.Add(sortedAccountsLogList[i]); } return(filteredProducts); }
public MenuItemDetailWindow(DatabaseLayer db, MenuItem menuItem) { InitializeComponent(); _menuItem = menuItem; _db = db; LoadData(); }
public void CreateDbSqliteTest() { DatabaseLayer.Init(dbPath); ColumnsDB c = new ColumnsDB(SloupecDB.CI(TypeAffinity.Int64, ID), SloupecDB.CI(TypeAffinity.Int64, value)); SQLiteCommand comm = c.GetSqlCreateTable(tableName); if (comm.CommandText != null) { comm.ExecuteNonQuery(); } long first = 1; long second = 2; StoredProceduresSqliteI.ci.Insert4(tableName, 0, 1); StoredProceduresSqliteI.ci.Insert4(tableName, 2, 3); var dt = StoredProceduresSqliteI.ci.GetDataTableAllRows(tableName); Assert.Equal(first, dt.Rows[0][1]); Assert.Equal(second, dt.Rows[1][0]); }
public ClientDetailWindow(DatabaseLayer db, Client client) { InitializeComponent(); _client = client; _db = db; LoadData(); }
public List<Post> GetPosts(string emailAddress) { List<Post> lstPosts = new List<Post>(); using (DatabaseLayer dbLayer = new DatabaseLayer()) { SqlCommand cmd = new SqlCommand("GetPosts"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@emailAddress", emailAddress); DataSet postDataset = dbLayer.FillDataSet(cmd); if (postDataset != null && postDataset.Tables.Count > 0) { foreach (DataRow row in postDataset.Tables[0].Rows) { Post post = new Post(); post.Id = Convert.ToInt32(row["Id"].ToString()); post.Message = row["Message"].ToString(); post.CreatedOn = Convert.ToDateTime(row["CreatedOn"].ToString()); post.CreatedByString = row["CreatedByString"].ToString(); post.CreatedBy = Convert.ToInt32(row["CreatedBy"].ToString()); lstPosts.Add(post); } } } return lstPosts; }
public OrderDetailWindow(DatabaseLayer db, Client forClient) { InitializeComponent(); _db = db; _forClient = forClient; date.SelectedDate = DateTime.Now.Date; }
public void getUserData(string queryoption) { DataSet data = null; string query = ""; try { DatabaseLayer dataObj = new DatabaseLayer(); if (queryoption.Equals("all")) { query = "select id as 'S.No',username as 'User Name' from userquestionanswers"; } else { string liekquery = QASecurity.Encryptdata(queryoption); query = "select id as 'S.No',username as 'User Name' from userquestionanswers where username like '%" + liekquery + "%'"; } data = dataObj.getTableDataGrid(query); if (data != null) { GridView1.DataSource = data; GridView1.DataBind(); } else { GridView1.DataSource = data; GridView1.DataBind(); } } catch (Exception er) { } }
public TerminalServicePage(Window owner, DatabaseLayer db) { _owner = owner; _db = db; InitializeComponent(); ReloadData(); }
public SubAppsPage(Window owner, DatabaseLayer db) { _owner = owner; InitializeComponent(); this.db = db; LoadData(); }
public User GetUser(string emailAddress, out string password) { User user = null; using (DatabaseLayer dbLayer = new DatabaseLayer()) { SqlCommand sqlCmd = new SqlCommand("GetUser"); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@emailAddress", emailAddress); user = new User(); DataSet dataSet = dbLayer.FillDataSet(sqlCmd); user.EmailAddress = dataSet.Tables[0].Rows[0]["EmailAddress"].ToString(); user.CreatedOn = Convert.ToDateTime(dataSet.Tables[0].Rows[0]["CreatedOn"].ToString()); user.DOB = Convert.ToDateTime(dataSet.Tables[0].Rows[0]["DOB"].ToString()); user.FirstName = dataSet.Tables[0].Rows[0]["FirstName"].ToString(); user.Gender = dataSet.Tables[0].Rows[0]["Gender"].ToString(); user.Id = Convert.ToInt32(dataSet.Tables[0].Rows[0]["Id"].ToString()); user.LastLoggedIn = Convert.ToDateTime(dataSet.Tables[0].Rows[0]["LastLoggedIn"].ToString()); user.LastName = dataSet.Tables[0].Rows[0]["LastName"].ToString(); user.ProfilePicPath = dataSet.Tables[0].Rows[0]["ProfilePicPath"].ToString(); password = dataSet.Tables[0].Rows[0]["Password"].ToString(); } return user; }
public bool sendSMSDetails(string username) { try { //generate random string string otpstr = RandomString(6); SMSRequest smsObj = new SMSRequest(); DatabaseLayer dbObj = new DatabaseLayer(); string mobileno = getuserMobileNo(username); SSAErrorLog logObj = new SSAErrorLog(); if (mobileno != null) { string query = "delete from userotp where username='******'"; logObj.ErrorLog(ConfigurationManager.AppSettings["logfilepath"].ToString(), "query delete " + query); dbObj.deleteTableData(query); string str = String.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now); dbObj.insertTableData("insert into userotp (username,otp,otpcreatedatetime,otpactivate) values ('" + QASecurity.Encryptdata(username) + "','" + otpstr + "','" + String.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now) + "' , 0) "); //insert into db //send SMS smsObj.sendSMS(mobileno, ConfigurationManager.AppSettings["otpmessage"].ToString() + " " + otpstr); return(true); } else { return(false); } } catch (Exception er) { return(false); } }
public ClientsPage(Window owner, DatabaseLayer db) { _owner = owner; _db = db; InitializeComponent(); ReloadData(); }
public newRelation() { InitializeComponent(); var dt = new DataTable(); studentList.ItemsSource = DatabaseLayer.FillStudentList().DefaultView; parentList.ItemsSource = DatabaseLayer.FillParentList().DefaultView; }
private void button_createRelation(object sender, RoutedEventArgs e) { if (studentId == 0 || parentId == 0) { MessageBox.Show("Please select parent or student"); } DatabaseLayer.createRelation(studentId, parentId); }
public MenuPage(Window owner, DatabaseLayer db) { _owner = owner; _db = db; InitializeComponent(); _forDate = DateTime.Now.Date; LoadData(); }
public ActionResult <string> Get(Guid id) { using (DatabaseLayer db = new DatabaseLayer()) { var game = db.Games.First((g) => g.Id == id); return(Ok(game)); } }
public ActionResult <IEnumerable <string> > Get() { using (DatabaseLayer db = new DatabaseLayer()) { var games = db.Games.ToList(); return(Ok(games)); } }
public ActionResult <string> Get(int id) { using (DatabaseLayer db = new DatabaseLayer()) { var user = db.Users.First((u) => u.Id == id); return(Ok(user)); } }
public ActionResult <IEnumerable <string> > Get() { using (DatabaseLayer db = new DatabaseLayer()) { var users = db.Users.ToList(); return(Ok(users)); } }
public SubAppDetailWindow(MyApplication app, DatabaseLayer db) { InitializeComponent(); _app = app; _db = db; ReloadData(); //AppDevicesDataGrid.Columns[0].Visibility = Visibility.Collapsed; }
private void deleteButton_Clicked(object sender, RoutedEventArgs e) { MessageBoxResult messageBoxResult = MessageBox.Show("Are you sure?", "Delete Confirmation Dialog Box", MessageBoxButton.YesNo); if (messageBoxResult == MessageBoxResult.No) { return; } DataRowView row = respectivePersonList.SelectedItem as DataRowView; if (row == null) { return; } selected_id = (int)row.Row.ItemArray[0]; if (selected_person_type == "Student" || selected_person_type == "resStudent") { DatabaseLayer.deleteStudent(selected_id); } else if (selected_person_type == "Parent" || selected_person_type == "resParent") { DatabaseLayer.deleteParent(selected_id); } /** * if (selection == "main") * { * if (personType == "Student") * { * DatabaseLayer.deleteEntry(studentID, personType); * personList.ItemsSource = DatabaseLayer.FillStudentList().DefaultView; * return; * } * if (personType == "Parent") * { * DatabaseLayer.deleteEntry(parentID, personType); * personList.ItemsSource = DatabaseLayer.FillParentList().DefaultView; * personList.ItemsSource = Parent; * return; * } * } * else if (selection == "respective") * { * if (respectivePersonType == "Student") * { * DatabaseLayer.deleteEntry(studentID, personType); * respectivePersonList.ItemsSource = DatabaseLayer.getRespectiveStudentFromDatabase(parentID).DefaultView; * } * if (respectivePersonType == "Parent") * { * DatabaseLayer.deleteEntry(parentID, personType); * respectivePersonList.ItemsSource = DatabaseLayer.getRespectiveParentFromDatabase(studentID).DefaultView; * } * } **/ }
public InformTerminalService(List <Device> devices, MyApplication app, DatabaseLayer dbLayer) : base(app, dbLayer) { if (devices.Count != 1) { throw new ArgumentOutOfRangeException(); } Rallo = new Rallo(this); Rallo.Connect(devices[0].IP, devices[0].Port); }
public void GetDataFromFileTest() { DatabaseLayer.Init(dbPath); var expected = 1; var actual = StoredProceduresSqliteI.ci.GetValueColumnInt(tableName, value, ID, 0); Assert.Equal(expected, actual[0]); }
public GameResultResponseModel PostRound(GameResultRequestModel angularGameRequest) { GameResultResponseModel GameResponse = new GameResultResponseModel(angularGameRequest); var dbl = new DatabaseLayer(); dbl.insertTurn(this.connectionString, GameResponse.DateTimeStarted, GameResponse.Username, GameResponse.roundLimit, GameResponse.roundCounter, GameResponse.Outcome, GameResponse.PlayerChoice, GameResponse.CpuChoice); return(GameResponse); }
public Form1( ) { InitializeComponent( ); Messager.Caption = this.Text; if (!DatabaseLayer.IsDataAccessSettingsValid( )) { MessageBox.Show("Database settings is not valid. Please run the PACS Database Configuration Demo.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } _source = new WorklistDataSource( ); _databaseLayer = new DatabaseLayer(_source); _iodPath = Application.StartupPath; _iodPath = Path.Combine(_iodPath, "CustomMWLIOD.xml"); using (Stream iodStream = MWLCFindCommand.DefualtMWLIOD) { using (FileStream customIODStream = new FileStream(_iodPath, FileMode.Create)) { CopyTo(iodStream, customIODStream); } } _source.DatabaseTags.Add(new DatabaseDicomTags("Visit", "ServiceEpisodeDescription", DicomTag.ServiceEpisodeDescription)); _source.DatabaseTags.Add(new DatabaseDicomTags("ScheduledProcedureStep", "CommentsOnTheScheduledProcedureStep", DicomTag.CommentsOnTheScheduledProcedureStep)); _source.DatabaseTags.Add(new DatabaseDicomTags("Patient", "SmokingStatus", DicomTag.SmokingStatus)); _worklistAgent = _databaseLayer.GetWorklistDataAgent( ); DataAccessServices.RegisterDataAccessService <IWorklistDataAccessAgent> (_worklistAgent); databaseStatus1.ConnectionString = _databaseLayer.ConnectionString; databaseStatus1.ProviderName = _databaseLayer.Provider; dicomTags1.SetSource(_source.DatabaseTags); worklistUpdate1.SetSource(_source.DatabaseTags); dicomQuery1.SetSource(_source.DatabaseTags, _iodPath); if (_databaseLayer.IsDatabaseUpdated()) { try { WorklistIODUpdater.UpdateIOD(_source.DatabaseTags, _iodPath); } catch (Exception exception) { Messager.ShowError(this, "Error Updating the Modality Work-list IOD document.\n" + exception); } } UpdateDatabaseButton.Click += new EventHandler(UpdateDatabaseButton_Click); }
public MenuDetailWindow(DatabaseLayer db, DateTime forDate) { InitializeComponent(); _db = db; _menu = new Menu() { ForDate = forDate }; LoadData(); }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { DatabaseLayer dataObj = new DatabaseLayer(); string autoid = GridView1.Rows[e.RowIndex].Cells[1].Text; if (dataObj.deleteTableData("delete from userquestionanswers where id='" + autoid + "'")) { getUserData("all"); } }
public IActionResult Delete(int id) { var eventToDelete = DatabaseLayer.GetEventById(id); if (eventToDelete == null) { return(NotFound()); } return(View(eventToDelete)); }
public IActionResult Add(Event @event) { if (!TryValidateModel(@event)) { return(View("New", @event)); } DatabaseLayer.AddEvent(@event, 3); return(RedirectToAction("Index")); }
public IActionResult DeleteSurvey(int id) { Survey survey = DatabaseLayer.GetSurveyById(id); if (survey == null) { return(NotFound()); } return(View(survey)); }
public IActionResult Show(int id) { Event surveyEvent = DatabaseLayer.GetEventById(id); if (surveyEvent == null) { return(NotFound()); } return(View(surveyEvent)); }
public User UpdateUserInfo(int userId,string lastName,string firstName,string profilePicPath) { User user = null; using (DatabaseLayer dbLayer = new DatabaseLayer()) { SqlCommand sqlCmd = new SqlCommand("UpdateUserInfo"); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@id", userId); sqlCmd.Parameters.AddWithValue("@lastName", lastName); sqlCmd.Parameters.AddWithValue("@firstName", firstName); sqlCmd.Parameters.AddWithValue("@profilePic", profilePicPath); user = new User(); DataSet dataSet = dbLayer.FillDataSet(sqlCmd); user.EmailAddress = dataSet.Tables[0].Rows[0]["EmailAddress"].ToString(); user.CreatedOn = Convert.ToDateTime(dataSet.Tables[0].Rows[0]["CreatedOn"].ToString()); user.FirstName = dataSet.Tables[0].Rows[0]["FirstName"].ToString(); user.Id = Convert.ToInt32(dataSet.Tables[0].Rows[0]["Id"].ToString()); user.LastLoggedIn = Convert.ToDateTime(dataSet.Tables[0].Rows[0]["LastLoggedIn"].ToString()); user.LastName = dataSet.Tables[0].Rows[0]["LastName"].ToString(); user.ProfilePicPath = dataSet.Tables[0].Rows[0]["ProfilePicPath"].ToString(); } return user; }