Example #1
0
        public int Insert(string IDEA_ID, string EMP_ID, string EMP_NAME)
        {
            //string ID = this.GenerateId();
            var sql = "INSERT INTO PRJ_LIKE(IDEA_ID,EMP_ID,EMP_NAME,INS_DATE) VALUES(@IDEA_ID,@EMP_ID,@EMP_NAME,GETDATE())";

            return(DBManager <PRJ_LIKE> .Execute(sql, new { IDEA_ID = IDEA_ID, EMP_ID = EMP_ID, EMP_NAME = EMP_NAME }));
        }
Example #2
0
        public override int Insert(string EMP_ID, string IDEA_TITLE, string DETAIL, string QUANTITATIVE, string QUALITATIVE)
        {
            var ID  = this.GenerateId();
            var sql = "INSERT INTO IDEA(ID,EMP_ID,IDEA_TITLE,DETAIL,QUANTITATIVE,QUALITATIVE,DATE) VALUES(@ID,@EMP_ID,@IDEA_TITLE,@DETAIL,@QUANTITATIVE,@QUALITATIVE,GETDATE())";

            return(DBManager <IDEA> .Execute(sql, new { ID = ID, EMP_ID = EMP_ID, IDEA_TITLE = IDEA_TITLE, DETAIL = DETAIL, QUANTITATIVE = QUANTITATIVE, QUALITATIVE = QUALITATIVE }));
        }
Example #3
0
        public int InsertPlan(string IDEA_ID, string PLAN_CONTENTS, DateTime PLAN_DATE, int COMPLETE_YN, DateTime COMPLETE_DATE)
        {
            var ID  = GenerateId();
            var sql = "INSERT INTO PROJECT_PLAN(ID,IDEA_ID,PLAN_CONTENTS,PLAN_DATE,COMPLETE_YN, COMPLETE_DATE) VALUES(@ID,@IDEA_ID,@PLAN_CONTENTS,@PLAN_DATE,@COMPLETE_YN, @COMPLETE_DATE)";

            DynamicParameters parameter = new DynamicParameters();

            parameter.Add("@ID", ID, DbType.String, ParameterDirection.Input);
            parameter.Add("@IDEA_ID", IDEA_ID, DbType.String, ParameterDirection.Input);
            parameter.Add("@PLAN_CONTENTS", PLAN_CONTENTS, DbType.String, ParameterDirection.Input);
            if (PLAN_DATE == DateTime.MinValue)
            {
                parameter.Add("@PLAN_DATE", DBNull.Value, DbType.Date, ParameterDirection.Input);
            }
            else
            {
                parameter.Add("@PLAN_DATE", PLAN_DATE, DbType.Date, ParameterDirection.Input);
            }
            parameter.Add("@COMPLETE_YN", COMPLETE_YN, DbType.Int32, ParameterDirection.Input);
            if (COMPLETE_DATE == DateTime.MinValue)
            {
                parameter.Add("@COMPLETE_DATE", DBNull.Value, DbType.Date, ParameterDirection.Input);
            }
            else
            {
                parameter.Add("@COMPLETE_DATE", COMPLETE_DATE, DbType.Date, ParameterDirection.Input);
            }

            return(DBManager <PROJECT_PLAN> .Execute(sql, parameter));
        }
Example #4
0
        public virtual int Update(string IDEA_ID, string PLAN_CONTENTS, DateTime PLAN_DATE, int COMPLETE_YN, DateTime COMPLETE_DATE, string ID)
        {
            var sql = "UPDATE PROJECT_PLAN SET IDEA_ID=@IDEA_ID,PLAN_CONTENTS=@PLAN_CONTENTS,PLAN_DATE=@PLAN_DATE,COMPLETE_YN=@COMPLETE_YN,COMPLETE_DATE=@COMPLETE_DATE WHERE ID=@ID";
            DynamicParameters parameter = new DynamicParameters();

            parameter.Add("@ID", ID, DbType.String, ParameterDirection.Input);
            parameter.Add("@IDEA_ID", IDEA_ID, DbType.String, ParameterDirection.Input);
            parameter.Add("@PLAN_CONTENTS", PLAN_CONTENTS, DbType.String, ParameterDirection.Input);
            if (PLAN_DATE == DateTime.MinValue)
            {
                parameter.Add("@PLAN_DATE", DBNull.Value, DbType.Date, ParameterDirection.Input);
            }
            else
            {
                parameter.Add("@PLAN_DATE", PLAN_DATE, DbType.Date, ParameterDirection.Input);
            }
            parameter.Add("@COMPLETE_YN", COMPLETE_YN, DbType.Int32, ParameterDirection.Input);
            if (COMPLETE_DATE == DateTime.MinValue)
            {
                parameter.Add("@COMPLETE_DATE", DBNull.Value, DbType.Date, ParameterDirection.Input);
            }
            else
            {
                parameter.Add("@COMPLETE_DATE", COMPLETE_DATE, DbType.Date, ParameterDirection.Input);
            }
            return(DBManager <PROJECT_PLAN> .Execute(sql, parameter));
        }
