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 })); }
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 })); }
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)); }
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)); }
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)); }
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 }); }
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 })); }
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 })); }
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 })); }
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 })); }
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 })); }
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 })); }
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 })); }
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 })); }
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 })); }
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 })); }
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 })); }
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 })); }
public int DeletePlanByIdeaId(string ID) { var sql = "DELETE FROM PROJECT_PLAN WHERE IDEA_ID=@ID"; return(DBManager <PROJECT_PLAN> .Execute(sql, new { ID = ID })); }
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 })); }
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 })); }
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 })); }
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 })); }
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 })); }
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 })); }
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 })); }
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 })); }
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 })); }
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 })); }
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 })); }