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