// GET: ClubInfo public ActionResult ClubInfo() { #region sub query //var Club = (from u in db.TUsers // where u.user_code.Equals(HttpContext.User.Identity.Name) // join m in db.Members on u.member_seq equals m.member_seq // select m.club_id); //ViewBag.ClubID = null; //var clubs = (from c in db.Clubs where Club.Contains(c.club_id) select c); #endregion var identity = (System.Web.HttpContext.Current.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; var tClub_id = identity.User.club_id; Club club = db.Clubs.Find(tClub_id); if (club == null) { return(HttpNotFound()); } // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "ClubInfo", identity.User.club_id); return(View(club)); }
public ActionResult Edit([Bind(Include = "club_id,club_name_thai,club_name_eng,charter_date,meeting_place,district_id,club_sts")] Club club, HttpPostedFileBase image, Club m) { if (ModelState.IsValid) { if (image != null && image.ContentLength > 0) { using (var reader = new System.IO.BinaryReader(image.InputStream)) { club.image = reader.ReadBytes(image.ContentLength); } } else if (m.image != null) { club.image = m.image; } db.Entry(club).State = EntityState.Modified; db.SaveChanges(); var identity = (HttpContext.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "EditClub", identity.User.club_id); return(RedirectToAction("Index")); } ViewBag.district_id = new SelectList(db.Districts, "district_id", "district_name_thai", club.district_id); ViewBag.club_sts = new SelectList(db.ClubStatus, "club_sts", "club_status_desc", club.club_sts); // ViewBag.province_id = new SelectList(db.Provinces, "province_id", "province_name", club.province_id); return(View(club)); }
public ActionResult Edit([Bind(Include = "user_code,user_pwd,eff_date,exp_date,member_seq,role_name")] TUser tUser) { if (ModelState.IsValid) { tUser.upd_date = DateTime.Now; var user_pwd_2 = Request.Form["user_pwd_edit"]; if (user_pwd_2 != null) { tUser.user_pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(user_pwd_2, "SHA1"); } db.Entry(tUser).State = EntityState.Modified; db.SaveChanges(); var identity = (HttpContext.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "EditTUser", identity.User.club_id); return(RedirectToAction("Index")); } ViewBag.member_seq = new SelectList(db.Members.OrderBy(x => x.first_name_eng).ThenBy(x => x.last_name_eng), "member_seq", "full_name_eng", tUser.member_seq); ViewBag.club_id = new SelectList(db.Clubs.OrderBy(x => x.club_name_thai), "club_id", "club_name_thai", tUser.Member.club_id); List <SelectListItem> lstRoleName = new List <SelectListItem>(); lstRoleName.Add(new SelectListItem() { Text = "ผู้ดูแลระบบ", Value = "Admin" }); lstRoleName.Add(new SelectListItem() { Text = "ผู้ใช้งาน", Value = "User" }); ViewBag.role_name = new SelectList(lstRoleName, "Value", "Text", tUser.role_name); return(View(tUser)); }
public ActionResult Create([Bind(Include = "region_officer_id,region_no,fiscal_year,member_seq")] RegionOfficer regionOfficer) { var identity = (System.Web.HttpContext.Current.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; if (ModelState.IsValid) { db.RegionOfficers.Add(regionOfficer); db.SaveChanges(); // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "CreateRegionOfficer", identity.User.club_id); return(RedirectToAction("Index")); } var member = (from m in db.Members join co in db.ClubOfficers on m.member_seq equals co.member_seq where co.officer_id == 21 join c in db.Clubs on m.club_id equals c.club_id where c.district_id == identity.User.district_id select m ).OrderBy(x => x.first_name); ViewBag.member_seq = new SelectList(member, "member_seq", "full_name", regionOfficer.member_seq); return(View(regionOfficer)); }
public ActionResult Create([Bind(Include = "fiscal_year,member_seq,officer_id,club_officer_id,club_id,seq_no")] ClubOfficer clubOfficer) { if (ModelState.IsValid) { db.ClubOfficers.Add(clubOfficer); db.SaveChanges(); var identity = (HttpContext.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "CreateClubOfficer", identity.User.club_id); return(RedirectToAction("Index")); } var c_member = from m in db.Members select new { full_name = m.first_name + " " + m.last_name, m.member_seq, m.first_name, m.last_name }; ViewBag.member_seq = new SelectList(c_member.OrderBy(x => x.first_name).ThenBy(x => x.last_name), "member_seq", "full_name", clubOfficer.member_seq); ViewBag.officer_id = new SelectList(db.Officers.OrderBy(x => x.officer_id), "officer_id", "title", clubOfficer.officer_id); ViewBag.club_id = new SelectList(db.Clubs.OrderBy(x => x.club_name_thai), "club_id", "club_name_thai", clubOfficer.club_id); return(View(clubOfficer)); }
public ActionResult EditProfile([Bind(Include = "member_id,full_name,first_name,last_name,gender,member_address_eng,post_code,email,cell_phone,birth_year,occupation,Join_Date,club_id,member_seq,membership_type,first_name_eng,last_name_eng,member_address_thai,sponsor_name,charter_flag,member_sts")] Member member, HttpPostedFileBase image, Member m) { if (ModelState.IsValid) { if (image != null && image.ContentLength > 0) { using (var reader = new System.IO.BinaryReader(image.InputStream)) { member.image = reader.ReadBytes(image.ContentLength); } } else if (m.image != null) { member.image = m.image; } db.Entry(member).State = EntityState.Modified; db.SaveChanges(); var identity = (HttpContext.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "EditProfile", identity.User.club_id); return(RedirectToAction("Profile", new { Message = "ChangeInformationSuccess" })); } //ViewBag.club_id = new SelectList(db.Clubs, "club_id", "club_name_thai", member.club_id); // ViewBag.membership_type = new SelectList(db.MembershipTypes, "membership_type", "membership_desc_thai", member.membership_type); return(View(member)); }
public ActionResult ChangePassword(ChangePwd model) { var identity = (System.Web.HttpContext.Current.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; #region if (!ModelState.IsValid) { return(View(model)); } string Username = HttpContext.User.Identity.Name; if (!System.Web.Security.Membership.ValidateUser(Username, model.OldPassword)) { ModelState.AddModelError("", "รหัสผ่านปัจจุบันไม่ถูกต้อง"); return(View(model)); } var u = (from c in db.TUsers where c.user_code == Username select c).First(); u.user_pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(model.NewPassword, "SHA1"); u.upd_date = DateTime.Now; db.SaveChanges(); // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "ChangePassword", identity.User.club_id); return(RedirectToAction("Profile", new { Message = "ChangePasswordSuccess" })); #endregion }
public ActionResult Edit([Bind(Include = "member_id,first_name,first_name,last_name,gender,member_address_eng,post_code,email,cell_phone,birth_year,occupation,Join_Date,club_id,member_seq,membership_type,first_name_eng,last_name_eng,member_address_thai,sponsor_name,charter_flag,member_sts,line_id")] Member member, HttpPostedFileBase image, Member m) //public ActionResult Edit([Bind(Include = "member_id,first_name,first_name,last_name,gender,member_address_eng,email,cell_phone,birth_year,occupation,Join_Date,club_id,member_seq,membership_type,first_name_eng,last_name_eng,member_address_thai")] Member member) { var identity = (HttpContext.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; if (ModelState.IsValid) { if (image != null && image.ContentLength > 0) { using (var reader = new System.IO.BinaryReader(image.InputStream)) { member.image = reader.ReadBytes(image.ContentLength); } } else if (m.image != null) { member.image = m.image; } member.upd_date = DateTime.Now; db.Entry(member).State = EntityState.Modified; db.SaveChanges(); // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "EditMember", identity.User.club_id); return(RedirectToAction("Index")); } ViewBag.club_id = new SelectList(db.Clubs.Where(x => x.district_id == identity.User.district_id).OrderBy(x => x.club_name_thai), "club_id", "club_name_thai", member.club_id); ViewBag.membership_type = new SelectList(db.MembershipTypes.OrderBy(x => x.membership_desc_thai), "membership_type", "membership_desc_thai", member.membership_type); ViewBag.movement = new SelectList(db.Movements.OrderBy(x => x.move_desc), "move_sts", "move_desc"); return(View(member)); }
public gpPnt2d ToPoint2D(gpAx2 ax2) { var pointPlane = new gpPln(new gpAx3(ax2)); var point2D = ProjLib.Project(pointPlane, GpPnt); return(point2D); }
public ActionResult GenerateUser() { var member = (from m in db.Members where m.member_sts == 1 select m ).ToList(); foreach (var t in member) { if (t.member_seq != 326 && t.member_seq != 356 && t.member_seq != 357 && t.member_seq != 396 && t.member_seq != 474 && t.member_seq != 708 && t.member_seq != 932 && t.member_seq != 1111 && t.member_seq != 1168 && t.member_seq != 1194 && t.member_seq != 1263 && t.member_seq != 1265 && t.member_seq != 1316) { var user = (from u in db.TUsers where u.member_seq == t.member_seq select u).ToList(); if (user.Count() == 0) { //ProjLib projlib = new ProjLib(); string user_code = ProjLib.chkUserCode(t.first_name_eng, t.last_name_eng); TUser tuser = new TUser(); tuser.user_code = user_code; tuser.user_pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(user_code + "@123", "SHA1"); tuser.role_name = "User"; tuser.member_seq = t.member_seq; tuser.upd_date = DateTime.Now; db.TUsers.Add(tuser); db.SaveChanges(); } } } return(View()); }
public ActionResult About() { ViewBag.Message = "Your application description page."; // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(0, "About", 0); return(View()); }
public ActionResult Contact() { ViewBag.Message = "Your contact page."; // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(0, "Contact", 0); return(View()); }
public ActionResult DeleteConfirmed(int id) { MembershipType membershipType = db.MembershipTypes.Find(id); db.MembershipTypes.Remove(membershipType); var identity = (HttpContext.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "DeleteMembershipType", identity.User.club_id); db.SaveChanges(); return RedirectToAction("Index"); }
public ActionResult DeleteConfirmed(int id) { var identity = (System.Web.HttpContext.Current.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; RegionOfficer regionOfficer = db.RegionOfficers.Find(id); db.RegionOfficers.Remove(regionOfficer); db.SaveChanges(); // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "DeleteRegionOfficer", identity.User.club_id); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "club_sts,club_status_desc")] ClubStatus clubStatus) { if (ModelState.IsValid) { db.Entry(clubStatus).State = EntityState.Modified; var identity = (HttpContext.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "EditClubStatus", identity.User.club_id); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(clubStatus)); }
// GET: MyLionsClubs //public ActionResult Membership(string searchString, int? memberSts) public ActionResult Membership(string searchString) { #region sub query //var Club = (from u in db.TUsers // where u.user_code.Equals(HttpContext.User.Identity.Name) // join m in db.Members on u.member_seq equals m.member_seq // select m.club_id); //var member = (from m in db.Members // where Club.Contains(m.club_id) // join c in db.Clubs on m.club_id equals c.club_id // join mt in db.MembershipTypes on m.membership_type equals mt.membership_type // select m); #endregion var identity = (System.Web.HttpContext.Current.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; var tClub_id = identity.User.club_id; var member = (from m in db.Members where m.club_id == tClub_id join c in db.Clubs on m.club_id equals c.club_id join mt in db.MembershipTypes on m.membership_type equals mt.membership_type select m); //List<SelectListItem> lstMemberSts = new List<SelectListItem>(); //lstMemberSts.Add(new SelectListItem() { Text = "สมาชิกสถานะปกติ", Value = "1" }); //lstMemberSts.Add(new SelectListItem() { Text = "สมาชิกสถานะพ้นสภาพ", Value = "2" }); //this.ViewBag.memberSts = new SelectList(lstMemberSts, "Value", "Text"); if (!String.IsNullOrEmpty(searchString)) { member = member.Where(x => x.first_name.Contains(searchString) || x.last_name.Contains(searchString) || x.first_name_eng.Contains(searchString) || x.last_name_eng.Contains(searchString)); } //if ((memberSts != null)) //{ // member = member.Where(x => x.member_sts == memberSts); //}else //{ // this.ViewBag.memberSts = new SelectList(lstMemberSts, "Value", "Text","1"); //} member = member.Where(x => x.member_sts == 1); ViewBag.MemberCount = member.Count(); // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "Membership", identity.User.club_id); return(View(member.ToList())); }
public ActionResult Edit([Bind(Include = "multiple_district_id,multiple_district_name_thai,multiple_district_name_eng")] MultipleDistrict multipleDistrict) { if (ModelState.IsValid) { db.Entry(multipleDistrict).State = EntityState.Modified; db.SaveChanges(); var identity = (HttpContext.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; // Write log to table TransactionLog // ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "EditMultipleDistrict", identity.User.club_id); return(RedirectToAction("Index")); } return(View(multipleDistrict)); }
public ActionResult Edit([Bind(Include = "membership_type,membership_desc_thai,membership_desc_eng")] MembershipType membershipType) { if (ModelState.IsValid) { db.Entry(membershipType).State = EntityState.Modified; db.SaveChanges(); var identity = (HttpContext.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "EditMembershipType", identity.User.club_id); return RedirectToAction("Index"); } return View(membershipType); }
//-------------------------------------------------------------------------------------------------- public Pnt2d?SnapOnPlane(SnapInfo snapInfo, Pln?localPlane = null) { if (snapInfo != null) { var plane = localPlane ?? _WorkspaceController.Workspace.WorkingPlane; switch (snapInfo.SnapMode) { case SnapMode.Grid: case SnapMode.Vertex: case SnapMode.Edge: return(ProjLib.Project(plane, snapInfo.Point)); } } return(null); }
public ActionResult Edit([Bind(Include = "officer_id,title,title_eng,officer_type,officer_grp")] Officer officer) { if (ModelState.IsValid) { db.Entry(officer).State = EntityState.Modified; db.SaveChanges(); var identity = (HttpContext.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "EditOfficer", identity.User.club_id); return(RedirectToAction("Index")); } ViewBag.officer_grp = new SelectList(db.OfficerGroups.OrderBy(x => x.officer_grp), "officer_grp", "officer_grp_desc", officer.officer_grp); return(View(officer)); }
// GET: MyHistory public ActionResult OfficerHistory() { var identity = (System.Web.HttpContext.Current.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; //identity.User.member_seq var clubOfficer = (from co in db.ClubOfficers where co.member_seq == identity.User.member_seq join c in db.Clubs on co.club_id equals c.club_id join o in db.Officers on co.officer_id equals o.officer_id select co).OrderBy(x => x.fiscal_year).ThenBy(x => x.officer_id); // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "OfficerHistory", identity.User.club_id); return(View(clubOfficer)); }
public ActionResult Create([Bind(Include = "district_id,district_name_thai,district_name_eng,multiple_district_id")] District district) { if (ModelState.IsValid) { string dt_name = district.district_name_thai; db.Districts.Add(district); db.SaveChanges(); var identity = (HttpContext.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "CreateDistrict", identity.User.club_id); return(RedirectToAction("Index")); } ViewBag.multiple_district_id = new SelectList(db.MultipleDistricts, "multiple_district_id", "multiple_district_name_thai", district.multiple_district_id); return(View(district)); }
//-------------------------------------------------------------------------------------------------- public override bool OnMouseDown(MouseEventData data) { _RotateMode = RotateMode.None; if (data.DetectedEntities.Count == 0 && _Gizmo != null) { if (_Gizmo.IsPartDetected(AIS_RotationGizmo.Part.Part_XAxis)) { _RotateMode = RotateMode.AxisX; RotationAxis = new Ax1(_CoordinateSystem.Location, _CoordinateSystem.XDirection); _RotationPlane = new Pln(new Ax3(_CoordinateSystem.Location, _CoordinateSystem.XDirection, _CoordinateSystem.Direction)); _Gizmo.ForcePartHilighting(AIS_RotationGizmo.Part.Part_XAxis); } else if (_Gizmo.IsPartDetected(AIS_RotationGizmo.Part.Part_YAxis)) { _RotateMode = RotateMode.AxisY; RotationAxis = new Ax1(_CoordinateSystem.Location, _CoordinateSystem.YDirection); _RotationPlane = new Pln(new Ax3(_CoordinateSystem.Location, _CoordinateSystem.YDirection, _CoordinateSystem.Direction)); _Gizmo.ForcePartHilighting(AIS_RotationGizmo.Part.Part_YAxis); } else if (_Gizmo.IsPartDetected(AIS_RotationGizmo.Part.Part_ZAxis)) { _RotateMode = RotateMode.AxisZ; RotationAxis = new Ax1(_CoordinateSystem.Location, _CoordinateSystem.Direction); _RotationPlane = new Pln(new Ax3(_CoordinateSystem.Location, _CoordinateSystem.Direction, _CoordinateSystem.XDirection)); _Gizmo.ForcePartHilighting(AIS_RotationGizmo.Part.Part_ZAxis); } if (_RotateMode != RotateMode.None) { Pnt resultPnt; if (WorkspaceController.ActiveViewport.ScreenToPoint(_RotationPlane, (int)data.ScreenPoint.X, (int)data.ScreenPoint.Y, out resultPnt)) { var planeDelta = ProjLib.Project(_RotationPlane, resultPnt); _StartValue = Dir2d.DX.Angle(new Dir2d(planeDelta.Coord)); } _AxisHintLine = new HintLine(WorkspaceController, HintStyle.ThinDashed); _AxisHintLine.Set(RotationAxis); WorkspaceController.Invalidate(); WorkspaceController.HudManager?.SetCursor(Cursors.Rotate); return(true); } } return(base.OnMouseDown(data)); }
public ActionResult Create([Bind(Include = "zone_officer_id,zone_no,fiscal_year,region_officer_id,member_seq")] ZoneOfficer zoneOfficer) { var identity = (System.Web.HttpContext.Current.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; if (ModelState.IsValid) { db.ZoneOfficers.Add(zoneOfficer); db.SaveChanges(); // Write log to table TransactionLog // ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "CreateZoneOfficer", identity.User.club_id); return(RedirectToAction("Index")); } var memberZone = (from m in db.Members join co in db.ClubOfficers on m.member_seq equals co.member_seq where co.officer_id == 22 join c in db.Clubs on m.club_id equals c.club_id where c.district_id == identity.User.district_id select m ).OrderBy(x => x.first_name); var c_memberRegion = (from m in db.Members join r in db.RegionOfficers on m.member_seq equals r.member_seq join c in db.Clubs on m.club_id equals c.club_id where c.district_id == identity.User.district_id select new { region_officer_id = r.region_officer_id, first_name = m.first_name, last_name = m.last_name, region_no = r.region_no }).ToList(); var memberRegion = from m in c_memberRegion select new { m.region_officer_id, full_name = string.Format("{0} {1} ภาคที่ {2}", m.first_name, m.last_name, m.region_no) }; ViewBag.member_seq = new SelectList(memberZone, "member_seq", "full_name", zoneOfficer.member_seq); ViewBag.region_officer_id = new SelectList(memberRegion, "region_officer_id", "full_name", zoneOfficer.region_officer_id); return(View(zoneOfficer)); }
// GET: TUsers public ActionResult Index(string searchString) { var tUser = db.TUsers.Include(t => t.Member); // var dt_name = db.Districts.Where(x=>x.district_id.Equals()) if (!String.IsNullOrEmpty(searchString)) { tUser = tUser.Where(x => x.user_code.Contains(searchString) || x.Member.first_name_eng.Contains(searchString) || x.Member.last_name_eng.Contains(searchString) || x.Member.first_name.Contains(searchString) || x.Member.last_name.Contains(searchString)); } var identity = (HttpContext.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "ListTUser", identity.User.club_id); return(View(tUser.OrderBy(x => x.user_code).ToList())); }
public ActionResult Membership(string searchString, int?club_id) { var identity = (System.Web.HttpContext.Current.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; var tDistrict_id = identity.User.district_id; var member = (from m in db.Members where m.member_sts == 1 join c in db.Clubs on m.club_id equals c.club_id join d in db.Districts on c.district_id equals d.district_id where d.district_id == tDistrict_id select m); if (!String.IsNullOrEmpty(searchString)) { member = member.Where(x => x.first_name.Contains(searchString) || x.last_name.Contains(searchString) || x.first_name_eng.Contains(searchString) || x.last_name_eng.Contains(searchString)); } ViewBag.club_id = new SelectList(db.Clubs.OrderBy(x => x.club_name_thai).Where(x => x.club_sts == 1 && x.district_id == identity.User.district_id).OrderBy(x => x.club_name_thai), "club_id", "club_name_thai"); ViewBag.clubName = null; if (club_id != null) { member = member.Where(x => x.club_id == club_id); var clubName = (from c in db.Clubs where c.club_id == club_id select c); foreach (var c in clubName) { ViewBag.clubName = c.club_name_thai; } } if (String.IsNullOrEmpty(searchString) && club_id == null) { member = member.Where(x => x.first_name.Contains("-")); } else { member = member.OrderBy(x => x.first_name_eng).ThenBy(x => x.last_name_eng); // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "Membership", identity.User.club_id); } ViewBag.MemberCount = member.Count(); return(View(member.ToList())); }
// GET: ClubOfficers/Details/5 public ActionResult MembershipDetails(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Member member = db.Members.Find(id); if (member == null) { return(HttpNotFound()); } var identity = (System.Web.HttpContext.Current.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "MembershipDetails", identity.User.club_id); return(View(member)); }
//-------------------------------------------------------------------------------------------------- #endregion #region Screen Space Conversions public bool ScreenToPoint(int screenX, int screenY, out Pnt resultPnt) { try { var viewPlane = GetViewPlane(); double x = 0, y = 0, z = 0; V3dView.Convert(screenX, screenY, ref x, ref y, ref z); Pnt convertedPoint = new Pnt(x, y, z); Pnt2d convertedPointOnPlane = ProjLib.Project(viewPlane, convertedPoint); resultPnt = ElSLib.Value(convertedPointOnPlane.X, convertedPointOnPlane.Y, viewPlane); return(true); } catch (Exception) { Debug.Assert(false); } resultPnt = Pnt.Origin; return(false); }
public new ActionResult Profile(string message, string returnURL = "") { var identity = (System.Web.HttpContext.Current.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; ViewBag.StatusMessage = message == "ChangePasswordSuccess" ? "เปลี่ยนรหัสผ่านเรียบร้อยแล้ว" : message == "ChangeInformationSuccess" ? "แก้ไขข้อมูลส่วนตัวเรียบร้อยแล้ว" : ""; var Tuser = (from u in db.TUsers join m in db.Members on u.member_seq equals m.member_seq join c in db.Clubs on m.club_id equals c.club_id join d in db.MembershipTypes on m.membership_type equals d.membership_type join e in db.Districts on c.district_id equals e.district_id where u.user_code.Equals(HttpContext.User.Identity.Name) select u).FirstOrDefault(); ViewBag.member_seq = Tuser.member_seq; // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "Profile", identity.User.club_id); return(View(Tuser)); }
//public ActionResult DeleteConfirmed(Bind(Include = "member_id,first_name,last_name,gender,member_address_eng,post_code,email,cell_phone,birth_year,occupation,Join_Date,club_id,member_seq,membership_type,first_name_eng,last_name_eng,member_address_thai,sponsor_name,charter_flag,member_sts")] Member member, Member m) public ActionResult Movement([Bind(Include = "member_id,first_name,last_name,gender,member_address_eng,post_code,email,cell_phone,birth_year,occupation,Join_Date,club_id,member_seq,membership_type,first_name_eng,last_name_eng,member_address_thai,sponsor_name,charter_flag,member_sts")] Member member, Member m) { //Member member = db.Members.Find(id); //db.Members.Remove(member); //db.SaveChanges(); if (ModelState.IsValid) { string tComment = Request.Form["comment"]; string tMoveDate = Request.Form["movedate"]; string tMovement = Request.Form["movement"]; if (tMovement == "4") { member.member_sts = 2; } else { member.member_sts = 1; } member.image = m.image; member.upd_date = DateTime.Now; db.Entry(member).State = EntityState.Modified; db.SaveChanges(); MemberMovement memberMovement = new MemberMovement(); memberMovement.member_seq = member.member_seq; memberMovement.club_id = m.club_id; memberMovement.move_sts = Int32.Parse(tMovement); memberMovement.comment = tComment; memberMovement.hist_date = Convert.ToDateTime(tMoveDate); db.MemberMovements.Add(memberMovement); db.SaveChanges(); var identity = (HttpContext.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "MovementMember", identity.User.club_id); } return(RedirectToAction("Index")); }