public async Task <Models.Result <Models.Contact> > CreateContact(Models.ContactCreate contactCreate)
{
var result = new Models.Result <Models.Contact>();
try
{
//check Contact with same Email does not already exist
var checkEmailEntity = await _contactRepository.GetSingleAsync(x => x.Email == contactCreate.Email);
if (checkEmailEntity != null)
{
result.ErrorMessage = ERROR_CREATE_CONTACT_DUPLICATE_EMAIL;
return(result);
}
//Create new contactEntity by mapping contactCreate to Entities.Contact
var contactEntity = _mapper.Map <Entities.Contact>(contactCreate);
//Add contactEntity
await _contactRepository.AddAsync(contactEntity);
result.Data = _mapper.Map <Models.Contact>(contactEntity);
}
catch (Exception e)
{
result.ErrorMessage = LogError(e, "CreateContact", new object[] { contactCreate });
}
return(result);
}
public async Task <Models.Result <bool?> > UpdateContactStatus(ContactUpdateStatus contactUpdateStatus)
{
var result = new Models.Result <bool?>();
try
{
//Get contactEntity using GetSingleAsync to avoid tracking
var contactEntity = await _contactRepository.GetSingleAsync(x => x.Id == contactUpdateStatus.Id);
if (contactEntity == null)
{
result.Data = false; //result.Data = false => controller will return 404
return(result);
}
//Check/Update contactEntity properties as per contactUpdateStatus provided
if (!contactUpdateStatus.MapUpdatesToEntity(ref contactEntity))
{
result.ErrorMessage = ERROR_UPDATE_CONTACT_NO_CHANGES_DETECTED;
return(result);
}
result.Data = await _contactRepository.UpdateAsync(contactEntity);
}
catch (Exception e)
{
result.ErrorMessage = LogError(e, "UpdateContactStatus", new object[] { contactUpdateStatus });
}
return(result);
}
public Models.Result AddThreeNumbers(int number1, int number2, int number3, int token)
{
Models.Result result = new Models.Result();
string status;
//creating connection with the Authenticator to check if token is valid
authenticateInterface = Models.AuthenticatorAccessInterface.remoteConnection();
//returns validity status
status = authenticateInterface.validate(token);
//token validated
if (status.Equals("validated"))
{
//need to convert to string as string is the safest native data type for serialization
string serviceAnswer = (number1 + number2 + number3).ToString();
result.Value = serviceAnswer;
result.Reason = "Validated";
result.Status = "Value Returned";
}
else if (status.Equals("not validated"))//invalid token
{
//will not be sending the result as not validated
result.Value = null;
result.Reason = "Authentication Error";
result.Status = "Denied";
}
return(result);
}
public void IsSuccessful_IsFalse_WhenExceptionIsNotNull()
{
var sut = new Models.Result(new Exception());
sut.Exception.Should().NotBeNull();
sut.IsSuccessful.Should().BeFalse();
}
public JsonResult DeleteCatalog(int id, FormCollection collection)
{
Models.Result result = new Models.Result();
var assetCatalog = (from o in db.AssetCatalogs where o.Id == id select o).FirstOrDefault();
if (assetCatalog == null)
{
result.success = false;
result.obj = "找不到节点";
}
else
{
bool candelete = true;
if ((from o in db.AssetCatalogs where o.PId == id select o).Count() > 0)
{
candelete = true;
}
if ((from o in db.Materials where o.CatalogId == id select o).Count() > 0)
{
candelete = true;
}
if (!candelete)
{
result.success = false;
result.obj = "要删除的节点有子节点或已有物资为此物料类型，不能删除";
}
else
{
//db.Database.ExecuteSqlCommand(string.Format("delete departmentusers where departmentid={0}", id));
db.AssetCatalogs.Remove(assetCatalog);
db.SaveChanges();
result.success = true;
}
}
return Json(result);
}
public ActionResult AccessRestPassword(string acc, string access)
{
//http://60.251.140.166/WebTHCApp/Members/[email protected]&access=29b67e6e0c874958989747007b1d4e8c
THC_Library.Error error;
Models.Result result = new Models.Result();
if (string.IsNullOrEmpty(acc) || string.IsNullOrEmpty(access))
{
return(View("../Error/NotAllow"));
}
Models.Member member = new Models.Member();
bool bCodeExist = member.accessResetPassword(acc, access, out error);
if (error == null)
{
if (bCodeExist)
{
ViewBag.ACCESS_CODE = access;
ViewBag.ACC = acc;
return(View());
}
else
{
return(View("../Error/NotAllow"));
}
}
else
{
ViewBag.NUMBER = 201;
ViewBag.ERROR = "系統錯誤";
return(View("../Error/SystemError"));
}
}
private async Task HandleException(HttpContext context, Exception e)
{
string error = "";
void ReadException(Exception ex)
{
error += $"{ex.Message} | {ex.StackTrace} | {ex.InnerException}";
if (ex.InnerException != null)
{
ReadException(ex.InnerException);
}
}
ReadException(e);
// wrap friendly result for exception
string message = e.Message;
int code = AnalyzingException(e, ref message);
var result = new Models.Result(code, message);
var json = JsonConvert.SerializeObject(result, jsonSerializerSettings);
var input = AnalyzingRequestParameters(context);
logger.LogError(e, $"msg: {message} \r\n- input: {input} \r\n- err: {error}");
context.Response.Clear();
context.Response.ContentType = "text/json;charset=utf-8;";
await context.Response.WriteAsync(json);
}
public Models.Result MulTwoNumbers(int number1, int number2, int token)
{
Models.Result result = new Models.Result();
string status;
//connecting to the autheticator
authenticateInterface = Models.AuthenticatorAccessInterface.remoteConnection();
status = authenticateInterface.validate(token);
if (status.Equals("validated"))
{
string serviceAnswer = (number1 * number2).ToString();
result.Value = serviceAnswer;
result.Reason = "Validated";
result.Status = "Returned";
}
else if (status.Equals("not validated"))//invalid token
{
result.Value = null;
result.Reason = "Authentication Error";
result.Status = "Denied";
}
return(result);
}
public ActionResult DoRestPassword(string acc, string access, string pwd)
{
THC_Library.Error error;
Models.Result result = new Models.Result();
if (string.IsNullOrEmpty(acc) || string.IsNullOrEmpty(access) || string.IsNullOrEmpty(pwd))
{
result.Number = 201;
result.ErrorMessage = "無效的請求";
return(Json(result, "application/json", JsonRequestBehavior.AllowGet));
}
Models.Member member = new Models.Member();
member.doResetPassword(acc, access, pwd, out error);
if (error == null)
{
result.Number = 0;
result.ErrorMessage = "";
}
else
{
result.Number = 201;
result.ErrorMessage = "系統錯誤";
}
return(Json(result, "application/json", JsonRequestBehavior.AllowGet));
}
public ActionResult RemoveTask(int id)
{
var task = db.Tasks.Find(id);
if (task == null)
{
return(Json(new Models.Result(Models.ResultEnum.Fail, "该任务不存在"), JsonRequestBehavior.AllowGet));
}
if (task.author_userid != Convert.ToInt32(Session["uid"]))
{
return(Json(new Models.Result(Models.ResultEnum.Fail, "您没有权限操作"), JsonRequestBehavior.AllowGet));
}
db.Tasks.Remove(task);
bool res = db.SaveChanges() > 0;
Models.Result result = new Models.Result();
if (res)
{
result = new Models.Result(Models.ResultEnum.Success);
}
else
{
result = new Models.Result(Models.ResultEnum.Fail, "删除失败");
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public async Task AddResult(Models.Result result)
{
using (var context = new SqlServerDb())
{
var client = await context.Clients.Where(c => c.Ip.Equals(result.Client.Ip) && c.Isp.Equals(result.Client.Isp)).SingleOrDefaultAsync();
if (client != null)
{
result.Client = null;
result.ClientId = client.ClientId;
}
var server = await context.Servers.Where(s => s.Id == result.Server.Id).SingleOrDefaultAsync();
if (server != null)
{
result.Server = null;
result.ServerId = server.Id;
}
try
{
context.Results.Add(result);
await context.SaveChangesAsync().ConfigureAwait(false);
}
catch (Exception e)
{
Console.WriteLine($"Something went wrong saving the results to the database: {ExceptionHelpers.ConcatInnerExceptions(e)} These results were discarded. Timestamp: {DateTime.Now:T}");
}
}
}
public Models.Result AddTwoNumbers(int number1, int number2, int token)
{
Models.Result result = new Models.Result();
string status;
//calling connection and assign to the authenticator interface
authenticateInterface = Models.AuthenticatorAccessInterface.remoteConnection();
status = authenticateInterface.validate(token);
//if token is valid
if (status.Equals("validated"))
{
//has to be in string format as it is the safest native data type for serialization and de-serialization
string serviceAnswer = (number1 + number2).ToString();
result.Value = serviceAnswer;
result.Reason = "Validated";
result.Status = "Returned";
}
//invalid token
else if (status.Equals("not validated"))
{
//valus is not returned as not validated
result.Value = null;
result.Reason = "Authentication Error";
result.Status = "Denied";
}
return(result);
}
private async Task <List <Result> > GetResults(Models.Crew crew)
{
List <Models.Crew> allCrews = await _context.Crews.Include(c => c.Results)
.Include("Results.TimingPoint").ToListAsync();
Models.Result previousResult = null;
bool isFirst = true;
Models.TimingPoint startPoint = crew.Competition.TimingPoints.First();
List <Result> results = new List <Result>();
foreach (Models.Result result in crew.Results.OrderBy(x => x.TimingPoint.Order))
{
results.Add(new Result()
{
Id = result.TimingPointId,
Name = result.TimingPoint.Name,
TimeOfDay = result.TimeOfDay,
SectionTime = isFirst ? null : crew.RunTime(previousResult.TimingPoint, result.TimingPoint),
RunTime = isFirst ? null : crew.RunTime(startPoint, result.TimingPoint),
Rank = isFirst ? String.Empty : crew.Rank(allCrews.Where(x => x.RunTime(startPoint, result.TimingPoint).HasValue)
.OrderBy(x => x.RunTime(startPoint, result.TimingPoint)).ToList(),
startPoint, result.TimingPoint)
});
previousResult = result;
isFirst = false;
}
return(results);
}
public JsonResult MaterialDelete(int id, FormCollection collection)
{
if (!UserInfo.CurUser.HasRight("系统管理-物资名称维护")) return Json("没有权限");
//if (!UserInfo.CurUser.HasRight("系统管理-部门管理")) return Json(new Result { success = false, obj = "没有权限" });
Models.Result result = new Models.Result();
result.success = false;
string checksql1 = "select top 1 1 from materialinitems where materialid={0} union select top 1 1 from materialoutitems where materialid={0}";
if(db.Database.SqlQuery<int>(string.Format(checksql1,id)).Count()>0)
{
result.obj = "有入库或出库单使用过此物资名称，不能删除";
}
else
{
Material m = (from o in db.Materials where o.Id == id select o).FirstOrDefault();
if(m==null)
{
result.obj = "找不到物资名称";
}
else
{
db.Materials.Remove(m);
db.SaveChanges();
result.success = true;
}
}
return Json(result);
}
public void IsSuccessful_IsTrue_WhenExceptionIsNull()
{
var sut = new Models.Result();
sut.Exception.Should().BeNull();
sut.IsSuccessful.Should().BeTrue();
}
public string ExamRecord()
{
JxLib.UserExamController userExamController = new JxLib.UserExamController();
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
DatabaseLib.Tools tools = new DatabaseLib.Tools();
System.Collections.Hashtable data = tools.paramToData(context.Request.Form);
string user_id = context.Request.Cookies["user_id"].Value;
data["StudentID"] = user_id;
userExamController.ExamLog(data);
Models.Result result = new Models.Result();
if (userExamController.Result)
{
result.code = "200";
}
else
{
result.code = "0";
}
result.message = userExamController.Message;
return Newtonsoft.Json.JsonConvert.SerializeObject(result).Replace("\"", "'");
}
public Models.Result GetList(int pageIndex = 0, int pageSize = 20)
{
Models.Result result = new Models.Result();
result.IsOk = true;
result.Data = Models.Ev.GetList(pageIndex, pageSize);
return(result);
}
public Models.Result GetDetay(int Id)
{
Models.Result result = new Models.Result();
result.IsOk = true;
result.Data = Models.Ev.GetDetay(Id);
return(result);
}
public IActionResult ActionResult(Models.Result result)
{
if (result.Success)
{
return(new OkObjectResult(result));
}
return(new BadRequestObjectResult(result));
}
public string SendSms()
{
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];
string account = "cf_yunejia";
string password = "******";//密码可以使用明文密码或使用32位MD5加密
string mobile = context.Request.Form["mobile"];
Random rad = new Random();
int mobile_code = rad.Next(1000, 10000);
string content = "您的验证码是：" + mobile_code + " 。请不要把验证码泄露给其他人。";
//Session["mobile"] = mobile;
//Session["mobile_code"] = mobile_code;
string postStrTpl = "account={0}&password={1}&mobile={2}&content={3}";
UTF8Encoding encoding = new UTF8Encoding();
byte[] postData = encoding.GetBytes(string.Format(postStrTpl, account, password, mobile, content));
HttpWebRequest myRequest = (HttpWebRequest)WebRequest.Create(PostUrl);
myRequest.Method = "POST";
myRequest.ContentType = "application/x-www-form-urlencoded";
myRequest.ContentLength = postData.Length;
Stream newStream = myRequest.GetRequestStream();
// Send the data.
newStream.Write(postData, 0, postData.Length);
newStream.Flush();
newStream.Close();
HttpWebResponse myResponse = (HttpWebResponse)myRequest.GetResponse();
Models.Result result = new Models.Result();
if (myResponse.StatusCode == HttpStatusCode.OK)
{
StreamReader reader = new StreamReader(myResponse.GetResponseStream(), Encoding.UTF8);
string res = reader.ReadToEnd();
int len1 = res.IndexOf("</code>");
int len2 = res.IndexOf("<code>");
string code = res.Substring((len2 + 6), (len1 - len2 - 6));
int len3 = res.IndexOf("</msg>");
int len4 = res.IndexOf("<msg>");
string msg = res.Substring((len4 + 5), (len3 - len4 - 5));
result.message = "短息已发送,请注意接收!";
result.code = "200";
result.data = mobile_code.ToString();
}
else
{
result.message = "短息发送失败!";
result.code = "0";
}
return Newtonsoft.Json.JsonConvert.SerializeObject(result).Replace("\"", "'");
}
public JsonResult CatalogJson()
{
Models.Result result = new Models.Result();
var list = from o in db.AssetCatalogs select new TreeNode { id = o.Id, name = o.Name, pId = o.PId, tag = o.CatalogType };
result.success = true;
result.obj = list;
return Json(result);
}
public ActionResult EditUserAction(int id, string name, string account, string email, string system_authority)
{
if (string.IsNullOrEmpty(name))
{
return(Json(new Models.Result(Models.ResultEnum.Fail, "error", "请输入姓名")));
}
if (string.IsNullOrEmpty(account))
{
return(Json(new Models.Result(Models.ResultEnum.Fail, "error", "请输入手机号")));
}
if (!Comm.ValidateMobile(account))
{
return(Json(new Models.Result(Models.ResultEnum.Fail, "error", "手机号格式错误")));
}
//检查手机号是否存在
if (db.Users.Where(w => w.account == account && w.id != id).Count() > 0)
{
return(Json(new Models.Result(Models.ResultEnum.Fail, "error", "手机号已存在")));
}
if (string.IsNullOrEmpty(email))
{
return(Json(new Models.Result(Models.ResultEnum.Fail, "error", "请输入Email")));
}
if (!Comm.ValidateEmail(email))
{
return(Json(new Models.Result(Models.ResultEnum.Fail, "error", "Email格式错误")));
}
//检查手机号是否存在
if (db.Users.Where(w => w.email == email && w.id != id).Count() > 0)
{
return(Json(new Models.Result(Models.ResultEnum.Fail, "error", "Email已存在")));
}
var euser = new Models.Users()
{
id = id
};
db.Entry(euser).State = System.Data.Entity.EntityState.Unchanged;
euser.name = name;
euser.account = account;
euser.email = email;
euser.system_authority = system_authority;
var res = db.SaveChanges() > 0;
Models.Result result;
if (res)
{
result = new Models.Result(Models.ResultEnum.Success, "更新成功");
}
else
{
result = new Models.Result(Models.ResultEnum.Fail, "更新失败");
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult RenewUserInfo2(HttpPostedFileBase userFile)
{
byte[] bImage = null;
THC_Library.Error error;
Models.Result result = new Models.Result();
if (Session["tk"] == null)
{
result.Number = 999;
result.Verify = 0;
result.ErrorMessage = "無效的操作";
return(Json(result, "application/json", JsonRequestBehavior.AllowGet));
}
var reqMail = Request.Form["ml"];
var reqTicket = Request.Form["tk"];
var reqMobil = Request.Form["m"];
var reqGender = Request.Form["g"];
var reqAge = Request.Form["a"];
var reqIId = Request.Form["iid"];
var reqAddr = Request.Form["addr"];
Models.Member member = new Models.Member();
if (userFile != null)
{
bImage = member.compressImage(userFile.InputStream);
}
int iRowCount = member.updateAccount(reqMail, reqTicket, reqMobil, reqGender,
reqAge, reqIId, reqAddr, bImage, out error);
if (error == null)
{
if (iRowCount > 0)
{
result.Number = 0;
result.Verify = 1;
result.Addition = iRowCount.ToString();
}
else
{
result.Number = 20;
result.Verify = 0;
result.ErrorMessage = "資料未更新錯誤";
}
}
else
{
result.Number = error.Number;
result.ErrorMessage = error.ErrorMessage;
}
return(Json(result, "application/json", JsonRequestBehavior.AllowGet));
}
public EffortUpdate(TourModelContainer db, Models.Result dbResult, int segmentID, double elevationGain)
{
this.db = db;
this.dbResult = dbResult;
this.segmentID = segmentID;
this.elevationGain = elevationGain;
LeaderBoards = new List<Models.LeaderBoard>();
AthleteEffortsList = new Dictionary<int, List<int>>();
}
public JsonResult PerformanceDelete(int id)
{
Models.Result result = new Models.Result();
Performance s = db.Performance.Find(id);
db.Performance.Remove(s);
db.SaveChanges();
result.success = true;
result.obj = "已删除";
return Json(result);
}
public ActionResult ShowFavorite(String name)
{
Models.Result results = new Models.Result();
results.docs = new List<String>();
var items = DocumentDBRepository<Models.Item>.Get10Items(name);
foreach( var item in items ) {
results.docs.Add(JsonConvert.SerializeObject(item, Formatting.Indented));
}
Response.Write(JsonConvert.SerializeObject(results));
return null;
}
public JsonResult Delete(int id)
{
if (!UserInfo.CurUser.HasRight("业务管理-汇率修改")) return Json(new Result { obj = "没有权限" });
Models.Result result = new Models.Result();
ExchangeRate s = db.ExchangeRates.Find(id);
db.ExchangeRates.Remove(s);
db.SaveChanges();
result.success = true;
result.obj = "已删除";
return Json(result);
}
public ActionResult RSSFeed(int timestamp)
{
Models.Result results = new Models.Result();
results.docs = new List<String>();
var items = DocumentDBRepository<Models.Feed>.Get10Feed(timestamp);
foreach (var item in items)
{
results.docs.Add(JsonConvert.SerializeObject(item, Formatting.Indented));
}
Response.Write(JsonConvert.SerializeObject(results));
return null;
}
public JsonResult THC_Member_02()
{
THC_Library.Error error = null;
string strTick = Request.Headers["QPID-TICK"];
string strData = Request.Headers["QPID-DATA"];
error = WebTHCAPP.Models.RequestChecker.CheckRequest(strTick, strData);
Models.Result result = new Models.Result();
if (error == null)
{
var reqMail = Request.Form["mail"];
var reqPwd = Request.Form["pwd"];
int state;
Models.Member member = new Models.Member();
long lgTimestamp = member.verifyAccount(reqMail, reqPwd, out state, out error);
if (lgTimestamp > -1)
{
result.Verify = 1;
result.Ticket = lgTimestamp.ToString();
result.Acc = reqMail;
}
else
{
result.Ticket = lgTimestamp.ToString();
result.Number = 10;
result.Verify = 0;
if (state == 1)
{
result.ErrorMessage = "帳號不存在";
}
else if (state == 2)
{
result.ErrorMessage = "密碼錯誤";
}
else
{
result.ErrorMessage = "登入錯誤";
}
}
}
if (error != null)
{
result.Number = error.Number;
result.ErrorMessage = error.ErrorMessage;
}
return(Json(result, "application/json", JsonRequestBehavior.AllowGet));
}
public async Task <Models.Result <bool?> > DeleteContact(Guid contactId, Guid deletedUserId)
{
var result = new Models.Result <bool?>();
try
{
result.Data = await _contactRepository.DeleteAsync(contactId, deletedUserId);
}
catch (Exception e)
{
result.ErrorMessage = LogError(e, "DeleteContact", new object[] { contactId });
}
return(result);
}
public ActionResult RenewUserInfo()
{
THC_Library.Error error;
Models.Result result = new Models.Result();
//if (Session["tk"] == null)
//{
// result.Number = 10;
// result.Verify = 0;
// result.ErrorMessage = "無效的操作";
// return Json(result, "application/json", JsonRequestBehavior.AllowGet);
//}
var reqMail = Request.Form["ml"];
var reqTicket = Request.Form["tk"];
var reqMobil = Request.Form["m"];
var reqGender = Request.Form["g"];
var reqAge = Request.Form["a"];
var reqIId = Request.Form["iid"];
var reqAddr = Request.Form["addr"];
Models.Member member = new Models.Member();
int iRowCount = member.updateAccount(reqMail, reqTicket, reqMobil, reqGender,
reqAge, reqIId, reqAddr, null, out error);
if (error == null)
{
if (iRowCount > 0)
{
result.Number = 0;
result.Verify = 1;
result.Addition = iRowCount.ToString();
}
else
{
result.Number = 20;
result.Verify = 0;
result.ErrorMessage = "資料未更新錯誤";
}
}
else
{
result.Number = error.Number;
result.ErrorMessage = error.ErrorMessage;
}
return(Json(result, "application/json", JsonRequestBehavior.AllowGet));
}
protected override void HandleUnauthorizedRequest(System.Web.Mvc.AuthorizationContext filterContext)
{
if (filterContext.HttpContext.User.Identity.IsAuthenticated == false)
{
Models.Result res2 = new Models.Result((int)Models.ResultCodeEnum.Login, "请登录以后在操作。",null);
string temp2 = new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(res2);
filterContext.HttpContext.Response.Write(temp2);
filterContext.HttpContext.Response.End();
return;
}
//base.HandleUnauthorizedRequest(filterContext);
Models.Result res = new Models.Result ( (int)Models.ResultCodeEnum.Error ,"你无权访问。" ,null);
string temp = new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(res);
filterContext.HttpContext.Response.Write(temp);
filterContext.HttpContext.Response.End();
}
public JsonResult THC_Member_03()
{
THC_Library.Error error = null;
string strTick = Request.Headers["QPID-TICK"];
string strData = Request.Headers["QPID-DATA"];
error = WebTHCAPP.Models.RequestChecker.CheckRequest(strTick, strData);
Models.Result result = new Models.Result();
if (error == null)
{
string regActivity = Request.Form["ac"];
string regCode = Request.Form["code"];
string regMail = Request.Form["fb"];
string regName = Request.Form["name"];
string regGender = Request.Form["gender"];
string strAccount;
Models.Member member = new Models.Member();
long lgTimestamp = member.verifyFaceBookAccount(regMail, regName, regGender, out strAccount, out error);
if (lgTimestamp > -1)
{
result.Verify = 1;
result.Ticket = lgTimestamp.ToString();
result.Acc = strAccount;
//retJson = string.Format("[{{ \"VERIFY\" : 1 , \"TICKET\" : \"{0}\" , \"ACC\" : \"{1}\" }} ]",
// lgTimestamp, strAccount);
}
else
{
result.Ticket = lgTimestamp.ToString();
result.Number = 10;
result.Verify = 0;
result.ErrorMessage = "登入錯誤";
//retJson = "[{ \"VERIFY\" : 0 , \"MESSAGE\" : \"登入錯誤\"} ]";
}
}
if (error != null)
{
result.Number = error.Number;
result.ErrorMessage = error.ErrorMessage;
}
return(Json(result, "application/json", JsonRequestBehavior.AllowGet));
}
public ActionResult MyPoto()
{
THC_Library.Error error;
Models.Result result = new Models.Result();
//if (Session["tk"] == null)
//{
// result.Number = 10;
// result.Verify = 0;
// result.ErrorMessage = "無效的操作";
// return Json(result, "application/json", JsonRequestBehavior.AllowGet);
//}
//Models.AppSession appSession = (Models.AppSession)Session["tk"];
//var reqMail = appSession.Account;
//var reqTicket = appSession.Ticket;
var reqMail = Request.Form["ml"];
var reqTicket = Request.Form["tk"];
Models.Member member = new Models.Member();
byte[] myPoto = member.getMyPoto(reqMail, reqTicket, out error);
if (error == null)
{
if (myPoto != null)
{
result.Number = 0;
result.Verify = 1;
result.Addition = "data:image/png;base64," + Convert.ToBase64String(myPoto, 0, myPoto.Length);
}
else
{
result.Number = 21;
result.Verify = 0;
result.ErrorMessage = "取得圖檔錯誤";
}
}
else
{
result.Number = error.Number;
result.ErrorMessage = error.ErrorMessage;
}
return(Json(result, "application/json", JsonRequestBehavior.AllowGet));
}
private DbCommand CreateResultInsertCommand(Models.Result result, int eventId)
{
DbCommand resultInsertCommand = _dbConnection.CreateCommand();
resultInsertCommand.CommandText = "INSERT INTO Results (EventId,DriverId,Car,Class,Number,RawTime,PaxTime) " +
"OUTPUT INSERTED.ID " +
"VALUES (@EventId,@DriverId,@Car,@Class,@Number,@RawTime,@PaxTime)";
Utilities.Extensions.AddParamWithValue(ref resultInsertCommand, "@EventId", eventId);
Utilities.Extensions.AddParamWithValue(ref resultInsertCommand, "@DriverId", result.DriverInfo.Id);
Utilities.Extensions.AddParamWithValue(ref resultInsertCommand, "@Car", result.Car);
Utilities.Extensions.AddParamWithValue(ref resultInsertCommand, "@Class", result.ClassId);
Utilities.Extensions.AddParamWithValue(ref resultInsertCommand, "@Number", result.ClassNumber);
Utilities.Extensions.AddParamWithValue(ref resultInsertCommand, "@RawTime", result.RawTime);
Utilities.Extensions.AddParamWithValue(ref resultInsertCommand, "@PaxTime", result.PaxTime);
return(resultInsertCommand);
}
public JsonResult Delete(int id)
{
Models.Result result = new Models.Result();
Client s = db.Clients.Find(id); if (!UserInfo.CurUser.HasRight("业务管理-客户录入")) return Json(new Result { obj = "没有权限" });
var list = (from o in db.SalesContracts where o.ClientId == id select o).ToList();
if(list.Count>0)
{
result.obj = "Client has contract ,can not be deleted";
}else
{
db.Clients.Remove(s);
db.SaveChanges(); BLL.Utilities.AddLogAndSave(s.Id, Client.LogClass, "删除", "");
result.success = true;
result.obj = "已删除";
}
return Json(result);
}
public JsonResult Delete(int id)
{
Models.Result result = new Models.Result();
RentContract s = db.RentContracts.Find(id); if (!UserInfo.CurUser.HasRight("租赁管理-客户维护")) return Json(new Result { obj = "没有权限" });
//var query = (from o in db.RentContractRooms where o.RentContractId == id select o.Id).Count();
//if (query > 0)
//{
// result.obj = "已有合同记录，不能删除";
//}
//else
//{
// db.RentContracts.Remove(s);
// db.SaveChanges(); BLL.Utilities.AddLogAndSave(s.Id, RentContract.LogClass, "删除", "");
// result.success = true;
// result.obj = "已删除";
//}
return Json(result);
}
public JsonResult Delete(int id)
{
Models.Result result = new Models.Result();
Company s = db.Companies.Find(id); if (!UserInfo.CurUser.HasRight("租赁管理-公司账号")) return Json(new Result { obj = "没有权限" });
var query = (from o in db.RentIncomes where o.CompanyId == id select o.Id).Count();
if (query > 0)
{
result.obj = "已有收款记录，不能删除";
}
else
{
db.Companies.Remove(s);
db.SaveChanges(); BLL.Utilities.AddLogAndSave(s.Id, Company.LogClass, "删除", "");
result.success = true;
result.obj = "已删除";
}
return Json(result);
}
public JsonResult Delete(int id)
{
Models.Result result = new Models.Result();
SaleStore s = db.SaleStores.Find(id);
//var query = from o in db where o.AssetId == id select o;
//if (query.Count() > 0)
//{
// result.success = false;
// result.obj = "有用户领用记录，无法删除";
//}
//else
//{
db.SaleStores.Remove(s);
db.SaveChanges(); BLL.Utilities.AddLog(s.Id,SaleStore.LogClass, "删除", "");
result.success = true;
result.obj = "已删除";
//}
return Json(result);
}
public ActionResult ResetPasswordAction(int id, string password, string password2)
{
if (string.IsNullOrEmpty(password))
{
return(Json(new Models.Result(Models.ResultEnum.Fail, "error", "请输入密码")));
}
if (password != password2)
{
return(Json(new Models.Result(Models.ResultEnum.Fail, "error", "两次密码不一致")));
}
int uid = Convert.ToInt32(Session["uid"]);
if (id != uid)
{
//我是否有权利修改其他人的密码
Models.Users suser = Session["user"] as Models.Users;
if (!suser.authoritys.Contains(3))
{
return(Json(new Models.Result(Models.ResultEnum.Fail, "你没有权限操作"), JsonRequestBehavior.AllowGet));
}
}
var user = new Models.Users()
{
id = id
};
db.Entry(user).State = System.Data.Entity.EntityState.Unchanged;
user.password = password.GetMd5();
var res = db.SaveChanges() > 0;
Models.Result result;
if (res)
{
result = new Models.Result(Models.ResultEnum.Success, "密码重置成功");
}
else
{
result = new Models.Result(Models.ResultEnum.Fail, "密码重置失败");
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
private int InsertResult(Models.Result result, int eventId)
{
int resultId = 0;
// Insert result into database
using (DbCommand resultInsertCommand = CreateResultInsertCommand(result, eventId))
{
// Execute insert command
resultId = (int)resultInsertCommand.ExecuteScalar();
if (resultId < 0)
{
Console.WriteLine("Error inserting result data into Database!");
// TODO handle error
}
}
return(resultId);
}
public JsonResult BuildingDelete(int id)
{
Models.Result result = new Models.Result();
Building s = db.Buildings.Find(id); if (!UserInfo.CurUser.HasRight("租赁管理-项目维护")) return Json(new Result { obj = "没有权限" });
var query = (from o in db.Rooms where o.BuildingId == id select o.Id).Count();
if (query > 0)
{
result.obj = "已有房屋记录，不能删除";
}
else
{
db.Buildings.Remove(s);
db.SaveChanges(); BLL.Utilities.AddLogAndSave(s.Id, Building.LogClass, "删除", "");
result.success = true;
result.obj = "已删除";
}
return Json(result);
}
public JsonResult THC_Member_01()
{
THC_Library.Error error = null;
long timeStamp = 0;
int newKey = -1;
string strTick = Request.Headers["QPID-TICK"];
string strData = Request.Headers["QPID-DATA"];
error = WebTHCAPP.Models.RequestChecker.CheckRequest(strTick, strData);
Models.Result result = new Models.Result();
if (error == null)
{
var reqMail = Request.Form["mail"];
var reqPwd = Request.Form["pwd"];
var reqMobil = Request.Form["mobil"];
var strAccount = Request.Form["acc"];
var reqGender = Request.Form["gender"];
var reqAge = Request.Form["age"];
Models.Member member = new Models.Member();
newKey = member.newAccount(strAccount, reqMail, reqMobil, reqPwd, reqGender, reqAge, out timeStamp, out error);
result.Addition = newKey.ToString();
result.Ticket = timeStamp.ToString();
result.Acc = strAccount;
result.Number = 0;
//retJson = string.Format("[{{ \"NewId\" : {0}, \"TICKET\" : \"{1}\" , \"ACC\" : \"{2}\" }} ]",
// newKey, timeStamp, strAccount);
}
if (error != null)
{
result.Number = error.Number;
result.ErrorMessage = error.ErrorMessage;
//retJson = Newtonsoft.Json.JsonConvert.SerializeObject(error);
}
return(Json(result, "application/json", JsonRequestBehavior.AllowGet));
}
public JsonResult Delete(int id)
{
if (!UserInfo.CurUser.HasRight("业务管理-供应商修改")) return Json(new Result { obj = "没有权限" });
Models.Result result = new Models.Result();
Supplier s = db.Suppliers.Find(id);
var query = from o in db.Products where o.SupplierId == id select o;
if (query.Count() > 0)
{
result.success = false;
result.obj = "有产品记录，无法删除";
}
else
{
db.Suppliers.Remove(s);
db.SaveChanges(); BLL.Utilities.AddLog(s.Id, Supplier.LogClass, "删除", "");
result.success = true;
result.obj = "已删除";
}
return Json(result);
}
public Models.Result SaveData(string formID, string dataID, Dictionary <string, object> dictionary)
{
Models.Result result = null;
var entity = this.Find(formID, dataID);
if (entity == null)
{
result = this.Create(formID, dataID);
if (result is Models.DataResult <Entities.DynamicForm> temp)
{
entity = temp.Data;
}
else
{
return(result);
}
}
else
{
result = this.HasPermit(entity);
if (result.Success == false)
{
return(result);
}
}
var data = entity.Data ?? new Dictionary <string, object>();
var fields = entity.CurrentNode.Fields ?? new List <string>();
foreach (var field in fields)
{
if (dictionary.TryGetValue(field, out object value))
{
data[field] = value;
}
}
var filter = this.BuildFilterEqualID <Entities.DynamicForm>(dataID);
var set = Builders <Entities.DynamicForm> .Update.Set(nameof(Entities.DynamicForm.Data), data);
this.DynamicForms(formID).UpdateOne(filter, set, UpdateOptions);
return(Models.Result.Create());
}
public async Task <IActionResult> DeleteByCrewAndTimingPoint(int id, int timingPointId)
{
Models.Crew crew = await _context.Crews.Include(x => x.Results).FirstOrDefaultAsync(x => x.BroeCrewId == id);
if (crew == null)
{
return(NotFound());
}
Models.Result result = crew.Results.FirstOrDefault(x => x.TimingPointId == timingPointId);
if (result == null)
{
return(NotFound());
}
_context.Results.Remove(result);
await _context.SaveChangesAsync();
return(NoContent());
}
public ActionResult ForgestPassword()
{
THC_Library.Error error;
Models.Result result = new Models.Result();
var reqMail = Request.Form["ml"];
string accessCode;
Models.Member member = new Models.Member();
member.requestResetPassword(reqMail, out accessCode, out error);
if (error == null)
{
//String myURL = HttpContext.Request.Url.Host;
String strPathAndQuery = Request.Url.PathAndQuery;
String strUrl = Request.Url.AbsoluteUri.Replace(strPathAndQuery, "/");
Models.MailClass mail = new Models.MailClass();
mail.Send(reqMail, accessCode, strUrl, out error);
if (error != null)
{
result.Number = error.Number;
result.ErrorMessage = error.ErrorMessage;
}
else
{
result.Number = 0;
result.ErrorMessage = "";
}
}
else
{
result.Number = error.Number;
result.ErrorMessage = error.ErrorMessage;
}
return(Json(result, "application/json", JsonRequestBehavior.AllowGet));
}
public JsonResult Delete(int id)
{
if (!UserInfo.CurUser.HasRight("业务管理-产品修改")) Json(new Result { obj = "没有权限" });
Models.Result result = new Models.Result();
Product s = db.Products.Find(id); if (!UserInfo.CurUser.HasRight("业务管理-产品修改")) return Json(new Result { obj = "没有权限" });
var num =
db.Database.SqlQuery<int>(
string.Format("select isnull(count(1),0) from salescontractitems where productid={0}", id)).
FirstOrDefault();
if(num>0)
{
result.obj = "已有销售记录，不能删除";
}
else
{
db.Products.Remove(s);
db.SaveChanges(); BLL.Utilities.AddLogAndSave(s.Id, Product.LogClass, "删除", "");
result.success = true;
result.obj = "已删除";
}
return Json(result);
}
public JsonResult ContractList( string seq , string contractnum , string projectnum ,
string projectname , string rfid , string contractplace ,
string bcompanay , string money , int pageidx =1, int pagesize = 20)
{
Contract query = new Contract();
query.seq = seq;
query.contractnum = contractnum;
query.projectnum = projectnum;
query.projectname = projectname;
query.contractrfid = rfid;
query.contractplace = contractplace;
query.bcompany = bcompanay;
query.money = money;
Page<Contract> page = GetData(query, pageidx, pagesize);
ContractMvcWeb.Models.Result result = new Models.Result((int)Models.ResultCodeEnum.Success, "", page);
JsonResult json = new JsonResult();
json.Data = result;
json.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
return json;
}
public JsonResult DeleteUser(int id, FormCollection collection)
{
if (!UserInfo.CurUser.HasRight("系统管理-部门管理")) return Json(new Result { success = false, obj = "没有权限" });
Models.Result result = new Models.Result();
result.success = true;
//var usercount = (from o in db.Plans where o.UserId == dictId select o).Count();
//if (usercount > 0)
//{
// result.success = false;
// result.obj = "已有计划，不能删除";
//}
//var auditcount = (from o in db.PlanAudits where o.Auditor == dictId select o).Count();
//if (auditcount > 0)
//{
// result.success = false;
// result.obj = "曾经做过计划考评，不能删除";
//}
if (result.success == true)
{
var r = (from o in db.SystemUsers where o.Id == id select o).FirstOrDefault();
if (r == null)
{
result.success = false;
result.obj = "找不到用户";
}
else
{
db.SystemUsers.Remove(r);
db.SaveChanges();
}
}
return Json(result);
}
public JsonResult Delete(int id)
{
if (!UserInfo.CurUser.HasRight("门店销售-会员维护")) return Json(new Result { obj = "没有权限" });
Models.Result result = new Models.Result();
Card s = db.Cards.Find(id);
var sales = (from o in db.ProductSales where o.CardId == s.Id select o).ToList();
if (sales.Count > 0)
{
result.obj = "会员存在消费记录，不能删除";
}
else
{
db.Cards.Remove(s);
BLL.Utilities.AddLog(s.Id, Card.LogClass, "删除", "");
db.SaveChanges();
result.success = true;
result.obj = "已删除";
}
return Json(result);
}
public JsonResult UpdateDepartmentParent(int id, int pid)
{
if (!UserInfo.CurUser.HasRight("系统管理-部门管理")) return Json(new Result { success = false, obj = "没有权限" });
Models.Result result = new Models.Result();
var dept = (from o in db.Departments where o.Id == id select o).FirstOrDefault();
if (dept == null)
{
result.success = false;
result.obj = "找不到部门";
}
else if (DepartmentBLL.IsParnet(id, pid))
{
result.success = false;
result.obj = "不能拖动到子部门下";
}
else
{
dept.PId = pid;
db.SaveChanges();
DepartmentBLL.UpdateDepartments();
result.success = true;
}
return Json(result);
}
public JsonResult PartDepartmentJson(int rootId)
{
Models.Result result = new Models.Result();
if (rootId == 0) rootId = 1;
List<TreeNode> list = new List<TreeNode>();
var root = (from o in DepartmentBLL.Departments where o.Id == rootId select o).FirstOrDefault();
if (root != null)
{
list.Add(new TreeNode { id = root.Id, name = root.Name, pId = root.PId, tag = root.DepartmentType, open = true });
}
result.success = true;
result.obj = list;
return Json(result);
}
public JsonResult UpdateDepartment(int id, FormCollection collection)
{
if (!UserInfo.CurUser.HasRight("系统管理-部门管理")) return Json(new Result { success = false, obj = "没有权限" });
Models.Result result = new Models.Result();
var dept = (from o in db.Departments where o.Id == id select o).FirstOrDefault();
if (dept == null)
{
dept = new Department();
dept.PId = int.Parse(collection["pid"]);
db.Departments.Add(dept);
}
dept.Name = collection["name"];
dept.DepartmentType = collection["departmenttype"];
if (dept.DepartmentType == null) dept.DepartmentType = "";
db.SaveChanges();
DepartmentBLL.UpdateDepartments();
result.success = true;
result.obj = dept;
return Json(result);
}
public JsonResult DepartmentUser(int id)
{
if (!UserInfo.CurUser.HasRight("系统管理-部门管理")) return Json(new Result { success = false, obj = "没有权限" });
Models.Result result = new Models.Result();
var list = from o in db.DepartmentUsers join u in db.SystemUsers on o.UserId equals u.Id where o.DepartmentId == id select new { userid = o.UserId, username = u.LoginName, workno = u.Name, ismanager = o.IsManager };
result.success = true;
result.obj = list;
return Json(result);
}
public JsonResult DepartmentSetManager(int id, FormCollection collection)
{
if (!UserInfo.CurUser.HasRight("系统管理-部门管理")) return Json(new Result { success = false, obj = "没有权限" });
Models.Result result = new Models.Result();
string managers = collection["managers[]"];
string[] managerlist = managers.Split(',');
foreach (string s in managerlist)
{
int i; int.TryParse(s, out i);
if (i > 0)
{
DepartmentUser du = (from o in db.DepartmentUsers where o.DepartmentId == id && o.UserId == i select o).FirstOrDefault();
if (du != null)
{
du.IsManager = 1;
}
}
}
db.SaveChanges(); DepartmentBLL.UpdateDepartments();
result.success = true;
return Json(result);
}
public JsonResult DepartmentJson(int parentid = 0)
{
Models.Result result = new Models.Result();
result.success = true;
if (parentid == 0)
{
result.obj = from o in DepartmentBLL.Departments select new TreeNode { id = o.Id, name = o.Name, pId = o.PId, tag = o.DepartmentType, open = o.PId == 0 };
}
else
{
result.obj = from o in DepartmentBLL.GetDepartmentByParent(parentid) select new TreeNode { id = o.Id, name = o.Name, pId = o.PId, tag = o.DepartmentType, open = o.PId == 0 };
}
return Json(result);
}
public JsonResult DepartmentAddUser(int id, int userid)
{
if (!UserInfo.CurUser.HasRight("系统管理-部门管理")) return Json(new Result { success = false, obj = "没有权限" });
Models.Result result = new Models.Result();
DepartmentUser du = (from o in db.DepartmentUsers where o.DepartmentId == id && o.UserId == userid select o).FirstOrDefault();
if (du == null)
{
du = new DepartmentUser { UserId = userid, DepartmentId = id };
db.DepartmentUsers.Add(du);
db.SaveChanges();
DepartmentBLL.UpdateDepartments();
}
result.success = true;
return Json(result);
}
public JsonResult DeleteRole(int id, FormCollection collection)
{
if (!UserInfo.CurUser.HasRight("系统管理-部门管理")) return Json(new Result { success = false, obj = "没有权限" });
Models.Result result = new Models.Result();
var usercount = (from o in db.RoleUsers where o.RoleId == id select o).Count();
if (usercount > 0)
{
result.success = false;
result.obj = "已有用户使用此角色，不能删除";
}
else
{
var r = (from o in db.Roles where o.Id == id select o).FirstOrDefault();
if (r == null)
{
result.success = false;
result.obj = "找不到节点";
}
else
{
db.Roles.Remove(r);
db.SaveChanges();
result.success = true;
}
}
return Json(result);
}
public JsonResult DeleteDepartment(int id, FormCollection collection)
{
if (!UserInfo.CurUser.HasRight("系统管理-部门管理")) return Json(new Result { success = false, obj = "没有权限" });
Models.Result result = new Models.Result();
var dept = (from o in db.Departments where o.Id == id select o).FirstOrDefault();
if (dept == null)
{
result.success = false;
result.obj = "找不到节点";
}
else
{
if ((from o in db.Departments where o.PId == id select o).Count() > 0)
{
result.success = false;
result.obj = "要删除的节点有子节点，请先删除子节点";
}
else
{
db.Database.ExecuteSqlCommand(string.Format("delete departmentusers where departmentid={0}", id));
db.Departments.Remove(dept);
db.SaveChanges();
DepartmentBLL.UpdateDepartments();
result.success = true;
}
}
return Json(result);
}
