public RepositoryResponse AddOrEditStarOfMonth(StarOfMonthModel model, string loggedInuserID)
{
_nominationRepo = new NominationRepo();
baseModel = new RepositoryResponse();
try
{
string nomID = string.Empty;
//string IPValue = string.Empty;
Nomination dbNomModel = new Nomination();
using (objSOMEntities = new SOMEntities())
{
//var config = objSOMEntities.Configurations.Where(r => r.Module == "SOM" && r.Type == "UPDATEIP" && r.IsActive == true).FirstOrDefault();
//IPValue = config.Value;
var dbModel = objSOMEntities.StarOfTheMonths.Where(r => r.TransID == model.TransID).FirstOrDefault();
if (string.IsNullOrEmpty(model.SelectedNominationID))
{
dbNomModel = objSOMEntities.Nominations.Where(r => r.NominationId == dbModel.NominationID).FirstOrDefault();
}
else
{
dbNomModel = objSOMEntities.Nominations.Where(r => r.NominationId == model.SelectedNominationID.Replace("\r\n", "")).FirstOrDefault();
}
if (dbModel == null)
{
nomID = dbNomModel.NominationId;
dbModel = new StarOfTheMonth.DataBase.StarOfTheMonth();
dbModel.EmpId = int.Parse(dbNomModel.EmployeeNumber);
dbModel.IsApproved = true;
dbModel.IsDisplay = true;
if (string.IsNullOrEmpty(model.Month))
{
dbModel.Month = model.MonthFilter;
}
else
{
dbModel.Month = model.Month;
}
if (string.IsNullOrEmpty(model.Year))
{
dbModel.Year = model.YearFilter;
}
else
{
dbModel.Year = model.Year;
}
dbModel.NominationID = dbNomModel.NominationId;
dbModel.Description = dbNomModel.Idea;
dbModel.ApprovedBy = int.Parse(loggedInuserID);
dbModel.CreatedBy = int.Parse(loggedInuserID);
//dbModel.CreatedDate = toISTDate(DateTime.Now);
dbModel.ModifiedBy = int.Parse(loggedInuserID);
// dbModel.ModifiedDate = toISTDate(DateTime.Now);
objSOMEntities.StarOfTheMonths.Add(dbModel);
objSOMEntities.SaveChanges();
baseModel = new RepositoryResponse {
success = true, message = "Star of Month Declared Successfully", Data = ""
};
}
else
{
nomID = dbModel.NominationID;
//dbModel.EmpId = int.Parse(model.EmpId);
//dbModel.IsApproved = true;
//dbModel.IsDisplay = true;
//dbModel.Description = model.Description;
dbModel.Month = model.MonthFilter;
dbModel.Year = model.YearFilter;
//dbModel.NominationID = model.NominationID;
dbModel.CreatedBy = int.Parse(loggedInuserID);
//dbModel.CreatedDate = DateTime.UtcNow;
dbModel.ModifiedBy = int.Parse(loggedInuserID);
//dbModel.ModifiedDate = DateTime.UtcNow;
objSOMEntities.SaveChanges();
baseModel = new RepositoryResponse {
success = true, message = "Star of Month Declared updated Successfully", Data = ""
};
}
if (dbNomModel != null)
{
dbNomModel.SOMComments = model.SOMComments;
dbNomModel.SOMSubmittedDate = DateTime.Now.ToString("ddMMyyyy");
dbNomModel.SOMSignature = loggedInuserID;
dbNomModel.Status = (int)NominationStatus.TQC_Declare_SOM;
dbNomModel.ModifiedBy = loggedInuserID;
objSOMEntities.SaveChanges();
}
Evaluation evalDbModel = objSOMEntities.Evaluations.Where(r => r.NominationID == nomID && r.EvaluatorID != "").FirstOrDefault();
long HODId = _nominationRepo.GetReportingIDByEmpID(dbNomModel.EmployeeNumber);
AuditLogModel objAuditLog = new AuditLogModel();
objAuditLog.CurrentStatus = NominationStatus.TQC_Declare_SOM;
objAuditLog.EmployeeNumber = dbNomModel.EmployeeNumber;
objAuditLog.IsNewAlert = true;
objAuditLog.IsNotification = true;
objAuditLog.DepartmentHeadID = HODId.ToString();
objAuditLog.TQCHeadID = loggedInuserID;
objAuditLog.EvaluatorID = evalDbModel.EvaluatorID;
objAuditLog.NominationID = nomID;
objAuditLog.CreatedBy = loggedInuserID;
_nominationRepo.AddEntryIntoAuditLog(objAuditLog);
}
//if (string.IsNullOrEmpty(IPValue) && IPValue == "true")
//{
// AddOrEditStarOfMonth_IntranetPortal(model, loggedInuserID);
//}
}
catch (Exception ex)
{
baseModel = new RepositoryResponse {
success = false, message = ex.ToString()
};
}
return(baseModel);
}
public RepositoryResponse AddOrEditStarOfMonth_IntranetPortal(StarOfMonthModel model, string loggedInuserID)
{
_nominationRepo = new NominationRepo();
baseModel = new RepositoryResponse();
try
{
string nomID = string.Empty;
Nomination dbNomModel = new Nomination();
using (objSOMEntities = new SOMEntities())
using (objIPEntities = new IntranetPortalEntities())
{
var dbModel = objIPEntities.StarOfTheMonths.Where(r => r.TransID == model.TransID).FirstOrDefault();
if (string.IsNullOrEmpty(model.SelectedNominationID))
{
dbNomModel = objSOMEntities.Nominations.Where(r => r.NominationId == dbModel.NominationID).FirstOrDefault();
}
else
{
dbNomModel = objSOMEntities.Nominations.Where(r => r.NominationId == model.SelectedNominationID.Replace("\r\n", "")).FirstOrDefault();
}
if (dbModel == null)
{
nomID = dbNomModel.NominationId;
dbModel = new StarOfTheMonth.DataBase.StarOfTheMonth();
dbModel.EmpId = int.Parse(dbNomModel.EmployeeNumber);
dbModel.IsApproved = true;
dbModel.IsDisplay = true;
if (string.IsNullOrEmpty(model.Month))
{
dbModel.Month = model.MonthFilter;
}
else
{
dbModel.Month = model.Month;
}
if (string.IsNullOrEmpty(model.Year))
{
dbModel.Year = model.YearFilter;
}
else
{
dbModel.Year = model.Year;
}
dbModel.NominationID = dbNomModel.NominationId;
dbModel.Description = dbNomModel.Idea;
dbModel.CreatedBy = int.Parse(loggedInuserID);
dbModel.ModifiedBy = int.Parse(loggedInuserID);
objIPEntities.StarOfTheMonths.Add(dbModel);
objIPEntities.SaveChanges();
baseModel = new RepositoryResponse {
success = true, message = "Star of Month Details Added Successfully", Data = ""
};
}
else
{
nomID = dbModel.NominationID;
dbModel.Month = model.MonthFilter;
dbModel.Year = model.YearFilter;
dbModel.CreatedBy = int.Parse(loggedInuserID);
dbModel.ModifiedBy = int.Parse(loggedInuserID);
objIPEntities.SaveChanges();
baseModel = new RepositoryResponse {
success = true, message = "Star of Month Details updated Successfully", Data = ""
};
}
}
}
catch (Exception ex)
{
baseModel = new RepositoryResponse {
success = false, message = ex.ToString()
};
}
return(baseModel);
}
