public DataTable GetVerification(string verify_code) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("@verify_code", verify_code, DbType.String); return(DbActions.GetTable(coll, "vom_company_get_verification", dp)); }
public DataTable GetCategory(Guid category_uuid) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("@category_uuid", category_uuid, DbType.Guid); return(DbActions.GetTable(coll, "vom_category_get", dp)); }
public DataTable GetCompanyUser(Guid user_uuid) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("@user_uuid", user_uuid, DbType.Guid); return(DbActions.GetTable(coll, "vom_company_getuser", dp)); }
public DataTable GetProjectUUID(Project obj) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("project_name", obj.project_name, DbType.String); return(DbActions.GetTable(coll, "vom_project_getuuid", dp)); }
public DataTable GetTask(Guid task_uuid) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("@task_uuid", task_uuid, DbType.Guid); return(DbActions.GetTable(coll, "vom_task_get", dp)); }
public DataTable GetAssignedTask(Guid emp_uuid) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("@emp_uuid", emp_uuid, DbType.Guid); return(DbActions.GetTable(coll, "vom_employee_getassignedtask", dp)); }
public DataTable GetCategoryUUID(Category obj) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("category_name", obj.category_name, DbType.String); return(DbActions.GetTable(coll, "vom_category_getuuid", dp)); }
public DataTable GetEmployeeDetails(Employees obj) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("email", obj.email, DbType.String); return(DbActions.GetTable(coll, "vom_employee_getdetails", dp)); }
public DataTable GetProject(Guid project_uuid) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("@project_uuid", project_uuid, DbType.Guid); return(DbActions.GetTable(coll, "vom_project_get", dp)); }
public DataTable ListEmployeeCount(Guid company_uuid) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("@company_uuid", company_uuid, DbType.String); return(DbActions.GetTable(coll, "vom_employee_count", dp)); }
public DataTable GetEmployee(Guid user_uuid) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("@user_uuid", user_uuid, DbType.Guid); return(DbActions.GetTable(coll, "vom_employee_get", dp)); }
public DataTable GetEmployeeUUID(Employees obj) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("emp_name", obj.emp_name, DbType.String); return(DbActions.GetTable(coll, "vom_employee_getuuid", dp)); }
//public DataTable EditEmployee(Employees obj) //{ // QueryParameterCollection coll = new QueryParameterCollection(); // coll.Add("uuid", obj.uuid, DbType.Guid); // coll.Add("emp_name", obj.emp_name, DbType.String); // coll.Add("emp_salary", obj.emp_salary, DbType.Int64); // coll.Add("email", obj.email, DbType.String); // coll.Add("password", obj.password, DbType.String); // coll.Add("emp_department", obj.emp_department, DbType.String); // coll.Add("emp_phone_number", obj.emp_phone_number, DbType.Int64); // coll.Add("emp_address", obj.emp_address, DbType.String); // DataTable dt = DbActions.GetTable(coll, "vom_employee_editprofile", dp); // return dt; //} public DataTable ListEmployee(Employees obj) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("company_uuid", obj.company_uuid, DbType.String); return(DbActions.GetTable(coll, "vom_employee_list", dp)); }
public DataTable RemoveCategory(string uuid) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("uuid", uuid, DbType.String); return(DbActions.GetTable(coll, "vom_category_remove", dp)); }
public DataTable ListCategory(Category obj) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("company_uuid", obj.company_uuid, DbType.String); return(DbActions.GetTable(coll, "vom_category_list", dp)); }
public DataTable SearchTask(string search_text, Guid emp_uuid) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("@search_text", search_text, DbType.String); coll.Add("@emp_uuid", emp_uuid, DbType.Guid); return(DbActions.GetTable(coll, "vom_task_search", dp)); }
public DataTable Verify(string verify_code, string ip_address) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("verify_code", verify_code, DbType.String); coll.Add("ip_address", ip_address, DbType.String); return(DbActions.GetTable(coll, "vom_company_verify", dp)); }
public DataTable Login(Company u) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("email", u.email, DbType.String); coll.Add("password", u.password, DbType.String); return(DbActions.GetTable(coll, "vom_company_login", dp)); }
public DataTable ResetPassword(Company u) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("new_password", u.new_password, DbType.String); coll.Add("verify_code", u.verify_code, DbType.String); return(DbActions.GetTable(coll, "vom_company_resetpassword", dp)); }
public DataTable GetTaskByFlag(string flag, Guid emp_uuid) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("@emp_uuid", emp_uuid, DbType.Guid); coll.Add("@flag", flag, DbType.String); return(DbActions.GetTable(coll, "vom_task_getbyflag", dp)); }
public DataTable ChangeEmpPassword(Employees u) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("uuid", u.uuid, DbType.Guid); coll.Add("old_password", u.password, DbType.String); coll.Add("new_password", u.new_password, DbType.String); return(DbActions.GetTable(coll, "vom_employee_changepassword", dp)); }
public DataTable EditCategory(Category obj) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("uuid", obj.uuid, DbType.Guid); coll.Add("category_name", obj.category_name, DbType.String); coll.Add("category_desc", obj.category_desc, DbType.String); return(DbActions.GetTable(coll, "vom_category_edit", dp)); }
public DataTable SaveCategory(Category obj) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("category_name", obj.category_name, DbType.String); coll.Add("category_desc", obj.category_desc, DbType.String); coll.Add("company_uuid", obj.company_uuid, DbType.String); DataTable dt = DbActions.GetTable(coll, "vom_category_save", dp); return(dt); }
public DataTable EditProfile(Company u) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("uuid", u.uuid, DbType.Guid); coll.Add("company_name", u.company_name, DbType.String); coll.Add("owner_name", u.owner_name, DbType.String); coll.Add("website_url", u.website_url, DbType.String); coll.Add("contact_number", u.contact_number, DbType.String); coll.Add("company_address", u.company_address, DbType.String); return(DbActions.GetTable(coll, "vom_company_editprofile", dp)); }
public DataTable EditEmpProfile(Employees u) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("uuid", u.uuid, DbType.Guid); coll.Add("emp_name", u.emp_name, DbType.String); coll.Add("emp_salary", u.emp_salary, DbType.Int64); coll.Add("emp_department", u.emp_department, DbType.String); coll.Add("emp_phone_number", u.emp_phone_number, DbType.Int64); coll.Add("emp_address", u.emp_address, DbType.String); return(DbActions.GetTable(coll, "vom_employee_editprofile", dp)); }
public void Company_Email_Verify(Company u) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("email", u.email, DbType.String); DataTable dt = DbActions.GetTable(coll, "vom_company_email_createverification", dp); DataRow r = dt.Rows[0]; if (dt.Columns.Contains("verify_code")) { sendEmail(u.email, "http://localhost:1156/verification.aspx?verify_code=" + r["verify_code"].ToString()); } }
public DataTable ForgetPassword(Company u) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("email", u.email, DbType.String); DataTable dt = DbActions.GetTable(coll, "vom_company_forgetpassword", dp); DataRow r = dt.Rows[0]; if (dt.Columns.Contains("verify_code")) { sendEmail(u.email, "http://localhost:1156/verification.aspx?verify_code=" + r["verify_code"].ToString()); } return(dt); }
public DataTable EditTask(Task obj) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("uuid", obj.uuid, DbType.Guid); coll.Add("task_name", obj.task_name, DbType.String); coll.Add("progress", obj.progress, DbType.String); coll.Add("status", obj.status, DbType.String); coll.Add("due_date", obj.due_date, DbType.Date); coll.Add("task_desc", obj.task_desc, DbType.String); DataTable dt = DbActions.GetTable(coll, "vom_task_edit", dp); return(dt); }
public DataTable EditProject(Project obj) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("uuid", obj.uuid, DbType.Guid); coll.Add("project_name", obj.project_name, DbType.String); coll.Add("budget", obj.budget, DbType.Decimal); coll.Add("status", obj.status, DbType.String); coll.Add("project_desc", obj.project_desc, DbType.String); coll.Add("end_date", obj.end_date, DbType.Date); coll.Add("category_uuid", obj.category_uuid, DbType.String); DataTable dt = DbActions.GetTable(coll, "vom_project_edit", dp); return(dt); }
public DataTable AddTask(Task obj) { QueryParameterCollection coll = new QueryParameterCollection(); coll.Add("task_name", obj.task_name, DbType.String); coll.Add("start_date", obj.start_date, DbType.Date); coll.Add("due_date", obj.due_date, DbType.Date); coll.Add("progress", obj.progress, DbType.String); coll.Add("status", obj.status, DbType.String); coll.Add("task_desc", obj.task_desc, DbType.String); coll.Add("project_uuid", obj.project_uuid, DbType.String); coll.Add("employee_uuid", obj.employee_uuid, DbType.String); coll.Add("assigner_uuid", obj.assigner_uuid, DbType.String); coll.Add("company_uuid", obj.company_uuid, DbType.String); DataTable dt = DbActions.GetTable(coll, "vom_task_save", dp); return(dt); }