/// <summary> /// Used for Save Additional Credentials details in mapping from JCR /// </summary> /// <param name="addReqId"></param> /// <param name="objLicenseInsuranceRequestParam"></param> /// <param name="icTypeId"></param> /// <createdby>bobi</createdby> /// <createddate>3 june 2014</createddate> private void SaveAdditionalReqToMappingFromJCR(int addReqId, LicenseInsuranceRequestParam objLicenseInsuranceRequestParam, string icTypeId) { FilterRequestParam objFilterRequestParam = null; try { objFilterRequestParam = new FilterRequestParam(); objFilterRequestParam.CompanyId = objLicenseInsuranceRequestParam.CompanyId; objFilterRequestParam.vendortypefilter = icTypeId; //get IC list of company objFilterRequestParam.type = 1; IEnumerable <ICResponseParam> IClist = GetICdetailforLicIns(objFilterRequestParam); using (objDecisionPointEntities = new DecisionPointEntities()) { foreach (var IC in IClist) { var addReqMappingDetails = (from docrec in objDecisionPointEntities.DP_AdditionalReqMapping where docrec.AddReqId == addReqId && docrec.UserId == IC.Id && docrec.CompanyId == IC.CompanyId select docrec).FirstOrDefault(); if (addReqMappingDetails == null) { DP_AdditionalReqMapping objDPAdditionalReqMapping = new DP_AdditionalReqMapping() { AddReqId = addReqId, CompanyId = IC.CompanyId, UserId = IC.Id, Status = Shared.Pending }; objDecisionPointEntities.DP_AdditionalReqMapping.Add(objDPAdditionalReqMapping); } else { addReqMappingDetails.AddReqId = addReqId; addReqMappingDetails.CompanyId = IC.CompanyId; addReqMappingDetails.UserId = IC.Id; } } objDecisionPointEntities.SaveChanges(); } } catch { throw; } }
/// <summary> /// Used for Save Additional Credentials details in mapping from profile page /// </summary> /// <param name="addReqId"></param> /// <param name="objLicenseInsuranceRequestParam"></param> /// <param name="icTypeId"></param> /// <createdby>bobi</createdby> /// <createddate>3 june 2014</createddate> private void SaveAdditionalReqToMappingFromProfile(int addReqId, LicenseInsuranceRequestParam objLicenseInsuranceRequestParam, string icTypeId) { try { using (objDecisionPointEntities = new DecisionPointEntities()) { var addReqMappingDetails = (from docrec in objDecisionPointEntities.DP_AdditionalReqMapping where docrec.AddReqId == addReqId && docrec.UserId == objLicenseInsuranceRequestParam.UserId && docrec.CompanyId == objLicenseInsuranceRequestParam.CompanyId select docrec).FirstOrDefault(); if (addReqMappingDetails == null) { DP_AdditionalReqMapping objDPAdditionalReqMapping = new DP_AdditionalReqMapping() { AddReqId = addReqId, CompanyId = objLicenseInsuranceRequestParam.CompanyId, UserId = objLicenseInsuranceRequestParam.UserId, Status = Shared.InProgress }; if (object.Equals(objLicenseInsuranceRequestParam.CompletedDate, null)) { objDPAdditionalReqMapping.CompletionDate = currentdate; } objDecisionPointEntities.DP_AdditionalReqMapping.Add(objDPAdditionalReqMapping); } else { addReqMappingDetails.AddReqId = addReqId; addReqMappingDetails.CompanyId = objLicenseInsuranceRequestParam.CompanyId; addReqMappingDetails.UserId = objLicenseInsuranceRequestParam.UserId; addReqMappingDetails.Status = Shared.InProgress; if (object.Equals(objLicenseInsuranceRequestParam.CompletedDate, null)) { addReqMappingDetails.CompletionDate = currentdate; } } objDecisionPointEntities.SaveChanges(); } } catch { throw; } }
/// <summary> /// Usd for Save Additiona Credentials from JCR /// </summary> /// <param name="objLicInsRequestParam"></param> /// <returns>int</returns> /// <CreatedBy>Bobi</CreatedBy> /// <CreatedDate>19 May 2015</CreatedDate> public int SaveAdditionalReqFromJCR(LicenseInsuranceRequestParam objLicInsRequestParam) { int addReqId = 0; try { foreach (var client in objLicInsRequestParam.ClientIds) { foreach (var icType in objLicInsRequestParam.ICTypeIds) { using (objDecisionPointEntities = new DecisionPointEntities()) { userId = Convert.ToInt32(client.Split(char.Parse(Shared.Colon))[0], CultureInfo.InvariantCulture); companyId = client.Split(char.Parse(Shared.Colon))[1]; icTypeId = Convert.ToInt32(icType, CultureInfo.InvariantCulture); var chkAddAkDetails = (from reqdoc in objDecisionPointEntities.DP_AdditionalReqMaster where reqdoc.CreatorCompanyId == objLicInsRequestParam.CompanyId && reqdoc.UserId == userId && reqdoc.CompanyId == companyId && reqdoc.ICTypeId == icTypeId select reqdoc).FirstOrDefault(); if (chkAddAkDetails != null) { chkAddAkDetails.ICTypeId = Convert.ToInt32(icType, CultureInfo.InvariantCulture); chkAddAkDetails.IsStaffTitle = objLicInsRequestParam.IsStaffTitle; chkAddAkDetails.UserId = Convert.ToInt32(client.Split(char.Parse(Shared.Colon))[0], CultureInfo.InvariantCulture); chkAddAkDetails.CompanyId = client.Split(char.Parse(Shared.Colon))[1]; chkAddAkDetails.CreatorCompanyId = objLicInsRequestParam.CompanyId; chkAddAkDetails.CreatedBy = objLicInsRequestParam.UserId; chkAddAkDetails.CreatedDate = currentdate; chkAddAkDetails.IsActive = true; chkAddAkDetails.IsDeleted = false; chkAddAkDetails.Review = objLicInsRequestParam.Review; chkAddAkDetails.Title = objLicInsRequestParam.Title; chkAddAkDetails.UploadedBy = objLicInsRequestParam.UploadedBy; chkAddAkDetails.ExpirationDate = objLicInsRequestParam.ExpirationDate; addReqId = chkAddAkDetails.Id; //delete ack details as per req doc Id var resack = (from reqdocack in objDecisionPointEntities.DP_AdditionalReqAck where reqdocack.AddReqId == chkAddAkDetails.Id select reqdocack).ToList(); foreach (var item in resack) { objDecisionPointEntities.DP_AdditionalReqAck.Remove(item); } //remove uploaded documents by child user[Who received the JCR] var insUploadDocs = (from profLicUploadDoc in objDecisionPointEntities.DP_AdditionalReqUploadDocs where profLicUploadDoc.AddReqMapId == objLicInsRequestParam.LicInsMapId select profLicUploadDoc).ToList(); if (!object.Equals(insUploadDocs, null)) { foreach (var item in insUploadDocs) { objDecisionPointEntities.DP_AdditionalReqUploadDocs.Remove(item); } } } else { //Insert req doc details for sender in database DP_AdditionalReqMaster objDPAdditionalReqMaster = new DP_AdditionalReqMaster() { ICTypeId = Convert.ToInt32(icType, CultureInfo.InvariantCulture), IsStaffTitle = objLicInsRequestParam.IsStaffTitle, UserId = Convert.ToInt32(client.Split(char.Parse(Shared.Colon))[0], CultureInfo.InvariantCulture), CompanyId = client.Split(char.Parse(Shared.Colon))[1], CreatorCompanyId = objLicInsRequestParam.CompanyId, CreatedBy = objLicInsRequestParam.UserId, CreatedDate = currentdate, IsActive = true, IsDeleted = false, Review = objLicInsRequestParam.Review, Title = objLicInsRequestParam.Title, UploadedBy = objLicInsRequestParam.UploadedBy, ExpirationDate = objLicInsRequestParam.ExpirationDate }; objDecisionPointEntities.DP_AdditionalReqMaster.Add(objDPAdditionalReqMaster); objDecisionPointEntities.SaveChanges(); addReqId = objDPAdditionalReqMaster.Id; } #region DocUpload and Remove List <string> DocLoclist = new List <string>(); if (!string.IsNullOrEmpty(objLicInsRequestParam.UploadedDoc)) { DocLoclist = objLicInsRequestParam.UploadedDoc.Split(';').ToList(); } foreach (var item in DocLoclist) { if (!string.IsNullOrEmpty(item)) { string[] str = item.Split(char.Parse(Shared.Hash)); var DocLocation = str[0]; int docSequence = Convert.ToInt32(str[1]); DP_AdditionalReqUploadDocs objDP_AdditionalReqUploadDocs = new DP_AdditionalReqUploadDocs() { AddReqMapId = objLicInsRequestParam.LicInsMapId, DocLoc = DocLocation, DocSeqNo = docSequence, UserId = objLicInsRequestParam.UserId, CompanyId = objLicInsRequestParam.CompanyId, AddReqId = addReqId }; objDecisionPointEntities.DP_AdditionalReqUploadDocs.Add(objDP_AdditionalReqUploadDocs); } } #endregion if (!object.Equals(objLicInsRequestParam.Acknowleagement, null)) { //Save Req doc Ack in database foreach (var item in objLicInsRequestParam.Acknowleagement) { DP_AdditionalReqAck objDPAdditionalReqAck = new DP_AdditionalReqAck() { AddReqId = addReqId, IsDeleted = false, Ackknow = item }; objDecisionPointEntities.DP_AdditionalReqAck.Add(objDPAdditionalReqAck); } } objDecisionPointEntities.SaveChanges(); } //Sent Professional License to Recipients SentAdditionalReqTorecipients(addReqId, objLicInsRequestParam, icType); } } } catch { throw; } return(addReqId); }