public ActionResult PrincipalNomineeDataEntry(List <ScmUploadedData> scmdata, HttpPostedFileBase SCMHardcopy, string Remarks) { List <ScmUploadedData> scmcheckeddata = scmdata.ToList(); int collegeId = 0; int SCMId = 0; if (scmcheckeddata.Count() != 0 && User.Identity.Name != null && SCMHardcopy != null) { collegeId = scmcheckeddata[0].CollegeId; var emailId = db.jntuh_registration.Where(e => e.Email == User.Identity.Name).Select(e => e.Email).FirstOrDefault(); int userId = db.jntuh_ffc_auditor.Where(e => e.isActive == true && e.auditorEmail1 == emailId && e.auditorDepartmentID == 60).Select(e => e.id).FirstOrDefault(); if (userId != 0) { var fileName = string.Empty; var filepath = string.Empty; var collegescmrequests = new jntuh_scmproceedingsrequests(); const string scmnotificationpath = "~/Content/Upload/SCMPROCEEDINGSREQUEST/UploadSCMHardCopy"; if (SCMHardcopy != null) { if (!Directory.Exists(Server.MapPath(scmnotificationpath))) { Directory.CreateDirectory(Server.MapPath(scmnotificationpath)); } var ext = Path.GetExtension(SCMHardcopy.FileName); if (ext != null) { var scmfileName = scmcheckeddata[0].CollegeId + "_" + "UploadSCMHardCopyForPrincipal" + "_" + DateTime.Now.ToString("yyyMMddHHmmss"); SCMHardcopy.SaveAs(string.Format("{0}/{1}{2}", Server.MapPath(scmnotificationpath), scmfileName, ext)); fileName = scmfileName + ext; } } foreach (var item in scmcheckeddata) { if (item != null) { jntuh_auditors_dataentry dataentry = new jntuh_auditors_dataentry(); dataentry.CollegeId = item.CollegeId; dataentry.SpecializationId = 0; dataentry.DepartmentId = 0; dataentry.DegreeId = 0; dataentry.DesignationId = 0; dataentry.RegistrationNo = item.RegistrationNumber; dataentry.AuditorId = userId; dataentry.IsSelected = item.Checked; dataentry.IsActive = true; dataentry.NomineeRemarks = Remarks; dataentry.CreatedBy = userId; dataentry.CreatedOn = DateTime.Now; dataentry.SCMhardcopy = fileName; dataentry.ScmProceedingId = item.SCMId; SCMId = item.SCMId; db.jntuh_auditors_dataentry.Add(dataentry); } } TempData["Success"] = "Information Saved Successfully"; db.SaveChanges(); var AuditorAssignedData = db.jntuh_auditor_assigned.Where(e => e.AuditorId == userId && e.ScmId == SCMId).Select(e => e).FirstOrDefault(); if (AuditorAssignedData != null) { AuditorAssignedData.RequestSubmittedDate = DateTime.Now; AuditorAssignedData.UpdatedBy = userId; AuditorAssignedData.UpdatedOn = DateTime.Now; db.Entry(AuditorAssignedData).State = EntityState.Modified; db.SaveChanges(); } // return RedirectToAction("PrincipalNomineeDataEntry", "User", new { collegeId = collegeId }); return(RedirectToAction("ApprovedFacultyBasedOnNominee", "Admin", new { SCMId = SCMId })); } } return(View()); }
public ActionResult Index(List <ScmUploadedData> scmdata, HttpPostedFileBase SCMHardcopy, int?DesignationId, string Remarks) { List <ScmUploadedData> scmcheckeddata = scmdata.ToList(); int collegeId = 0; int specializationId = 0; int SCMId = 0; if (scmcheckeddata.Count() != 0 && User.Identity.Name != null && SCMHardcopy != null) { List <int> SCMIds = new List <int>(); collegeId = scmcheckeddata[0].CollegeId; specializationId = scmcheckeddata[0].SpecializationId; // var emailId =db.jntuh_registration.Where(e => e.Email == User.Identity.Name).Select(e => e.Email).FirstOrDefault(); int userId = scmcheckeddata.GroupBy(e => e.AuditorId).Select(e => e.Key).FirstOrDefault(); var AuditorAssignSCMIds = scmcheckeddata.GroupBy(e => e.SCMId).Select(e => e.Key).ToArray(); SCMIds.AddRange(scmcheckeddata.GroupBy(e => e.SCMId).Select(e => e.Key).ToArray()); //db.jntuh_ffc_auditor.Where(e => e.isActive == true && e.auditorEmail1 == emailId).Select(e => e.id).FirstOrDefault(); // var AuditorsIds =db.jntuh_auditor_assigned.Where(e => e.ScmId == scmdata[0].SCMId).Select(e => e.AuditorId).Distinct().ToArray(); if (userId != 0) { string scmIds = ""; foreach (var ids in SCMIds) { if (!string.IsNullOrEmpty(scmIds)) { scmIds += "," + ids.ToString(); } else { scmIds = ids.ToString(); } } var fileName = string.Empty; var filepath = string.Empty; var collegescmrequests = new jntuh_scmproceedingsrequests(); const string scmnotificationpath = "~/Content/Upload/SCMPROCEEDINGSREQUEST/UploadSCMHardCopy"; if (SCMHardcopy != null) { if (!Directory.Exists(Server.MapPath(scmnotificationpath))) { Directory.CreateDirectory(Server.MapPath(scmnotificationpath)); } var ext = Path.GetExtension(SCMHardcopy.FileName); if (ext != null) { var scmfileName = scmcheckeddata[0].CollegeId + "_" + "UploadSCMHardCopy" + "_" + DateTime.Now.ToString("yyyMMddHHmmss"); SCMHardcopy.SaveAs(string.Format("{0}/{1}{2}", Server.MapPath(scmnotificationpath), scmfileName, ext)); fileName = scmfileName + ext; } } foreach (var item in scmcheckeddata) { if (item != null) { jntuh_auditors_dataentry dataentry = new jntuh_auditors_dataentry(); dataentry.CollegeId = item.CollegeId; dataentry.SpecializationId = item.SpecializationId; dataentry.DepartmentId = item.DepartmentId; dataentry.DegreeId = item.DegreeId; dataentry.DesignationId = (int)(DesignationId ?? 0); dataentry.RegistrationNo = item.RegistrationNumber; dataentry.AuditorId = userId; dataentry.IsSelected = item.Checked; dataentry.IsActive = true; dataentry.CreatedBy = userId; dataentry.NomineeRemarks = Remarks; dataentry.CreatedOn = DateTime.Now; dataentry.SCMhardcopy = fileName; dataentry.ScmProceedingId = item.SCMId; dataentry.DesignationId = item.DesignationId; SCMId = item.SCMId; db.jntuh_auditors_dataentry.Add(dataentry); } } db.SaveChanges(); var jntuh_auditor_assign = db.jntuh_auditor_assigned.AsNoTracking().ToList(); if (AuditorAssignSCMIds.Count() != 0) { foreach (var adata in AuditorAssignSCMIds) { var AuditoeAssigneddata = db.jntuh_auditor_assigned.Where(e => e.ScmId == adata && e.CollegeId == collegeId).ToList(); if (AuditoeAssigneddata.Count() != 0) { AuditoeAssigneddata.ForEach(e => { e.RequestSubmittedDate = DateTime.Now; e.UpdatedBy = userId; e.UpdatedOn = DateTime.Now; }); // var AuditorAssigndata = db.jntuh_auditor_assigned.Find(Aid); // AuditorAssigndata.RequestSubmittedDate = DateTime.Now; // AuditorAssigndata.UpdatedBy = userId; // AuditorAssigndata.UpdatedOn = DateTime.Now; //db.Entry(AuditorAssigndata).State=EntityState.Modified; db.SaveChanges(); } } } TempData["Success"] = "Information Saved Successfully"; // return RedirectToAction("Index", "User",new {collegeId = collegeId, specializationId = specializationId}); return(RedirectToAction("ApprovedFacultyBasedOnNominee", "Admin", new { SCMId = scmIds })); } } return(View()); }