/// <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>
/// 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>
/// 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 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>
/// 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());
}
}
}
/// <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 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 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());
}
}
}
/// <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());
}
}
}
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>
/// 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>
/// Delete GlobleNote
/// </summary>
/// <returns></returns>
public string DeleteGlobleNote(long[] globleNoteId)
{
using (itjob_mainEntities db = new itjob_mainEntities())
{
var found = db.tbl_globle_note.Where(d => globleNoteId.Contains(d.id)).ToList();
if (found.Count() == 0)
{
return("Cant Delete not found globleNote");
}
db.tbl_globle_note.RemoveRange(found);
try
{
db.SaveChanges();
return(null);
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
}
}
/// <summary>
/// Delete Email
/// </summary>
/// <returns></returns>
public string DeleteEmail(long emailId, string userUuid)
{
using (itjob_mainEntities db = new itjob_mainEntities())
{
var found = db.tbl_company_has_accept_email.Where(d => d.id == emailId).FirstOrDefault();
if (found == null)
{
return("Cant Delete not found Email");
}
db.tbl_company_has_accept_email.Remove(found);
try
{
db.SaveChanges();
return(null);
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
}
}
/// <summary>
/// Save job
/// </summary>
/// <returns></returns>
public string JobSave(JobMain job, string userUuid, out long jobId)
{
using (itjob_mainEntities db = new itjob_mainEntities())
{
tbl_job_main tblModel = new tbl_job_main()
{
id = 0,
job_type_id = (int)job.JobTypes,
category_id = job.CategoryId,
title = job.Title,
description = job.Description,
cv_accept_email_id = job.CvAcceptEmailId,
close_date = job.CloseDate,
open_date = job.OpenDate,
number_of_vacancy = job.NumberOfVacancy,
added_by = userUuid,
updated_by = userUuid,
added_date = DateTime.Now,
updated_date = DateTime.Now,
is_active = true,
web_approval = (int)Approval.pending,
};
db.tbl_job_main.Add(tblModel);
try
{
db.SaveChanges();
jobId = tblModel.id;
return(null);
}
catch (Exception ex)
{
jobId = 0;
return(ex.Message.ToString());
}
}
}
/// <summary>
/// Delete company has job
/// </summary>
/// <param name="jobId"></param>
/// <returns></returns>
public string deleteCompanyHasJobByJobId(long jobId)
{
using (itjob_mainEntities db = new itjob_mainEntities())
{
var dbobj = db.tbl_company_has_job.Where(d => d.job_main_id == jobId).FirstOrDefault();
if (dbobj == null)
{
return("company has Table is empty");
}
db.tbl_company_has_job.Remove(dbobj);
try
{
db.SaveChanges();
return(null);
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
}
}
/// <summary>
/// Delete Document
/// </summary>
/// <param name="documentIds"></param>
/// <returns></returns>
public string DeleteDocument(long[] documentIds)
{
using (itjob_mainEntities db = new itjob_mainEntities())
{
var found = db.tbl_document.Where(d => documentIds.Contains(d.id)).ToList();
if (found.Count() == 0)
{
return("Cant Delete not found Document");
}
DeleteServerDocumentFiles(found.Select(x => x.path).ToArray());
db.tbl_document.RemoveRange(found);
try
{
db.SaveChanges();
return(null);
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
}
}
/// <summary>
/// Delete job
/// </summary>
/// <returns></returns>
public string Delete(long jobId)
{
using (itjob_mainEntities db = new itjob_mainEntities())
{
var dbobj = db.tbl_job_main.Where(d => d.id == jobId).FirstOrDefault();
if (dbobj == null)
{
return("Table is empty");
}
db.tbl_job_main.Remove(dbobj);
try
{
db.SaveChanges();
return(null);
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
}
}