public void getBarLiquorDisplay(ref List <barData> barDataList, int store)
{
using (SqlCommand cmd = new SqlCommand("getBarLiquorDisplay", _sqlConn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@store", SqlDbType.TinyInt).Value = store;
try
{
_sqlConn.Open();
using (var data = cmd.ExecuteReader())
{
barDataList.Clear();
if (data.HasRows)
{
while (data.Read())
{
if (data[0].Equals(DBNull.Value))
{
break;
}
barData c = new barData();
c.guid = data["uKey"].ToString();
c.guid = c.guid.Replace(" ", string.Empty);
c.nickName = data["nickName"].ToString();
c.nickName = c.nickName.Replace(" ", string.Empty);
DateTime date = DateTime.Parse(data["ans1"].ToString());
c.ans1 = date.ToString("yyyy-MM-dd");
c.ans2 = Convert.ToInt32(data["ans2"]);
c.ans3 = Convert.ToInt32(data["ans3"]);
c.ans4 = Convert.ToInt32(data["ans4"]);
c.ans5 = Convert.ToInt32(data["ans5"]);
if (!data.IsDBNull(7))
{
c.likeCount = Convert.ToInt32(data["likeCount"]);
}
else
{
c.likeCount = 0;
}
barDataList.Add(c);
}
}
}
}
catch (Exception ex)
{
throw ex.GetBaseException();
}
finally
{
_sqlConn.Close();
cmd.Dispose();
}
}
}
// Use this for initialization
void Start()
{
power = new barData(false, 0);
air = new barData(false, 0);
food = new barData(false, 0);
water = new barData(false, 0);
}
public void updateBarData(string guid, barData data)
{
using (SqlCommand cmd = new SqlCommand("updateBarData", _sqlConn))
{
string format = "yyyy-MM-dd";
CultureInfo provider = CultureInfo.InvariantCulture;
DateTime date = DateTime.ParseExact(data.ans1, format, provider);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@uKey", SqlDbType.NChar).Value = guid;
cmd.Parameters.Add("@ans1", SqlDbType.Date).Value = date;
cmd.Parameters.Add("@ans2", SqlDbType.TinyInt).Value = data.ans2;
cmd.Parameters.Add("@ans3", SqlDbType.TinyInt).Value = data.ans3;
cmd.Parameters.Add("@ans4", SqlDbType.TinyInt).Value = data.ans4;
cmd.Parameters.Add("@ans5", SqlDbType.TinyInt).Value = data.ans5;
try
{
_sqlConn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex.GetBaseException();
}
finally
{
_sqlConn.Close();
cmd.Dispose();
}
}
}
private bool checkShare(string uKey, string nickame, int store)
{
bool result = true;
if (!File.Exists(Server.MapPath("~/s/barShareImg/" + uKey + ".jpg")))
{
barData data = _dbMgr.getBarLiquorData(uKey, store);
if (data != null)
{
string shareStr = getShareMsg(ref data);
createImage(uKey, shareStr, nickame);
createSharePage(uKey);
}
}
return(result);
}
public static void Bar([MarshalAs(UnmanagedType.LPWStr)]string pair, [MarshalAs(UnmanagedType.LPWStr)]string period,int time, double open, double high, double low, double close)
{
var time1 = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc).AddSeconds(time).ToString("yy.MM.dd HH:mm");
barData barData1 = new barData();
barData1.pair = pair;
barData1.period = period;
barData1.time = time1;
barData1.open = open;
barData1.high = high;
barData1.low = low;
barData1.close = close;
var serializer = new JavaScriptSerializer();
var json = serializer.Serialize(barData1);
websocket.Send(json);
}
public void getNewBarLiquor(ref barData bData, int store)
{
using (SqlCommand cmd = new SqlCommand("getNewBarLiquor", _sqlConn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@store", SqlDbType.TinyInt).Value = store;
try
{
_sqlConn.Open();
using (var data = cmd.ExecuteReader())
{
if (data.HasRows)
{
data.Read();
bData.guid = data["uKey"].ToString();
bData.guid = bData.guid.Replace(" ", string.Empty);
bData.nickName = data["nickName"].ToString();
bData.nickName = bData.nickName.Replace(" ", string.Empty);
DateTime date = DateTime.Parse(data["ans1"].ToString());
bData.ans1 = date.ToString("yyyy-MM-dd");
bData.ans2 = Convert.ToInt32(data["ans2"]);
bData.ans3 = Convert.ToInt32(data["ans3"]);
bData.ans4 = Convert.ToInt32(data["ans4"]);
bData.ans5 = Convert.ToInt32(data["ans5"]);
bData.likeCount = Convert.ToInt32(data["likeCount"]);
}
else
{
bData = null;
}
}
}
catch (Exception ex)
{
throw ex.GetBaseException();
}
finally
{
_sqlConn.Close();
cmd.Dispose();
}
}
}
public static void Bar([MarshalAs(UnmanagedType.LPWStr)] string pair, [MarshalAs(UnmanagedType.LPWStr)] string period, int time, double open, double high, double low, double close)
{
var time1 = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc).AddSeconds(time).ToString("yy.MM.dd HH:mm");
barData barData1 = new barData();
barData1.pair = pair;
barData1.period = period;
barData1.time = time1;
barData1.open = open;
barData1.high = high;
barData1.low = low;
barData1.close = close;
var serializer = new JavaScriptSerializer();
var json = serializer.Serialize(barData1);
websocket.Send(json);
}
public barData getBarLiquorData(string guid, int store)
{
using (SqlCommand cmd = new SqlCommand("getBarLiquorData", _sqlConn))
{
barData bData = new barData();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@uKey", SqlDbType.NChar).Value = guid;
cmd.Parameters.Add("@store", SqlDbType.TinyInt).Value = store;
try
{
_sqlConn.Open();
using (var data = cmd.ExecuteReader())
{
if (data.HasRows)
{
data.Read();
bData.nickName = data["nickName"].ToString();
bData.nickName = bData.nickName.Replace(" ", string.Empty);
bData.ans1 = data["ans1"].ToString();
bData.ans2 = Convert.ToInt32(data["ans2"]);
bData.ans3 = Convert.ToInt32(data["ans3"]);
bData.ans4 = Convert.ToInt32(data["ans4"]);
bData.ans5 = Convert.ToInt32(data["ans5"]);
}
else
{
bData = null;
}
}
}
catch (Exception ex)
{
throw ex.GetBaseException();
}
finally
{
_sqlConn.Close();
cmd.Dispose();
}
return(bData);
}
}
private string getShareMsg(ref barData data)
{
string shareMsg = "";
if (data.ans2 == 0 || data.ans3 == 0 || data.ans4 == 0 || data.ans5 == 0)
{
string lifeNumberText = parameter._barAns1[0];
string foodText = parameter._barAns2[0];
string lifeStateText = parameter._barAns3[0];
string retireText = parameter._barAns5[0];
shareMsg = String.Format(parameter._barShareMsgT, lifeStateText, lifeNumberText, foodText, retireText);
}
else
{
int lifeNumber = getLifeNum(data.ans1);
string lifeNumberText = parameter._barAns1[lifeNumber - 1];
string foodText = parameter._barAns2[data.ans2 - 1];
string lifeStateText = parameter._barAns3[data.ans3 - 1];
string retireText = parameter._barAns5[data.ans5 - 1];
shareMsg = String.Format(parameter._barShareMsgT, lifeStateText, lifeNumberText, foodText, retireText);
}
return(shareMsg);
}
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);
}