void fillGrip() { var ArrayCategory = DaoCategory.GetCatagory(); DataTable dt = new DataTable(); try { dt.TableName = "localVehicleDetails"; foreach (PropertyInfo property in ArrayCategory[0].GetType().GetProperties()) { dt.Columns.Add(new DataColumn(property.Name, property.PropertyType)); } foreach (var i in ArrayCategory) { DataRow newRow = dt.NewRow(); foreach (PropertyInfo property in i.GetType().GetProperties()) { newRow[property.Name] = i.GetType().GetProperty(property.Name).GetValue(i, null); } dt.Rows.Add(newRow); } dataGridView1.DataSource = dt; } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private void buttonAdd_Click(object sender, EventArgs e) { string name = textBoxName.Text.Trim(); string description = textBoxDescription.Text.Trim(); DaoCategory.InsertCategory(name, description); MessageBox.Show("done!"); fillGrip(); }
private void buttonEdit_Click(object sender, EventArgs e) { foreach (DataGridViewRow row in dataGridView1.Rows) { int id = Convert.ToInt32(row.Cells[0].Value.ToString()); string name = row.Cells[1].Value.ToString(); string description = row.Cells[2].Value.ToString(); DaoCategory.EditCategory(id, name, description); } MessageBox.Show("done!"); }
private void deleteButton_Click(object sender, EventArgs e) { int id1 = 110; foreach (DataGridViewRow row in dataGridView1.SelectedRows) { int id = Convert.ToInt32(row.Cells[0].Value.ToString()); id1 = id; DaoCategory.DeleteCategory(id); } fillGrip(); MessageBox.Show("done!" + id1); }
public ReturnObject GetCategoryByID(string CategoryId) { ReturnObject obj = new ReturnObject(); try { DaoCategory daoCategory = new DaoCategory(tWG_ACHECKContext); var lsCategory = daoCategory.GetCategoriesByID(CategoryId); obj.status = 1; obj.value = lsCategory; } catch (Exception ex) { obj.status = -1; obj.message = ex.StackTrace; } return(obj); }
public ReturnObject Get() { ReturnObject obj = new ReturnObject(); try { DaoCategory daoCategory = new DaoCategory(tWG_ACHECKContext); var result = daoCategory.Get(); obj.status = 1; obj.value = result; } catch (Exception ex) { obj.status = -1; obj.message = ex.StackTrace; } return(obj); }
public ReturnObject CheckCategoryCode(string CategoryCode) { ReturnObject obj = new ReturnObject(); obj.status = -1; try { DaoCategory daoCategory = new DaoCategory(tWG_ACHECKContext); var result = daoCategory.CheckUniqueCategoryCode(CategoryCode, ""); obj.status = 1; obj.value = result; } catch (Exception ex) { obj.status = -1; obj.message = ex.StackTrace; } return(obj); }
public ReturnObject GetCategoriesByKeyWord(string keyWord) { ReturnObject obj = new ReturnObject(); obj.status = -1; try { object result = new object(); DaoCategory daoCategory = new DaoCategory(tWG_ACHECKContext); if (!string.IsNullOrEmpty(keyWord)) { result = daoCategory.GetCategoriesByKeyWord(keyWord); } obj.status = 1; obj.value = result; } catch (Exception ex) { obj.status = -1; obj.message = ex.StackTrace; } return(obj); }
public async Task <ReturnObject> ArrangeCategory(List <ModelViews.ViewArrangeCategory> lsentity) { ReturnObject obj = new ReturnObject(); obj.status = -1; try { DaoCategory daoCategory = new DaoCategory(tWG_ACHECKContext); int result = await daoCategory.ArrangeCategory(lsentity); if (result > 0) { obj.status = 1; } obj.value = result; } catch (Exception ex) { obj.status = -1; obj.message = ex.StackTrace; } return(obj); }
public async Task <ReturnObject> UpdateCategory(string CategoryId) { ReturnObject obj = new ReturnObject(); obj.status = -1; try { DaoCategory daoCategory = new DaoCategory(tWG_ACHECKContext); int result = await daoCategory.DeleteCategory(CategoryId); if (result > 0) { obj.status = 1; } obj.value = result; } catch (Exception ex) { obj.status = -1; obj.message = ex.StackTrace; } return(obj); }
public async Task <ReturnObject> Update(ViewAddCategory entity) { ReturnObject obj = new ReturnObject(); obj.status = -1; try { DaoCategory daoCategory = new DaoCategory(tWG_ACHECKContext); var result = await daoCategory.Update(entity); if (result > 0) { obj.status = 1; } obj.value = result; } catch (Exception ex) { obj.status = -1; obj.message = ex.StackTrace; } return(obj); }