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