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