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