private void Save_Address(object sender, DialogClickEventArgs args) { tblmember updatemember = new tblmember(); updatemember.id = Convert.ToInt32(Intent.GetStringExtra("member_id")); updatemember.address_id = Intent.GetStringExtra("address_id"); updatemember.fname = txtfname.Text; updatemember.mname = txtmname.Text; updatemember.lname = txtlname.Text; updatemember.ename = txtexname.Text; updatemember.gender = spngender.SelectedItem.ToString(); updatemember.birthday = txtbday.Text; updatemember.birth_certificate = spnbirthcert.SelectedItem.ToString(); updatemember.marital_status = spnmarital.SelectedItem.ToString(); updatemember.religion = txtreligion.Text; updatemember.school_attendance = spnschoolattendance.SelectedItem.ToString(); updatemember.literacy = spnliteracy.SelectedItem.ToString(); updatemember.highest_grade = spnschoolhigh.SelectedItem.ToString(); updatemember.occupation = txtoccupation.Text; updatemember.rhousehold = spnrhouse.SelectedItem.ToString(); updatemember.work_status = spnworkstatus.SelectedItem.ToString(); ConMember.UpdateMemberList(updatemember); var builder = new AlertDialog.Builder(this); builder.SetTitle("Census"); builder.SetMessage("Updating Member Successful"); builder.SetPositiveButton("Ok", Save_success); builder.Show(); }
public static long UpdateMemberList(tblmember item) { using (var database = Database.Connection()) { database.Update(item); return(item.id); } }
public ActionResult Register(HttpPostedFileBase file, RegisterViewModel viewModel) { if (!ModelState.IsValid) { return(View(viewModel)); } var exists = db.tblmembers.Any(a => a.Active && a.PICEmail == viewModel.Email); if (!ModelState.IsValid) { ModelState.AddModelError("", "Invalid email."); return(View(viewModel)); } var member = new tblmember() { PICName = viewModel.Name, PICEmail = viewModel.Email, Roles = "NU", Password = Util.GetMD5Hash(viewModel.Password), CreateDT = DateTime.Now, Language = "EN", Active = true }; if (file != null) { var fileName = FileUploadManager.UploadAndSave(file); member.ProfileImagePath = fileName; } db.tblmembers.Add(member); db.SaveChanges(); var emailBody = string.Format(@"Hi {0}, <br /><br /> Thanks for Subscribing to the EZ Go Holiday Website ! You’re joining an amazing community of folks who love nerding out about travelling. <br /><br /> As you wait for the next issue, check out some of our most popular posts. They’re a great place to get started. <br /><br /> Website: http://www.ezgoholiday.com <br /> Username: {1} <br /> Password: {2} <br /><br /> Have an awesome day! <br /> EZ Go Holiday Management", viewModel.Name, viewModel.Email, viewModel.Password); Util.SendEmail("Welcome to EZ Go Holiday!", emailBody, viewModel.Email, "", ""); Util.SessionAccess = member; FormsAuthentication.SetAuthCookie(viewModel.Email, false); return(RedirectToAction("Index", "Home")); }
public ActionResult Create(MemberCreateViewModel viewModel) { var defaultPassword = Util.RandomString(); var Member = new tblmember() { BusinessRegNo = viewModel.BusinessRegNo, CompanyName = viewModel.CompanyName, PICName = viewModel.PICName, PICContact = viewModel.PICContact, PICEmail = viewModel.PICEmail, OfficeContact = "-", Address = viewModel.Address, Postcode = viewModel.Postcode, State = viewModel.State, Country = viewModel.Country, Roles = viewModel.Roles, Password = Util.GetMD5Hash(defaultPassword), CreateDT = DateTime.Now, Language = "EN", Active = true }; db.tblmembers.Add(Member); db.SaveChanges(); var emailBody = string.Format(@"Hi {0}, <br /><br /> Thanks for Subscribing to the EZ Go Holiday Website ! You’re joining an amazing community of folks who love nerding out about travelling. <br /><br /> As you wait for the next issue, check out some of our most popular posts. They’re a great place to get started. <br /><br /> Website: http://www.ezgoholiday.com <br /> Username: {1} <br /> Password: {2} <br /><br /> Have an awesome day! <br /> EZ Go Holiday Management", viewModel.PICName, viewModel.PICEmail, defaultPassword); Util.SendEmail("Welcome to EZ Go Holiday!", emailBody, viewModel.PICEmail, "", ""); return(RedirectToAction("Index")); }
//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 txt.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. txt.SaveChanges(); //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")); } }
//To add a new member record // POST api/<controller> public HttpResponseMessage Post([FromBody] tblmember _member) { try { //To add an new member record txt.tblmembers.Add(_member); //Save the submitted record txt.SaveChanges(); //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)); } }