//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")); }
public ActionResult Create([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,line_id")] Member member, HttpPostedFileBase image) //public ActionResult Create([Bind(Include = "member_id,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) { //Member result = db.Members.Find(member.member_id); var result = (from m in db.Members where m.member_id == member.member_id select m ); if (result.Count() == 0) { if (image != null && image.ContentLength > 0) { using (var reader = new System.IO.BinaryReader(image.InputStream)) { member.image = reader.ReadBytes(image.ContentLength); } } member.upd_date = DateTime.Now; db.Members.Add(member); string tMovement = Request.Form["movement"]; string tMoveDate = Request.Form["movedate"]; MemberMovement memberMovement = new MemberMovement(); if (tMovement != "1" && Convert.ToDateTime(tMoveDate) != memberMovement.hist_date) { MemberMovement memberMovement1 = new MemberMovement(); memberMovement1.member_seq = member.member_seq; memberMovement1.hist_date = member.join_date; memberMovement1.club_id = null; memberMovement1.move_sts = 1; db.MemberMovements.Add(memberMovement1); } if (tMovement == "1") { memberMovement.hist_date = member.join_date; } else { memberMovement.hist_date = Convert.ToDateTime(tMoveDate); } memberMovement.member_seq = member.member_seq; memberMovement.club_id = member.club_id; memberMovement.move_sts = Int32.Parse(tMovement); db.MemberMovements.Add(memberMovement); //ProjLib projlib = new ProjLib(); var user_code = ProjLib.chkUserCode(member.first_name_eng, member.last_name_eng); TUser tuser = new TUser(); //tuser.user_code = member.first_name_eng.ToLower() + "." + member.last_name_eng.ToLower().Substring(0, 1); tuser.user_code = user_code; //tuser.user_pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(member.first_name_eng.ToLower() + "." + member.last_name_eng.ToLower().Substring(0, 1) + "@123", "SHA1"); tuser.user_pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(user_code + "@123", "SHA1"); tuser.role_name = "User"; tuser.member_seq = member.member_seq; tuser.upd_date = DateTime.Now; db.TUsers.Add(tuser); db.SaveChanges(); // Write log to table TransactionLog ProjLib.writeTransactionLog(identity.User.member_seq, "CreateMember", identity.User.club_id); return(RedirectToAction("Index")); } else { ViewBag.errorMessage = "รหัสสมาชิกซ้ำ"; } } 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)); }