public ReturnClass.ReturnDataTable delete_action(bl_Action bl)
{
string str = "delete FROM ddl_list where DDL_List_ID=@DDL_List_ID";
MySqlParameter[] pm = new MySqlParameter[]{
new MySqlParameter("DDL_List_ID",bl.DDL_List_ID)
};
rd = db.executeSelectQuery(str,pm);
return rd;
}
public ReturnClass.ReturnDataTable select_admin_info(bl_Action bl)
{
string str = @"select lo.UserID, emp.Name_en, emp.state_id,emp.base_department_id, emp.NewOfficeCode,
emp.district_id,lo.RollID from login lo
inner join employee_table emp on emp.emp_id=lo.LoginID
where lo.UserID=@user";
MySqlParameter[] pm = new MySqlParameter[]{
new MySqlParameter("user",bl.Userid)
};
rd = db.executeSelectQuery(str, pm);
return rd;
}
public ReturnClass.ReturnBool insertAction(bl_Action bl)
{
string str = "insert into ddl_list(DDL_List_ID,DDL_Name_Value,DisplayName_en,Remarks,DisplayOrder,Category) values(@Ddl_id,@DDL_Name_Value,@ActionName,@Remarks,@DisplayOrder,@Category)";
MySqlParameter[] pm = new MySqlParameter[]{
new MySqlParameter("Ddl_id",bl.Ddl_id),
new MySqlParameter("DDL_Name_Value",bl.DDL_Name_Value),
new MySqlParameter("ActionName",bl.Actionname),
new MySqlParameter("Remarks",bl.Remark),
new MySqlParameter("DisplayOrder",bl.DisplayOrder),
new MySqlParameter("Category",bl.Category)
};
rb = db.executeInsertQuery(str, pm);
return rb;
}