// 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"));
}
