public ActionResult Recharge(recharge card)
{
//充值代码
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
recharge searchCard = db.recharge.Where(c => c.rechargeId == card.rechargeId).FirstOrDefault();
if (searchCard == null)
{
Tools.AlertAndRedirect("卡号或卡密错误", Url.Action("Recharge", "Home"));
return(View());
}
if (searchCard.rechargePwd != card.rechargePwd)
{
Tools.AlertAndRedirect("卡号或卡密错误", Url.Action("Recharge", "Home"));
return(View());
}
if (searchCard.isAvailable == 0)
{
Tools.AlertAndRedirect("该卡已被使用", Url.Action("Recharge", "Home"));
return(View());
}
int userId = Int32.Parse(ViewBag.UserId);
userInfo user = db.userInfo.Where(u => u.userId == userId).FirstOrDefault();
user.userAccount += searchCard.amount;
searchCard.isAvailable = 0;
ViewBag.UserInfo = user;
db.SaveChanges();
}
Tools.AlertAndRedirect("充值成功", Url.Action("Recharge", "Home"));
return(View());
}
public string adoptAnswer(int quesAnswId, int userId)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
var dbQuesAnswReply = db.quesAnswReply.Where(u => u.quesAnswId == quesAnswId && u.userId == userId);
var obQuesAnswReply = dbQuesAnswReply.FirstOrDefault();
//将此对象的isAgree 改为1 表示采纳
obQuesAnswReply.isAgree = 1;
//修改此问答帖子的状态
var dbQuesAnsw = db.quesAnswInfo.Where(u => u.quesAnswId == quesAnswId);
var obQuesAnsw = dbQuesAnsw.FirstOrDefault();
//增加回答者的钱
//提问者的钱在提问时就扣除了
int getPayId = userId;
var dbInfo = db.userInfo.Where(u => u.userId == getPayId);
var obInfo = dbInfo.FirstOrDefault();
obInfo.userAccount += obQuesAnsw.amount;
obQuesAnsw.quesAnswStatus = 1;
db.SaveChanges();
return("true");
}
}
catch
{
return("false");
}
}
public string delete(string userName)
{
try
{
//根据不可重复的用户名找到userSecurity里面的userId,将其删除
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <userInfo> dbInfo = db.userInfo.Where(u => u.userName == userName.Trim()) as DbQuery <userInfo>;
userInfo obInfo = dbInfo.FirstOrDefault();
//创建一个要删除的对象
userSecurity deleSecurity = new userSecurity
{
userId = obInfo.userId,
};
//附加到ef中
db.userSecurity.Attach(deleSecurity);
//标记为删除--标记当前对象为删除状态
db.userSecurity.Remove(deleSecurity);
db.SaveChanges();
return("删除成功");
}
}
catch
{
return("删除失败");
}
}
public ActionResult PersonalData()
{
if (Request.Cookies["loginId"] != null)
{
//获取Cookies的值
HttpCookie cookieName = Request.Cookies["loginId"];
var cookieText = Server.HtmlEncode(cookieName.Value);
var loginId = cookieText.ToString();
HttpCookie cookieNameUserId = Request.Cookies["userId"];
var cookieTextUserId = Server.HtmlEncode(cookieNameUserId.Value);
var userId = Convert.ToInt32(cookieTextUserId.ToString());
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <userInfo> dbsearch = db.userInfo.Where(u => u.userId == userId) as DbQuery <userInfo>;
userInfo _userInfo = dbsearch.FirstOrDefault();
if (_userInfo != null)
{
ViewBag.userId = _userInfo.userId;
ViewBag.userName = _userInfo.userName;
ViewBag.userAge = _userInfo.userAge;
ViewBag.userSex = _userInfo.userSex;
ViewBag.userEmail = _userInfo.userEmail;
ViewBag.userStatus = _userInfo.userStatus;
ViewBag.userAccount = _userInfo.userAccount;
ViewBag.userIntroduce = _userInfo.userIntroduce;
ViewBag.userHeaderPic = _userInfo.userHeaderPic;
}
}
}
return(View());
}
public string login(userSecurity security)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <userSecurity> dbSecuritySureId = db.userSecurity.Where(u => u.loginId == security.loginId.Trim()) as DbQuery <userSecurity>;
userSecurity obSureId = dbSecuritySureId.FirstOrDefault();
string MD5Pwd = MD5Helper.MD5Helper.encrypt(security.userPwd.Trim());
if (obSureId == null)
{
return("未注册");
}
DbQuery <userSecurity> dbSecuritySurePwd = db.userSecurity.Where(u => u.loginId == security.loginId.Trim()).Where(u => u.userPwd == MD5Pwd) as DbQuery <userSecurity>;
userSecurity obSurePwd = dbSecuritySurePwd.FirstOrDefault();
if (obSurePwd != null)
{
HttpCookie cookieName = new HttpCookie("loginId");
cookieName.Value = security.loginId.Trim();
cookieName.Expires = DateTime.Now.AddHours(1);
Response.Cookies.Add(cookieName);
return("登录成功");
}
else
{
return("密码错误");
}
}
}
catch (Exception ex)
{
return(ex.ToString());
}
}
public ActionResult findUsername(userInfo info)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
userInfo[] user = toolsHelpers.selectToolsController.selectUserInfo(u => u.userEmail == info.userEmail.Trim(), u => u.userId);
if (user.Length == 0 || user == null)
{
Tools.AlertAndRedirect("没有此用户", Url.Action("findUserName", "passwordManager", new { area = "account" }));
return(Content("此邮箱没有注册！"));
}
int userId = user[0].userId;
userSecurity[] securityInfo = toolsHelpers.selectToolsController.selectUserSecurity(u => u.userId == userId, u => u.userId);
string rightLoginName = securityInfo[0].loginId;
Tools.AlertAndRedirect("您的登录名：" + rightLoginName, Url.Action("Index", "Home", new { area = "" }));
return(Content(rightLoginName));
}
}
catch
{
Tools.AlertAndRedirect("寻找用户名出错，请联系管理员", Url.Action("findUserName", "passwordManager", new { area = "account" }));
return(Content("找用户名出错!"));
}
}
public string update(userInfo info, userSecurity security)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <userInfo> dbInfosearch = db.userInfo.Where(u => u.userName == info.userName) as DbQuery <userInfo>;
userInfo _userInfo = dbInfosearch.FirstOrDefault();
DbQuery <userSecurity> dbSecuritysearch = db.userSecurity.Where(u => u.userId == _userInfo.userId) as DbQuery <userSecurity>;
userSecurity _userSecurity = dbSecuritysearch.FirstOrDefault();
//将要修改的值，放到数据上下文中
_userSecurity.userId = security.userId;
_userSecurity.loginId = security.loginId;
_userSecurity.userPwd = security.userPwd;
_userInfo.userId = info.userId;
_userInfo.userName = info.userName;
_userInfo.userAge = info.userAge;
_userInfo.userSex = info.userSex;
_userInfo.userTel = info.userTel;
_userInfo.userStatus = info.userStatus;
_userInfo.userAccount = info.userAccount;
db.SaveChanges(); //将修改之后的值保存到数据库中
}
return("修改成功");
}
catch
{
return("修改失败");
}
}
public string addArea(resourceArea area)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
//先检查分区名存不存在
resourceArea[] isExistArea = toolsHelpers.selectToolsController.selectResourceArea(u => u.areaName == area.areaName, u => u.areaId);
if (isExistArea.Length != 0)
{
return("存在相同的名字");
}
resourceArea obResourceArea = new resourceArea
{
areaName = area.areaName.Trim(),
areaBrief = area.areaBrief.Trim(),
};
if (toolsHelpers.insertToolsController.insertResourceArea(obResourceArea) == true)
{
Response.Redirect("/backStage/articleManagement/areaManagement");
return("success");
}
return("增加分区失败");
}
}
catch
{
return("增加分区出错");
}
}
/// <summary>
/// 修改userInfo表的数据
/// </summary>
/// <param name="whereLambda"></param>
/// <param name="info"></param>
/// <returns></returns>
public static Boolean updateUserInfo(Expression <Func <userInfo, bool> > whereLambda, userInfo info)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <userInfo> dataObject = db.userInfo.Where(whereLambda) as DbQuery <userInfo>;
userInfo oldInfo = dataObject.FirstOrDefault();
oldInfo.userName = info.userName;
oldInfo.userAge = info.userAge;
oldInfo.userSex = info.userSex;
oldInfo.userEmail = info.userEmail;
oldInfo.userStatus = info.userStatus;
oldInfo.userAccount = info.userAccount;
oldInfo.userIntroduce = info.userIntroduce;
oldInfo.userHeaderPic = info.userHeaderPic;
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public string add(userSecurity security)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
//先判断登录Id是否可用
var isLoginId = db.userSecurity.Where(u => u.loginId == security.loginId.Trim());
if (isLoginId.ToList().Count != 0)
{
return("用户已存在");
}
userSecurity user = new userSecurity
{
loginId = security.loginId,
userPwd = MD5Helper.MD5Helper.encrypt(security.userPwd)
};
db.userSecurity.Add(user);
db.SaveChanges();
}
return("增加成功");
}
catch
{
return("增加失败");
}
}
public string delete(userInfo info)
{
try
{
//此处判断有没有这个userId
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <userSecurity> dataObject = db.userSecurity.Where(u => u.userId == info.userId) as DbQuery <userSecurity>;
int dataNum = dataObject.ToList().Count;
if (dataNum == 0)
{
return("没有此用户！");
}
}
if (toolsHelpers.deleteToolsController.deleteUserUserId(info.userId))
{
Response.Redirect("/backStage/userManagement/Index");
return("success");
}
else
{
return("false");
}
}
catch (Exception ex)
{
return(ex.ToString());
}
}
public string changePassword(string loginId, string userOldPwd, string userPwd)
{
try
{
string MD5Pwd = MD5Helper.MD5Helper.encrypt(userOldPwd.Trim());
string MD5NewPwd = MD5Helper.MD5Helper.encrypt(userPwd.Trim());
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <userSecurity> dbSecurity = db.userSecurity.Where(u => u.loginId == loginId.Trim()).Where(u => u.userPwd == MD5Pwd) as DbQuery <userSecurity>;
userSecurity obSecurity = dbSecurity.FirstOrDefault();
if (obSecurity == null)
{
Tools.AlertAndRedirect("用户名或密码错误", Url.Action("changePassword", "passwordManager", new { area = "account" }));
return("用户名或密码错误");
}
obSecurity.userPwd = MD5NewPwd;
db.SaveChanges();
Tools.AlertAndRedirect("修改成功", Url.Action("Logout", "userManagement"));
return("修改成功");
}
}
catch
{
Tools.AlertAndRedirect("修改失败,请与管理员联系", Url.Action("changePassword", "passwordManager", new { area = "account" }));
return("修改失败");
}
}
public string login(backManager manager)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <backManager> dbManager = db.backManager.Where(u => u.managerId == manager.managerId) as DbQuery <backManager>;
backManager obManager = dbManager.FirstOrDefault();
string MD5Pwd = MD5Helper.MD5Helper.encrypt(manager.managerPwd.Trim());
if (obManager == null)
{
return("无效用户名");
}
DbQuery <backManager> dbManagerPwd = db.backManager.Where(u => u.managerId == manager.managerId).Where(u => u.managerPwd == MD5Pwd) as DbQuery <backManager>;
backManager obSurePwd = dbManagerPwd.FirstOrDefault();
if (obSurePwd != null)
{
HttpCookie cookieName = new HttpCookie("managerId");
cookieName.Value = manager.managerId.ToString();
cookieName.Expires = DateTime.Now.AddHours(1);
Response.Cookies.Add(cookieName);
return("登录成功");
}
else
{
return("密码错误");
}
}
}
catch
{
return("登录失败");
}
}
//问答帖子分区
public quesAnswInfo[] GetPagedListquesAnsw <TKey>(int pageIndex, int pageSize, Expression <Func <quesAnswInfo, bool> > whereLambda, Expression <Func <quesAnswInfo, TKey> > orderBy)
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
//分页时一定注意：Skip之前一定要OrderBy
return(db.quesAnswInfo.Where(whereLambda).OrderBy(orderBy).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToArray());
}
}
/// <summary>
/// 分页查询
/// </summary>
/// <typeparam name="TKey"></typeparam>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">页容量</param>
/// <param name="whereLambda">条件 lambda表达式</param>
/// <param name="orderBy">排列 lambda表达式</param>
/// <returns></returns>
public resourceArea[] GetPagedListArea <TKey>(int pageIndex, int pageSize, Expression <Func <resourceArea, bool> > whereLambda, Expression <Func <resourceArea, TKey> > orderBy)
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
//分页时一定注意：Skip之前一定要OrderBy
return(db.resourceArea.Where(whereLambda).OrderBy(orderBy).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToArray());
}
}
// GET: backStage/articleManagement
public ActionResult Index()
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
ViewBag.Model = db.resourceArea.ToList();
return(View(ViewBag.Model));
}
}
public int GetSumPageCard(int pageSize)
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
int listSum = db.recharge.ToList().Count;
return((listSum / pageSize) + 1);
}
}
/// <summary>
/// 分页查询
/// </summary>
/// <typeparam name="TKey"></typeparam>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">页容量</param>
/// <param name="whereLambda">条件 lambda表达式</param>
/// <param name="orderBy">排列 lambda表达式</param>
/// <returns></returns>
public List <recharge> GetPagedListCard <TKey>(int pageIndex, int pageSize, Expression <Func <recharge, bool> > whereLambda, Expression <Func <recharge, TKey> > orderBy)
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
//分页时一定注意：Skip之前一定要OrderBy
return(db.recharge.Where(whereLambda).OrderBy(orderBy).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList());
}
}
public ActionResult VerifyInfo(userSecurity security, userInfo info, string code)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
userSecurity[] securityInfo = toolsHelpers.selectToolsController.selectUserSecurity(u => u.loginId == security.loginId, u => u.userId);
if (securityInfo == null || securityInfo.Length == 0)
{
Tools.AlertAndRedirect("没有此用户", Url.Action("VerifyInfo", "passwordManager", new { area = "account" }));
return(Content("没有此用户"));
}
int userId = securityInfo[0].userId;
userInfo[] user = toolsHelpers.selectToolsController.selectUserInfo(u => u.userId == userId, u => u.userId);
if (user == null || user.Length == 0)
{
Tools.AlertAndRedirect("登录名与邮箱不匹配", Url.Action("VerifyInfo", "passwordManager", new { area = "account" }));
return(Content("登录名与邮箱不匹配"));
}
//获取邮箱
string Email = user[0].userEmail;
//把用户输入的验证码 和邮箱地址进行加密验证
string encryptCode = certificateTools.encryptContent(Email);
string encryptemailAddress = certificateTools.encryptContent(code);
//获取Cookies的值
HttpCookie cookieName = Request.Cookies["emailCodePassword"];
var rightCode = Server.HtmlEncode(cookieName.Value);
HttpCookie cookieAddress = Request.Cookies["emailAddressPassword"];
var rightEmail = Server.HtmlEncode(cookieAddress.Value);
if (rightEmail != encryptCode || rightCode != encryptemailAddress)
{
//验证码错误
Tools.AlertAndRedirect("验证失败！", Url.Action("VerifyInfo", "passwordManager", new { area = "account" }));
return(Content("验证失败！"));
}
userSecurity obSecurity = db.userSecurity.Where(u => u.userId == userId).FirstOrDefault();
obSecurity.userPwd = MD5Helper.MD5Helper.encrypt(security.userPwd.Trim());
db.SaveChanges();
//清空找回密码相关的cookies
Response.Cookies.Add(CookiesHelper.CookiesHelper.clearCookie("emailCodePassword"));
Response.Cookies.Add(CookiesHelper.CookiesHelper.clearCookie("emailAddressPassword"));
Tools.AlertAndRedirect("修改成功", Url.Action("login", "userManagement", new { area = "account" }));
return(Content("修改成功！"));
}
}
catch
{
Tools.AlertAndRedirect("验证出错,请与管理员联系", Url.Action("VerifyInfo", "passwordManager", new { area = "account" }));
return(Content("验证出错"));
}
}
public int GetSumPageArea(int pageSize)
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
int listSum = db.resourceArea.ToList().Count;
if ((listSum != 0) && listSum % pageSize == 0)
{
return(listSum / pageSize);
}
return((listSum / pageSize) + 1);
}
}
public int GetSumPagequesAnsw(int pageSize)
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
int listSum = db.quesAnswInfo.ToList().Count;
if ((listSum != 0) && listSum % pageSize == 0)
{
return(listSum / pageSize);
}
return((listSum / pageSize) + 1);
}
}
public int GetSumPage(int pageSize, Expression <Func <serverShowInfo, bool> > whereLambda)
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
int listSum = db.serverShowInfo.Where(whereLambda).ToList().Count;
if ((listSum != 0) && listSum % pageSize == 0)
{
return(listSum / pageSize);
}
return((listSum / pageSize) + 1);
}
}
public string add(userSecurity security)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
//先判断登录Id是否可用
var isLoginId = db.userSecurity.Where(u => u.loginId == security.loginId.Trim());
if (isLoginId.ToList().Count != 0)
{
return("用户已存在");
}
userSecurity user = new userSecurity
{
loginId = security.loginId,
userPwd = MD5Helper.MD5Helper.encrypt(security.userPwd)
};
//得到插入成功的数据对象以获得userId
userSecurity successUser = toolsHelpers.insertToolsController.insertUserSecurity(user);
if (successUser == null)
{
return("false");
}
//把这个userId写入userInfo表中
userInfo newUserInfo = new userInfo
{
userId = successUser.userId,
userName = successUser.loginId,
userAge = 0,
userSex = 2,
userEmail = null,
userStatus = 1,
userAccount = 0,
userIntroduce = "这个人很懒，没有说什么",
userHeaderPic = "/Resource/picture/DefaultHeadPic1.png",
};
if (toolsHelpers.insertToolsController.insertUserInfo(newUserInfo) == true)
{
Response.Redirect("/backStage/userManagement/Index");
return("success");
}
else
{
return("false");
}
}
}
catch
{
return("false");
}
}
public string checkEmail(string emailAddress)
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
var isExistEmail = db.userInfo.Where(u => u.userEmail == emailAddress.Trim());
if (isExistEmail.ToList().Count != 0)
{
//邮箱注册过了
return("EF");
}
}
return("T");
}
public string registerUser(userSecurity security, userInfo info, string code)
{
//使用entity framework 进行数据的插入
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
//先把用户写入userSecurity表
var isLoginID = db.userSecurity.Where <userSecurity>(u => u.loginId == security.loginId.Trim());
if (isLoginID.ToList().Count != 0)
{
return("已经有账户");
}
userSecurity obSecurity = new userSecurity
{
loginId = security.loginId.Trim(),
userPwd = MD5Helper.MD5Helper.encrypt(security.userPwd.Trim()),
};
db.userSecurity.Add(obSecurity);
db.SaveChanges();
//把userInfo表写入默认数据
int uniformId;
DbQuery <userSecurity> dbSecuritySureUserId = db.userSecurity.Where(u => u.loginId == security.loginId.Trim()) as DbQuery <userSecurity>;
userSecurity dbSecurity = dbSecuritySureUserId.FirstOrDefault();
uniformId = dbSecurity.userId;
userInfo obInfo = new userInfo
{
userId = uniformId,
userName = security.loginId.Trim(),
userAge = info.userAge,
userSex = info.userSex,
userEmail = info.userEmail,
userStatus = 1,
userAccount = 0,
userIntroduce = "这个人很懒，没有说什么",
userHeaderPic = "/Resource/picture/DefaultHeadPic1.png"
};
db.userInfo.Add(obInfo);
db.SaveChanges();
}
Response.Redirect(Url.Action("Index", "Home", new { area = "" }));
return("Ok");
}
catch (Exception EX)
{
return(EX.ToString());
}
}
public ActionResult PersonalDataUpdate(userInfo info)
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <userInfo> dbsearch = db.userInfo.Where(u => u.userId == info.userId) as DbQuery <userInfo>;
userInfo _userInfo = dbsearch.FirstOrDefault();
if (_userInfo != null)
{
if (info.userHeaderPic == null)
{
_userInfo.userHeaderPic = "/Resource/picture/DefaultHeadPic1.png";
}
else
{
_userInfo.userHeaderPic = info.userHeaderPic;
}
if (info.userName == null)
{
_userInfo.userName = "******";
}
else
{
_userInfo.userName = info.userName;
}
if (info.userAge == null)
{
_userInfo.userAge = 0;
}
else
{
_userInfo.userAge = info.userAge;
}
_userInfo.userSex = info.userSex;
_userInfo.userEmail = info.userEmail;
if (info.userIntroduce == null)
{
_userInfo.userIntroduce = "这个人很懒，没有写简介";
}
else
{
_userInfo.userIntroduce = info.userIntroduce;
}
db.SaveChanges();
}
}
Response.Redirect("/Home/PersonalData");
return(Content("sueccess"));
}
/// <summary>
/// 向论坛回复表中插入信息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static Boolean insertPostReply(postReply info)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
db.postReply.Add(info);
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
/// <summary>
/// 问答分区表增加数据
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static Boolean insertQuesArea(quesArea info)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
db.quesArea.Add(info);
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
/// <summary>
/// 向文章表中插入信息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static Boolean insertResourceInfo(resourceInfo info)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
db.resourceInfo.Add(info);
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
/// <summary>
/// 查找文章分区表中的数据
/// </summary>
/// <typeparam name="TKey"></typeparam>
/// <param name="whereLambda"></param>
/// <param name="orderBy"></param>
/// <returns></returns>
public static resourceArea[] selectResourceArea <TKey>(Expression <Func <resourceArea, bool> > whereLambda, Expression <Func <resourceArea, TKey> > orderBy)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <resourceArea> dataObject = db.resourceArea.Where(whereLambda).OrderBy(orderBy) as DbQuery <resourceArea>;
resourceArea[] infoList = dataObject.ToArray();
return(infoList);
}
}
catch
{
resourceArea[] nullInfo = new resourceArea[0];
return(nullInfo);
}
}
