public Apq.STReturn Login_LoginNameFromCookie(string LoginName, string SqlLoginPwd)
{
// 先清除已登录数据
Session.Clear();
Apq.STReturn stReturn = new Apq.STReturn();
DinnerSession ApqSession = new DinnerSession(Session);
if (SqlLoginPwd.Length < 63)
{
stReturn.NReturn = -1;
stReturn.ExMsg = "密码不允许为空";
return(stReturn);
}
byte[] binLoginPwd = Apq.Data.SqlClient.Common.ParseSqlON <byte[]>(System.Data.SqlDbType.VarBinary, SqlLoginPwd) as byte[];
stReturn = DBLogin(LoginName, binLoginPwd);
// Session操作
if (stReturn.NReturn > 0)
{
DataTable dt = stReturn.FNReturn as DataTable;
Login_Session(ApqSession, dt);
}
return(stReturn);
}
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)]
public Apq.STReturn Dinner_Restaurant_List()
{
Apq.STReturn stReturn = new Apq.STReturn();
DinnerSession ApqSession = new DinnerSession(Session);
if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession))
{
return stReturn;
}
DataSet ds = new DataSet();
DbConnection SqlConn = null;
using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn))
{
Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn);
DbDataAdapter sda = dbch.CreateAdapter();
sda.SelectCommand.CommandText = "dbo.Dinner_Restaurant_List";
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sda.SelectCommand);
dch.AddParameter("rtn", 0, DbType.Int32);
sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue;
SqlConn.Open();
sda.Fill(ds);
stReturn.NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value);
stReturn.FNReturn = ds.Tables[0];
sda.Dispose();
SqlConn.Close();
}
return stReturn;
}
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml)]
public Apq.STReturn Login_LoginName(string LoginName, string LoginPwd)
{
// 先清除已登录数据
Session.Clear();
Apq.STReturn stReturn = new Apq.STReturn();
DinnerSession ApqSession = new DinnerSession(Session);
if (LoginPwd.Length < 1)
{
stReturn.NReturn = -1;
stReturn.ExMsg = "密码不允许为空";
return(stReturn);
}
System.Security.Cryptography.SHA512 SHA512 = System.Security.Cryptography.SHA512.Create();
byte[] binLoginPwd = SHA512.ComputeHash(System.Text.Encoding.Unicode.GetBytes(LoginPwd));
stReturn = DBLogin(LoginName, binLoginPwd);
// Session操作
if (stReturn.NReturn > 0)
{ // 登录成功
DataTable dt = stReturn.FNReturn as DataTable;
Login_Session(ApqSession, dt);
}
return(stReturn);
}
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)]
public Apq.STReturn UserEditLoginPwd(string LoginPwd_C, string LoginPwd)
{
Apq.STReturn stReturn = new Apq.STReturn();
DinnerSession ApqSession = new DinnerSession(Session);
if (!CheckLoginPage.CheckLogin(ref stReturn, ApqSession))
{
return(stReturn);
}
// 检测旧密码
System.Security.Cryptography.SHA512 SHA512 = System.Security.Cryptography.SHA512.Create();
byte[] binLoginPwd_C = SHA512.ComputeHash(System.Text.Encoding.Unicode.GetBytes(LoginPwd_C));
string SqlLoginPwd_C = Apq.Data.SqlClient.Common.ConvertToSqlON(binLoginPwd_C);
string SqlLoginPwd_DB = Apq.Data.SqlClient.Common.ConvertToSqlON(ApqSession.ApqLogin.LoginPwd);
if (SqlLoginPwd_C != SqlLoginPwd_DB)
{
stReturn.NReturn = -1;
stReturn.ExMsg = "原密码输入错误";
return(stReturn);
}
byte[] binLoginPwd = SHA512.ComputeHash(System.Text.Encoding.Unicode.GetBytes(LoginPwd));
DbConnection SqlConn = null;
using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn))
{
Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn);
DbCommand sc = SqlConn.CreateCommand();
sc.CommandText = "dbo.Dinner_User_UpdateLoginPwd";
sc.CommandType = CommandType.StoredProcedure;
Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc);
dch.AddParameter("rtn", 0, DbType.Int32);
dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1);
dch.AddParameter("LoginID", ApqSession.ApqLogin.LoginID);
dch.AddParameter("LoginPwd", binLoginPwd);
sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue;
sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput;
SqlConn.Open();
sc.ExecuteNonQuery();
stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value);
stReturn.ExMsg = sc.Parameters["ExMsg"].Value.ToString();
sc.Dispose();
SqlConn.Close();
}
// 更新Session中的密码信息
ApqSession.ApqLogin.LoginPwd = binLoginPwd;
// 返回客户端
stReturn.FNReturn = Apq.Data.SqlClient.Common.ConvertToSqlON(binLoginPwd);
return(stReturn);
}
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)]
public Apq.STReturn UserEditSelf(long UserID, string Name, short Sex, string PhotoUrl, DateTime Birthday
, string IDCard, string Alipay)
{
Apq.STReturn stReturn = new Apq.STReturn();
DinnerSession ApqSession = new DinnerSession(Session);
if (!CheckLoginPage.CheckPwdExpire(ref stReturn, ApqSession))
{
return(stReturn);
}
DbConnection SqlConn = null;
using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn))
{
Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn);
DbCommand sc = SqlConn.CreateCommand();
sc.CommandText = "Dinner.Dinner_User_UpdateSelf";
sc.CommandType = CommandType.StoredProcedure;
Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc);
dch.AddParameter("rtn", 0, DbType.Int32);
dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1);
dch.AddParameter("_OperID", ApqSession);
dch.AddParameter("_OpTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
IPAddress ipa;
if (IPAddress.TryParse(HttpContext.Current.Request.UserHostAddress, out ipa))
{
dch.AddParameter("_OperIP", ipa.GetAddressBytes());
}
dch.AddParameter("UserID", UserID);
dch.AddParameter("Name", Name);
dch.AddParameter("Sex", Sex);
dch.AddParameter("PhotoUrl", PhotoUrl);
//dch.AddParameter("Expire", Expire.ToString("yyyy-MM-dd HH:mm:ss.fff"));
//dch.AddParameter("Status", Status);
//dch.AddParameter("IsAdmin", IsAdmin);
dch.AddParameter("Birthday", Birthday);
dch.AddParameter("IDCard", IDCard);
dch.AddParameter("Alipay", Alipay);
sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue;
sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput;
SqlConn.Open();
sc.ExecuteNonQuery();
stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value);
stReturn.ExMsg = sc.Parameters["ExMsg"].Value.ToString();
sc.Dispose();
SqlConn.Close();
}
return(stReturn);
}
public ActionResult CreateAdminRestaurant(AdminRestaurant adminRestaurant)
{
if (ModelState.IsValid)
{
var filename = CreateFileName(adminRestaurant.Restaurant.Name);
var path = Path.Combine(Server.MapPath(restaurantImagePath), filename);
adminRestaurant.Restaurant.ImagePath = restaurantImagePath + filename;
Image sourceimage = Image.FromStream(adminRestaurant.File.InputStream);
sourceimage.Save(path, ImageFormat.Jpeg);
restaurantRepository.AddRestaurant(adminRestaurant.Restaurant);
//New DinnerSessions are created
foreach (var day in dayRepository.GetAllDays())
{
var startTime = adminRestaurant.StartTime;
for (var i = 0; i < adminRestaurant.Sessions; i++)
{
var dinnerSession = new DinnerSession
{
DayId = day.Id,
AvailableSeats = adminRestaurant.Restaurant.Seats,
RestaurantId = adminRestaurant.Restaurant.Id,
Duration = adminRestaurant.Duration,
TableType = "DinnerSessions"
};
if (i != 0)
{
startTime.AddHours((double)adminRestaurant.Duration);
}
dinnerSession.StartTime = startTime;
dinnerSessionRepository.AddDinnerSession(dinnerSession);
}
}
foreach (var id in adminRestaurant.FoodTypeIdList)
{
RestaurantFoodType restaurantFoodType = new RestaurantFoodType()
{
FoodTypeId = id,
RestaurantId = restaurantRepository.GetLastRestaurant()
};
restaurantFoodTypeRepository.AddRestaurantFoodType(restaurantFoodType);
}
}
else
{
ModelState.AddModelError("Error", "One or more Fields were empty.");
}
var adminEventEditViewModel = (AdminEventEditViewModel)Session["adminEventEditViewModel"];
adminEventEditViewModel.AdminRestaurant = adminRestaurant;
Session["adminEventEditViewModel"] = adminEventEditViewModel;
return(RedirectToAction("AdminEventEdit"));
}
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)]
public Apq.STReturn UserEditSelf(long UserID, string Name, short Sex, string PhotoUrl, DateTime Birthday
, string IDCard, string Alipay)
{
Apq.STReturn stReturn = new Apq.STReturn();
DinnerSession ApqSession = new DinnerSession(Session);
if (!CheckLoginPage.CheckPwdExpire(ref stReturn, ApqSession))
{
return stReturn;
}
DbConnection SqlConn = null;
using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn))
{
Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn);
DbCommand sc = SqlConn.CreateCommand();
sc.CommandText = "Dinner.Dinner_User_UpdateSelf";
sc.CommandType = CommandType.StoredProcedure;
Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc);
dch.AddParameter("rtn", 0, DbType.Int32);
dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1);
dch.AddParameter("_OperID", ApqSession);
dch.AddParameter("_OpTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
IPAddress ipa;
if (IPAddress.TryParse(HttpContext.Current.Request.UserHostAddress, out ipa))
{
dch.AddParameter("_OperIP", ipa.GetAddressBytes());
}
dch.AddParameter("UserID", UserID);
dch.AddParameter("Name", Name);
dch.AddParameter("Sex", Sex);
dch.AddParameter("PhotoUrl", PhotoUrl);
//dch.AddParameter("Expire", Expire.ToString("yyyy-MM-dd HH:mm:ss.fff"));
//dch.AddParameter("Status", Status);
//dch.AddParameter("IsAdmin", IsAdmin);
dch.AddParameter("Birthday", Birthday);
dch.AddParameter("IDCard", IDCard);
dch.AddParameter("Alipay", Alipay);
sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue;
sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput;
SqlConn.Open();
sc.ExecuteNonQuery();
stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value);
stReturn.ExMsg = sc.Parameters["ExMsg"].Value.ToString();
sc.Dispose();
SqlConn.Close();
}
return stReturn;
}
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)]
public Apq.STReturn Dinner_Admin_EmDinner_ListPager(int start, int limit, DateTime BTime, DateTime ETime, long RestID, bool IsDoDinner)
{
int Pager_Page = start / limit;
int Pager_PageSize = limit;
Apq.STReturn stReturn = new Apq.STReturn();
DinnerSession ApqSession = new DinnerSession(Session);
if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession))
{
return(stReturn);
}
DataSet ds = new DataSet();
DbConnection SqlConn = null;
using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn))
{
Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn);
DbDataAdapter sda = dbch.CreateAdapter();
sda.SelectCommand.CommandText = "dbo.Dinner_Admin_EmDinner_ListPager";
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sda.SelectCommand);
dch.AddParameter("rtn", 0, DbType.Int32);
//dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1);
dch.AddParameter("Pager_Page", Pager_Page, DbType.Int32);
dch.AddParameter("Pager_PageSize", Pager_PageSize);
dch.AddParameter("Pager_RowCount", 0, DbType.Int32);
dch.AddParameter("BTime", BTime);
dch.AddParameter("ETime", ETime);
dch.AddParameter("RestID", RestID);
dch.AddParameter("State", IsDoDinner);
sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue;
//sda.SelectCommand.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput;
sda.SelectCommand.Parameters["Pager_RowCount"].Direction = ParameterDirection.InputOutput;
SqlConn.Open();
sda.Fill(ds);
stReturn.NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value);
//stReturn.ExMsg = sda.SelectCommand.Parameters["ExMsg"].Value.ToString();
stReturn.FNReturn = ds.Tables[0];
stReturn.POuts.Add(sda.SelectCommand.Parameters["Pager_Page"].Value);
stReturn.POuts.Add(sda.SelectCommand.Parameters["Pager_RowCount"].Value);
sda.Dispose();
SqlConn.Close();
}
return(stReturn);
}
//Updates the DinnerSessions
private void UpdateDinnersSessions(decimal Duration, string StartTime, int RestaurantId, int AvailableSeats, int Sessions)
{
var dinnerSessions = dinnerSessionRepository.GetAllDinnerSessionsByRestaurantId(RestaurantId);
var startDateTime = Convert.ToDateTime(StartTime);
//Check if the number of sessions have been changed
//If the number is not changed, update the dinner sessions
if (Sessions == dinnerSessions.Count())
{
foreach (var dinnerSession in dinnerSessions)
{
dinnerSession.Duration = Duration;
dinnerSession.RestaurantId = RestaurantId;
dinnerSession.AvailableSeats = AvailableSeats;
if (!dinnerSession.Equals(dinnerSessions.First()))
{
startDateTime.AddHours((double)Duration);
}
dinnerSession.StartTime = startDateTime;
}
}
//If the number of sessions has been changed recreate the Dinnersessions
else
{
dinnerSessionRepository.DeleteDinnerSessions(dinnerSessions.ToList());
foreach (var day in dayRepository.GetAllDays())
{
for (var i = 0; i < Sessions; i++)
{
var dinnerSession = new DinnerSession()
{
AvailableSeats = AvailableSeats,
DayId = day.Id,
Duration = Duration,
RestaurantId = RestaurantId,
TableType = "DinnerSessions"
};
if (i != 0)
{
startDateTime.AddHours((double)Duration);
}
dinnerSession.StartTime = startDateTime;
dinnerSessionRepository.AddDinnerSession(dinnerSession);
}
}
}
}
/// <summary>
/// 登录成功,Session操作
/// </summary>
public void Login_Session(DinnerSession ApqSession, DataTable dt)
{
ApqSession.ApqLogin.LoginID = Apq.Convert.ChangeType <long>(dt.Rows[0]["LoginID"]);
ApqSession.ApqLogin.LoginName = Apq.Convert.ChangeType <string>(dt.Rows[0]["LoginName"]);
ApqSession.ApqLogin.LoginPwd = Apq.Convert.ChangeType <byte[]>(dt.Rows[0]["LoginPwd"]);
ApqSession.ApqLogin.PwdExpire = Apq.Convert.ChangeType <DateTime>(dt.Rows[0]["PwdExpire"]);
ApqSession.ApqLogin.LoginStatus = Apq.Convert.ChangeType <int>(dt.Rows[0]["LoginStatus"]);
ApqSession.ApqLogin.RegTime = Apq.Convert.ChangeType <DateTime>(dt.Rows[0]["RegTime"]);
ApqSession.ApqLogin.LoginTime = DateTime.Now;
ApqSession.Employee.EmID = Apq.Convert.ChangeType <long>(dt.Rows[0]["EmID"]);
ApqSession.Employee.EmName = Apq.Convert.ChangeType <string>(dt.Rows[0]["EmName"]);
ApqSession.Employee.LoginID = ApqSession.ApqLogin.LoginID;
ApqSession.Employee.IsAdmin = Apq.Convert.ChangeType <bool>(dt.Rows[0]["IsAdmin"]);
}
public ActionResult DetailsPage(int Id)
{
DinnerDetails dinnerDetails = new DinnerDetails();
DinnerSession dinnerSession = dinnerSessionRepository.GetDinnerSessionByRestaurantId(Id);
IEnumerable <FoodType> foodTypeList = restaurantFoodTypeRepository.GetFoodTypeByRestaurantId(Id);
string foodTypes = foodTypesAsString(Id);
dinnerDetails.foodtype = foodTypesAsString(Id);
dinnerDetails.restaurant = restaurantRepository.GetRestaurant(Id);
dinnerDetails.duration = (dinnerSession.Duration * 45).ToString();
dinnerDetails.startTimes = retrieveStarttimes(Id, true).startTimeString;
return(View(dinnerDetails));
}
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)]
public Apq.STReturn Dinner_Stat_EmDinner_Food(DateTime BTime, DateTime ETime, bool State)
{
Apq.STReturn stReturn = new Apq.STReturn();
DinnerSession ApqSession = new DinnerSession(Session);
if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession))
{
return(stReturn);
}
DataSet ds = new DataSet();
DbConnection SqlConn = null;
using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn))
{
Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn);
DbDataAdapter sda = dbch.CreateAdapter();
sda.SelectCommand.CommandText = "dbo.Dinner_Stat_EmDinner_Food";
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sda.SelectCommand);
dch.AddParameter("rtn", 0, DbType.Int32);
//dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1);
dch.AddParameter("BTime", BTime);
dch.AddParameter("ETime", ETime);
dch.AddParameter("State", State);
sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue;
//sda.SelectCommand.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput;
SqlConn.Open();
sda.Fill(ds);
stReturn.NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value);
//stReturn.ExMsg = sda.SelectCommand.Parameters["ExMsg"].Value.ToString();
stReturn.FNReturn = ds.Tables[0];
sda.Dispose();
SqlConn.Close();
}
return(stReturn);
}
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)]
public Apq.STReturn Dinner_Food_Save(long FoodID, long RestID, string FoodName, decimal FoodPrice)
{
Apq.STReturn stReturn = new Apq.STReturn();
DinnerSession ApqSession = new DinnerSession(Session);
if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession))
{
return(stReturn);
}
DbConnection SqlConn = null;
using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn))
{
Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn);
DbCommand sc = SqlConn.CreateCommand();
sc.CommandText = "dbo.Dinner_Food_Save";
sc.CommandType = CommandType.StoredProcedure;
Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc);
dch.AddParameter("rtn", 0, DbType.Int32);
dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1);
dch.AddParameter("FoodID", FoodID);
dch.AddParameter("RestID", RestID);
dch.AddParameter("FoodName", FoodName);
dch.AddParameter("FoodPrice", FoodPrice);
sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue;
sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput;
sc.Parameters["FoodID"].Direction = ParameterDirection.InputOutput;
SqlConn.Open();
sc.ExecuteNonQuery();
stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value);
stReturn.ExMsg = Apq.Convert.ChangeType <string>(sc.Parameters["ExMsg"].Value);
stReturn.POuts.Add(sc.Parameters["FoodID"]);
sc.Dispose();
SqlConn.Close();
}
return(stReturn);
}
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)]
public Apq.STReturn Dinner_Employee_Update(long EmID, string EmName, bool EmStatus, bool IsAdmin, string LoginName)
{
Apq.STReturn stReturn = new Apq.STReturn();
DinnerSession ApqSession = new DinnerSession(Session);
if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession))
{
return(stReturn);
}
DbConnection SqlConn = null;
using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn))
{
Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn);
DbCommand sc = SqlConn.CreateCommand();
sc.CommandText = "dbo.Dinner_Employee_Update";
sc.CommandType = CommandType.StoredProcedure;
Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc);
dch.AddParameter("rtn", 0, DbType.Int32);
dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1);
dch.AddParameter("EmID", EmID);
dch.AddParameter("EmName", EmName);
dch.AddParameter("EmStatus", EmStatus, DbType.Int32);
dch.AddParameter("IsAdmin", IsAdmin);
dch.AddParameter("LoginName", LoginName);
sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue;
sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput;
SqlConn.Open();
sc.ExecuteNonQuery();
stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value);
stReturn.ExMsg = sc.Parameters["ExMsg"].Value.ToString();
sc.Dispose();
SqlConn.Close();
}
return(stReturn);
}
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)]
public Apq.STReturn Dinner_Admin_EmDinner_DoDinner(DateTime BTime, DateTime ETime)
{
Apq.STReturn stReturn = new Apq.STReturn();
DinnerSession ApqSession = new DinnerSession(Session);
if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession))
{
return(stReturn);
}
DataSet ds = new DataSet();
DbConnection SqlConn = null;
using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn))
{
Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn);
DbCommand sc = SqlConn.CreateCommand();
sc.CommandText = "dbo.Dinner_Admin_EmDinner_DoDinner";
sc.CommandType = CommandType.StoredProcedure;
Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc);
dch.AddParameter("rtn", 0, DbType.Int32);
//dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1);
dch.AddParameter("BTime", BTime);
dch.AddParameter("ETime", ETime);
sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue;
//sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput;
SqlConn.Open();
sc.ExecuteNonQuery();
stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value);
//stReturn.ExMsg = sc.Parameters["ExMsg"].Value.ToString();
sc.Dispose();
SqlConn.Close();
}
return(stReturn);
}
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)]
public Apq.STReturn Dinner_Restaurant_Save(long RestID, string RestName, string RestAddr)
{
Apq.STReturn stReturn = new Apq.STReturn();
DinnerSession ApqSession = new DinnerSession(Session);
if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession))
{
return stReturn;
}
DbConnection SqlConn = null;
using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn))
{
Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn);
DbCommand sc = SqlConn.CreateCommand();
sc.CommandText = "dbo.Dinner_Restaurant_Save";
sc.CommandType = CommandType.StoredProcedure;
Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc);
dch.AddParameter("rtn", 0, DbType.Int32);
dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1);
dch.AddParameter("RestID", RestID);
dch.AddParameter("RestName", RestName);
dch.AddParameter("RestAddr", RestAddr);
sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue;
sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput;
sc.Parameters["RestID"].Direction = ParameterDirection.InputOutput;
SqlConn.Open();
sc.ExecuteNonQuery();
stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value);
stReturn.ExMsg = Apq.Convert.ChangeType<string>(sc.Parameters["ExMsg"].Value);
stReturn.POuts.Add(sc.Parameters["RestID"]);
sc.Dispose();
SqlConn.Close();
}
return stReturn;
}
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)]
public Apq.STReturn Dinner_Restaurant_List()
{
Apq.STReturn stReturn = new Apq.STReturn();
DinnerSession ApqSession = new DinnerSession(Session);
if (!CheckLoginPage.CheckLogin(ref stReturn, ApqSession))
{
return(stReturn);
}
DataSet ds = new DataSet();
DbConnection SqlConn = null;
using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn))
{
Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn);
DbDataAdapter sda = dbch.CreateAdapter();
sda.SelectCommand.CommandText = "dbo.Dinner_Restaurant_List";
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sda.SelectCommand);
dch.AddParameter("rtn", 0, DbType.Int32);
sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue;
SqlConn.Open();
sda.Fill(ds);
stReturn.NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value);
stReturn.FNReturn = ds.Tables[0];
sda.Dispose();
SqlConn.Close();
}
return(stReturn);
}
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)]
public Apq.STReturn Dinner_Stat_EmDinner_Food(DateTime BTime, DateTime ETime, bool State)
{
Apq.STReturn stReturn = new Apq.STReturn();
DinnerSession ApqSession = new DinnerSession(Session);
if (!CheckLoginPage.CheckAdmin(ref stReturn, ApqSession))
{
return stReturn;
}
DataSet ds = new DataSet();
DbConnection SqlConn = null;
using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn))
{
Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn);
DbDataAdapter sda = dbch.CreateAdapter();
sda.SelectCommand.CommandText = "dbo.Dinner_Stat_EmDinner_Food";
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sda.SelectCommand);
dch.AddParameter("rtn", 0, DbType.Int32);
//dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1);
dch.AddParameter("BTime", BTime);
dch.AddParameter("ETime", ETime);
dch.AddParameter("State", State);
sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue;
//sda.SelectCommand.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput;
SqlConn.Open();
sda.Fill(ds);
stReturn.NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value);
//stReturn.ExMsg = sda.SelectCommand.Parameters["ExMsg"].Value.ToString();
stReturn.FNReturn = ds.Tables[0];
sda.Dispose();
SqlConn.Close();
}
return stReturn;
}
public void AddDinnerSession(DinnerSession dinnerSession)
{
db.DinnerSessions.Add(dinnerSession);
db.SaveChanges();
}
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml)]
public Apq.STReturn Login_LoginName(string LoginName, string LoginPwd)
{
// 先清除已登录数据
Session.Clear();
Apq.STReturn stReturn = new Apq.STReturn();
DinnerSession ApqSession = new DinnerSession(Session);
if (LoginPwd.Length < 1)
{
stReturn.NReturn = -1;
stReturn.ExMsg = "密码不允许为空";
return stReturn;
}
System.Security.Cryptography.SHA512 SHA512 = System.Security.Cryptography.SHA512.Create();
byte[] binLoginPwd = SHA512.ComputeHash(System.Text.Encoding.Unicode.GetBytes(LoginPwd));
stReturn = DBLogin(LoginName, binLoginPwd);
// Session操作
if (stReturn.NReturn > 0)
{// 登录成功
DataTable dt = stReturn.FNReturn as DataTable;
Login_Session(ApqSession, dt);
}
return stReturn;
}
public Apq.STReturn Login_LoginNameFromCookie(string LoginName, string SqlLoginPwd)
{
// 先清除已登录数据
Session.Clear();
Apq.STReturn stReturn = new Apq.STReturn();
DinnerSession ApqSession = new DinnerSession(Session);
if (SqlLoginPwd.Length < 63)
{
stReturn.NReturn = -1;
stReturn.ExMsg = "密码不允许为空";
return stReturn;
}
byte[] binLoginPwd = Apq.Data.SqlClient.Common.ParseSqlON<byte[]>(System.Data.SqlDbType.VarBinary, SqlLoginPwd) as byte[];
stReturn = DBLogin(LoginName, binLoginPwd);
// Session操作
if (stReturn.NReturn > 0)
{
DataTable dt = stReturn.FNReturn as DataTable;
Login_Session(ApqSession, dt);
}
return stReturn;
}
public ActionResult Reservation(FormCollection collection)
{
//check if session is already set and set of new reservation or load from session
if (Session["Reservation"] != null)
{
reservation = (Reservation)Session["Reservation"];
}
else
{
reservation = new Reservation();
}
DinnerSession selectedDinnerSession = new DinnerSession();
//get input from user from the Collection that's passed from the view
int amount = Convert.ToInt32(collection.Get("ticket-amount"));
int dayId = Convert.ToInt32(collection.Get("day"));
DateTime timeSlot = Convert.ToDateTime(collection.Get("timeslot"));
int restaurantId = Convert.ToInt32(collection.Get("restaurantId"));
string remarks = collection.Get("remarks");
Restaurant restaurant = restaurantRepository.GetRestaurant(restaurantId);
//get dinnerSessions by restaurantId and timeslot the customer selected
List <DinnerSession> dinnerSession = dinnerSessionRepository.getDinnerSessionsByRestaurantAndStartTime(restaurantId, timeSlot).ToList();
//check for each session in the dinnersession list if the dayId matches the selected dayId by the customer
foreach (DinnerSession session in dinnerSession)
{
if (session.DayId == dayId)
{
selectedDinnerSession = session;
}
}
//fill dinnerTicket and PreTicket
DinnerTicket dinnerTicket = new DinnerTicket
{
Ticket = new PreTicket
{
Id = 1,
EventId = selectedDinnerSession.EventId,
Event = eventRepository.GetEvent(selectedDinnerSession.EventId),
Count = amount
},
Restaurant = restaurant,
Remarks = remarks,
Count = amount,
Id = selectedDinnerSession.EventId
};
//create new list of Tickets if reservation doesn't contain any.
if (reservation.Tickets == null)
{
reservation.Tickets = new List <BaseTicket>();
}
reservation.Tickets.Add(dinnerTicket);
Session["Reservation"] = reservation;
return(RedirectToAction("Basket", "Home"));
}
/// <summary>
/// 登录成功,Session操作
/// </summary>
public void Login_Session(DinnerSession ApqSession, DataTable dt)
{
ApqSession.ApqLogin.LoginID = Apq.Convert.ChangeType<long>(dt.Rows[0]["LoginID"]);
ApqSession.ApqLogin.LoginName = Apq.Convert.ChangeType<string>(dt.Rows[0]["LoginName"]);
ApqSession.ApqLogin.LoginPwd = Apq.Convert.ChangeType<byte[]>(dt.Rows[0]["LoginPwd"]);
ApqSession.ApqLogin.PwdExpire = Apq.Convert.ChangeType<DateTime>(dt.Rows[0]["PwdExpire"]);
ApqSession.ApqLogin.LoginStatus = Apq.Convert.ChangeType<int>(dt.Rows[0]["LoginStatus"]);
ApqSession.ApqLogin.RegTime = Apq.Convert.ChangeType<DateTime>(dt.Rows[0]["RegTime"]);
ApqSession.ApqLogin.LoginTime = DateTime.Now;
ApqSession.Employee.EmID = Apq.Convert.ChangeType<long>(dt.Rows[0]["EmID"]);
ApqSession.Employee.EmName = Apq.Convert.ChangeType<string>(dt.Rows[0]["EmName"]);
ApqSession.Employee.LoginID = ApqSession.ApqLogin.LoginID;
ApqSession.Employee.IsAdmin = Apq.Convert.ChangeType<bool>(dt.Rows[0]["IsAdmin"]);
}
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)]
public Apq.STReturn Dinner_EmDinner_Delete(long ID)
{
Apq.STReturn stReturn = new Apq.STReturn();
DinnerSession ApqSession = new DinnerSession(Session);
if (!CheckLoginPage.CheckLogin(ref stReturn, ApqSession))
{
return stReturn;
}
DataSet ds = new DataSet();
DbConnection SqlConn = null;
using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn))
{
Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn);
DbCommand sc = SqlConn.CreateCommand();
sc.CommandText = "dbo.Dinner_EmDinner_Delete";
sc.CommandType = CommandType.StoredProcedure;
Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc);
dch.AddParameter("rtn", 0, DbType.Int32);
dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1);
dch.AddParameter("ID", ID);
sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue;
sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput;
SqlConn.Open();
sc.ExecuteNonQuery();
stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value);
stReturn.ExMsg = sc.Parameters["ExMsg"].Value.ToString();
sc.Dispose();
SqlConn.Close();
}
return stReturn;
}
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)]
public Apq.STReturn UserEditLoginPwd(string LoginPwd_C, string LoginPwd)
{
Apq.STReturn stReturn = new Apq.STReturn();
DinnerSession ApqSession = new DinnerSession(Session);
if (!CheckLoginPage.CheckLogin(ref stReturn, ApqSession))
{
return stReturn;
}
// 检测旧密码
System.Security.Cryptography.SHA512 SHA512 = System.Security.Cryptography.SHA512.Create();
byte[] binLoginPwd_C = SHA512.ComputeHash(System.Text.Encoding.Unicode.GetBytes(LoginPwd_C));
string SqlLoginPwd_C = Apq.Data.SqlClient.Common.ConvertToSqlON(binLoginPwd_C);
string SqlLoginPwd_DB = Apq.Data.SqlClient.Common.ConvertToSqlON(ApqSession.ApqLogin.LoginPwd);
if (SqlLoginPwd_C != SqlLoginPwd_DB)
{
stReturn.NReturn = -1;
stReturn.ExMsg = "原密码输入错误";
return stReturn;
}
byte[] binLoginPwd = SHA512.ComputeHash(System.Text.Encoding.Unicode.GetBytes(LoginPwd));
DbConnection SqlConn = null;
using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn))
{
Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn);
DbCommand sc = SqlConn.CreateCommand();
sc.CommandText = "dbo.Dinner_User_UpdateLoginPwd";
sc.CommandType = CommandType.StoredProcedure;
Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sc);
dch.AddParameter("rtn", 0, DbType.Int32);
dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1);
dch.AddParameter("LoginID", ApqSession.ApqLogin.LoginID);
dch.AddParameter("LoginPwd", binLoginPwd);
sc.Parameters["rtn"].Direction = ParameterDirection.ReturnValue;
sc.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput;
SqlConn.Open();
sc.ExecuteNonQuery();
stReturn.NReturn = System.Convert.ToInt32(sc.Parameters["rtn"].Value);
stReturn.ExMsg = sc.Parameters["ExMsg"].Value.ToString();
sc.Dispose();
SqlConn.Close();
}
// 更新Session中的密码信息
ApqSession.ApqLogin.LoginPwd = binLoginPwd;
// 返回客户端
stReturn.FNReturn = Apq.Data.SqlClient.Common.ConvertToSqlON(binLoginPwd);
return stReturn;
}
//[ScriptMethod(ResponseFormat = System.Web.Script.Services.ResponseFormat.Xml, XmlSerializeString = true)]
public Apq.STReturn Dinner_EmDinner_ListPager(int start, int limit)
{
int Pager_Page = start / limit;
int Pager_PageSize = limit;
Apq.STReturn stReturn = new Apq.STReturn();
DinnerSession ApqSession = new DinnerSession(Session);
if (!CheckLoginPage.CheckLogin(ref stReturn, ApqSession))
{
return stReturn;
}
DataSet ds = new DataSet();
DbConnection SqlConn = null;
using (SqlConn = Apq.DBC.Common.CreateDBConnection("Dinner", ref SqlConn))
{
Apq.Data.Common.DbConnectionHelper dbch = new Apq.Data.Common.DbConnectionHelper(SqlConn);
DbDataAdapter sda = dbch.CreateAdapter();
sda.SelectCommand.CommandText = "dbo.Dinner_EmDinner_ListPager";
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
Apq.Data.Common.DbCommandHelper dch = new Apq.Data.Common.DbCommandHelper(sda.SelectCommand);
dch.AddParameter("rtn", 0, DbType.Int32);
//dch.AddParameter("ExMsg", stReturn.ExMsg, DbType.String, -1);
dch.AddParameter("Pager_Page", Pager_Page, DbType.Int32);
dch.AddParameter("Pager_PageSize", Pager_PageSize);
dch.AddParameter("Pager_RowCount", 0, DbType.Int32);
dch.AddParameter("EmID", ApqSession.Employee.EmID);
sda.SelectCommand.Parameters["rtn"].Direction = ParameterDirection.ReturnValue;
//sda.SelectCommand.Parameters["ExMsg"].Direction = ParameterDirection.InputOutput;
sda.SelectCommand.Parameters["Pager_RowCount"].Direction = ParameterDirection.InputOutput;
SqlConn.Open();
sda.Fill(ds);
stReturn.NReturn = System.Convert.ToInt32(sda.SelectCommand.Parameters["rtn"].Value);
//stReturn.ExMsg = sda.SelectCommand.Parameters["ExMsg"].Value.ToString();
stReturn.FNReturn = ds.Tables[0];
stReturn.POuts.Add(sda.SelectCommand.Parameters["Pager_Page"].Value);
stReturn.POuts.Add(sda.SelectCommand.Parameters["Pager_RowCount"].Value);
sda.Dispose();
SqlConn.Close();
}
return stReturn;
}