Example #5
0
        public int InsertProject(PROJECT project)
        {
            var sql = string.Format(@"INSERT INTO PROJECT(IDEA_ID,EMP_ID,IDEA_TITLE,PRJECT_GRADE,KPI_NAME,KPI_UNIT,BACKGROUND,NAME,
            INS_DT,PRJ_CURR,CURR_VALUE,ATTACHMENT) VALUES(@IDEA_ID,@EMP_ID,@IDEA_TITLE,@PRJECT_GRADE,@KPI_NAME,@KPI_UNIT,@BACKGROUND,@NAME,
            GETDATE(),@PRJ_CURR,@CURR_VALUE,@ATTACHMENT)");

            return(DBManager <PROJECT> .Execute(sql, project));
        }
Example #6
0
        public void DeleteLikeReply(string IdeaId)
        {
            var sql  = "DELETE FROM IDEA_LIKE WHERE IDEA_ID=@ID;";
            var sql1 = "DELETE FROM IDEA_REPLY WHERE IDEA_ID=@ID;";

            DBManager <IDEA_LIKE> .Execute(sql, new { ID = IdeaId });

            DBManager <IDEA_REPLY> .Execute(sql1, new { ID = IdeaId });
        }
Example #7
0
        public virtual int Delete(string ID = "")
        {
            var sql = "DELETE FROM IDEA ";

            if (string.IsNullOrWhiteSpace(ID))
            {
                return(DBManager <IDEA> .Execute(sql));
            }
            sql += " WHERE ID=@ID ";
            return(DBManager <IDEA> .Execute(sql, new { ID = ID }));
        }
Example #8
0
        public virtual int Delete(int ID = 0)
        {
            var sql = "DELETE FROM EMPLOYEE ";

            if (ID == 0)
            {
                return(DBManager <EMPLOYEE> .Execute(sql));
            }
            sql += " WHERE ID=@ID ";
            return(DBManager <EMPLOYEE> .Execute(sql, new { ID = ID }));
        }
Example #9
0
        public int InsertPlan(string IDEA_ID, string PLAN_CONTENTS, DateTime PLAN_DATE)
        {
            var ID  = GenerateId();
            var sql = "INSERT INTO PROJECT_PLAN(ID,IDEA_ID,PLAN_CONTENTS,PLAN_DATE) VALUES(@ID,@IDEA_ID,@PLAN_CONTENTS,@PLAN_DATE)";

            if (PLAN_DATE == DateTime.MinValue)
            {
                return(DBManager <PROJECT_PLAN> .Execute(sql, new { ID = ID, IDEA_ID = IDEA_ID, PLAN_CONTENTS = PLAN_CONTENTS, PLAN_DATE = DBNull.Value }));
            }
            return(DBManager <PROJECT_PLAN> .Execute(sql, new { ID = ID, IDEA_ID = IDEA_ID, PLAN_CONTENTS = PLAN_CONTENTS, PLAN_DATE = PLAN_DATE }));
        }
Example #10
0
        public int UpdateTranslate(string IDEA_ID, string REQUEST, string ISSUE)
        {
            var sql = string.Format(@"UPDATE PROJECT SET REQUEST_KOREAN=@REQUEST,ISSUE_KOREAN=@ISSUE WHERE IDEA_ID=@IDEA_ID");

            return(DBManager <PROJECT> .Execute(sql, new
            {
                IDEA_ID = IDEA_ID,
                REQUEST = REQUEST,
                ISSUE = ISSUE
            }));
        }
Example #11
0
        public virtual int Delete(int ID = 0)
        {
            var sql = "DELETE FROM PRJ_REPLY ";

            if (ID == 0)
            {
                return(DBManager <PRJ_REPLY> .Execute(sql));
            }
            sql += " WHERE ID=@ID ";
            return(DBManager <PRJ_REPLY> .Execute(sql, new { ID = ID }));
        }
