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 AddorUpdateEvaluationData(EvaluationModel model, string _loggedInUserID, bool isSubmit) { baseModel = new RepositoryResponse(); try { using (objSOMEntities = new SOMEntities()) { Evaluation db = objSOMEntities.Evaluations.Where(r => r.ID == model.ID).FirstOrDefault(); if (db == null) { objSOMEntities.Evaluations.Add(ConvertEvaluation_Model2DB(model, _loggedInUserID, isSubmit)); objSOMEntities.SaveChanges(); if (isSubmit) { baseModel = new RepositoryResponse { success = true, message = "Evaluations Scroe Details Submitted to TQC Successfully" }; } else { baseModel = new RepositoryResponse { success = true, message = "Evaluations Scroe Details added Successfully" }; } } else { db.TotalScore = int.Parse(model.TotalScore); db.AheadOfPlan = model.AheadOfPlan; db.AsPerPlan = model.AsPerPlan; db.BasedOnInstruction = model.BasedOnInstruction; db.BreakthroughImprovement = model.BreakthroughImprovement; db.CoordiantionWithInTheDept = model.CoordiantionWithInTheDept; db.CoordinationWithAnotherFunction = model.CoordinationWithAnotherFunction; db.CoordinationWithMultipleFunctions = model.CoordinationWithMultipleFunctions; db.Delayed = model.Delayed; //db.EmployeeID = model.EmployeeID; db.NominationID = model.NominationID; //db.EvaluatorID = model.EvaluatorID; db.FollowedUp = model.FollowedUp; //db.ID = model.ID; db.Implemented = model.Implemented; db.ImplementedInAllApplicableAreas = model.ImplementedInAllApplicableAreas; db.ImplementedPartially = model.ImplementedPartially; db.ImprovementFromCurrentSituation = model.ImprovementFromCurrentSituation; db.IsActive = true; db.Participated = model.Participated; db.PreventionOfaFailure = model.PreventionOfaFailure; db.ProactiveIdeaGeneratedBySelf = model.ProactiveIdeaGeneratedBySelf; db.ReactiveIdeaDrivenBySituation = model.ReactiveIdeaDrivenBySituation; db.ScopeIdentified = model.ScopeIdentified; if (isSubmit) { db.Status = (int)NominationStatus.Evaluators_Assign_TQC; } else { db.Status = (int)NominationStatus.Evaluators_Save; } db.ModifiedBy = _loggedInUserID; objSOMEntities.SaveChanges(); if (isSubmit) { configRepo = new ConfigurationRepo(); bool result = configRepo.SendEmailUsingSOM_Evaluator_Assign_TQC(db.NominationID, _loggedInUserID); if (result) { baseModel = new RepositoryResponse { success = true, message = "Evaluations Scroe Details Submitted to TQC Successfully and Send Mail to TQC" }; } else { baseModel = new RepositoryResponse { success = true, message = "Evaluations Scroe Details Submitted to TQC Successfully. Unable to Send Mail to TQC" }; } } else { baseModel = new RepositoryResponse { success = true, message = "Evaluations Scroe Details updated Successfully" }; } } } using (objSOMEntities = new SOMEntities()) { if (isSubmit) { var nomDet = objSOMEntities.Nominations.Where(r => r.NominationId == model.NominationID).FirstOrDefault(); nomDet.Status = (int)NominationStatus.Evaluators_Assign_TQC; nomDet.ModifiedBy = _loggedInUserID; objSOMEntities.SaveChanges(); } } if (isSubmit) { nomRepo = new NominationRepo(); //Add entry into Audit Log AuditLogModel objAuditLog = new AuditLogModel(); objAuditLog.CurrentStatus = NominationStatus.Evaluators_Assign_TQC; objAuditLog.EmployeeNumber = model.EmployeeNumber; objAuditLog.IsNewAlert = true; objAuditLog.IsNotification = true; objAuditLog.NominationID = model.NominationID; objAuditLog.CreatedBy = _loggedInUserID; objAuditLog.EvaluatorID = _loggedInUserID; nomRepo.AddEntryIntoAuditLog(objAuditLog); Nomination _nomModel; using (objSOMEntities = new SOMEntities()) { _nomModel = objSOMEntities.Nominations.Where(r => r.NominationId == model.NominationID).FirstOrDefault(); } // Add entry into SOM StarOfMonthModel SOMmodel = new StarOfMonthModel(); SOMmodel.Month = _nomModel.SubmittedMonth; SOMmodel.Year = _nomModel.SubmittedYear; SOMmodel.Description = _nomModel.Idea; SOMmodel.EmpId = model.EmployeeNumber; SOMmodel.NominationID = model.NominationID; SOMmodel.IsDisplay = true; SOMmodel.IsApproved = true; SOMmodel.ApprovedBy = int.Parse(_loggedInUserID); SOMmodel.CreatedBy = int.Parse(_loggedInUserID); SOMmodel.CreatedDate = DateTime.Now; SOMmodel.ModifiedBy = int.Parse(_loggedInUserID); SOMmodel.ModifiedDate = DateTime.Now; starRepo = new StarOfMonthRepo(); //starRepo.AddOrEditStarOfMonth(SOMmodel, _loggedInUserID); } if (isSubmit) //Send Nomination Submit Details to DH { using (objSOMEntities = new SOMEntities()) { } } } catch (Exception ex) { baseModel = new RepositoryResponse { success = false, message = ex.ToString() }; } return(baseModel); }