public object UpdateComp(ParamComplaintDetails PR)
{
GRContext db = new GRContext();
try
{
tbl_complaintdetails objuser = db.tbl_complaintdetails.Where(r => r.CompID == PR.CompID).FirstOrDefault();
objuser.GrievanceAction = PR.GrievanceAction;
objuser.status = PR.status;
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "User Saved Successfully."
});
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
public object SetStatus(SetStatusParameters obj)
{
try
{
tbl_complaintdetails cobj = db.tbl_complaintdetails.First(r => r.CompID == obj.CompId && r.Display == 1);
if (cobj != null)
{
cobj.CompID = obj.CompId;
cobj.GrievanceAction = obj.GrievanceAction;
cobj.status = obj.Status;
cobj.modified_date = DateTime.Now;
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "Status Updates Successfully.."
});
}
else
{
return(new Error()
{
IsError = true, Message = " Record Not Found"
});
}
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = " Error"
});
}
}
public object SaveGrievance(ParamSaveGriveance obj)
{
if (obj.UserId == null)
{
return(new Result {
IsSucess = false, ResultData = "Invalid User."
});
}
int grievancetypeid = Convert.ToInt32(obj.GriveanceType);
var grievancetypelist = objcontext.tbl_grievance_list.Where(r => r.grivance_id == grievancetypeid).First();
tbl_postgriev objpost = new tbl_postgriev();
if (obj.Code == null)
{
return(new Result {
IsSucess = false, ResultData = "Invalid User."
});
}
else
{
objpost.code = obj.Code;
objpost.email = obj.Email;
objpost.grivtype = grievancetypelist.grivance_name;
objpost.subject = obj.Subject;
objpost.post = obj.PostDetails;
objpost.userid = obj.UserId;
objpost.status = "Pending";
objpost.Display = 1;
objpost.created_date = DateTime.Now;
objcontext.tbl_postgriev.Add(objpost);
//objcontext.SaveChanges();
tbl_complaintdetails comp = new tbl_complaintdetails();
comp.GrievanceType = grievancetypelist.grivance_name;
comp.Date = DateTime.Now.Date;
comp.Subject = objpost.subject;
comp.Post = objpost.post;
comp.status = objpost.status;
comp.GrievanceAction = "Pending";
comp.GrievMemID = grievancetypeid;
comp.StackHolderType = obj.Type;
comp.StackholderID = Convert.ToString(objpost.code);
comp.UserId = obj.UserId;
comp.Display = 1;
comp.created_date = DateTime.Now;
objcontext.tbl_complaintdetails.Add(comp);
objcontext.SaveChanges();
return(new Result {
IsSucess = true, ResultData = "Griveance Posted Sucessfully."
});
}
}