Example #12
0
        public virtual int Insert(string IDEA_ID, string REP_EMP_ID, string REP_EMP_NAME, string COMMENTS, DateTime INS_DATE)
        {
            var sql = "INSERT INTO IDEA_REPLY(IDEA_ID,REP_EMP_ID,REP_EMP_NAME,COMMENTS,INS_DATE) VALUES(@IDEA_ID,@REP_EMP_ID,@REP_EMP_NAME,@COMMENTS,@INS_DATE)";

            return(DBManager <IDEA_REPLY> .Execute(sql, new
            {
                IDEA_ID = IDEA_ID,
                REP_EMP_ID = REP_EMP_ID,
                COMMENTS = COMMENTS,
                INS_DATE = INS_DATE,
                REP_EMP_NAME = REP_EMP_NAME
            }));
        }
Example #13
0
        public virtual int Update(string EMP_ID, string EMP_NAME, string DIVISION, string DEPARTMENT, string EMAIL, int ROLE)
        {
            var sql = "UPDATE EMPLOYEE SET EMP_ID=@EMP_ID,EMP_NAME=@EMP_NAME,EMAIL=@EMAIL,DIVISION=@DIVISION,DEPARTMENT=@DEPARTMENT,ROLE=@ROLE WHERE EMP_ID=@EMP_ID";

            return(DBManager <EMPLOYEE> .Execute(sql, new
            {
                EMP_ID = EMP_ID,
                EMP_NAME = EMP_NAME,
                EMAIL = EMAIL,
                DIVISION = DIVISION,
                DEPARTMENT = DEPARTMENT,
                ROLE = ROLE
            }));
        }
Example #14
0
        public int InsertReply(PRJ_REPLY rep)
        {
            //string ID = GenerateId();
            var sql = "INSERT INTO PRJ_REPLY(IDEA_ID,REP_EMP_ID,REP_EMP_NAME,COMMENTS,INS_DATE) VALUES(@IDEA_ID,@REP_EMP_ID,@REP_EMP_NAME,@COMMENTS,GETDATE())";

            return(DBManager <PRJ_REPLY> .Execute(sql, new
            {
                IDEA_ID = rep.IDEA_ID,
                REP_EMP_ID = rep.REP_EMP_ID,
                REP_EMP_NAME = rep.REP_EMP_NAME,
                COMMENTS = rep.COMMENTS,
                INS_DATE = INS_DATE
            }));
        }
Example #15
0
        public virtual int Insert(string EMP_ID, string EMP_PW, string EMP_NAME, string DIVISION, string DEPARTMENT, string EMAIL, int ROLE)
        {
            var sql = "INSERT INTO EMPLOYEE(EMP_ID,EMP_PW,EMP_NAME,DIVISION,DEPARTMENT,EMAIL,ROLE) VALUES(@EMP_ID,@EMP_PW,@EMP_NAME,@DIVISION,@DEPARTMENT,@EMAIL,@ROLE)";

            return(DBManager <EMPLOYEE> .Execute(sql, new
            {
                EMP_ID = EMP_ID,
                EMP_PW = EMP_PW,
                EMP_NAME = EMP_NAME,
                DIVISION = DIVISION,
                DEPARTMENT = DEPARTMENT,
                EMAIL = EMAIL,
                ROLE = ROLE
            }));
        }
