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