private void Drop_Click(object sender, EventArgs e)
{
string dbPath_attributes = System.IO.Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "attributes.db3");
SQLiteConnection db_attributes = new SQLiteConnection(dbPath_attributes);
MyAttributes myAttributes = db_attributes.Get <MyAttributes>(1);
string dbPath_login = System.IO.Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "user.db3");
SQLiteConnection db_login = new SQLiteConnection(dbPath_login);
string myCompanyQFilename = "qs_" + myAttributes.cfid.ToString() + "_" + myAttributes.attribute1 + ".db3";
string dbPath_myCompanyQ = System.IO.Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), myCompanyQFilename);
var db_myCompanyQ = new SQLiteConnection(dbPath_myCompanyQ);
int studentid = db_myCompanyQ.Get <SQLite_Tables.Queue>(1).studentid;
StudentTable thisStudentAttributes = db_login.Get <StudentTable>(studentid);
LoginTable thisStudentLogin = db_login.Query <LoginTable>("SELECT * FROM LoginTable WHERE email = ?", thisStudentAttributes.email).First();
string fileName_studentQ = "myqs_" + thisStudentLogin.cfid + "_" + thisStudentLogin.id + ".db3";
string dbPath_studentQ = System.IO.Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), fileName_studentQ);
var db_studentQ = new SQLiteConnection(dbPath_studentQ);
SQLite_Tables.MyQueue thisQ = db_studentQ.Query <SQLite_Tables.MyQueue>("SELECT * FROM MyQueue WHERE company = ?", myAttributes.attribute1).First();
int thisQid = thisQ.id;
int numStudentQs = db_studentQ.Table <SQLite_Tables.MyQueue>().Count();
db_studentQ.Delete <SQLite_Tables.MyQueue>(thisQ.id);
for (int i = thisQid; i <= numStudentQs - 1; i++)
{
SQLite_Tables.MyQueue currentEntry = db_studentQ.Get <SQLite_Tables.MyQueue>(i + 1);
SQLite_Tables.MyQueue newEntry = new SQLite_Tables.MyQueue();
newEntry.id = i;
newEntry.company = currentEntry.company;
newEntry.position = currentEntry.position;
db_studentQ.InsertOrReplace(newEntry);
}
db_studentQ.Delete <SQLite_Tables.MyQueue>(numStudentQs);
int numStudents = db_myCompanyQ.Table <SQLite_Tables.Queue>().Count();
db_myCompanyQ.Delete <SQLite_Tables.Queue>(1);
for (int i = 1; i <= numStudents - 1; i++)
{
SQLite_Tables.Queue newStudent = new SQLite_Tables.Queue();
newStudent.id = i;
newStudent.studentid = db_myCompanyQ.Get <SQLite_Tables.Queue>(i + 1).studentid;
db_myCompanyQ.InsertOrReplace(newStudent);
}
db_myCompanyQ.Delete <SQLite_Tables.Queue>(numStudents);
Android.Support.V4.App.FragmentTransaction trans = FragmentManager.BeginTransaction();
trans.Replace(Resource.Id.qs_root_frame, new QsFragment());
trans.Commit();
}
public override View GetView(int position, View convertView, ViewGroup parent)
{
row = convertView;
string dbPath_attributes = System.IO.Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "attributes.db3");
var db_attributes = new SQLiteConnection(dbPath_attributes);
var myAttributes = db_attributes.Get <MyAttributes>(1);
int myCFID = myAttributes.cfid;
string dbPath_login = System.IO.Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "user.db3");
var db_login = new SQLiteConnection(dbPath_login);
var loginQueryResults = db_login.Query <LoginTable>("SELECT * FROM LoginTable WHERE email = ?", myAttributes.email);
LoginTable myLogInInfo = loginQueryResults.First();
string favoritesFileName = "fav_" + myCFID.ToString() + "_" + myLogInInfo.id.ToString() + ".db3";
string dbPath_favorites = System.IO.Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), favoritesFileName);
var db_favorites = new SQLiteConnection(dbPath_favorites);
if (row == null)
{
row = LayoutInflater.From(mContext).Inflate(Resource.Layout.companieslistview_row, null, false);
}
string fileName_companies = myCFID.ToString() + ".db3";
string dbPath_companies = System.IO.Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), fileName_companies);
var db_companies = new SQLiteConnection(dbPath_companies);
int companyId = db_companies.Query <Companies>("SELECT * FROM Companies WHERE name = ?", mItems[position]).First().id;
TextView companyName = row.FindViewById <TextView>(Resource.Id.companyName);
ImageView companyLogo = row.FindViewById <ImageView>(Resource.Id.companyLogo);
LinearLayout companyInfo = row.FindViewById <LinearLayout>(Resource.Id.companyInfo);
LinearLayout favorite = row.FindViewById <LinearLayout>(Resource.Id.favorite);
LinearLayout q_ll = row.FindViewById <LinearLayout>(Resource.Id.q_ll);
ImageView star = row.FindViewById <ImageView>(Resource.Id.star);
q_ll.Enabled = false;
companyName.Text = mItems[position];
string fileName = companyName.Text.ToLower().Replace(" ", "");
int resourceId = (int)typeof(Resource.Drawable).GetField(fileName).GetValue(null);
companyLogo.SetImageResource(resourceId);
bool isFavorite = db_favorites.Get <SQLite_Tables.MyFavorites>(companyId).isFavorite;
if (isFavorite == true)
{
star.SetImageResource(Resource.Drawable.starfilled);
}
else if (isFavorite == false)
{
star.SetImageResource(Resource.Drawable.starunfilled);
}
favorite.Click += (sender, e) =>
{
//bool isFavorite = db_favorites.Get<SQLite_Tables.MyFavorites>(position + 1).isFavorite;
if (isFavorite == true)
{
SQLite_Tables.MyFavorites newIsFavorite = new SQLite_Tables.MyFavorites();
newIsFavorite.id = companyId;
newIsFavorite.isFavorite = false;
star.SetImageResource(Resource.Drawable.starunfilled);
isFavorite = false;
db_favorites.Update(newIsFavorite);
}
else if (isFavorite == false)
{
SQLite_Tables.MyFavorites newIsFavorite = new SQLite_Tables.MyFavorites();
newIsFavorite.id = companyId;
newIsFavorite.isFavorite = true;
star.SetImageResource(Resource.Drawable.starfilled);
isFavorite = true;
db_favorites.Update(newIsFavorite);
}
};
companyInfo.Click += (sender, e) =>
{
Android.Support.V4.App.FragmentTransaction trans = ((FragmentActivity)mContext).SupportFragmentManager.BeginTransaction();
CompanyInfoFragment fragment = new CompanyInfoFragment();
Bundle arguments = new Bundle();
arguments.PutInt("CompanyInt", companyId);
if (mSender == "CurrentQs")
{
arguments.PutString("Sender", "CurrentQs");
}
else if (mSender == "PastQs")
{
arguments.PutString("Sender", "PastQs");
}
fragment.Arguments = arguments;
trans.Replace(Resource.Id.qs_root_frame, fragment);
//trans.AddToBackStack(null);
trans.Commit();
};
return(row);
}
