Exemplo n.º 1
0
        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));
        }
Exemplo n.º 2
0
        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));
        }
Exemplo n.º 3
0
        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));
        }
Exemplo n.º 4
0
        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));
        }
Exemplo n.º 5
0
        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));
        }
Exemplo n.º 6
0
        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));
        }
Exemplo n.º 7
0
        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));
        }
Exemplo n.º 8
0
        public DataTable GetEmployeeDetails(Employees obj)
        {
            QueryParameterCollection coll = new QueryParameterCollection();

            coll.Add("email", obj.email, DbType.String);
            return(DbActions.GetTable(coll, "vom_employee_getdetails", dp));
        }
Exemplo n.º 9
0
        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));
        }
Exemplo n.º 10
0
        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));
        }
Exemplo n.º 11
0
        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));
        }
Exemplo n.º 12
0
        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));
        }
Exemplo n.º 13
0
        //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));
        }
Exemplo n.º 14
0
        public DataTable RemoveCategory(string uuid)
        {
            QueryParameterCollection coll = new QueryParameterCollection();

            coll.Add("uuid", uuid, DbType.String);
            return(DbActions.GetTable(coll, "vom_category_remove", dp));
        }
Exemplo n.º 15
0
        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));
        }
Exemplo n.º 16
0
        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));
        }
Exemplo n.º 17
0
        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));
        }
Exemplo n.º 18
0
        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));
        }
Exemplo n.º 19
0
        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));
        }
Exemplo n.º 20
0
        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));
        }
Exemplo n.º 21
0
        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));
        }
Exemplo n.º 22
0
        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));
        }
Exemplo n.º 23
0
        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);
        }
Exemplo n.º 24
0
        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));
        }
Exemplo n.º 25
0
        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));
        }
Exemplo n.º 26
0
        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());
            }
        }
Exemplo n.º 27
0
        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);
        }
Exemplo n.º 28
0
        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);
        }
Exemplo n.º 29
0
        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);
        }
Exemplo n.º 30
0
        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);
        }