/// <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);
}
