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