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