public void addConfigData(configData data, int store)
{
using (SqlCommand cmd = new SqlCommand("addConfigData", _sqlConn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@cid", SqlDbType.TinyInt).Value = data.id;
cmd.Parameters.Add("@value_1", SqlDbType.Int).Value = data.value_1;
cmd.Parameters.Add("@value_2", SqlDbType.Float).Value = data.value_2;
cmd.Parameters.Add("@value_3", SqlDbType.NChar).Value = data.value_3;
cmd.Parameters.Add("@store", SqlDbType.Int).Value = store;
try
{
_sqlConn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex.GetBaseException();
}
finally
{
_sqlConn.Close();
cmd.Dispose();
}
}
}
public configData getConfigData(int id, int store)
{
configData config = new configData();
using (SqlCommand cmd = new SqlCommand("getConfig", _sqlConn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@cid", SqlDbType.TinyInt).Value = id;
cmd.Parameters.Add("@store", SqlDbType.Int).Value = store;
try
{
_sqlConn.Open();
using (var data = cmd.ExecuteReader())
{
if (data.HasRows)
{
data.Read();
if (!data.IsDBNull(data.GetOrdinal("value_1")))
{
config.value_1 = Convert.ToInt32(data["value_1"]);
}
if (!data.IsDBNull(data.GetOrdinal("value_2")))
{
config.value_2 = (float)Convert.ToDouble(data["value_2"]);
}
if (!data.IsDBNull(data.GetOrdinal("value_3")))
{
config.value_3 = Convert.ToString(data["value_3"]);
config.value_3 = config.value_3.Replace(" ", string.Empty);
}
}
else
{
config = null;
}
}
}
catch (Exception ex)
{
throw ex.GetBaseException();
}
finally
{
_sqlConn.Close();
cmd.Dispose();
}
}
return(config);
}
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)
{
//admin
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 "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 "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 "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;
}
//Lab Run
case "getRunRank":
{
getRunRank(ref rep, store);
break;
}
case "updateRunData":
{
if (Request["runData"] == null)
{
break;
}
var runData = JsonConvert.DeserializeObject <runData>(Request["runData"]);
_dbMgr.updateRunData(Request["guid"], runData);
rep.result = true;
break;
}
case "createRunData":
{
string guid = getShortGUID();
_dbMgr.addRunData(guid, store);
rep.result = true;
rep.data = guid;
break;
}
case "getUserRank":
{
int rank = -1;
int score = 0;
_dbMgr.getUserRank(Request["guid"], ref rank, ref score, store);
if (rank != -1)
{
rep.result = true;
rep.data = rank;
}
break;
}
case "getRunSetting":
{
configData runResetT = _dbMgr.getConfigData(configData.ConfigMap["RunResetT"], store);
configData boxType = _dbMgr.getConfigData(configData.ConfigMap["RunBoxType"], store);
configData runStartT = _dbMgr.getConfigData(configData.ConfigMap["RunStartT"], store);
runSetting setting = new runSetting();
setting.resetSecond = runResetT.value_1;
setting.boxType = boxType.value_1;
setting.startSecond = runStartT.value_1;
rep.result = true;
rep.data = setting;
break;
}
//LabCity
case "getCityData":
{
getCityData(ref rep, store);
break;
}
case "getNewCityUser":
{
cityDisplayData cityData = new cityDisplayData();
try
{
_dbMgr.getNewCityUser(ref cityData, store);
rep.result = true;
rep.data = cityData;
}
catch (Exception ex)
{
rep.result = false;
rep.msg = "DB Error";
throw ex.GetBaseException();
}
break;
}
//Mobile
case "addMobileData":
{
var ukey = Request["guid"];
if (ukey == null)
{
rep.result = false;
}
else
{
if (_dbMgr.addMobileData(ukey))
{
rep.result = true;
}
else
{
rep.msg = "Wrong guid";
rep.result = false;
}
}
break;
}
case "addCityData":
{
var ukey = Request["guid"];
var nickName = Request["nick"];
if (ukey == null || nickName == null)
{
rep.result = false;
}
else
{
int rank = -1;
int score = 0;
_dbMgr.getUserRank(Request["guid"], ref rank, ref score, store);
cityDisplayData cityData = _dbMgr.addCityData(ukey, nickName, rank, store);
if (cityData == null)
{
rep.result = false;
rep.msg = "GUID Dupicate";
}
else
{
rep.data = cityData;
rep.result = true;
}
}
break;
}
case "updateMobileData":
{
if (Request["mobileData"] == null || Request["guid"] == null)
{
break;
}
var mobileData = JsonConvert.DeserializeObject <mobileData>(Request["mobileData"]);
var guid = Request["guid"];
_dbMgr.updateMobileData(guid, mobileData);
rep.result = true;
break;
}
case "getShareUrl":
{
var ukey = Request["guid"];
var imgData = Request["img"];
var shareTo = Request["share"];
if (!checkShare(ukey, ref imgData, store))
{
rep.result = false;
rep.msg = "DB error";
}
else
{
rep.result = true;
if (shareTo == "line")
{
_dbMgr.updateShare(ukey, 0, 1);
}
else
{
_dbMgr.updateShare(ukey, 1, 0);
}
rep.data = parameter._serverUrl + "s/share/" + ukey + ".html";
}
break;
}
//DEGUB
case "listShare":
{
List <string> shareList = new List <string>();
listShare(ref shareList);
rep.data = shareList;
rep.result = true;
break;
}
case "fixShare":
{
List <string> shareList = new List <string>();
listShare(ref shareList);
foreach (var name in shareList)
{
_dbMgr.updateShare(name, 1, 0);
}
rep.data = shareList;
rep.result = true;
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;
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);
}
