public object UpdateGrievance(GrievanceParam PR)
{
try
{
tbl_grievance_list obGR = db.tbl_grievance_list.Where(r => r.grivance_id == PR.GrievanceId).FirstOrDefault();
obGR.grivance_name = PR.GrievanceName;
obGR.grivance_description = PR.GrievanceDescription;
obGR.Isalloted = 0;
//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 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 object GrievanceSave(GrievanceParam PR)
{
try
{
//var usercode = db.tbl_user.Where(r => r.code == PR.Code).FirstOrDefault();
if (PR.GrievanceName == null)
{
return(new Error()
{
IsError = true, Message = "Required Grievance Name"
});
}
tbl_grievance_list objuser = new tbl_grievance_list();
var result = db.tbl_grievance_list.Where(r => r.grivance_name == PR.GrievanceName);
if (result != null)
{
return(new Error()
{
IsError = true, Message = "Duplicate Entry Not Allowd"
});
}
objuser.grivance_name = PR.GrievanceName;
objuser.grivance_description = PR.GrievanceDescription;
objuser.Display = 1;
objuser.created_date = DateTime.Now;
objuser.Isalloted = 0;
db.tbl_grievance_list.Add(objuser);
db.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "User Saved 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 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!"
});
}
public object ReportDwonload(int id, string fromdate, string todate, int GriveanceType, int CellMember)
{
ViewData["Fromdate"] = fromdate;
ViewData["Todate"] = todate;
if (CellMember != -1)
{
tbl_user user = db.tbl_user.Where(r => r.UserId == CellMember).FirstOrDefault();
var membername = user.name;
ViewData["MemberName"] = membername;
switch (id)
{
case 8:
id = 8;
var result9 = rpt.GrievanceMemberPendingRpt(fromdate, todate, CellMember);
return(View("PendingRCellMember", result9));
case 9:
id = 9;
var result10 = rpt.GrievanceMemberClosedRpt(fromdate, todate, CellMember);
return(View("ClosedRCellMember", result10));
}
}
if (GriveanceType != -1)
{
tbl_grievance_list obGR = db.tbl_grievance_list.Where(r => r.grivance_id == GriveanceType).FirstOrDefault();
GrievanceNm = obGR.grivance_name;
switch (id)
{
case 5:
id = 5;
var resul5 = rpt.GRDetailedReport(fromdate, todate, GrievanceNm);
return(View("DetailedRGriType", resul5));
case 6:
id = 6;
var result7 = rpt.GRDetailedClosedReport(fromdate, todate, GrievanceNm);
return(View("ClosedRGriType", result7));
case 7:
id = 7;
var result6 = rpt.GRDetailedPendingReport(fromdate, todate, GrievanceNm);
return(View("PendingRGriType", result6));
}
}
switch (id)
{
case 1:
id = 1;
var result1 = rpt.ShowGraphFunction();
return(View("ConsolidatedGrievance", result1));
case 2:
id = 2;
var result7 = rpt.DetailedReport(fromdate, todate);
return(View("DetailedGrievance", result7));
case 3:
id = 3;
var result = rpt.GetGrievanceList(fromdate, todate);
ViewData["resultData"] = result;
return(View("PendingGrievance", result));
case 4:
id = 4;
var result4 = rpt.ClosedGrievance(fromdate, todate);
return(View("ClosedGrievance", result4));
}
return(null);
}