public override View GetGroupView(int groupPosition, bool isExpanded, View convertView, ViewGroup parent)
{
//string headerTitle = (string)GetGroup(groupPosition);
ParentProductsModel group = GetProductGroup(groupPosition);
string headerTitle = group.ParentProductName;
convertView = convertView ?? _supportFragment.LayoutInflater.Inflate(Resource.Layout.products_fragment_items_list_item_parent, parent, false);
var lblListHeader = (TextView)convertView.FindViewById(Resource.Id.lblListHeader);
var cardViewItemImageHolder = (CardView)convertView.FindViewById(Resource.Id.cardViewItemImageHolder);
var txtItemAlias = convertView.FindViewById <TextView>(Resource.Id.txtItemAlias);
var txtParentProductId = (TextView)convertView.FindViewById(Resource.Id.txtParentProductId);
var rlEdit = (RelativeLayout)convertView.FindViewById(Resource.Id.rlEdit);
var imgEdit = (ImageView)convertView.FindViewById(Resource.Id.btnEditParentItem);
lblListHeader.Text = headerTitle;
txtParentProductId.Text = group.Id.ToString();
cardViewItemImageHolder.SetCardBackgroundColor(Android.Graphics.Color.ParseColor("#" + group.ProductColorBg));
txtItemAlias.Text = group.ProductAlias;
rlEdit.Click -= RlEdit_Click;
rlEdit.Click += RlEdit_Click;
imgEdit.Click -= ImgEdit_Click;
imgEdit.Click += ImgEdit_Click;
return(convertView);
}
public bool InsertIntoTable(ParentProductsModel row)
{
try
{
using (var connection = new SQLiteConnection(connectionString))
{
connection.Insert(row);
return(true);
}
}
catch (SQLiteException ex)
{
Log.Info("SQLiteEx", ex.Message);
return(false);
}
}
private ParentProductsModel ParentProductToSave(string _parentProductName, int _categoryId, string _categoryName,
string _productAlias, string _productColorBg, byte[] _productImage, string _productDescription)
{
ParentProductsModel parentProduct = new ParentProductsModel
{
ParentProductName = _parentProductName,
CategoryId = _categoryId,
CategoryName = _categoryName,
ProductColorBg = _productColorBg,
ProductAlias = _productAlias,
ProductImage = _productImage,
ProductDescription = _productDescription,
DateCreated = DateTime.Now.ToString(GlobalVariables.DATABASE_TIME_FORMAT),
DateModified = DateTime.Now.ToString(GlobalVariables.DATABASE_TIME_FORMAT)
};
return(parentProduct);
}
public bool UpdateTable(ParentProductsModel ParentProductsModel)
{
try
{
using (var connection = new SQLiteConnection(connectionString))
{
connection.Query <ParentProductsModel>("UPDATE ParentProductsModel set ParentProductName=?, CategoryId=?, " +
"CategoryName=?, ProductColorBg=?, ProductImage=?, ProductAlias=?, " +
"ProductDescription=?, DateModified=? Where Id=?",
ParentProductsModel.ParentProductName, ParentProductsModel.CategoryId, ParentProductsModel.CategoryName,
ParentProductsModel.ProductColorBg, ParentProductsModel.ProductImage, ParentProductsModel.ProductAlias,
ParentProductsModel.ProductDescription, ParentProductsModel.DateModified,
ParentProductsModel.Id);
return(true);
}
}
catch (SQLiteException ex)
{
Log.Info("SQLiteEx", ex.Message);
return(false);
}
}
