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