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