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);
//string dbPath_companies = System.IO.Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), myCFID.ToString() + ".db3");
//var db_companies = new SQLiteConnection(dbPath_companies);
//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.favoritecompanieslistview_row, null, false);
}
TextView companyName = row.FindViewById <TextView>(Resource.Id.companyName);
ImageView companyLogo = row.FindViewById <ImageView>(Resource.Id.companyLogo);
LinearLayout info = row.FindViewById <LinearLayout>(Resource.Id.ll_info);
companyName.Text = mCompanies[position];
string fileName = companyName.Text.ToLower().Replace(" ", "");
int resourceId = (int)typeof(Resource.Drawable).GetField(fileName).GetValue(null);
companyLogo.SetImageResource(resourceId);
info.Click += (sender, e) =>
{
Android.Support.V4.App.FragmentTransaction trans = ((FragmentActivity)mContext).SupportFragmentManager.BeginTransaction();
CompanyInfoFragment fragment = new CompanyInfoFragment();
Bundle arguments = new Bundle();
arguments.PutInt("CompanyInt", mItems[position]);
arguments.PutString("Sender", "Profile");
fragment.Arguments = arguments;
trans.Replace(Resource.Id.profile_root_frame, fragment);
//trans.AddToBackStack(null);
trans.Commit();
};
return(row);
}
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);
}
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;
companyid = Convert.ToInt32(mCompanyIds[position]);
favoritesFileName = "fav_" + myCFID.ToString() + "_" + myAttributes.typeid.ToString();
if (row == null)
{
row = LayoutInflater.From(mContext).Inflate(Resource.Layout.companieslistview_row, null, false);
}
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);
TextView timeText = row.FindViewById <TextView>(Resource.Id.timeText);
TextView positionText = row.FindViewById <TextView>(Resource.Id.positionText);
companyName.Text = mItems[position];
string fileName = companyName.Text.ToLower().Replace(" ", "");
int resourceId = (int)typeof(Resource.Drawable).GetField(fileName).GetValue(null);
companyLogo.SetImageResource(resourceId);
timeText.Text = mTimes[position];
positionText.Text = mNumStudents[position];
isFavorite = mFavs[position];
if (isFavorite == true)
{
star.SetImageResource(Resource.Drawable.starfilled);
}
else if (isFavorite == false)
{
star.SetImageResource(Resource.Drawable.starunfilled);
}
q_ll.Click += (sender, e) =>
{
companyid = Convert.ToInt32(mCompanyIds[position]);
InputMethodManager imm = (InputMethodManager)mContext.ApplicationContext.GetSystemService(Context.InputMethodService);
imm.HideSoftInputFromWindow(q_ll.WindowToken, 0);
Android.Support.V4.App.FragmentTransaction trans = ((FragmentActivity)mContext).SupportFragmentManager.BeginTransaction();
Fragments.confirmQ fragment = new Fragments.confirmQ();
Bundle arguments = new Bundle();
arguments.PutInt("CompanyInt", companyid);
fragment.Arguments = arguments;
trans.Replace(Resource.Id.companies_root_frame, fragment);
trans.Commit();
};
favorite.Click += (sender, e) =>
{
companyid = Convert.ToInt32(mCompanyIds[position]);
InputMethodManager imm = (InputMethodManager)mContext.ApplicationContext.GetSystemService(Context.InputMethodService);
imm.HideSoftInputFromWindow(favorite.WindowToken, 0);
bool thisFavorite = mFavs[position];
if (thisFavorite == true)
{
star.SetImageResource(Resource.Drawable.starunfilled);
bool newFavorite = false;
mFavs[position] = false;
UpdateIsFavorite(newFavorite, companyid);
}
else if (thisFavorite == false)
{
star.SetImageResource(Resource.Drawable.starfilled);
bool newFavorite = true;
mFavs[position] = true;
UpdateIsFavorite(newFavorite, companyid);
}
};
companyInfo.Click += (sender, e) =>
{
companyid = Convert.ToInt32(mCompanyIds[position]);
InputMethodManager imm = (InputMethodManager)mContext.ApplicationContext.GetSystemService(Context.InputMethodService);
imm.HideSoftInputFromWindow(companyInfo.WindowToken, 0);
Android.Support.V4.App.FragmentTransaction trans = ((FragmentActivity)mContext).SupportFragmentManager.BeginTransaction();
CompanyInfoFragment fragment = new CompanyInfoFragment();
Bundle arguments = new Bundle();
arguments.PutInt("CompanyInt", companyid);
arguments.PutString("Sender", "Companies");
fragment.Arguments = arguments;
trans.Replace(Resource.Id.companies_root_frame, fragment);
trans.Commit();
};
return(row);
}