Example #16
0
        public int UpdatePrj(string IDEA_ID, string EMP_ID, string IDEA_TITLE, string KPI_NAME, string KPI_UNIT, string REMARK,
                             string NAME, string PRJ_CURR, decimal CURR_VALUE, string PRJECT_GRADE, string ATTACHMENT, string ISSUE, string REQUEST)
        {
            var sql = string.Format(@"UPDATE PROJECT SET IDEA_ID=@IDEA_ID,EMP_ID=@EMP_ID,IDEA_TITLE=@IDEA_TITLE,KPI_NAME=@KPI_NAME,
                                   NAME=@NAME,KPI_UNIT=@KPI_UNIT,REMARK=@REMARK,CURR_VALUE=@CURR_VALUE,PRJ_CURR=@PRJ_CURR,
                                   PRJECT_GRADE=@PRJECT_GRADE,ATTACHMENT=@ATTACHMENT,ISSUE=@REMARK,REQUEST=@REQUEST WHERE IDEA_ID=@IDEA_ID");

            return(DBManager <PROJECT> .Execute(sql, new
            {
                IDEA_ID = IDEA_ID,
                EMP_ID = EMP_ID,
                IDEA_TITLE = IDEA_TITLE,
                KPI_NAME = KPI_NAME,
                KPI_UNIT = KPI_UNIT,
                REMARK = REMARK,
                NAME = NAME,
                PRJ_CURR = PRJ_CURR,
                CURR_VALUE = CURR_VALUE,
                PRJECT_GRADE = PRJECT_GRADE,
                ATTACHMENT = ATTACHMENT,
                REQUEST = REQUEST
            }));
        }
Example #17
0
        public virtual int Update(string ID, string EMP_ID, string IDEA_TITLE, string DETAIL, string QUANTITATIVE, string QUALITATIVE)
        {
            var sql = "UPDATE IDEA SET EMP_ID=@EMP_ID,IDEA_TITLE=@IDEA_TITLE,DETAIL=@DETAIL,QUANTITATIVE=@QUANTITATIVE,QUALITATIVE=@QUALITATIVE WHERE ID=@ID";

            return(DBManager <IDEA> .Execute(sql, new { ID = ID, EMP_ID = EMP_ID, IDEA_TITLE = IDEA_TITLE, DETAIL = DETAIL, QUANTITATIVE = QUANTITATIVE, QUALITATIVE = QUALITATIVE }));
        }
Example #18
0
        public int Delegate(string EMP_ID, string IDEA_ID)
        {
            var sql = "UPDATE IDEA SET EMP_ID=@EMP_ID WHERE ID=@IDEA_ID";

            return(DBManager <IDEA> .Execute(sql, new { IDEA_ID = IDEA_ID, EMP_ID = EMP_ID }));
        }
Example #19
0
        public int DeletePlanByIdeaId(string ID)
        {
            var sql = "DELETE FROM PROJECT_PLAN WHERE IDEA_ID=@ID";

            return(DBManager <PROJECT_PLAN> .Execute(sql, new { ID = ID }));
        }
Example #20
0
        public virtual int Update(string IDEA_ID, string PRJ_MONTH, decimal TARGET_VALUE, decimal RESULT_VALUE, string ID)
        {
            var sql = "UPDATE KPI SET IDEA_ID=@IDEA_ID,PRJ_MONTH=@PRJ_MONTH,TARGET_VALUE=@TARGET_VALUE,RESULT_VALUE=@RESULT_VALUE WHERE ID=@ID";

            return(DBManager <KPI> .Execute(sql, new { IDEA_ID = IDEA_ID, PRJ_MONTH = PRJ_MONTH, TARGET_VALUE = TARGET_VALUE, RESULT_VALUE = RESULT_VALUE, ID = ID }));
        }
Example #21
0
        public virtual int Insert(string IDEA_ID, string PRJ_MONTH, decimal TARGET_VALUE, decimal RESULT_VALUE)
        {
            var sql = "INSERT INTO KPI(IDEA_ID,PRJ_MONTH,TARGET_VALUE,RESULT_VALUE) VALUES(@IDEA_ID,@PRJ_MONTH,@TARGET_VALUE,@RESULT_VALUE)";

            return(DBManager <KPI> .Execute(sql, new { IDEA_ID = IDEA_ID, PRJ_MONTH = PRJ_MONTH, TARGET_VALUE = TARGET_VALUE, RESULT_VALUE = RESULT_VALUE }));
        }
Example #22
0
        public virtual int Update(string IDEA_ID, string EMP_ID, string IDEA_TITLE, string PRJECT_GRADE, string KPI_NAME, string KPI_UNIT, string BACKGROUND)
        {
            var sql = "UPDATE PROJECT SET IDEA_ID=@IDEA_ID,EMP_ID=@EMP_ID,IDEA_TITLE=@IDEA_TITLE,PRJECT_GRADE=@PRJECT_GRADE,KPI_NAME=@KPI_NAME,KPI_UNIT=@KPI_UNIT,BACKGROUND=@BACKGROUND WHERE ID=@ID";

            return(DBManager <PROJECT> .Execute(sql, new { IDEA_ID = IDEA_ID, EMP_ID = EMP_ID, IDEA_TITLE = IDEA_TITLE, PRJECT_GRADE = PRJECT_GRADE, KPI_NAME = KPI_NAME, KPI_UNIT = KPI_UNIT, BACKGROUND = BACKGROUND }));
        }
Example #23
0
        public virtual int Insert(string IDEA_ID, string EMP_ID, string IDEA_TITLE, string PRJECT_GRADE, string KPI_NAME, string KPI_UNIT, string BACKGROUND, string NAME)
        {
            var sql = "INSERT INTO PROJECT(IDEA_ID,EMP_ID,IDEA_TITLE,PRJECT_GRADE,KPI_NAME,KPI_UNIT,BACKGROUND,NAME,INS_DT) VALUES(@IDEA_ID,@EMP_ID,@IDEA_TITLE,@PRJECT_GRADE,@KPI_NAME,@KPI_UNIT,@BACKGROUND,@NAME,GETDATE())";

            return(DBManager <PROJECT> .Execute(sql, new { IDEA_ID = IDEA_ID, EMP_ID = EMP_ID, IDEA_TITLE = IDEA_TITLE, PRJECT_GRADE = PRJECT_GRADE, KPI_NAME = KPI_NAME, KPI_UNIT = KPI_UNIT, BACKGROUND = BACKGROUND, NAME = NAME }));
        }
Example #24
0
        public int ResetPassword(string EMP_ID)
        {
            var sql = "UPDATE EMPLOYEE SET EMP_PW='123' WHERE EMP_ID=@EMP_ID";

            return(DBManager <EMPLOYEE> .Execute(sql, new { EMP_ID = EMP_ID }));
        }
Example #25
0
        public int ChangePassword(string EmpId, string pass, string newpass)
        {
            var sql = "UPDATE EMPLOYEE SET EMP_PW=@NEWPASS WHERE EMP_ID=@EMP_ID AND EMP_PW=@PASS";

            return(DBManager <EMPLOYEE> .Execute(sql, new { NEWPASS = newpass, EMP_ID = EmpId, PASS = pass }));
        }
Example #26
0
        public int UpdateDepartment(string EmpId, string DEPARTMENT)
        {
            var sql = "UPDATE EMPLOYEE SET DEPARTMENT=@DEPARTMENT WHERE EMP_ID=@EMP_ID";

            return(DBManager <EMPLOYEE> .Execute(sql, new { DEPARTMENT = DEPARTMENT, EMP_ID = EmpId }));
        }
Example #27
0
        public virtual int Insert(string IDEA_ID, string PLAN_CONTENTS, DateTime PLAN_DATE, int COMPLETE_YN, DateTime COMPLETE_DATE)
        {
            var sql = "INSERT INTO PROJECT_PLAN(IDEA_ID,PLAN_CONTENTS,PLAN_DATE,COMPLETE_YN,COMPLETE_DATE) VALUES(@IDEA_ID,@PLAN_CONTENTS,@PLAN_DATE,@COMPLETE_YN,@COMPLETE_DATE)";

            return(DBManager <PROJECT_PLAN> .Execute(sql, new { IDEA_ID = IDEA_ID, PLAN_CONTENTS = PLAN_CONTENTS, PLAN_DATE = PLAN_DATE, COMPLETE_YN = COMPLETE_YN, COMPLETE_DATE = COMPLETE_DATE }));
        }
Example #28
0
        public virtual int Update(string IDEA_ID, string REP_EMP_ID, string REP_EMP_NAME, string COMMENTS, DateTime INS_DATE, string ID)
        {
            var sql = "UPDATE PRJ_REPLY SET IDEA_ID=@IDEA_ID,REP_EMP_ID=@REP_EMP_ID,REP_EMP_NAME=@REP_EMP_NAME,COMMENTS=@COMMENTS,INS_DATE=@INS_DATE WHERE ID=@ID";

            return(DBManager <PRJ_REPLY> .Execute(sql, new { IDEA_ID = IDEA_ID, REP_EMP_ID = REP_EMP_ID, REP_EMP_NAME = REP_EMP_NAME, COMMENTS = COMMENTS, INS_DATE = INS_DATE, ID = ID }));
        }
Example #29
0
        public virtual int Insert(string EMP_ID, string IDEA_TITLE, string DETAIL, string QUANTITATIVE, string QUALITATIVE)
        {
            var sql = "INSERT INTO IDEA(EMP_ID,IDEA_TITLE,DETAIL,QUANTITATIVE,QUALITATIVE,DATE) VALUES(@EMP_ID,@IDEA_TITLE,@DETAIL,@QUANTITATIVE,@QUALITATIVE,GETDATE())";

            return(DBManager <IDEA> .Execute(sql, new { EMP_ID = EMP_ID, IDEA_TITLE = IDEA_TITLE, DETAIL = DETAIL, QUANTITATIVE = QUANTITATIVE, QUALITATIVE = QUALITATIVE }));
        }
Example #30
0
        public int UpdateDivision(string EmpId, string Division)
        {
            var sql = "UPDATE EMPLOYEE SET DIVISION=@DIVISION WHERE EMP_ID=@EMP_ID";

            return(DBManager <EMPLOYEE> .Execute(sql, new { DIVISION = Division, EMP_ID = EmpId }));
        }