public string FeelGood(string target) { if (Session["member"] != null) { var loginMember = (tMember)Session["member"]; int select = Convert.ToInt32(target); tActivity theTarget = db.tActivity.FirstOrDefault(x => x.f活動編號 == select); int index = -1; if (!string.IsNullOrEmpty(theTarget.f活動按過讚的會員編號)) { var past = theTarget.f活動按過讚的會員編號.Split(','); //將按過讚得會員編號 字串 切割 成陣列 index = Array.IndexOf(past, loginMember.f會員編號.ToString()); //透過查詢值在陣列內的索引值(不存在則回傳-1) //查看是否會員編號包含在陣列內 } if (index == -1) //陣列起始為0,因此只要pos>=0則表示該編號已存在,反之index=-1表示該編號不存在,可執行 { theTarget.f活動讚數 = (theTarget.f活動讚數 + 1); theTarget.f活動按過讚的會員編號 += "," + loginMember.f會員編號; db.SaveChanges(); } else { return("0"); } } return("1"); }
public string FeelGood(int memberID, int actID) { tActivity theTarget = db.tActivity.FirstOrDefault(x => x.f活動編號 == actID); int index = -1; if (!string.IsNullOrEmpty(theTarget.f活動按過讚的會員編號)) { var past = theTarget.f活動按過讚的會員編號.Split(','); //將按過讚得會員編號 字串 切割 成陣列 index = Array.IndexOf(past, memberID.ToString()); //透過查詢值在陣列內的索引值(不存在則回傳-1) //查看是否會員編號包含在陣列內 } if (index == -1)//陣列起始為0,因此只要pos>=0則表示該編號已存在,反之index=-1表示該編號不存在,可執行 { theTarget.f活動讚數 = (theTarget.f活動讚數 + 1); theTarget.f活動按過讚的會員編號 += "," + memberID; db.SaveChanges(); return(null); } else { return("0"); } }
public async Task <IHttpActionResult> PuttActivity(int id, tActivity Activity) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != Activity.ID) { return(BadRequest()); } db.Entry(Activity).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!tActivityExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public CGetMore ReadMore(int memberID, int actID) { AddViewCounts(actID); var loginMember = db.tMember.Where(t => t.f會員編號 == memberID).FirstOrDefault(); tActivity targetAct = db.tActivity.Where(t => t.f活動編號 == actID).FirstOrDefault(); if (targetAct.tMember.f會員評分 == null) { targetAct.tMember.f會員評分 = 0.0; } CGetMore result = new CGetMore(); int index = -1; if (!string.IsNullOrEmpty(loginMember.f會員收藏的活動編號)) { var analyze = loginMember.f會員收藏的活動編號.Split(','); index = Array.IndexOf(analyze, actID.ToString()); } result.MemberLike = index > -1; string[] blackList = { }; if (!string.IsNullOrEmpty(loginMember.f會員黑名單)) { blackList = loginMember.f會員黑名單.Split(','); } result.BlackList = blackList; result.TargetAct = targetAct; result.LoginMember = loginMember; return(result); }
public ActionResult check_statusname() { DateTime nowdate = DateTime.Now; Session["today"] = nowdate.ToString("yyyy/MM/dd"); var acvdates = from t in db.tActivity select t; foreach (tActivity item in acvdates) { tActivity x = db.tActivity.FirstOrDefault(m => m.fId == item.fId); if (string.Compare(item.fActivityDate, nowdate.ToString("yyyy/MM/dd H:mm:ss")) > 0) { x.fActTypeId = 1; } else if (string.Compare(item.fActivityDate, nowdate.ToString("yyyy/MM/dd H:mm:ss")) < 0 && string.Compare(item.fActivityEndDate, nowdate.ToString("yyyy/MM/dd")) > 0) { x.fActTypeId = 2; } else if (string.Compare(item.fActivityDate, nowdate.ToString("yyyy/MM/dd H:mm:ss")) < 0) { x.fActTypeId = 3; } } db.SaveChanges(); return(RedirectToAction("ActivityList")); }
public ActionResult get_ajax_readmore(int act_id) { ViewCounts(act_id); tActivity target_act = db.tActivity.Where(t => t.f活動編號 == act_id).FirstOrDefault(); return(View(target_act)); }
public ActionResult ActivityDetailsEdit(tActivity t) { tActivity A = db.tActivity.FirstOrDefault(m => m.fId == t.fId); if (A != null) { A.fActName = t.fActName; A.fCreatDate = t.fCreatDate; A.fActivityDate = t.fActivityDate; A.fIntroduction = t.fIntroduction; A.fMaxLimit = t.fMaxLimit; A.fMinLimit = t.fMinLimit; A.fActLocation = t.fActLocation; A.fCoordinateX = t.fCoordinateX; A.fCoordinateY = t.fCoordinateY; A.fActLabelId = int.Parse(Request.Form["MLLDrop"]); A.fActAttestId = int.Parse(Request.Form["AttDrop"]); A.fActTypeId = int.Parse(Request.Form["ActDrop"]); A.fMemberId = int.Parse(Request.Form["MemDrop"]); db.SaveChanges(); } return(RedirectToAction("ActivityList")); }
public ActionResult active_list_detail_Delete(int?id) { tActivity x = db.tActivity.FirstOrDefault(m => m.fId == id); db.tActivity.Remove(x); db.SaveChanges(); return(View()); }
public ActionResult ActivityStatusEdit(int Act, int Att, int fId) { tActivity a = db.tActivity.FirstOrDefault(m => m.fId == fId); a.fActAttestId = Att; a.fActTypeId = Act; db.SaveChanges(); return(RedirectToAction("ActivityList")); }
public ActionResult ActivityCreate(tActivity a) { a.fMemberId = int.Parse(Request["MemDrop"]); a.fActLabelId = int.Parse(Request["LabDrop"]); db.tActivity.Add(a); db.SaveChanges(); return(RedirectToAction("ActivityList")); }
public async Task <IHttpActionResult> GettActivity(int id) { tActivity tActivity = await db.tActivities.FindAsync(id); if (tActivity == null) { return(NotFound()); } return(Ok(tActivity)); }
public async Task <IHttpActionResult> PosttActivity(tActivity Activity) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tActivities.Add(Activity); await db.SaveChangesAsync(); return(CreatedAtRoute("DefaultApi", new { id = Activity.ID }, Activity)); }
public ActionResult ActivityDelete(int?id) { tActivity a = db.tActivity.FirstOrDefault(m => m.fId == id); if (id == null) { return(RedirectToAction("ActivitiyList")); } db.tActivity.Remove(a); db.SaveChanges(); return(RedirectToAction("ActivityList")); }
public ActionResult Edit(tActivity act) { tMember loginMember = (tMember)Session["member"]; HttpPostedFileBase picFile = Request.Files["picFile"]; string filePath = Server.MapPath("~/Content/images/"); var result = travelModel.EditAct(loginMember.f會員編號, act, picFile, filePath); if (result == "1") { RedirectToAction("TravelIndex", "Travel", new { msg = "錯誤! 修改的活動時間與既有活動時間相衝" }); } return(RedirectToAction("TravelIndex")); }
public ActionResult v查看(int?id) { if (id == null) { RedirectToAction("List"); } dbJoutaEntities db = new dbJoutaEntities(); tActivity x = new tActivity(); x = db.tActivity.FirstOrDefault(m => m.f活動編號 == id); return(View(x)); }
public async Task <IHttpActionResult> DeletetActivity(int id) { tActivity tActivity = await db.tActivities.FindAsync(id); if (tActivity == null) { return(NotFound()); } db.tActivities.Remove(tActivity); await db.SaveChangesAsync(); return(Ok(tActivity)); }
public CGetMore ReadMore(int actID) { AddViewCounts(actID); tActivity targetAct = db.tActivity.Where(t => t.f活動編號 == actID).FirstOrDefault(); if (targetAct.tMember.f會員評分 == null) { targetAct.tMember.f會員評分 = 0.0; } CGetMore result = new CGetMore(); result.TargetAct = targetAct; return(result); }
public ActionResult Add(tActivity p) { tMember Member = (tMember)Session["member"]; //判別登入會員其活動時段是否已占用 var NowMember = db.tMember.Where(t => t.f會員編號 == Member.f會員編號).FirstOrDefault(); if (!string.IsNullOrEmpty(NowMember.f會員已占用時間)) { string[] usedTime = NowMember.f會員已占用時間.Split(','); string[] used; foreach (var item in usedTime) { if (!string.IsNullOrEmpty(item)) { used = item.Split('~'); //used[0] 已佔用的開始時間,used[1] 已佔用的結束時間 if (string.Compare(p.f活動開始時間, used[1]) > 0 || string.Compare(used[0], p.f活動結束時間) > 0) { } else { return(RedirectToAction("EatIndex", "Eat", new { msg = "錯誤! 新增的活動與既有活動時間相衝" })); } } } } //添加占用時間 NowMember.f會員已占用時間 += "," + p.f活動開始時間 + "~" + p.f活動結束時間; p.f會員編號 = Member.f會員編號; p.f活動類型 = "飯局"; p.f活動參加的會員編號 = "," + Member.f會員編號; db.tActivity.Add(p); db.SaveChanges(); int ID = db.tActivity.Where(t => t.f會員編號 == Member.f會員編號) .OrderByDescending(t => t.f活動發起日期).Select(t => t.f活動編號).FirstOrDefault(); NowMember.f會員發起的活動編號 += "," + ID; NowMember.f會員參加的活動編號 += "," + ID; HttpPostedFileBase PicFile = Request.Files["PicFile"]; if (PicFile != null) { var NewFileName = Guid.NewGuid() + Path.GetExtension(PicFile.FileName); var NewFilePath = Path.Combine(Server.MapPath("~/Content/images/"), NewFileName); PicFile.SaveAs(NewFilePath); p.f活動團圖 = NewFileName; } db.SaveChanges(); return(RedirectToAction("EatIndex")); }
public ActionResult Create(CBlog p) { HttpPostedFileBase blogPhoto = Request.Files["blogPhoto"]; if (p.blogPhoto != null) { string photName = Guid.NewGuid().ToString() + Path.GetExtension(p.blogPhoto.FileName); var path = Path.Combine(Server.MapPath("~/Content/images/"), photName); p.blogPhoto.SaveAs(path); p.f活動團圖 = photName; } tActivity article = new tActivity(); article.f活動類型 = "文章"; article.f活動標題 = p.txtTitle; article.f活動地點 = p.txtLocation; article.f活動內容 = p.txtContent; article.f活動團圖 = p.f活動團圖; article.fQRcode網址 = p.QRcode; article.fQRcodeImage = p.QRcodeImage; article.f活動發起日期 = (DateTime.Now).ToString("yyyy-MM-dd HH:mm:ss"); article.f活動地區 = p.f活動地區; article.f活動瀏覽次數 = 0; article.f活動讚數 = 0; var LoginMember = (tMember)Session["member"]; article.f會員編號 = LoginMember.f會員編號; if (article != null) { dbJoutaEntities db = new dbJoutaEntities(); db.tActivity.Add(article); db.SaveChanges(); return(RedirectToAction("index")); } else { return(RedirectToAction("index")); } }
public ActionResult d刪除(int?id) { if (id == null) { RedirectToAction("List"); } tActivity x = new tActivity(); dbJoutaEntities db = new dbJoutaEntities(); x = db.tActivity.FirstOrDefault(m => m.f活動編號 == id); db.tActivity.Remove(x); db.SaveChanges(); return(RedirectToAction("List")); }
public ActionResult active_list_detail_edit(tActivity s) { tActivity m = db.tActivity.FirstOrDefault(z => z.fId == s.fId); m.fActName = s.fActName; m.fCreatDate = s.fCreatDate; m.fActivityDate = s.fActivityDate; m.fActivityEndDate = s.fActivityEndDate; m.fMemberId = s.fMemberId; m.fIntroduction = s.fIntroduction; m.fMaxLimit = s.fMaxLimit; m.fMinLimit = s.fMinLimit; m.fActAttestId = s.fActAttestId; m.fActAttestId = s.fActAttestId; m.fActLocation = s.fActLocation; m.fCoordinateX = s.fCoordinateX; m.fCoordinateY = s.fCoordinateY; m.fActLabelId = s.fActLabelId; m.fImgPath = s.fImgPath; db.SaveChanges(); return(RedirectToAction("active_list_detail")); }
public ActionResult ActivityDetailsEdit(int?id) { if (id == null) { return(RedirectToAction("ActivityList")); } tActivity t = db.tActivity.FirstOrDefault(m => m.fId == id); var cActivityType = db.tActivityType.ToDictionary(x => x.fId, y => y.fStatusName); var cAttestType = db.tAttestType.ToDictionary(x => x.fId, y => y.fAttestName); List <SelectListItem> itemsAct = new List <SelectListItem>(); List <SelectListItem> itemsAtt = new List <SelectListItem>(); List <SelectListItem> itemsMem = new List <SelectListItem>(); var cMainLabel = db.tActivityMainLabel.ToDictionary(x => x.fId, y => y.fLabelName); List <SelectListItem> itemsMainLabel = new List <SelectListItem>(); SelectList MainLabelList = new SelectList(cMainLabel, cMainLabel.Keys, cMainLabel.Values); var cMember = db.tMember.ToDictionary(x => x.fId, y => y.fName); foreach (var cm in cMember) { if (cm.Key < 3) { continue; } itemsMem.Add(new SelectListItem() { Text = cm.Value, Value = cm.Key.ToString() }); } foreach (var a in cActivityType) { itemsAct.Add(new SelectListItem() { Text = a.Value, Value = a.Key.ToString() }); } foreach (var a in cAttestType) { itemsAtt.Add(new SelectListItem() { Text = a.Value, Value = a.Key.ToString() }); } foreach (var a in cMainLabel) { itemsMainLabel.Add(new SelectListItem() { Text = a.Value, Value = a.Key.ToString() }); } ViewBag.ActDrop = itemsAct; ViewBag.AttDrop = itemsAtt; ViewBag.MemDrop = itemsMem; ViewBag.MainLabelList = MainLabelList; ViewBag.MainLabelList1 = itemsMainLabel; return(View(t)); }
public dynamic EditAct(int memberID, tActivity act, HttpPostedFileBase picFile, string filePath) { tActivity targetAct = db.tActivity.Where(t => t.f活動編號 == act.f活動編號).FirstOrDefault(); var loginMember = db.tMember.Where(t => t.f會員編號 == memberID).FirstOrDefault(); string[] usedTime = { }; if (!string.IsNullOrEmpty(loginMember.f會員已占用時間)) { usedTime = loginMember.f會員已占用時間.Split(','); //先移除登入會員原本這筆活動的活動時段 usedTime = usedTime.Where(t => t != targetAct.f活動開始時間 + "~" + targetAct.f活動結束時間).ToArray(); //再判別修改的活動時段是否已占用 string[] used; foreach (var item in usedTime) { if (!string.IsNullOrEmpty(item)) { used = item.Split('~'); //used[0] 已佔用的開始時間,used[1] 已佔用的結束時間 if (string.Compare(act.f活動開始時間, used[1]) > 0 || string.Compare(used[0], act.f活動結束時間) > 0) { } else { return("1"); } } } } //時間過關 //因為活動時段變更所以要剔除所有參加者(不是每個人都想參加新時段) //撈出所有參加會員的編號,並讓他們退團 if (!string.IsNullOrEmpty(targetAct.f活動參加的會員編號)) { string[] DeleteList = targetAct.f活動參加的會員編號.Split(','); foreach (var item in DeleteList) { if (!string.IsNullOrEmpty(item)) { //移除活動編號 tMember Delete = db.tMember.Where(t => t.f會員編號.ToString() == item).FirstOrDefault(); Delete.f會員參加的活動編號 = string.Join(",", Delete.f會員參加的活動編號.Split(',').Where(t => t != targetAct.f活動編號.ToString())); //移除占用時間 string[] usedTime2 = Delete.f會員已占用時間.Split(','); Delete.f會員已占用時間 = string.Join(",", usedTime2.Where(t => t != targetAct.f活動開始時間 + "~" + targetAct.f活動結束時間)); } } } //修改變更項目 //使用刪除舊活動過後的占用時間加上新的活動時間 loginMember.f會員已占用時間 = string.Join(",", usedTime) + "," + act.f活動開始時間 + "~" + act.f活動結束時間; loginMember.f會員參加的活動編號 += "," + targetAct.f活動編號; //因為被剔除了,所以重新添加 targetAct.f活動內容 = act.f活動內容; targetAct.f活動參加的會員編號 = loginMember.f會員編號.ToString(); targetAct.f活動地區 = act.f活動地區; targetAct.f活動招募截止時間 = act.f活動招募截止時間; targetAct.f活動標題 = act.f活動標題; targetAct.f活動結束時間 = act.f活動結束時間; targetAct.f活動開始時間 = act.f活動開始時間; targetAct.f活動預算 = act.f活動預算; targetAct.f活動經度 = act.f活動經度; targetAct.f活動緯度 = act.f活動緯度; targetAct.f活動審核名單 = null; if (picFile != null) { var NewFileName = Guid.NewGuid() + Path.GetExtension(picFile.FileName); var NewFilePath = Path.Combine(filePath, NewFileName); picFile.SaveAs(NewFilePath); targetAct.f活動團圖 = NewFileName; } db.SaveChanges(); return(null); }
public ActionResult Edit(tActivity p) { tMember Member = (tMember)Session["member"]; tActivity targetAct = db.tActivity.Where(t => t.f活動編號 == p.f活動編號).FirstOrDefault(); var NowMember = db.tMember.Where(t => t.f會員編號 == Member.f會員編號).FirstOrDefault(); string[] usedTime = { }; if (!string.IsNullOrEmpty(NowMember.f會員已占用時間)) { usedTime = NowMember.f會員已占用時間.Split(','); //先移除登入會員原本這筆活動的活動時段 usedTime = usedTime.Where(t => t != targetAct.f活動開始時間 + "~" + targetAct.f活動結束時間).ToArray(); //再判別修改的活動時段是否已占用 string[] used; foreach (var item in usedTime) { if (!string.IsNullOrEmpty(item)) { used = item.Split('~'); //used[0] 已佔用的開始時間,used[1] 已佔用的結束時間 if (string.Compare(p.f活動開始時間, used[1]) > 0 || string.Compare(used[0], p.f活動結束時間) > 0) { } else { return(RedirectToAction("TravelIndex", "Travel", new { msg = "錯誤! 修改的活動時間與既有活動時間相衝" })); } } } } //時間過關 //因為活動時段變更所以要剔除所有參加者(不是每個人都想參加新時段) //撈出所有參加會員的編號,並讓他們退團 if (!string.IsNullOrEmpty(targetAct.f活動參加的會員編號)) { string[] DeleteList = targetAct.f活動參加的會員編號.Split(','); foreach (var item in DeleteList) { if (!string.IsNullOrEmpty(item)) { //移除活動編號 tMember Delete = db.tMember.Where(t => t.f會員編號.ToString() == item).FirstOrDefault(); Delete.f會員參加的活動編號 = string.Join(",", Delete.f會員參加的活動編號.Split(',').Where(t => t != targetAct.f活動編號.ToString())); //移除占用時間 string[] usedTime2 = Delete.f會員已占用時間.Split(','); Delete.f會員已占用時間 = string.Join(",", usedTime2.Where(t => t != targetAct.f活動開始時間 + "~" + targetAct.f活動結束時間)); } } } //修改變更項目 //使用刪除舊活動過後的占用時間加上新的活動時間 NowMember.f會員已占用時間 = string.Join(",", usedTime) + "," + p.f活動開始時間 + "~" + p.f活動結束時間; NowMember.f會員參加的活動編號 += "," + targetAct.f活動編號; //因為被剔除了,所以重新添加 tActivity Temp = new tActivity(); targetAct.f活動內容 = Request.Form["f活動內容2"]; //配合文字編輯器,待改良; targetAct.f活動參加的會員編號 = NowMember.f會員編號.ToString(); targetAct.f活動地區 = p.f活動地區; targetAct.f活動招募截止時間 = p.f活動招募截止時間; targetAct.f活動標題 = p.f活動標題; targetAct.f活動結束時間 = p.f活動結束時間; targetAct.f活動開始時間 = p.f活動開始時間; targetAct.f活動預算 = p.f活動預算; targetAct.f活動經度 = p.f活動經度; targetAct.f活動緯度 = p.f活動緯度; targetAct.f活動審核名單 = null; HttpPostedFileBase PicFile = Request.Files["PicFile2"]; if (PicFile != null) { var NewFileName = Guid.NewGuid() + Path.GetExtension(PicFile.FileName); var NewFilePath = Path.Combine(Server.MapPath("~/Content/images/"), NewFileName); PicFile.SaveAs(NewFilePath); targetAct.f活動團圖 = NewFileName; } db.SaveChanges(); return(RedirectToAction("TravelIndex")); }
public IHttpActionResult Post(Activities value) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (value.source == null || value.humanId == null) { return(BadRequest()); } using (var dbContextTransaction = db.Database.BeginTransaction()) { try { tActivity activityObj = db.tActivities.SingleOrDefault(x => x.Name == value.type); if (activityObj == null) { activityObj = new tActivity(); activityObj.Name = value.type; db.tActivities.Add(activityObj); } tSourceService sourceServiceObj = db.tSourceServices .SingleOrDefault(x => x.ServiceName == value.source && x.SourceID == 5); if (sourceServiceObj == null) { sourceServiceObj = new tSourceService(); sourceServiceObj.ServiceName = value.source; sourceServiceObj.TypeID = 2; //Wellness sourceServiceObj.SourceID = 5; //HumanAPI db.tSourceServices.Add(sourceServiceObj); } tUserSourceService userSourceServiceObj = null; //Get credentials tCredential credentialObj = db.tCredentials.SingleOrDefault(x => x.SourceID == 5 && x.SourceUserID == value.humanId && x.SystemStatusID == 1); if (credentialObj == null) { throw new NoUserCredentialsException("Unable to find any matching HAPI user credentials"); } else { userSourceServiceObj = db.tUserSourceServices.SingleOrDefault( x => x.SourceServiceID == sourceServiceObj.ID && x.CredentialID == credentialObj.ID && x.SystemStatusID == 1); if (userSourceServiceObj == null) { userSourceServiceObj = new tUserSourceService(); userSourceServiceObj.SourceServiceID = sourceServiceObj.ID; userSourceServiceObj.UserID = credentialObj.UserID; userSourceServiceObj.CredentialID = credentialObj.ID; userSourceServiceObj.ConnectedOnDateTime = DateTime.Now; userSourceServiceObj.LastSyncDateTime = DateTime.Now; userSourceServiceObj.LatestDateTime = value.updatedAt; userSourceServiceObj.StatusID = 3; //connected userSourceServiceObj.SystemStatusID = 1; //valid userSourceServiceObj.tCredential = credentialObj; db.tUserSourceServices.Add(userSourceServiceObj); } else { //update LatestDateTime to the most recent datetime if (userSourceServiceObj.LatestDateTime == null || userSourceServiceObj.LatestDateTime < value.updatedAt) { userSourceServiceObj.LatestDateTime = value.updatedAt; } } } tUserActivity userActivity = null; userActivity = db.tUserActivities .SingleOrDefault(x => x.SourceObjectID == value.id); if (userActivity == null) { userActivity = new tUserActivity(); userActivity.UserID = credentialObj.UserID; userActivity.SourceObjectID = value.id; userActivity.UserSourceServiceID = sourceServiceObj.ID; userActivity.ActivityID = activityObj.ID; //Dates DateTimeOffset dtoStart, dtoEnd; if (RESTfulBAL.Models.DynamoDB.Utilities.ConvertToDateTimeOffset(value.startTime, value.tzOffset, out dtoStart)) { userActivity.StartDateTime = dtoStart; } else { userActivity.StartDateTime = value.startTime; } if (RESTfulBAL.Models.DynamoDB.Utilities.ConvertToDateTimeOffset(value.endTime, value.tzOffset, out dtoEnd)) { userActivity.EndDateTime = dtoEnd; } else { userActivity.EndDateTime = value.endTime; } userActivity.Duration = value.duration; userActivity.DurationUOMID = 8; userActivity.Distance = value.distance; userActivity.DistanceUOMID = 9; userActivity.Steps = value.steps; userActivity.Calories = value.calories; userActivity.SystemStatusID = 1; userActivity.tUserSourceService = userSourceServiceObj; db.tUserActivities.Add(userActivity); } else { userActivity.ActivityID = activityObj.ID; //Dates DateTimeOffset dtoStart, dtoEnd; if (RESTfulBAL.Models.DynamoDB.Utilities.ConvertToDateTimeOffset(value.startTime, value.tzOffset, out dtoStart)) { userActivity.StartDateTime = dtoStart; } else { userActivity.StartDateTime = value.startTime; } if (RESTfulBAL.Models.DynamoDB.Utilities.ConvertToDateTimeOffset(value.endTime, value.tzOffset, out dtoEnd)) { userActivity.EndDateTime = dtoEnd; } else { userActivity.EndDateTime = value.endTime; } userActivity.Duration = value.duration; userActivity.DurationUOMID = 8; userActivity.Distance = value.distance; userActivity.DistanceUOMID = 9; userActivity.Steps = value.steps; userActivity.Calories = value.calories; userActivity.SystemStatusID = 1; userActivity.tUserSourceService = userSourceServiceObj; userActivity.LastUpdatedDateTime = DateTime.Now; } db.SaveChanges(); dbContextTransaction.Commit(); return(Ok(userActivity)); } catch (Exception ex) { dbContextTransaction.Rollback(); //Insert Error Log tUserDataErrLog userErrorLog = new tUserDataErrLog(); userErrorLog.ErrTypeID = (int)ErrorLogging.enumErrorType.Application; userErrorLog.ErrSourceID = (int)AuditLogging.enumApplication.SFCBAL; userErrorLog.Code = ex.HResult.ToString(); userErrorLog.Description = ex.Message; userErrorLog.Trace = ex.StackTrace; dbErr.tUserDataErrLogs.Add(userErrorLog); dbErr.SaveChanges(); string ErrMsg = "An error occured and we have logged the error. Please try again later."; Exception Err = new Exception(ErrMsg, ex); return(InternalServerError(Err)); } } }
public ActionResult active_list_detail_edit(int?id) { tActivity x = db.tActivity.FirstOrDefault(m => m.fId == id); return(View(x)); }
public ActionResult active_list_detail_Creat(tActivity x) { db.tActivity.Add(x); db.SaveChanges(); return(RedirectToAction("active_list_detail")); }
public override dynamic AddAct(int memberID, tActivity act, HttpPostedFileBase picFile, string filePath) { //判別登入會員其活動時段是否已占用 var loginMember = db.tMember.Where(t => t.f會員編號 == memberID).FirstOrDefault(); if (!string.IsNullOrEmpty(loginMember.f會員已占用時間)) { string[] usedTime = loginMember.f會員已占用時間.Split(','); string[] used; foreach (var item in usedTime) { if (!string.IsNullOrEmpty(item)) { used = item.Split('~'); //used[0] 已佔用的開始時間,used[1] 已佔用的結束時間 if (string.Compare(act.f活動開始時間, used[1]) > 0 || string.Compare(used[0], act.f活動結束時間) > 0) { } else { return("1"); } } } } //添加占用時間 loginMember.f會員已占用時間 += "," + act.f活動開始時間 + "~" + act.f活動結束時間; act.f會員編號 = memberID; act.f活動類型 = "旅遊"; act.f活動參加的會員編號 = "," + memberID; var theCategory = Convert.ToDateTime(act.f活動結束時間) - Convert.ToDateTime(act.f活動開始時間); int timeCheck = Convert.ToInt32(theCategory.ToString("dd")); switch (timeCheck)//時間判斷 { case 1: act.f活動分類 = "兩天一夜"; break; case 2: act.f活動分類 = "三天兩夜"; break; case 4: act.f活動分類 = "五天四夜"; break; case 6: act.f活動分類 = "七天六夜"; break; default: act.f活動分類 = "其他"; break; } db.tActivity.Add(act); db.SaveChanges(); int ID = db.tActivity.Where(t => t.f會員編號 == memberID) .OrderByDescending(t => t.f活動發起日期).Select(t => t.f活動編號).FirstOrDefault(); loginMember.f會員發起的活動編號 += "," + ID; loginMember.f會員參加的活動編號 += "," + ID; if (picFile != null) { var newFileName = Guid.NewGuid() + Path.GetExtension(picFile.FileName); var newFilePath = Path.Combine(filePath, newFileName); picFile.SaveAs(newFilePath); act.f活動團圖 = newFileName; } db.SaveChanges(); return(null); }
public abstract dynamic AddAct(int memberID, tActivity act, HttpPostedFileBase picFile, string filePath);