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