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