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);
}
public RepositoryResponse AddPanelMembers(string data, string _loggedInUserID)
{
baseModel = new RepositoryResponse();
try
{
if (!string.IsNullOrEmpty(data))
{
string[] _dataStr = data.Split(',');
foreach (var item in _dataStr)
{
if (!string.IsNullOrEmpty(item))
{
string month = Assistant.GetMonthFromCurrentDate();
string year = Assistant.GetYearFromCurrentDate();
using (objSOMEntities = new SOMEntities())
{
var _details = objSOMEntities.EvaluatorAvailabilities.Where(r => r.EvaluatorID == item && r.IsActive == true &&
r.Month == month && r.Year == year).FirstOrDefault();
if (_details == null)
{
EvaluatorAvailability dbModel = new EvaluatorAvailability();
dbModel.EvaluatorID = item;
dbModel.CreatedBy = _loggedInUserID;
dbModel.IsActive = true;
dbModel.Month = month;
dbModel.Year = year;
objSOMEntities.EvaluatorAvailabilities.Add(dbModel);
objSOMEntities.SaveChanges();
}
}
baseModel = new RepositoryResponse {
success = true, message = "Panel Members Added Successfully"
};
}
}
}
}
catch (Exception ex)
{
baseModel = new RepositoryResponse {
success = false, message = ex.ToString()
};
}
return(baseModel);
}
