/// <summary> /// Save Company Record and upload and save image /// </summary> public string Save(string userUuid, CompanyDom company, out int comapanyDetailsId) { using (itjob_mainEntities db = new itjob_mainEntities()) { tbl_user_company_details tblModel = new tbl_user_company_details() { id = 0, company_logo_Id = company.CompanyLogoId == null ? 0 : company.CompanyLogoId, company_name = company.CompanyName, company_web_link = company.WebLink, trust_id = (int)TrustEnum.NotDeside, user_id = userUuid, added_by = userUuid, updated_by = userUuid, added_date = DateTime.Now, updated_date = DateTime.Now, is_active = true, contact_number = company.ContactNo, }; db.tbl_user_company_details.Add(tblModel); try { db.SaveChanges(); comapanyDetailsId = tblModel.id; return(null); } catch (Exception ex) { comapanyDetailsId = 0; return(ex.Message.ToString()); } } }
/// <summary> ///Save document /// </summary> public long[] SaveDocument(List <Document> doc, string userId, out string error) { using (itjob_mainEntities db = new itjob_mainEntities()) { List <tbl_document> document = new List <tbl_document>(); document = doc.Select(d => new tbl_document { id = Convert.ToInt32(d.DocumentId), path = d.virtualPath, ResolutionType = d.ResolutionType, added_by = userId, updated_by = userId, added_date = DateTime.Now, updated_date = DateTime.Now, is_active = true, }).ToList(); db.tbl_document.AddRange(document); try { db.SaveChanges(); error = null; return(document.Select(d => (long)d.id).ToArray()); } catch (Exception ex) { error = ex.Message.ToString(); return(null); } } }
/// <summary> /// Update job /// </summary> /// <returns></returns> public string Update(JobMain job, string userUuid) { using (itjob_mainEntities db = new itjob_mainEntities()) { var dbobj = db.tbl_job_main.Where(d => d.id == job.JobMainId).FirstOrDefault(); if (dbobj == null) { return("Table is empty"); } dbobj.job_type_id = (int)job.JobTypes; dbobj.category_id = job.CategoryId; dbobj.title = job.Title; dbobj.description = job.Description; dbobj.cv_accept_email_id = job.CvAcceptEmailId; dbobj.close_date = job.CloseDate; dbobj.open_date = job.OpenDate; dbobj.number_of_vacancy = job.NumberOfVacancy; dbobj.updated_by = userUuid; dbobj.updated_date = DateTime.Now; db.Entry(dbobj).State = EntityState.Modified; try { db.SaveChanges(); return(null); } catch (Exception ex) { return(ex.Message.ToString()); } } }
/// <summary> /// company Details Add Domain Model /// </summary> /// <param name="found"></param> /// <param name="db"></param> /// <returns></returns> public List <JobMain> MakeComDetails(IQueryable found, itjob_mainEntities db) { var result = (from tbl_job_main uc in found from pt in db.tbl_company_has_accept_email.Where(x => x.id == uc.cv_accept_email_id).DefaultIfEmpty() from ca in db.tbl_category.Where(x => x.id == uc.category_id).DefaultIfEmpty() select new JobMain { JobMainId = uc.id, JobTypeId = uc.job_type_id, CategoryId = uc.category_id, Category = ca.category, CloseDate = uc.close_date, OpenDate = uc.open_date, CvAcceptEmailId = uc.cv_accept_email_id, CvAcceptEmail = pt.accept_email, Description = uc.description, NumberOfVacancy = uc.number_of_vacancy, Title = uc.title, AddedBy = uc.added_by, UpdatedBy = uc.updated_by, AddedDate = uc.added_date, UpdatedDate = uc.updated_date, IsActive = uc.is_active, JobTypes = (JobType)uc.job_type_id, WebApproval = uc.web_approval, WebApprovaltype = (Approval)uc.web_approval, }).ToList(); return(result); }
/// <summary> /// Update Company Details /// </summary> /// <returns></returns> public string Update(string userUuid, CompanyDom company) { using (itjob_mainEntities db = new itjob_mainEntities()) { var dbobj = db.tbl_user_company_details.Where(d => d.id == company.CompanyDetailsId).FirstOrDefault(); if (dbobj == null) { return("Table is empty"); } dbobj.company_logo_Id = company.CompanyLogoId == null?0: company.CompanyLogoId; dbobj.company_name = company.CompanyName; dbobj.company_web_link = company.WebLink; dbobj.updated_by = userUuid; dbobj.contact_number = company.ContactNo; dbobj.updated_date = DateTime.Now; db.Entry(dbobj).State = EntityState.Modified; try { db.SaveChanges(); return(null); } catch (Exception ex) { return(ex.Message.ToString()); } } }
/// <summary> /// Save Email /// </summary> /// <returns></returns> public string EditEmail(AcceptEmail email, string userUuid) { using (itjob_mainEntities db = new itjob_mainEntities()) { var dbobj = db.tbl_company_has_accept_email.Where(d => d.id == email.AcceptEmailId).FirstOrDefault(); if (dbobj == null) { return("Table is empty"); } dbobj.company_id = email.CompanyId; dbobj.accept_email = email.EmailAddress; dbobj.update_by = userUuid; dbobj.system_comment = "Update"; dbobj.update_date = DateTime.Now; db.Entry(dbobj).State = EntityState.Modified; try { db.SaveChanges(); return(null); } catch (Exception ex) { return(ex.Message.ToString()); } } }
/// <summary> /// Save GlobleNote /// </summary> /// <returns></returns> public string SaveGlobleNote(List <GlobleNote> globleNote, string userUuid) { using (itjob_mainEntities db = new itjob_mainEntities()) { List <tbl_globle_note> globleNotes = new List <tbl_globle_note>(); globleNotes = globleNote.Select(d => new tbl_globle_note { id = d.GlobleNoteId, section_id = d.SectionId, related_id = d.ParentId, document_id = d.DocumentId, added_by = userUuid, updated_by = userUuid, added_date = DateTime.Now, updated_date = DateTime.Now, is_Active = true, }).ToList(); db.tbl_globle_note.AddRange(globleNotes); try { db.SaveChanges(); return(null); } catch (Exception ex) { return(ex.Message.ToString()); } } }
/// <summary> /// Save Email /// </summary> /// <returns></returns> public string SaveEmail(AcceptEmail email, string userUuid, out long emailId) { using (itjob_mainEntities db = new itjob_mainEntities()) { tbl_company_has_accept_email tblModel = new tbl_company_has_accept_email() { id = 0, company_id = email.CompanyId, accept_email = email.EmailAddress, system_comment = "Save", added_by = userUuid, update_by = userUuid, added_date = DateTime.Now, update_date = DateTime.Now, is_active = true, }; db.tbl_company_has_accept_email.Add(tblModel); try { db.SaveChanges(); emailId = tblModel.id; return(null); } catch (Exception ex) { emailId = 0; return(ex.Message.ToString()); } } }
public string SavejobhasTag(long[] TagIds, long jobId, string userId) { using (itjob_mainEntities db = new itjob_mainEntities()) { var dbModel = TagIds.Select(d => new tbl_tag_has_Job { tagId = d, jobmainId = jobId, added_by = userId.ToString(), added_date = DateTime.Now, is_active = true, }); db.tbl_tag_has_Job.AddRange(dbModel); try { db.SaveChanges(); return(null); } catch (Exception ex) { return(ex.Message.ToString()); } } }
/// <summary> /// Delete Tag /// </summary> /// <param name="jobId"></param> /// <returns></returns> public string DeleteTag(long jobId) { using (itjob_mainEntities db = new itjob_mainEntities()) { var found = db.tbl_tag_has_Job.Where(d => d.jobmainId == jobId).ToList(); if (found.Count() == 0) { return(null); } long[] tagIdArray = found.Select(k => k.tagId).ToArray(); db.tbl_tag_has_Job.RemoveRange(found); try { db.SaveChanges(); } catch (Exception ex) { return(ex.Message.ToString()); } var foundTag = db.tbl_tag.Where(d => tagIdArray.Contains(d.TagId)).ToList(); db.tbl_tag.RemoveRange(foundTag); try { db.SaveChanges(); return(null); } catch (Exception ex) { return(ex.Message.ToString()); } } }
/// <summary> /// save Tag /// </summary> /// <param name="tagName"></param> /// <param name="jobId"></param> /// <returns></returns> public string SaveTag(string[] tagName, long jobId, string userId, out long[] TagIds) { using (itjob_mainEntities db = new itjob_mainEntities()) { var dbModel = tagName.Select(d => new tbl_tag { TagId = 0, TagName = d.ToString(), added_by = userId.ToString(), added_date = DateTime.Now, is_active = true, }).ToList(); db.tbl_tag.AddRange(dbModel); try { db.SaveChanges(); TagIds = dbModel.Select(d => d.TagId).ToArray(); return(null); } catch (Exception ex) { TagIds = null; return(ex.Message.ToString()); } } }
/// <summary> /// Save company Has Job /// </summary> /// <returns></returns> public string Save(CompanyHasJob job, string userUuid) { using (itjob_mainEntities db = new itjob_mainEntities()) { tbl_company_has_job tblModel = new tbl_company_has_job() { id = 0, company_id = job.CompanyId, job_main_id = job.JobMainId, added_by = userUuid, update_by = userUuid, added_date = DateTime.Now, update_date = DateTime.Now, is_active = true, }; db.tbl_company_has_job.Add(tblModel); try { db.SaveChanges(); return(null); } catch (Exception ex) { return(ex.Message.ToString()); } } }
//-------------------------Drop Down--------------------------- /// <summary> /// Get drop down /// </summary> /// <returns></returns> public List <NewSelectList> DropDown(long CompanyId) { using (itjob_mainEntities db = new itjob_mainEntities()) { var result = (from tbl_company_has_accept_email c in db.tbl_company_has_accept_email.Where(d => d.is_active == true && d.company_id == CompanyId) select new NewSelectList { Id = c.id, value = c.accept_email, }).ToList(); return(result); } }
//-------------------------------dropdown-------------------- /// <summary> /// Dropdown /// </summary> /// <returns></returns> public List <NewSelectList> DropDown() { using (itjob_mainEntities db = new itjob_mainEntities()) { var result = (from tbl_category c in db.tbl_category.Where(d => d.is_active == true) select new NewSelectList { Id = c.id, value = c.category, }).ToList(); return(result); } }
/// <summary> /// Get All Category /// </summary> /// <returns></returns> public List <CategoryDom> GetAllCategory() { using (itjob_mainEntities db = new itjob_mainEntities()) { IQueryable found = db.tbl_category; if (found != null) { return(MakeComDetails(found, db)); } else { return(null); } } }
/// <summary> /// Get Single Email /// </summary> /// <returns></returns> public AcceptEmail GetSingleEmail(long emailId) { using (itjob_mainEntities db = new itjob_mainEntities()) { IQueryable found = db.tbl_company_has_accept_email.Where(d => d.id == emailId); if (found != null) { return(MakeComDetails(found, db).FirstOrDefault()); } else { return(null); } } }
/// <summary> /// Get All Email /// </summary> /// <returns></returns> public List <AcceptEmail> GetEmail(long CompanyId) { using (itjob_mainEntities db = new itjob_mainEntities()) { IQueryable found = db.tbl_company_has_accept_email; if (found != null) { return(MakeComDetails(found, db)); } else { return(null); } } }
/// <summary> /// Get Job using job id /// </summary> /// <param name="JobId"></param> /// <returns></returns> public JobMain GetJob(long JobId) { using (itjob_mainEntities db = new itjob_mainEntities()) { IQueryable found = db.tbl_job_main.Where(d => d.id == JobId); if (found != null) { return(MakeComDetails(found, db).FirstOrDefault()); } else { return(null); } } }
/// <summary> /// Get All Job /// </summary> /// <param name="JobId"></param> /// <returns></returns> public List <JobMain> GetAllJob(DateTime startTime, long skipCount) { using (itjob_mainEntities db = new itjob_mainEntities()) { var found = db.tbl_job_main.Where(d => d.web_approval == (int)Approval.approved && d.is_active == true && d.open_date <= startTime && d.close_date >= startTime).OrderBy(d => d.id).Skip(Convert.ToInt32(skipCount)).Take(6).ToList(); if (found != null && found.Count() > 0) { return(MakeComDetails(found.Select(d => d.id).ToArray(), db)); } else { return(null); } } }
/// <summary> /// Get Company /// </summary> /// <param name="jobId"></param> /// <returns></returns> public long GetCompanyId(long jobId) { using (itjob_mainEntities db = new itjob_mainEntities()) { IQueryable found = db.tbl_company_has_job.Where(d => d.job_main_id == jobId); if (found != null) { return(MakeComDetails(found, db).FirstOrDefault().CompanyId); } else { return(0); } } }
/// <summary> /// Get Tag /// </summary> /// <param name="jobId"></param> /// <returns></returns> public List <Tag> GetTags(long jobId) { using (itjob_mainEntities db = new itjob_mainEntities()) { IQueryable tags = db.tbl_tag_has_Job.Where(d => d.jobmainId == jobId); if (tags != null) { return(MakeComDetails(tags, db)); } else { return(null); } } }
public List <CategoryDom> MakeComDetails(IQueryable found, itjob_mainEntities db) { var result = (from tbl_category uc in found select new CategoryDom { Id = uc.id, Category = uc.category, AddedBy = uc.added_by, UpdatedBy = uc.update_by, AddedDate = uc.added_date, UpdatedDate = uc.update_date, IsActive = uc.is_active, }).ToList(); return(result); }
/// <summary> /// Get Document using Parent Id /// </summary> /// <param name="parentId"></param> /// <returns></returns> public List <Document> GetDocument(long parentId) { using (itjob_mainEntities db = new itjob_mainEntities()) { IQueryable found = db.tbl_globle_note.Where(d => d.related_id == parentId); if (found != null) { return(MakeComDetails(found, db)); } else { return(null); } } }
/// <summary> /// Get All Job /// </summary> /// <param name="JobId"></param> /// <returns></returns> public List <JobMain> GetAllJob() { using (itjob_mainEntities db = new itjob_mainEntities()) { IQueryable found = db.tbl_job_main.Where(d => d.web_approval == (int)Approval.approved); if (found != null) { return(MakeComDetails(found, db)); } else { return(null); } } }
/// <summary> /// Retrive GlobleNote /// </summary> /// <returns></returns> public List <GlobleNote> RetriveGlobleNote(int sectionId, long parentId) { using (itjob_mainEntities db = new itjob_mainEntities()) { IQueryable found = db.tbl_globle_note.Where(d => d.section_id == sectionId && d.related_id == parentId); if (found != null) { return(MakeGlobleNote(found, db)); } else { return(null); } } }
/// <summary> /// Get Company Details by Company Id /// </summary> /// <param name="userUuid"></param> /// <returns></returns> public CompanyDom GetCompanyDetailsByCompanyId(long companyId) { using (itjob_mainEntities db = new itjob_mainEntities()) { IQueryable company = db.tbl_user_company_details.Where(d => d.id == companyId); if (company != null) { return(MakeComDetails(company, db).FirstOrDefault()); } else { return(null); } } }
/// <summary> /// Get Job using job id /// </summary> /// <param name="JobId"></param> /// <returns></returns> public List <JobMain> GetJobbyCompanyId(long [] jobIds, Approval aproval) { using (itjob_mainEntities db = new itjob_mainEntities()) { IQueryable found = db.tbl_job_main.Where(d => jobIds.Contains(d.id) && d.web_approval == (int)aproval); if (found != null) { return(MakeComDetails(found, db)); } else { return(null); } } }
/// <summary> /// Get ComapnyHasJob /// </summary> /// <param name="companyId"></param> /// <returns></returns> public long[] GetComapnyHasJob(long companyId) { using (itjob_mainEntities db = new itjob_mainEntities()) { IQueryable found = db.tbl_company_has_job.Where(d => d.company_id == companyId); if (found != null) { return(MakeComDetails(found, db).Select(d => d.JobMainId).ToArray()); } else { return(null); } } }
/// <summary> /// company Details Add Domain Model /// </summary> /// <param name="found"></param> /// <param name="db"></param> /// <returns></returns> public List <CompanyHasJob> MakeComDetails(IQueryable found, itjob_mainEntities db) { var result = (from tbl_company_has_job uc in found select new CompanyHasJob { CompanyHasJobId = uc.id, CompanyId = uc.company_id, JobMainId = uc.job_main_id, AddedBy = uc.added_by, UpdatedBy = uc.update_by, AddedDate = uc.added_date, UpdatedDate = uc.update_date, IsActive = uc.is_active, }).ToList(); return(result); }
/// <summary> /// company Details Add Domain Model /// </summary> /// <param name="found"></param> /// <param name="db"></param> /// <returns></returns> public List <Tag> MakeComDetails(IQueryable found, itjob_mainEntities db) { var result = (from tbl_tag_has_Job thj in found from t in db.tbl_tag.Where(x => x.TagId == thj.tagId).DefaultIfEmpty() select new Tag { TagId = t.TagId, TagName = t.TagName, AddedBy = t.added_by, UpdatedBy = t.updated_by, AddedDate = t.added_date, UpdatedDate = t.updated_date, IsActive = t.is_active }).ToList(); return(result); }