public void addBarQuestion(ref barQuestion qData) { using (SqlCommand cmd = new SqlCommand("addQuestion", _sqlConn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@question", SqlDbType.NVarChar).Value = qData.question; cmd.Parameters.Add("@opt1", SqlDbType.NVarChar).Value = qData.opt1; cmd.Parameters.Add("@opt2", SqlDbType.NVarChar).Value = qData.opt2; cmd.Parameters.Add("@opt3", SqlDbType.NVarChar).Value = qData.opt3; cmd.Parameters.Add("@opt4", SqlDbType.NVarChar).Value = qData.opt4; cmd.Parameters.Add("@opt5", SqlDbType.NVarChar).Value = qData.opt5; cmd.Parameters.Add("@opt6", SqlDbType.NVarChar).Value = qData.opt6; try { _sqlConn.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex.GetBaseException(); } finally { _sqlConn.Close(); cmd.Dispose(); } } }
public barQuestion getBarQuestion() { using (SqlCommand cmd = new SqlCommand("getQuestion", _sqlConn)) { barQuestion qData = new barQuestion(); cmd.CommandType = CommandType.StoredProcedure; try { _sqlConn.Open(); using (var data = cmd.ExecuteReader()) { if (data.HasRows) { data.Read(); qData.question = data["question"].ToString(); qData.question = qData.question.Replace(" ", string.Empty); qData.question = qData.question.Replace("\r\n", string.Empty); qData.opt1 = data["opt1"].ToString(); qData.opt1 = qData.opt1.Replace(" ", string.Empty); qData.opt2 = data["opt2"].ToString(); qData.opt2 = qData.opt2.Replace(" ", string.Empty); qData.opt3 = data["opt3"].ToString(); qData.opt3 = qData.opt3.Replace(" ", string.Empty); qData.opt4 = data["opt4"].ToString(); qData.opt4 = qData.opt4.Replace(" ", string.Empty); qData.opt5 = data["opt5"].ToString(); qData.opt5 = qData.opt5.Replace(" ", string.Empty); qData.opt6 = data["opt6"].ToString(); qData.opt6 = qData.opt6.Replace(" ", string.Empty); } else { qData = null; } } } catch (Exception ex) { throw ex.GetBaseException(); } finally { _sqlConn.Close(); cmd.Dispose(); } return(qData); } }
private void handleActive() { var active = Request["active"]; var store = Int32.Parse(Request["store"]); response rep = new response(); rep.active = active; switch (active) { //Bartender case "createBarData": { string guid = getShortGUID(); _dbMgr.addBarData(guid, store); rep.result = true; rep.data = guid; break; } case "updateBarData": { var barData = JsonConvert.DeserializeObject <barData>(Request["barData"]); _dbMgr.updateBarData(Request["guid"], barData); rep.result = true; break; } case "uploadBarLiquor": { string uKey = Request["guid"]; try { var fileSet = Request.Files; var file = fileSet["liquor"]; var path = Path.Combine(Server.MapPath("~/s/liquor"), uKey + ".png"); file.SaveAs(path); rep.result = true; } catch (Exception e) { rep.msg = e.Message; rep.result = false; } break; } case "getBarQuestion": { barQuestion qData = _dbMgr.getBarQuestion(); if (qData != null) { rep.result = true; rep.data = qData; } else { rep.result = false; rep.msg = "data is null"; } break; } case "getBarSetting": { configData barQRT = _dbMgr.getConfigData(configData.ConfigMap["BarQRShowT"], store); configData barLiquorT = _dbMgr.getConfigData(configData.ConfigMap["BarLiquorDisplayT"], store); bartenderSettingcs setting = new bartenderSettingcs(); setting.qrDisplaySecond = barQRT.value_1; setting.liquorDisplaySecoud = barLiquorT.value_1; rep.result = true; rep.data = setting; break; } //Bar case "getBarLiquorDisplay": { List <barData> barList = new List <barData>(); _dbMgr.getBarLiquorDisplay(ref barList, store); if (barList.Count < 16) { int addNum = (16 - barList.Count); parameter.loadDefaultLiquor(Server.MapPath("~/s/defaultLiquor.json")); for (int i = 0; i < addNum; i++) { barList.Add(parameter._barDefault[i]); } } rep.result = true; rep.data = barList; break; } case "getNewBarLiquor": { barData data = new barData(); _dbMgr.getNewBarLiquor(ref data, store); rep.result = true; rep.data = data; break; } case "addLike": { string uKey = Request["guid"]; int likeCount = _dbMgr.setBarLiquorLike(uKey); rep.result = true; rep.data = likeCount; break; } //Mobile case "setLiquorNickname": { var uKey = Request["guid"]; var nickName = Request["nickname"]; _dbMgr.setBarLiquorNickname(uKey, nickName, store); checkShare(uKey, nickName, store); rep.result = true; break; } case "addBarMobileData": { var uKey = Request["guid"]; var name = Request["userName"]; var phone = Request["mobile"]; _dbMgr.addBarMobile(uKey, name, phone); rep.result = true; break; } case "getResultMsg": { var msg = _dbMgr.getConfigData(configData.ConfigMap["BarMobileMsg"], store); rep.result = true; rep.data = msg.value_3; break; } case "getPopoutMsg": { var msg = _dbMgr.getConfigData(configData.ConfigMap["BarPopoutMsg"], store); rep.result = true; rep.data = msg.value_3; break; } case "getDataMsg": { var msg = _dbMgr.getConfigData(configData.ConfigMap["BarDataMsg"], store); rep.result = true; rep.data = msg.value_3; break; } case "getInfoState": { var config = _dbMgr.getConfigData(configData.ConfigMap["BarInfoState"], store); rep.result = true; rep.data = config.value_3; break; } default: { rep.result = false; rep.msg = "Unknow active"; break; } } var repJson = JsonConvert.SerializeObject(rep); Response.Write(repJson); }
private void handleActive() { var active = Request["active"]; var store = Int32.Parse(Request["store"]); response rep = new response(); rep.active = active; rep.store = store; switch (active) { #region Admin //admin case "login": { var ID = Request["id"]; var PW = Request["pw"]; rep.result = sklLogin("https://ws.skl.com.tw/ws/Auth/Login", ID, PW); rep.data = System.Web.Configuration.WebConfigurationManager.AppSettings["adminKey"]; break; } case "addAdmin": { var adminId = Request["adminID"]; _dbMgr.addAdmin(adminId); rep.result = true; break; } case "checkAdmin": { var adminId = Request["adminID"]; bool result = _dbMgr.checkAdmin(adminId); if (!result) { rep.msg = "This id was not in database"; } rep.result = result; break; } case "addQuestion": { var qData = JsonConvert.DeserializeObject <barQuestion>(Request["question"]); if (qData != null) { _dbMgr.addBarQuestion(ref qData); rep.result = true; } else { rep.result = false; } break; } #endregion #region Store Data case "addStoreData": { var storeData = JsonConvert.DeserializeObject <storeData>(Request["storeData"]); if (storeData != null) { _dbMgr.addStoreData(storeData); rep.result = true; } else { rep.result = false; } break; } case "updateStoreData": { var storeData = JsonConvert.DeserializeObject <storeData>(Request["storeData"]); if (storeData != null) { _dbMgr.updateStoreData(storeData); rep.result = true; } else { rep.result = false; } break; } case "getStoreData": { var data = _dbMgr.getStoreData(); if (data != null) { rep.data = data; rep.result = true; } else { rep.result = false; } break; } #endregion #region Lab //Lab case "getShareMsg": { var config = _dbMgr.getConfigData(configData.ConfigMap["MobileMsg"], store); if (config != null) { rep.result = true; rep.data = config.value_3; } else { rep.result = false; rep.msg = "Can't found config data"; } break; } case "updateShareMsg": { if (checkAdminKey(Request["key"])) { configData config = new configData(); config.id = configData.ConfigMap["MobileMsg"]; config.value_3 = Request["msg"]; _dbMgr.updateConfigData(config, store); rep.result = true; } else { rep.result = false; } break; } case "getAutoClearDay": { var config = _dbMgr.getConfigData(configData.ConfigMap["AutoClearDay"], store); if (config != null) { rep.result = true; rep.data = config.value_1; } else { rep.result = false; rep.msg = "Can't found config data"; } break; } case "updateAutoClearDay": { if (checkAdminKey(Request["key"])) { configData config = new configData(); config.id = configData.ConfigMap["AutoClearDay"]; config.value_1 = Convert.ToInt32(Request["day"]); _dbMgr.updateConfigData(config, store); rep.result = true; } else { rep.result = false; } break; } case "clearRun": { if (checkAdminKey(Request["key"])) { _dbMgr.clearRun(store); rep.result = true; } else { rep.result = false; } break; } case "clearCity": { if (checkAdminKey(Request["key"])) { _dbMgr.clearCity(store); rep.result = true; } else { rep.result = false; } break; } case "getLabRunStartTime": { var config = _dbMgr.getConfigData(configData.ConfigMap["RunStartT"], store); if (config != null) { rep.result = true; rep.data = config.value_1; } else { rep.result = false; rep.msg = "Can't found config data"; } break; } case "updateRunStartTime": { if (checkAdminKey(Request["key"])) { configData config = new configData(); config.id = configData.ConfigMap["RunStartT"]; config.value_1 = Convert.ToInt32(Request["RunStartT"]); _dbMgr.updateConfigData(config, store); rep.result = true; } else { rep.result = false; } break; } case "getLabRunRestTime": { var config = _dbMgr.getConfigData(configData.ConfigMap["RunResetT"], store); if (config != null) { rep.result = true; rep.data = config.value_1; } else { rep.result = false; rep.msg = "Can't found config data"; } break; } case "updateRunRestTime": { if (checkAdminKey(Request["key"])) { configData config = new configData(); config.id = configData.ConfigMap["RunResetT"]; config.value_1 = Convert.ToInt32(Request["RunResetT"]); _dbMgr.updateConfigData(config, store); rep.result = true; } else { rep.result = false; } break; } case "getBoxType": { var config = _dbMgr.getConfigData(configData.ConfigMap["RunBoxType"], store); if (config != null) { rep.result = true; rep.data = config.value_1; } else { rep.result = false; rep.msg = "Can't found config data"; } break; } case "updateBoxType": { if (checkAdminKey(Request["key"])) { configData config = new configData(); config.id = configData.ConfigMap["RunBoxType"]; config.value_1 = Convert.ToInt32(Request["BoxType"]); _dbMgr.updateConfigData(config, store); rep.result = true; break; } else { rep.result = false; } break; } #endregion #region Bar //Bar case "clearBar": { if (checkAdminKey(Request["key"])) { _dbMgr.clearBar(store); rep.result = true; } else { rep.result = false; } break; } case "getLiquorDisplayT": { var config = _dbMgr.getConfigData(configData.ConfigMap["BarLiquorDisplayT"], store); if (config != null) { rep.result = true; rep.data = config.value_1; } else { rep.result = false; rep.msg = "Can't found config data"; } break; } case "updateLiquorDisplayT": { if (checkAdminKey(Request["key"])) { configData config = new configData(); config.id = configData.ConfigMap["BarLiquorDisplayT"]; config.value_1 = Convert.ToInt32(Request["liquorDisplayT"]); _dbMgr.updateConfigData(config, store); rep.result = true; } else { rep.result = false; } break; } case "getBartenderRestTime": { var config = _dbMgr.getConfigData(configData.ConfigMap["BarQRShowT"], store); if (config != null) { rep.result = true; rep.data = config.value_1; } else { rep.result = false; rep.msg = "Can't found config data"; } break; } case "updateBartenderRestTime": { if (checkAdminKey(Request["key"])) { configData config = new configData(); config.id = configData.ConfigMap["BarQRShowT"]; config.value_1 = Convert.ToInt32(Request["BarQRShowT"]); _dbMgr.updateConfigData(config, store); rep.result = true; } else { rep.result = false; } break; } case "getBarShareMsg": { var config = _dbMgr.getConfigData(configData.ConfigMap["BarMobileMsg"], store); if (config != null) { rep.result = true; rep.data = config.value_3; } else { rep.result = false; rep.msg = "Can't found config data"; } break; } case "updateBarShareMsg": { if (checkAdminKey(Request["key"])) { configData config = new configData(); config.id = configData.ConfigMap["BarMobileMsg"]; config.value_3 = Regex.Replace(Request["msg"], @"\r|\n|\r\n", "<br>"); _dbMgr.updateConfigData(config, store); rep.result = true; } else { rep.result = false; } break; } case "getBarPopoutMsg": { var config = _dbMgr.getConfigData(configData.ConfigMap["BarPopoutMsg"], store); if (config != null) { rep.result = true; rep.data = config.value_3; } else { rep.result = false; rep.msg = "Can't found config data"; } break; } case "updateBarPopoutMsg": { if (checkAdminKey(Request["key"])) { configData config = new configData(); config.id = configData.ConfigMap["BarPopoutMsg"]; config.value_3 = Regex.Replace(Request["msg"], @"\r|\n|\r\n", "<br>"); _dbMgr.updateConfigData(config, store); rep.result = true; } else { rep.result = false; } break; } case "getBarDataMsg": { var config = _dbMgr.getConfigData(configData.ConfigMap["BarDataMsg"], store); if (config != null) { rep.result = true; rep.data = config.value_3; } else { rep.result = false; rep.msg = "Can't found config data"; } break; } case "updateBarDataMsg": { if (checkAdminKey(Request["key"])) { configData config = new configData(); config.id = configData.ConfigMap["BarDataMsg"]; config.value_3 = Request["msg"]; _dbMgr.updateConfigData(config, store); rep.result = true; } else { rep.result = false; } break; } case "getBarQuestion": { barQuestion qData = _dbMgr.getBarQuestion(); if (qData != null) { rep.result = true; rep.data = qData; } else { rep.result = false; rep.msg = "data is null"; } break; } case "updateBarQuestion": { if (checkAdminKey(Request["key"])) { if (Request["question"] != null) { var qData = JsonConvert.DeserializeObject <barQuestion>(Request["question"]); _dbMgr.updateQuestion(ref qData); rep.result = true; } else { rep.result = false; } } else { rep.result = false; } break; } case "getInfoState": { var config = _dbMgr.getConfigData(configData.ConfigMap["BarInfoState"], store); if (config != null) { rep.result = true; rep.data = config.value_3; } else { rep.result = false; rep.msg = "Can't found config data"; } break; } case "updateInfoState": { if (checkAdminKey(Request["key"])) { configData config = new configData(); config.id = configData.ConfigMap["BarInfoState"]; config.value_3 = Request["infoState"]; _dbMgr.updateConfigData(config, store); rep.result = true; } else { rep.result = false; } break; } case "updateInfoImg": { if (checkAdminKey(Request["key"])) { try { foreach (string fileName in Request.Files) { var file = Request.Files[fileName]; var path = Path.Combine(Server.MapPath("~/s/barShareInfo/"), fileName + ".jpg"); file.SaveAs(path); } } catch (Exception e) { rep.msg = e.Message; rep.result = false; } } else { rep.result = false; } break; } #endregion #region Config //Config case "getConfig": { var config = Request["config"]; configData data = _dbMgr.getConfigData(Convert.ToInt32(config), store); rep.result = true; rep.data = data; break; } case "addConfig": { configData data = JsonConvert.DeserializeObject <configData>(Request["config"]); _dbMgr.addConfigData(data, store); rep.result = true; break; } case "updateConfig": { configData data = JsonConvert.DeserializeObject <configData>(Request["config"]); _dbMgr.updateConfigData(data, store); rep.result = true; break; } #endregion default: { rep.result = false; rep.msg = "Unknow active"; break; } } var repJson = JsonConvert.SerializeObject(rep); Response.Write(repJson); }