public ActionResult DeleteConfirmed(int id)
{
tblResident tblResident = db.tblResidents.Find(id);
db.tblResidents.Remove(tblResident);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "IDResident,Lastname,Firstname,Middlename,Nickname,Birthdate,Age,Sex,Codep,Relationship,ContactNumber,EmailAddress")] tblResident tblResident)
{
if (ModelState.IsValid)
{
db.Entry(tblResident).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblResident));
}
// GET: Resident/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblResident tblResident = db.tblResidents.Find(id);
if (tblResident == null)
{
return(HttpNotFound());
}
return(View(tblResident));
}
public object SetResident(string Name, string DOB, string FlatNo, string Occupation, string Contact1, string Contact2, string Email, string Image, int PositionID, int FlatHolderID, string Gender)
{
var DC = new DataClassesDataContext();
tblResident ResidentObj = new tblResident();
ResidentObj.ResidentName = Name;
ResidentObj.Gender = Gender;
ResidentObj.DOB = Convert.ToDateTime(DOB).Date;
ResidentObj.FlatNo = FlatNo;
ResidentObj.Occupation = Occupation;
ResidentObj.ContactNo1 = Contact1;
ResidentObj.ContactNo2 = Contact2;
ResidentObj.Email = Email;
ResidentObj.Image = Image;
ResidentObj.PositionID = PositionID;
ResidentObj.FlatHolderID = FlatHolderID;
ResidentObj.IsActive = true;
ResidentObj.CreatedOn = DateTime.Now;
DC.tblResidents.InsertOnSubmit(ResidentObj);
DC.SubmitChanges();
return("True");
}
public object SetFlatHolder(string StartDate, string Name, string DOB, string FlatNo, string Occupation, string Contact1, string Contact2, string Email, string Image, int PositionID, int FlatHolderID, bool IsActive)
{
var DC = new DataClassesDataContext();
tblResident ResidentObj = new tblResident();
ResidentObj.ResidentName = Name;
ResidentObj.DOB = Convert.ToDateTime(DOB).Date;
ResidentObj.FlatNo = FlatNo;
ResidentObj.Occupation = Occupation;
ResidentObj.ContactNo1 = Contact1;
ResidentObj.ContactNo2 = Contact2;
ResidentObj.Email = Email;
ResidentObj.Image = Image;
ResidentObj.PositionID = PositionID;
ResidentObj.FlatHolderID = null;
ResidentObj.IsActive = true;
ResidentObj.CreatedOn = DateTime.Now;
DC.tblResidents.InsertOnSubmit(ResidentObj);
int ResidentID = (from ob in DC.tblResidents
where ob.FlatNo == FlatNo && ob.FlatHolderID == null
select ob.ResidentID).Single();
tblFlatHolder FlatHolderObj = new tblFlatHolder();
FlatHolderObj.FlatNo = FlatNo;
FlatHolderObj.ResidentID = ResidentID;
FlatHolderObj.StartDate = Convert.ToDateTime(StartDate);
FlatHolderObj.EndDate = null;
FlatHolderObj.IsActive = IsActive;
DC.tblFlatHolders.InsertOnSubmit(FlatHolderObj);
var FlatData = (from ob in DC.tblFlats
where ob.FlatNo == FlatNo
select ob).Single();
tblLogin LoginObj = new tblLogin();
LoginObj.LoginName = FlatData.FlatNo + ((FlatData.OnRent) ? "R" : "");
LoginObj.PhoneNo = Contact1;
LoginObj.Email = Email;
LoginObj.Password = Encryptdata(RandomPassword());
LoginObj.VerificationCode = null;
LoginObj.FlatNo = FlatNo;
LoginObj.MemberID = null;
LoginObj.MemberType = ((FlatData.OnRent) ? "Rent Flat Holder" : "Flat Holder");
LoginObj.IsBlocked = false;
DC.tblLogins.InsertOnSubmit(LoginObj);
string Message = "<!DOCTYPE html><html><head><title>Flat Holder Registration Email</title></head><body><p>Hello,<br> You are registered as Flat Holder in Smart Society app.<br> Your login credentials are as given below.<br><br> Username: <strong>" + LoginObj.Email + " or " + LoginObj.PhoneNo + "</strong> Password: <strong>" + Decryptdata(LoginObj.Password) + "</strong><br><br>Thank you</p></body></html>";
Mail(Email, "Flat Holder Registration: Login Credentials", Message);
DC.SubmitChanges();
return(true);
}
