public ActionResult SettingEmail(SettingEmailModels viewModel)
{
//권한 체크===================================================
if (!chk.chkPermission("SettingEmail", "PER_SELECT"))
{
return(RedirectToAction("Index", "Home", new { msg = chk.alertStr }));
}
//===========================================================
if (!ModelState.IsValid)
{
return(View(viewModel));
}
SettingDbModels act = new SettingDbModels();
string message = "성공";
if (act.SetEmailSettingModel(viewModel)) //
{
return(RedirectToAction("SettingEmail", "Setting", new { alert = message }));
}
message = "실패";
ViewBag.result = message;
return(View(viewModel));
}
public SettingEmailModels GetEmailSettingModel()
{
string errorStr = "";
SettingEmailModels result = new SettingEmailModels();
string sqlQueryStr = "SELECT SET_KEY, SET_VALUE FROM esm_settings WHERE SET_KEY in ('" + string.Join("','", strOPT_KEY) + "')";
DataTable dt = getQueryResult(sqlQueryStr, out errorStr);
if (dt == null || dt.Rows.Count == 0)
{
List <string> queryList = new List <string>();
for (int i = 0; i < strOPT_KEY.Length; i++)
{
queryList.Add("INSERT INTO esm_settings (SET_KEY, SET_VALUE) VALUES ('" + strOPT_KEY[i] + "', '') ");
}
exeQuery(queryList, out errorStr);
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["SET_KEY"].ToString() == "emaile_sender_server")
{
result.emaile_sender_server = dt.Rows[i]["SET_VALUE"].ToString();
}
if (dt.Rows[i]["SET_KEY"].ToString() == "emaile_sender_port")
{
result.emaile_sender_port = dt.Rows[i]["SET_VALUE"].ToString();
}
if (dt.Rows[i]["SET_KEY"].ToString() == "emaile_sender_id")
{
result.emaile_sender_id = dt.Rows[i]["SET_VALUE"].ToString();
}
if (dt.Rows[i]["SET_KEY"].ToString() == "emaile_sender_pw")
{
result.emaile_sender_pw = dt.Rows[i]["SET_VALUE"].ToString();
}
if (dt.Rows[i]["SET_KEY"].ToString() == "emaile_sender_email")
{
result.emaile_sender_email = dt.Rows[i]["SET_VALUE"].ToString();
}
if (dt.Rows[i]["SET_KEY"].ToString() == "emaile_sender_name")
{
result.emaile_sender_name = dt.Rows[i]["SET_VALUE"].ToString();
}
}
}
return(result);
}
public bool SetEmailSettingModel(SettingEmailModels model)
{
string errorStr = "";
bool result = false;
List <string> queryList = new List <string>();
queryList.Add("UPDATE esm_settings SET SET_VALUE ='" + model.emaile_sender_server + "' WHERE SET_KEY ='emaile_sender_server' ");
queryList.Add("UPDATE esm_settings SET SET_VALUE ='" + model.emaile_sender_port + "' WHERE SET_KEY ='emaile_sender_port' ");
queryList.Add("UPDATE esm_settings SET SET_VALUE ='" + model.emaile_sender_id + "' WHERE SET_KEY ='emaile_sender_id' ");
queryList.Add("UPDATE esm_settings SET SET_VALUE ='" + model.emaile_sender_pw + "' WHERE SET_KEY ='emaile_sender_pw' ");
queryList.Add("UPDATE esm_settings SET SET_VALUE ='" + model.emaile_sender_email + "' WHERE SET_KEY ='emaile_sender_email' ");
queryList.Add("UPDATE esm_settings SET SET_VALUE ='" + model.emaile_sender_name + "' WHERE SET_KEY ='emaile_sender_name' ");
result = exeQuery(queryList, out errorStr);
return(result);
}
// GET: Setting 설정 메일서버 설정
public ActionResult SettingEmail(string msg)
{
//권한 체크===================================================
if (!chk.chkPermission("SettingEmail", "PER_SELECT"))
{
return(RedirectToAction("Index", "Home", new { msg = chk.alertStr }));
}
//===========================================================
TempData["PublicMsg"] = null;
if (!string.IsNullOrEmpty(msg))
{
TempData["PublicMsg"] = msg;
}
SettingDbModels act = new SettingDbModels();
SettingEmailModels returnModel = act.GetEmailSettingModel();
return(View(returnModel));
}
