public object DeleteGrievanceAllocation(ParamRegistration PR) { try { tbl_member objmember = db.tbl_member.Where(r => r.UserId == PR.UserId).FirstOrDefault(); if (objmember.Display == 1) { objmember.Display = 0; } else { objmember.Display = 1; } db.SaveChanges(); return(new Result() { IsSucess = true, ResultData = "Member Updated Successfully." }); } catch (Exception ex) { return(new Error() { IsError = true, Message = ex.Message }); } }
public object GrievanceMemberClosedRpt(string fromdate, string todate, int userid) { var id = Convert.ToInt32(userid); try { tbl_member s = new tbl_member(); var MyGrievance = db.tbl_member.Where(r => r.UserId == id).SingleOrDefault(); var type = MyGrievance.griType; var list = db.View_ReportViewGrievanceList.Where(r => r.GrievanceType == type && r.status == "Closed").ToList(); if (MyGrievance == null) { return(new Error() { IsError = true, Message = "My Grievance Not Found" }); } else { return(list); } } catch (Exception E) { return(new Error() { IsError = true, Message = E.Message }); } }
public object UpdateGrievanceAllocation(GrievanceAllocationParam PR) { try { tbl_member obGR = db.tbl_member.Where(r => r.UserId == PR.UserId).FirstOrDefault(); obGR.griType = PR.griType; obGR.designation = PR.designation; obGR.modified_date = DateTime.Now; //db.tbl_user.Add(objuser); db.SaveChanges(); tbl_grievance_list objgrlist = db.tbl_grievance_list.Where(r => r.grivance_name == PR.griType).FirstOrDefault(); objgrlist.Isalloted = 1; db.SaveChanges(); tbl_user objuser = db.tbl_user.Where(r => r.UserId == PR.UserId).FirstOrDefault(); objuser.name = PR.name; objuser.code = PR.code; objuser.email = PR.email; objuser.contact = PR.contact; db.SaveChanges(); return(new Result() { IsSucess = true, ResultData = "Grievance Update Successfully." }); } catch (Exception ex) { return(new Error() { IsError = true, Message = ex.Message }); } }
public ActionResult Create([Bind(Include = "mem_id,mem_name,mem_email,mem_contact,mem_password,mem_address,mem_dob")] tbl_member tbl_member) { //var readings = db.Reading_History.Where(b => b.ebook_id == id).Any(); //if (readings == false) //{ var email = tbl_member.mem_email; var emailcheck = db.tbl_member.Where(b => b.mem_email == email).Any(); var emailcheck1 = db.Tbl_Vendorr.Where(b => b.Vendor_email == email).Any(); var emailcheck2 = db.Tbl_admin.Where(b => b.Admin_email == email).Any(); if (emailcheck == false && emailcheck1 == false && emailcheck2 == false) { if (ModelState.IsValid) { db.tbl_member.Add(tbl_member); db.SaveChanges(); return(RedirectToAction("vendorreaderLogin", "Home")); } return(View(tbl_member)); } else { Response.Write("<script>alert('Email Already registered';</script>"); } return(View(tbl_member)); }
//public ActionResult Searching(string searchBy, string search, int? page) //{ // if (searchBy == "cat_name") // { // return View(db.Tbl_Books.Where(x => x.Book_categoryy.cat_name.StartsWith(search) || search == null) // .ToList().ToPagedList(page ?? 1, 3)); // } // if (searchBy == "Book_name") // { // return View(db.Tbl_Books.Where(x => x.Book_name.StartsWith(search) || search == null) // .ToList().ToPagedList(page ?? 1, 3)); // } // else // return View(db.Tbl_Books.Where(x => x.pub_id.StartsWith(search) || search == null) // .ToList().ToPagedList(page ?? 1, 3)); //} public ActionResult vendorreaderLogin(String email, String pass, string sel) { if (sel == "reader") { tbl_member model = db.tbl_member.Where(x => x.mem_email == email && x.mem_password == pass).SingleOrDefault(); if (model != null) { Session["mem_email"] = model.mem_email; Session["mem_id"] = model.mem_id; Session["mem_password"] = model.mem_password; return(RedirectToAction("UserPanel", "Tbl_member")); } } else { Tbl_Vendorr model1 = db.Tbl_Vendorr .Where(x => x.Vendor_email == email && x.Vendor_password == pass).SingleOrDefault(); if (model1 != null) { Session["Vendor_email"] = model1.Vendor_email; Session["Vendor_id"] = model1.Vendor_id; return(RedirectToAction("VendorPanel", "Tbl_Vendorr")); } } return(View()); }
public ActionResult DeleteConfirmed(int id) { tbl_member tbl_member = db.tbl_member.Find(id); db.tbl_member.Remove(tbl_member); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "mem_id,mem_name,mem_email,mem_contact,mem_password,mem_address,mem_dob")] tbl_member tbl_member) { if (ModelState.IsValid) { db.Entry(tbl_member).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("UserPanel", "Tbl_member")); } return(View(tbl_member)); }
public ActionResult PersonalInfo() { tbl_member m = null; if (Session["mem_id"] != null) { int mem_id = Convert.ToInt32(Session["mem_id"].ToString()); m = db.tbl_member.Where(x => x.mem_id == mem_id).SingleOrDefault(); } return(View(m)); }
public ActionResult DetailsPublic(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_member tbl_member = db.tbl_member.Find(id); if (tbl_member == null) { return(HttpNotFound()); } return(View(tbl_member)); }
public ActionResult Login(String email, String pass) { tbl_member model = db.tbl_member.Where(x => x.mem_email == email && x.mem_password == pass).SingleOrDefault(); if (model != null) { Session["mem_email"] = model.mem_email; Session["mem_id"] = model.mem_id; Session["mem_password"] = model.mem_password; return(RedirectToAction("UserPanel", "Tbl_member")); } else { } return(View()); }
public object DeleteMember(MemberParameter PR) { GRContext db = new GRContext(); try { tbl_member objmember = db.tbl_member.Where(r => r.UserId == PR.UserId).FirstOrDefault(); if (objmember.Display == 1) { objmember.Display = 0; } else { objmember.Display = 1; } db.SaveChanges(); tbl_user objuser = db.tbl_user.Where(r => r.UserId == PR.UserId).FirstOrDefault(); if (objuser.Display == 1) { objuser.Display = 0; } else { objuser.Display = 1; } db.SaveChanges(); return(new Result() { IsSucess = true, ResultData = "Member Updated Successfully." }); } catch (Exception ex) { return(new Error() { IsError = true, Message = ex.Message }); } }
public object UpdateMemberDetail(MemberParameter PR) { GRContext db = new GRContext(); try { tbl_member objmember = db.tbl_member.Where(r => r.UserId == PR.UserId).FirstOrDefault(); objmember.griType = PR.GriType; objmember.designation = PR.Designation; objmember.modified_date = DateTime.Now; if (PR.GriType != null) { objmember.griType = PR.GriType; tbl_grievance_list list = db.tbl_grievance_list.Where(r => r.grivance_name == objmember.griType).FirstOrDefault(); list.Isalloted = 1; db.SaveChanges(); } db.SaveChanges(); tbl_user objuser = db.tbl_user.Where(r => r.UserId == PR.UserId).FirstOrDefault(); objuser.name = PR.Name; objuser.gender = PR.Gender; objuser.email = PR.EmailId; objuser.contact = PR.MobileNo; db.SaveChanges(); return(new Result() { IsSucess = true, ResultData = "Member Updated Successfully." }); } catch (Exception ex) { return(new Error() { IsError = true, Message = ex.Message }); } }
public object GetMember(ParamGetMyGrievance obj) { var id = Convert.ToString(obj.StudentCode); var userid = Convert.ToInt32(obj.Userid); if (id == "0") { return(new Error() { IsError = true, Message = "UserCode Not Found" }); } try { tbl_member s = new tbl_member(); var MyGrievance = db.tbl_member.Where(r => r.UserId == userid).SingleOrDefault(); var type = MyGrievance.griType; var list = db.tbl_complaintdetails.Where(r => r.GrievanceType == type).ToList(); if (MyGrievance == null) { return(new Error() { IsError = true, Message = "My Grievance Not Found" }); } else { return(new Result() { IsSucess = true, ResultData = list }); } } catch (Exception E) { return(new Error() { IsError = true, Message = E.Message }); } }
public object UpdateGrievanceAllocation(GrievanceAllocationParam PR) { try { tbl_member obGR = db.tbl_member.Where(r => r.UserId == PR.UserId).FirstOrDefault(); obGR.griType = PR.griType; //db.tbl_user.Add(objuser); db.SaveChanges(); return(new Result() { IsSucess = true, ResultData = "Grievance Update Successfully." }); } catch (Exception ex) { return(new Error() { IsError = true, Message = ex.Message }); } }
public object SaveMember([FromBody] MemberParameter obj) { GRContext db = new GRContext(); var usercode = db.tbl_member.Where(r => r.code == obj.Code).FirstOrDefault(); if (usercode != null) { return(new Error() { IsError = true, Message = "User Code Already Exists." }); } tbl_user objuser = new tbl_user(); objuser.name = obj.Name.ToString(); objuser.UserId = Convert.ToInt32(obj.UserId); objuser.code = obj.Code; objuser.type = "Member"; objuser.gender = obj.Gender.ToString(); objuser.email = obj.EmailId.ToString(); objuser.contact = Convert.ToInt64(obj.MobileNo); objuser.password = CryptIt.Encrypt(obj.Password); objuser.status = 1; objuser.Islive = 0; objuser.Display = 1; objuser.created_date = DateTime.Now; db.tbl_user.Add(objuser); try { db.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } tbl_member objmember = new tbl_member(); tbl_user omember = db.tbl_user.Where(r => r.code == obj.Code).FirstOrDefault(); objmember.UserId = omember.UserId; objmember.code = Convert.ToInt32(obj.Code); objmember.designation = obj.Designation.ToString(); if (obj.GriType != null) { objmember.griType = obj.GriType.ToString(); } objmember.Display = 1; objmember.created_date = DateTime.Now; db.tbl_member.Add(objmember); db.SaveChanges(); if (obj.GriType != null) { tbl_grievance_list list = db.tbl_grievance_list.Where(r => r.grivance_name == objmember.griType).FirstOrDefault(); list.Isalloted = 1; db.SaveChanges(); } return(new Result { IsSucess = true, ResultData = "Member Created!" }); }