//Get action methods of the previous section
public IHttpActionResult PostNewStudent(MemberViewModel member)
{
try
{
var newuser = new tblMember
{
MemberID = member.MemberID,
MemberName = member.MemberName,
PhoneNumber = member.PhoneNumber
};
db.tblMembers.InsertOnSubmit(newuser);
//Save the submitted record
db.SubmitChanges();
//return response status as successfully created with member entity
var msg = Request.CreateResponse(HttpStatusCode.Created, newuser);
//Response message with requesturi for check purpose
msg.Headers.Location = new Uri(Request.RequestUri + newuser.MemberID.ToString());
/// return msg;
return(Ok());
}
catch (Exception ex)
{
return(Ok());
//return response as bad request with exception message.
// return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex);
}
}
public ActionResult Index(MemberModel model)
{
string FileName = Path.GetFileNameWithoutExtension(model.ImageFile.FileName);
string FileExtension = Path.GetExtension(model.ImageFile.FileName);
FileName = DateTime.Now.ToString("yyyyMMdd") + "-" + FileName.Trim() + FileExtension;
string UploadPath = ConfigurationManager.AppSettings["UserUploadPath"].ToString();
model.ImagePath = UploadPath + FileName;
model.ImageFile.SaveAs(model.ImagePath);
tblMember member = new tblMember();
member.ImagePath = model.ImagePath;
member.MemberName = model.Name;
member.PhoneNumber = model.PhoneNumber;
using (MVCEntities entities = new MVCEntities())
{
entities.tblMembers.Add(member);
entities.SaveChanges();
}
return(View());
}
private async void SignUpButton_Clicked(object sender, EventArgs e)
{
MemberService memberservices = new MemberService();
//var xo = await memberservices.GetMemberAsync();
var member = await memberservices.GetMemberByPhoneNoAsync(phoneNo.Text);
if (member.Count == 0)
{
Member _member = new Member {
PhoneNo = phoneNo.Text, isInactive = false
};
var result = memberservices.PostMemberAsync(_member);
}
KooshDarooDatabase odb = new KooshDarooDatabase();
tblMember newmember = new tblMember {
PhoneNo = phoneNo.Text
};
int r = await odb.SaveItemAsync(newmember);
odb = new KooshDarooDatabase();
var oLoginItemS = odb.GetItemsAsync();
var o = oLoginItemS.Result.Count;
App.Current.MainPage = new MainPageTabbed();
//this.Content = (new MainPage()).Content;
}
public ActionResult DeleteConfirmed(int id)
{
tblMember tblMember = db.tblMembers.Find(id);
db.tblMembers.Remove(tblMember);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "MemberID, Name, Surname, Nickname, DateBirth, JMBG, Phone, Address, City, Number, Email, StatusID, LoginID, PrivilageID")] tblMember tblmember)
{
using (Service1Client wcf = new Service1Client())
{
wcf.AddMemebr(tblmember);
}
return(RedirectToAction("Index", "MemberList"));
}
public Task <int> SaveItemAsync(tblMember item)
{
if (item.id != 0)
{
return(database.UpdateAsync(item));
}
else
{
return(database.InsertAsync(item));
}
}
public ActionResult Details(int?id)
{
tblMember M = db.tblMembers.SingleOrDefault(x => x.intMemberID == id);
MemberModel P = new MemberModel()
{
MemberID = M.intMemberID, LoginID = (int)M.intLoginID, MemberName = M.strMemberName, Age = (int)M.intAge, Address = M.strAddress, PhoneNo = M.strPhoneNo,
Gender = M.strGender
};
return(View(P));
}
public ActionResult Add2([Bind(Include = "MemberID, LoginID")] tblMember tblmember)
{
tblMember mem;
using (Service1Client wcf = new Service1Client())
{
mem = wcf.GetOneMember(tblmember.MemberID);
mem.LoginID = tblmember.LoginID;
wcf.AddMemebr(mem);
}
return(RedirectToAction("Index", "MemberList"));
}
public ActionResult Authenticate(LoginModel L)
{
tblLogin t = db.tblLogins.SingleOrDefault(x => (x.strEmail == L.Email && x.strPassword == L.Password));
if (t != null)
{
if (t.strPassword == L.Password)
{
Session["usertype"] = t.strUserType.ToLower();
Session["loginid"] = t.intLoginid;
Session["email"] = t.strEmail;
if (t.strUserType.ToLower() == "admin")
{
return(RedirectToAction("Index", "Admin"));
}
else if (t.strUserType.ToLower() == "doctor")
{
tblDoctor d = db.tblDoctors.SingleOrDefault(x => x.intLoginID == t.intLoginid);
if (d != null)
{
Session["doctorid"] = d.intDoctorID;
return(RedirectToAction("Index", "DoctorUser"));
}
else
{
ViewBag.Error = "Invalid Details";
}
}
else if (t.strUserType.ToLower() == "member")
{
tblMember T = db.tblMembers.SingleOrDefault(x => x.intLoginID == t.intLoginid);
if (T != null)
{
Session["memberid"] = T.intMemberID;
return(RedirectToAction("Index", "MemberUser"));
}
else
{
ViewBag.Error = "Invalid Details";
}
}
}
else
{
ViewBag.Error = "Invalid Details";
}
}
else
{
ViewBag.Error = "Invalid Details";
}
return(View());
}
// GET: Members/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblMember tblMember = db.tblMembers.Find(id);
if (tblMember == null)
{
return(HttpNotFound());
}
return(View(tblMember));
}
public ActionResult AddHeistMember(HeistMemberModel model)
{
tblHeist heist = GetHeistByID(model.HeistID);
var _skillsList = heist.tblHeistSkills.OrderBy(m => m.HeistID).ToArray();
HeistModel hm = new HeistModel();
//Getting skills
hm.HeistSkills = new List <HeistSkillModel>();
for (int i = 0; i < _skillsList.Count(); i++)
{
HeistSkillModel mod = new HeistSkillModel
{
HeistID = _skillsList[i].HeistID,
SkillID = _skillsList[i].SkillsID,
Name = _skillsList[i].Name,
Level = _skillsList[i].SkillLevel,
MembersNo = (Int16)_skillsList[i].MembersNo
};
hm.HeistSkills.Add(mod);
}
//getting members
var _allMembers = GetMatchingMembers(model.HeistID);
List <HeistMemberModel> _list = _allMembers.ToList();
hm.HeistMembers = _allMembers as List <HeistMemberModel>;
ViewBag.MatchingMembers = new SelectList(_list);
tblHeistMembers member = new tblHeistMembers();
member.HeistID = model.HeistID;
member.MemberID = Convert.ToInt32(model.Name);
member.ActiveInHeist = true;
db.tblHeistMembers.Add(member);
tblMember mem = new tblMember();
mem = db.tblMember.SingleOrDefault(m => m.MemberID == member.MemberID);
mem.ActiveInHeist = true;
db.SaveChanges();
return(RedirectToAction("Details", "Heist", new { @id = model.HeistID }));
}
public ActionResult Edit(int?id)
{
ViewBag.MemberStatus = new SelectList(memberStatus);
ViewBag.memberGender = new SelectList(memberGender);
tblMember member = new tblMember();
if (id != null)
{
member = GetMemberByID(id);
}
return(View(member));
}
public ActionResult DeleteMember(int id)
{
tblHeistMembers member = db.tblHeistMembers.SingleOrDefault(m => m.MemberID == id);
int?heistID = member.HeistID;
db.tblHeistMembers.Remove(member);
tblMember mem = db.tblMember.SingleOrDefault(m => m.MemberID == id);
mem.ActiveInHeist = false;
db.SaveChanges();
return(RedirectToAction("Details", "Heist", new { @id = heistID }));
}
public ActionResult DeleteMember(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblMember member = db.tblMember.SingleOrDefault(m => m.MemberID == id);
if (member == null)
{
return(HttpNotFound());
}
return(View(member));
}
public ActionResult Details(int?id)
{
ViewBag.MemberStatus = new SelectList(memberStatus);
ViewBag.memberGender = new SelectList(memberGender);
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblMember member = GetMemberByID(id);
ViewBag.MemberID = member.MemberID;
if (member == null)
{
return(HttpNotFound());
}
var skillList = member.tblMemberSkills.OrderBy(m => m.Name).ToArray();
MemberModel mem = new MemberModel();
mem.Skills = new List <MemberSkill>();
mem.MemberID = member.MemberID;
mem.Name = member.Name;
mem.Email = member.Email;
mem.Sex = member.Sex;
mem.Status = member.Status;
mem.Active = member.Active;
//mem.ActiveInHeist = member.ActiveInHeist;
for (int i = 0; i < skillList.Count(); i++)
{
MemberSkill sk = new MemberSkill
{
SkillID = skillList[i].SkillID,
Name = skillList[i].Name,
Level = skillList[i].SkillLevel
};
mem.Skills.Add(sk);
}
return(View(mem));
}
protected void btnsaveMember_click(object sender, EventArgs e)
{
tblMember _mem = new tblMember();
_mem.Age = Convert.ToInt32(txtMemberAge.Text);
_mem.Relationship = txtRelationShip.Text;
_mem.isEmployed = rdbemplyed.SelectedValue == "0" ? "No" : "Yes";
_mem.MemberName = txtMemberName.Text;
_mem.sex = drpMemberSex.SelectedItem.Text;
if (Session["members"] == null)
{
Session["members"] = new List <tblMember>();
}
((List <tblMember>)Session["members"]).Add(_mem);
grdmembers.DataSource = ((List <tblMember>)Session["members"]);
grdmembers.DataBind();
}
public ActionResult DeleteConfirmed(int id)
{
tblMember member = GetMemberByID(id);
List <tblMemberSkills> lista = db.tblMemberSkills.Where(m => m.MemberID == id).ToList();
for (int i = 0; i < lista.Count(); i++)
{
db.tblMemberSkills.Remove(lista[i]);
db.SaveChanges();
}
db.tblMember.Remove(member);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "MemberID, Name, Surname, Nickname, DateBirth, JMBG, Phone, Address, City, Number, Email, StatusID, LoginID, PrivilageID")] tblMember tblMember)
{
if (ModelState.IsValid)
{
tblMember memOld = Session["MemberSession"] as tblMember;
tblMember.Name = memOld.Name;
tblMember.Number = memOld.Number;
using (Service1Client wcf = new Service1Client())
{
wcf.AddMemebr(tblMember);
}
Session["MemberSession"] = tblMember;
return(RedirectToAction("Index"));
}
return(View(tblMember));
}
public ActionResult Create(tblMember model)
{
tblMember member = new tblMember
{
Active = true,
//ActiveInHeist = false,
Name = model?.Name ?? "",
Email = model?.Email ?? "",
Sex = model.Sex,
Status = model?.Status ?? ""
};
db.tblMember.Add(member);
db.SaveChanges();
return(RedirectToAction("Index", "Member"));
}
public ActionResult Edit(tblMember model)
{
ViewBag.MemberStatus = new SelectList(memberStatus);
ViewBag.memberGender = new SelectList(memberGender);
tblMember member = GetMemberByID(model.MemberID);
member.Name = model?.Name ?? "";
member.Email = model?.Email ?? "";
member.Sex = model?.Sex ?? "";
member.Status = model?.Status ?? "";
member.Active = model.Active;
//member.ActiveInHeist = model.ActiveInHeist;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult ShowAll(string search)
{
List <tblLogin> list;
List <LoginWithOwner> list2 = new List <LoginWithOwner>();
using (Service1Client wcf = new Service1Client())
{
list = wcf.GetLoginList().ToList();
}
LoginWithOwner lwo;
tblMember mem;
foreach (tblLogin l in list)
{
lwo = new LoginWithOwner();
lwo.LoginID = l.LoginID;
lwo.Username = l.Username;
lwo.Password = l.Password;
using (Service1Client wcf = new Service1Client())
{
mem = new tblMember();
mem = wcf.GetOneMemberWithLoginID(l.LoginID);
if (mem != null)
{
lwo.Name = mem.Name;
lwo.Surname = mem.Surname;
}
else
{
lwo.Name = "";
lwo.Surname = "";
}
}
list2.Add(lwo);
}
if (search != null)
{
return(View(list2.Where(x => (x.Username).ToLower().Contains(search.ToLower()) || (x.Name).ToLower().Contains(search.ToLower()) || (x.Surname).ToLower().Contains(search.ToLower())).ToList()));
}
else
{
return(View(list2));
}
}
public ActionResult Edit([Bind(Include = "Id,Email,Password,Name,DateOfBirth,MobileNo,CityId,ReligionId,HeightId,MotherTongueId,CasteId,GenderId,SkinToneId,BodyTypeId,BodyWeight,DietId,Drink,Smoke,Education,AnnualIncomeId,Occupation,Hobbies,AboutMyself")] tblMember tblMember)
{
if (ModelState.IsValid)
{
db.Entry(tblMember).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CasteId = new SelectList(db.tblCasteMasters, "Id", "CasteName", tblMember.CasteId);
ViewBag.CityId = new SelectList(db.tblCityMasters, "Id", "CityName", tblMember.CityId);
ViewBag.GenderId = new SelectList(db.tblGenderMasters, "Id", "Gender", tblMember.GenderId);
ViewBag.HeightId = new SelectList(db.tblHeightMasters, "Id", "Height", tblMember.HeightId);
ViewBag.MotherTongueId = new SelectList(db.tblMotherTongueMasters, "Id", "MotherTongue", tblMember.MotherTongueId);
ViewBag.ReligionId = new SelectList(db.tblReligionMasters, "Id", "ReligionName", tblMember.ReligionId);
ViewBag.SkinToneId = new SelectList(db.tblSkinToneMasters, "Id", "SkinTone", tblMember.SkinToneId);
ViewBag.AnnualIncomeId = new SelectList(db.tblAnnualIncomeMasters, "Id", "AnnualIncome", tblMember.AnnualIncomeId);
ViewBag.BodyTypeId = new SelectList(db.tblBodyTypeMasters, "Id", "BodyType", tblMember.BodyTypeId);
ViewBag.DietId = new SelectList(db.tblDietMasters, "Id", "Diet", tblMember.DietId);
return(View(tblMember));
}
public ActionResult Edit(MemberModel mm)
{
tblMember m = db.tblMembers.SingleOrDefault(x => x.intMemberID == mm.MemberID);
if (m != null)
{
m.intMemberID = mm.MemberID;
m.intLoginID = mm.LoginID;
m.strMemberName = mm.MemberName;
m.intAge = mm.Age;
m.strAddress = mm.Address;
m.strPhoneNo = mm.PhoneNo;
m.strGender = mm.Gender;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
protected void btn_save_Click(object sender, EventArgs e)
{
try
{
if (txt_name.Text != "" && txt_tel.Text != "" && txt_addr.Text != "")
{
tblMember list = new tblMember();
list.full_name = txt_name.Text;
list.no_code_meli = txt_code_meli.Text;
list.name_store = txt_name_co.Text;
list.email = txt_email.Text;
list.tel = txt_email.Text;
list.mobile = txt_mob.Text;
list.addr = txt_addr.Text;
list.Create();
//msg it`s ok save
lbl_msg.ForeColor = Color.Orange;
lbl_msg.CssClass = "common_font";
tblMemberCollection list_mem = tblMember.readall();
lbl_msg.Text = "ذخیره سازی با موفقیت انجام گردید" + " کد کاربری شما : " + list_mem[(list_mem.Count) - 1].id.ToString();
//clear field
txt_addr.Text = "";
txt_code_meli.Text = "";
txt_email.Text = "";
txt_mob.Text = "";
txt_name.Text = "";
txt_name_co.Text = "";
txt_tel.Text = "";
}
}
catch (Exception)
{
//msg error
lbl_msg.ForeColor = Color.Red;
lbl_msg.CssClass = "common_font";
lbl_msg.Text = "روال ذخیره سازی با شکست مواجه شد";
}
}
//To update member record
// PUT api/<controller>/5
public HttpResponseMessage Put(int id, [FromBody] tblMember _member)
{
//fetching and filter specific member id record
var memberdetail = (from a in db.tblMembers where a.MemberID == id select a).FirstOrDefault();
//checking fetched or not with the help of NULL or NOT.
if (memberdetail != null)
{
//set received _member object properties with memberdetail
memberdetail.MemberName = _member.MemberName;
memberdetail.PhoneNumber = _member.PhoneNumber;
//save set allocation.
db.SubmitChanges();
//return response status as successfully updated with member entity
return(Request.CreateResponse(HttpStatusCode.OK, memberdetail));
}
else
{
//return response error as NOT FOUND with message.
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Invalid Code or Member Not Found"));
}
}
/*//Get action methods of the previous section
* public IHttpActionResult PostNewMember(MemberViewModel member)
* {
* if (!ModelState.IsValid)
* return BadRequest("Not a valid model");
*
* dynamic records = from rec in db.tblMembers
* select rec;
*
*
* var newuser = new tblMember
* {
* MemberID = member.MemberID,
* MemberName = member.MemberName,
* PhoneNumber = member.PhoneNumber
* };
*
* db.tblMembers.InsertOnSubmit(newuser);
* try
* {
* db.SubmitChanges();
*
* }
* catch (Exception ex)
* {
* ex.GetBaseException();
* string err = "";
* err = "<p> Couldn't register user. </p>";
*
* }
*
* return Ok();
* }*/
//To add a new member record
// POST api/<controller>
public HttpResponseMessage Post([FromBody] tblMember _member)
{
try
{
//To add an new member record
db.tblMembers.InsertOnSubmit(_member);
//Save the submitted record
db.SubmitChanges();
//return response status as successfully created with member entity
var msg = Request.CreateResponse(HttpStatusCode.Created, _member);
//Response message with requesturi for check purpose
msg.Headers.Location = new Uri(Request.RequestUri + _member.MemberID.ToString());
return(msg);
}
catch (Exception ex)
{
//return response as bad request with exception message.
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
// GET: Members/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblMember tblMember = db.tblMembers.Find(id);
if (tblMember == null)
{
return(HttpNotFound());
}
ViewBag.CasteId = new SelectList(db.tblCasteMasters, "Id", "CasteName", tblMember.CasteId);
ViewBag.CityId = new SelectList(db.tblCityMasters, "Id", "CityName", tblMember.CityId);
ViewBag.GenderId = new SelectList(db.tblGenderMasters, "Id", "Gender", tblMember.GenderId);
ViewBag.HeightId = new SelectList(db.tblHeightMasters, "Id", "Height", tblMember.HeightId);
ViewBag.MotherTongueId = new SelectList(db.tblMotherTongueMasters, "Id", "MotherTongue", tblMember.MotherTongueId);
ViewBag.ReligionId = new SelectList(db.tblReligionMasters, "Id", "ReligionName", tblMember.ReligionId);
ViewBag.SkinToneId = new SelectList(db.tblSkinToneMasters, "Id", "SkinTone", tblMember.SkinToneId);
ViewBag.AnnualIncomeId = new SelectList(db.tblAnnualIncomeMasters, "Id", "AnnualIncome", tblMember.AnnualIncomeId);
ViewBag.BodyTypeId = new SelectList(db.tblBodyTypeMasters, "Id", "BodyType", tblMember.BodyTypeId);
ViewBag.DietId = new SelectList(db.tblDietMasters, "Id", "Diet", tblMember.DietId);
return(View(tblMember));
}
public ActionResult Create(MemberRegisterModel Mr)
{
MemberModel M = Mr.member;
E_health_careModels.LoginModel L = Mr.login;
L.UserType = "Member";
tblLogin ln = new tblLogin();
ln.intLoginid = L.Loginid;
ln.strEmail = L.Email;
ln.strPassword = L.Password;
ln.strUserType = L.UserType;
db.tblLogins.Add(ln);
db.SaveChanges();
tblMember me = new tblMember();
me.intMemberID = M.MemberID;
me.intLoginID = ln.intLoginid;
me.strMemberName = M.MemberName;
me.intAge = M.Age;
me.strAddress = M.Address;
me.strPhoneNo = M.PhoneNo;
me.strGender = M.Gender;
db.tblMembers.Add(me);
db.SaveChanges();
return(RedirectToAction("Authenticate", "Login"));
}
/// <summary>
/// This method is used to save new members
/// </summary>
/// <returns></returns>
public OperationStatus SaveApplicationUser(ApplicationUserModel applicationUserModel)
{
OperationStatus status = OperationStatus.Error;
using (TransactionScope ts = new TransactionScope())
{
try
{
using (dbcontext = new ResourceManagementEntities())
{
if (applicationUserModel.ApplicationUserId == 0)
{
var rs = dbcontext.tblApplicationUsers.FirstOrDefault(x => x.UserName == applicationUserModel.UserName && x.IsDeleted == false);
if (rs == null)
{
tblMember _addMember = new tblMember
{
FName = applicationUserModel.FName,
LName = applicationUserModel.LName,
MemberCode = applicationUserModel.MemberCode,
UserTypeId = applicationUserModel.UserTypeId,
EmailId = applicationUserModel.EmailId,
MobileNo = applicationUserModel.MobileNo,
Address = applicationUserModel.Address,
Gender = applicationUserModel.Gender,
DateOfBirth = applicationUserModel.DateOfBirth,
FatherName = applicationUserModel.FatherName,
MotherName = applicationUserModel.MotherName,
Designation = applicationUserModel.Designation,
IsActive = true,
IsDeleted = false,
CreatedDate = DateTime.Now,
CreatedBy = applicationUserModel.CreatedBy,
ModifiedDate = DateTime.Now,
ModifiedBy = applicationUserModel.ModifiedBy,
};
dbcontext.tblMembers.Add(_addMember);
dbcontext.SaveChanges();
int userid = _addMember.MemberId;
tblApplicationUser _applicationUserinfo = new tblApplicationUser
{
FName = applicationUserModel.FName,
LName = applicationUserModel.LName,
MemberCode = applicationUserModel.MemberCode,
UserTypeId = applicationUserModel.UserTypeId,
EmailId = applicationUserModel.EmailId,
MobileNo = applicationUserModel.MobileNo,
Address = applicationUserModel.Address,
Gender = applicationUserModel.Gender,
DateOfBirth = applicationUserModel.DateOfBirth,
UserIdentityKey = userid,
UserName = applicationUserModel.UserName,
Password = applicationUserModel.Password,
IsActive = true,
IsDeleted = false,
CreatedDate = DateTime.Now,
CreatedBy = applicationUserModel.CreatedBy,
ModifiedDate = DateTime.Now,
ModifiedBy = applicationUserModel.ModifiedBy,
};
dbcontext.tblApplicationUsers.Add(_applicationUserinfo);
dbcontext.SaveChanges();
status = OperationStatus.Success;
ts.Complete();
}
else
{
status = OperationStatus.Duplicate;
//ts.Dispose();
}
}
}
}
catch (Exception ex)
{
dbcontext.Dispose();
status = OperationStatus.Exception;
ts.Dispose();
throw ex;
}
}
return(status);
}
public Task <int> DeleteItemAsync(tblMember item)
{
return(database.DeleteAsync(item));
}
