public ActionResult Edit(Models.MemberModel model)
{
member.UpdateData(model);
var dataList = member.DisplayData();
return(View("Index", dataList));
}
public ActionResult AddData(Models.MemberModel memberModel)
{
member.SaveData(memberModel);
var data = member.DisplayData();
return(View("Index", data));
}
public ActionResult Edit(Guid id, FormCollection collection)
{
try
{
// TODO: Add update logic here
Models.MemberModel memberModel = new Models.MemberModel();
UpdateModel(memberModel);
memberRepository.UpdateMember(memberModel);
return(RedirectToAction("Index"));
}
catch
{
return(View("Edit"));
}
}
public ActionResult Create(FormCollection collection)
{
try
{
// TODO: Add insert logic here
Models.MemberModel memberModel = new Models.MemberModel();
UpdateModel(memberModel);
memberRepository.InsertMember(memberModel);
return(RedirectToAction("Index"));
}
catch
{
return(View("CreateMember"));
}
}
public void SaveData(Models.MemberModel memberModel)
{
var data = new Member()
{
MemberID = memberModel.MemberID,
MemberName = memberModel.MemberName,
StaffMemberID = memberModel.StaffMemberID,
MemberAddress = memberModel.MemberAddress,
ContactNo = memberModel.ContactNo,
EmailAddress = memberModel.EmailAddress,
UserName = memberModel.UserName,
Password = memberModel.Password,
Status = memberModel.Status
};
context.Members.Add(data);
context.SaveChanges();
}
public static int AddMember(Models.MemberModel member)
{
SqlConnection sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["DatabaseString"].ConnectionString);
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand("AddMember", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(new SqlParameter("@Name", member.Name));
sqlCommand.Parameters.Add(new SqlParameter("@Mail", member.Mail));
sqlCommand.Parameters.Add(new SqlParameter("@Phone", member.Phone));
sqlCommand.Parameters.Add(new SqlParameter("@Password", Common.CommonClass.Hash(member.Mail)));
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
sqlDataReader.Read();
int result = int.Parse(sqlDataReader[0].ToString());
sqlConnection.Close();
return(result);
}
public static List <MemberModel> ChangeTOMemberModel(IEnumerable <Member> memberList)
{
List <MemberModel> mmList = new List <Models.MemberModel>();
foreach (var item in memberList)
{
MemberModel mm = new Models.MemberModel();
mm.Account = item.Account;
mm.Name = item.Name;
mm.ParentName = item.Parent;
mm.RoleCode = item.Role;
mm.Apcount = item.Apcount;
mm.Ascount = item.Ascount;
mm.Cocount = item.Cocount;
mmList.Add(mm);
}
return(mmList);
}
public void UpdateData(Models.MemberModel model)
{
try
{
Member data = new Member();
data = context.Members.
Where(a => a.MemberID == model.MemberID).FirstOrDefault();
data.MemberID = model.MemberID;
data.MemberName = model.MemberName;
data.StaffMemberID = model.StaffMemberID;
data.MemberAddress = model.MemberAddress;
data.ContactNo = model.ContactNo;
data.EmailAddress = model.EmailAddress;
data.UserName = model.UserName;
data.Password = model.Password;
data.Status = model.Status;
context.SaveChanges();
}
catch (Exception)
{
throw;
}
}
public ActionResult AddMemberDone(String tbName, String tbMail, String tbPhone)
{
if (System.Web.HttpContext.Current.Session["UserName"] == null)
{
return(RedirectToAction("logon", "account"));
}
else
{
if (!System.Web.HttpContext.Current.Session["UserName"].ToString().Equals("Admin"))
{
return(RedirectToAction("Index", "user"));
}
else
{
Models.MemberModel newMember = new Models.MemberModel();
newMember.Name = System.Globalization.CultureInfo.InvariantCulture.TextInfo.ToTitleCase(tbName);
newMember.Mail = tbMail;
newMember.Phone = tbPhone;
newMember.ID = RoomValue.Models.AdminModel.AddMember(newMember);
return(RedirectToAction("AddMemberPost/" + newMember.ID, "Admin"));
}
}
}
// GET: Member/Delete/5
public ActionResult Delete(Guid id)
{
Models.MemberModel memberModel = memberRepository.GetMemberByID(id);
return(View("DeleteMember", memberModel));
}
// GET: Member/Details/5
public ActionResult Details(Guid id)
{
Models.MemberModel memberModel = memberRepository.GetMemberByID(id);
return(View("MemberDetails", memberModel));
}
// GET: Member/Edit/5
public ActionResult Edit(Guid id)
{
Models.MemberModel membermodel = memberRepository.GetMemberByID(id);
return(View("Edit", membermodel));
}
