public ActionResult PanelMembersPopupSave(PanelMembersModel model)
{
if (ModelState.IsValid)
{
_panelMembersRepo = new PanelMembersRepo();
_repoResponse = new RepositoryResponse();
string _loggedInUserID = System.Web.HttpContext.Current.Session["UserID"].ToString();
_repoResponse = _panelMembersRepo.AddOrEditPanelMembersDetails(model, _loggedInUserID);
return(Json(new { success = _repoResponse.success, message = _repoResponse.message }));
}
else
{
string _message = string.Empty;
List <string> fieldOrder = new List <string>(new string[] {
"UserName", "Password"
})
.Select(f => f.ToLower()).ToList();
var _message1 = ModelState
.Select(m => new { Order = fieldOrder.IndexOf(m.Key.ToLower()), Error = m.Value })
.OrderBy(m => m.Order)
.SelectMany(m => m.Error.Errors.Select(e => e.ErrorMessage)).ToList();
_message = string.Join("<br/>", _message1);
return(Json(new { success = false, message = _message }));
}
}
public RepositoryResponse AddOrEditPanelMembersDetails(PanelMembersModel model, string _loggedInUserID)
{
baseModel = new RepositoryResponse();
EvaluatorAvailability dbModel;
try
{
using (objSOMEntities = new SOMEntities())
using (objIPEntities = new IntranetPortalEntities())
{
DateTime now = DateTime.Now;
dbModel = new EvaluatorAvailability();
var usr = objIPEntities.EmpMasters.Where(r => r.EmployeeNumber == model.EvaluatorID.ToString()).FirstOrDefault();
dbModel = objSOMEntities.EvaluatorAvailabilities.Where(r => r.ID == model.ID && r.Month == model.MonthFilter && r.Year == model.YearFilter).FirstOrDefault();
if (dbModel != null)
{
dbModel.EvaluatorID = usr.EmployeeNumber;
dbModel.Month = model.MonthFilter;
dbModel.Year = model.YearFilter;
dbModel.IsActive = true;
dbModel.ModifiedBy = _loggedInUserID;
objSOMEntities.SaveChanges();
baseModel = new RepositoryResponse {
success = true, message = "Panel Members Details updated Successfully"
};
}
else
{
dbModel = new EvaluatorAvailability();
dbModel.EvaluatorID = usr.EmployeeNumber;
dbModel.Month = model.MonthFilter;
dbModel.Year = model.YearFilter;
dbModel.IsActive = true;
dbModel.CreatedBy = _loggedInUserID;
objSOMEntities.EvaluatorAvailabilities.Add(dbModel);
objSOMEntities.SaveChanges();
baseModel = new RepositoryResponse {
success = true, message = "Panel Members Details added Successfully"
};
}
}
}
catch (Exception ex)
{
baseModel = new RepositoryResponse {
success = false, message = ex.ToString()
};
}
return(baseModel);
}
// GET: PanelMembers
public ActionResult Index()
{
PanelMembersModel model = new PanelMembersModel();
_loginRepo = new LoginRepo();
_panelMembersRepo = new PanelMembersRepo();
var monthFilter = _loginRepo.GetMonthYearFilter();
var deptFilter = _loginRepo.GetDepartmentDetails();
model.DateFilterlst = monthFilter;
model.DeptFilterlst = deptFilter;
model.MonthFilterlst = _panelMembersRepo.LoadListofMonth(Assistant.GetMonthFromCurrentDate());
model.YearFilterlst = _panelMembersRepo.LoadListofFutureYears(5, Assistant.GetYearFromCurrentDate());
return(View(model));
}
public RepositoryResponse GetPanelMembersByID(long ID)
{
baseModel = new RepositoryResponse();
try
{
PanelMembersModel model = new PanelMembersModel();
using (objSOMEntities = new SOMEntities())
using (objIPEntities = new IntranetPortalEntities())
{
var data = (from a in objIPEntities.EmpMasters.AsEnumerable()
join b in objSOMEntities.EvaluatorAvailabilities.AsEnumerable() on a.EmployeeNumber equals b.EvaluatorID.ToString()
where b.ID == ID && b.IsActive == true
select new { a, b }).FirstOrDefault();
//var data = objSOMEntities.Nominations.Where(r => r.ID == ID && r.IsActive == true).FirstOrDefault();
if (data != null)
{
model.MonthFilterlst = LoadListofMonth(data.b.Month);
model.YearFilterlst = LoadListofFutureYears(5, data.b.Year);
model.ID = data.b.ID;
model.EvaluatorID = data.b.EvaluatorID;
model.Name = data.a.EmployeeName;
model.MonthFilter = data.b.Month;
model.YearFilter = data.b.Year;
baseModel = new RepositoryResponse {
success = true, message = "Get Panel Members details Successfully", Data = model
};
}
else
{
baseModel = new RepositoryResponse {
success = false, message = "Unable to get Panel Members details", Data = model
};
}
}
}
catch (Exception ex)
{
baseModel = new RepositoryResponse {
success = false, message = ex.ToString()
};
}
return(baseModel);
}
public ActionResult PanelMembersPopupValues(string ID)
{
long _id = long.Parse(ID);
_panelMembersRepo = new PanelMembersRepo();
_repoResponse = new RepositoryResponse();
if (_id > 0)
{
_repoResponse = _panelMembersRepo.GetPanelMembersByID(_id);
}
if (_repoResponse.success == true)
{
PanelMembersModel model = new PanelMembersModel();
model = _repoResponse.Data;
//return JSon(model);
return(Json(new { success = _repoResponse.success, message = _repoResponse.message, data = model }));
}
else
{
EvaluationModel model = new EvaluationModel();
return(Json(new { success = _repoResponse.success, message = _repoResponse.message, data = model }));
}
}
public RepositoryResponse LoadPanelMembers(string dept, string date)
{
baseModel = new RepositoryResponse();
try
{
string subMonth = string.Empty;
string subYear = string.Empty;
if (!string.IsNullOrEmpty(date))
{
string[] sDate = date.Split('-');
subMonth = sDate[0];
subYear = sDate[1];
}
List <PanelMembersModel> _lstPanelMembers = new List <PanelMembersModel>();
using (objSOMEntities = new SOMEntities())
using (objIPEntities = new IntranetPortalEntities())
{
var lstPanelMembers = (from a in objIPEntities.EmpMasters.AsEnumerable()
join b in objSOMEntities.EvaluatorAvailabilities.AsEnumerable() on a.EmployeeNumber equals b.EvaluatorID.ToString()
where b.IsActive == true
select new
{
a.EmployeeNumber,
a.EmployeeName,
a.Department,
b.Month,
b.Year,
b.IsActive,
b.EvaluatorID,
b.ID
}).OrderByDescending(r => r.ID).ToList();
if (!string.IsNullOrEmpty(dept) && dept != "--ALL--")
{
lstPanelMembers = lstPanelMembers.Where(r => r.Department == dept).ToList();
}
if (!string.IsNullOrEmpty(subMonth) && !string.IsNullOrEmpty(subYear))
{
lstPanelMembers = lstPanelMembers.Where(r => r.Month == subMonth && r.Year == subYear).ToList();
}
int i = 1;
foreach (var item in lstPanelMembers)
{
PanelMembersModel _panelMembers = new PanelMembersModel();
_panelMembers.ID = item.ID;
_panelMembers.SlNo = i;
_panelMembers.EvaluatorID = item.EmployeeNumber;
_panelMembers.Name = item.EmployeeName;
_panelMembers.Department = item.Department;
_panelMembers.Month = item.Month;
_panelMembers.Year = item.Year;
_lstPanelMembers.Add(_panelMembers);
i++;
}
baseModel = new RepositoryResponse {
success = true, message = "Get Panel member details Successfully", Data = _lstPanelMembers
};
}
}
catch (Exception ex)
{
baseModel = new RepositoryResponse {
success = false, message = ex.ToString()
};
}
return(baseModel);
}
