public ReturnResult <JobPosition> UpdateStatusJobPosition(JobPosition JobPosition) { ReturnResult <JobPosition> result = new ReturnResult <JobPosition>();; DbProvider db; try { db = new DbProvider(); db.SetQuery("JobPosition_UpdateStatus", CommandType.StoredProcedure); db.SetParameter("Status", SqlDbType.TinyInt, JobPosition.Status); db.SetParameter("ErrorCode", SqlDbType.Int, DBNull.Value, ParameterDirection.Output); db.SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output); db.ExcuteNonQuery(); db.Complete(); db.GetOutValue("ErrorCode", out string errorCode); db.GetOutValue("ErrorMessage", out string errorMessage); if (errorCode.ToString() == "0") { result.ErrorCode = "0"; result.ErrorMessage = ""; } else { result.Failed(errorCode, errorMessage); } } catch (Exception ex) { result.Failed("-1", ex.Message); } return(result); }
public ReturnResult <BranchContact> UpdateBranchContact(BranchContact BranchContact) { ReturnResult <BranchContact> result = new ReturnResult <BranchContact>();; DbProvider db; try { db = new DbProvider(); db.SetQuery("BranchContact_Update", CommandType.StoredProcedure); db.SetParameter("BranchContactId", SqlDbType.Int, BranchContact.BranchContactId); db.SetParameter("BranchContactCode", SqlDbType.NVarChar, BranchContact.BranchContactCode); db.SetParameter("BranchContactName", SqlDbType.NVarChar, BranchContact.BranchContactName); db.SetParameter("ContactName", SqlDbType.NVarChar, BranchContact.ContactName); db.SetParameter("Email", SqlDbType.NVarChar, BranchContact.Email); db.SetParameter("Hotline", SqlDbType.NVarChar, BranchContact.Hotline); db.SetParameter("IPPhone", SqlDbType.NVarChar, BranchContact.IPPhone); db.SetParameter("OperateStatus", SqlDbType.Int, BranchContact.OperateStatus); db.SetParameter("ErrorCode", SqlDbType.Int, DBNull.Value, ParameterDirection.Output); db.SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output); db.ExcuteNonQuery(); db.Complete(); db.GetOutValue("ErrorCode", out string errorCode); db.GetOutValue("ErrorMessage", out string errorMessage); if (errorCode.ToString() == "0") { result.ErrorCode = "0"; result.ErrorMessage = ""; } else { result.Failed(errorCode, errorMessage); } } catch (Exception ex) { result.Failed("-1", ex.Message); } return(result); }
public ReturnResult <Vacancy> UpdateVacancy(Vacancy Vacancy) { ReturnResult <Vacancy> result = new ReturnResult <Vacancy>();; DbProvider db; try { db = new DbProvider(); db.SetQuery("Vacancy_Update", CommandType.StoredProcedure); db.SetParameter("Id", SqlDbType.Int, Vacancy.ID); db.SetParameter("VacancyName", SqlDbType.NVarChar, Vacancy.VacancyName); db.SetParameter("IsActivated", SqlDbType.Int, Vacancy.IsActivated); db.SetParameter("VacancyCode", SqlDbType.NVarChar, Vacancy.VacancyCode); db.SetParameter("DescriptionVN", SqlDbType.NVarChar, Vacancy.DescriptionVN); db.SetParameter("UpdatedBy", SqlDbType.NVarChar, Vacancy.UpdatedBy); db.SetParameter("ErrorCode", SqlDbType.Int, DBNull.Value, ParameterDirection.Output); db.SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output); db.ExcuteNonQuery(); db.Complete(); db.GetOutValue("ErrorCode", out string errorCode); db.GetOutValue("ErrorMessage", out string errorMessage); if (errorCode.ToString() == "0") { result.ErrorCode = "0"; result.ErrorMessage = ""; } else { result.Failed(errorCode, errorMessage); } } catch (Exception ex) { result.Failed("-1", ex.Message); } return(result); }
public ReturnResult <Skills> UpdateSkills(Skills Skills) { ReturnResult <Skills> result = new ReturnResult <Skills>();; DbProvider db; try { db = new DbProvider(); db.SetQuery("Skills_Update", CommandType.StoredProcedure); db.SetParameter("SkillId", SqlDbType.Int, Skills.SkillId); db.SetParameter("SkillName", SqlDbType.NVarChar, Skills.SkillName); db.SetParameter("Description", SqlDbType.NVarChar, Skills.Description); db.SetParameter("ModifiedUser", SqlDbType.NVarChar, Skills.ModifiedDate); db.SetParameter("Status", SqlDbType.TinyInt, Skills.Status); db.SetParameter("ErrorCode", SqlDbType.Int, DBNull.Value, ParameterDirection.Output); db.SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output); db.ExcuteNonQuery(); db.Complete(); db.GetOutValue("ErrorCode", out string errorCode); db.GetOutValue("ErrorMessage", out string errorMessage); if (errorCode.ToString() == "0") { result.ErrorCode = "0"; result.ErrorMessage = ""; } else { result.Failed(errorCode, errorMessage); } } catch (Exception ex) { result.Failed("-1", ex.Message); } return(result); }
public ReturnResult <RecruitmentNewsModel> UpdateRecruitmentNews(RecruitmentNewsModel recruitmentNews) { ReturnResult <RecruitmentNewsModel> result = new ReturnResult <RecruitmentNewsModel>();; DbProvider db = new DbProvider(); string outCode = String.Empty; string outMessage = String.Empty; string totalRecords = String.Empty; try { db = new DbProvider(); db.SetQuery("Inside_RecruitmentNews_Update", CommandType.StoredProcedure); db.SetParameter("IN_RecruitmentId", SqlDbType.Int, recruitmentNews.RecruitmentId) .SetParameter("BranchId", SqlDbType.Int, recruitmentNews.BranchId) .SetParameter("JobCode", SqlDbType.NVarChar, recruitmentNews.JobCode) .SetParameter("BranchHrId", SqlDbType.Int, recruitmentNews.BranchHrId) .SetParameter("AreaId", SqlDbType.Int, recruitmentNews.AreaId) .SetParameter("JobTypeId", SqlDbType.Int, recruitmentNews.JobTypeId) .SetParameter("Title", SqlDbType.NVarChar, recruitmentNews.Title) .SetParameter("NumberPositions", SqlDbType.SmallInt, recruitmentNews.NumberPositions) .SetParameter("JobPositionId", SqlDbType.Int, recruitmentNews.JobPositionId) .SetParameter("JobLevelId", SqlDbType.Int, recruitmentNews.JobLevelId) .SetParameter("MinSalary", SqlDbType.NVarChar, recruitmentNews.MinSalary) .SetParameter("MaxSalary", SqlDbType.NVarChar, recruitmentNews.MaxSalary) .SetParameter("CurrentUnit", SqlDbType.NVarChar, recruitmentNews.CurrentUnit) .SetParameter("ShowSalary", SqlDbType.TinyInt, recruitmentNews.ShowSalary) .SetParameter("JobDescription", SqlDbType.NVarChar, recruitmentNews.JobDescription) .SetParameter("JobRequirement", SqlDbType.NVarChar, recruitmentNews.JobRequirement) .SetParameter("JobFullDescription", SqlDbType.NVarChar, recruitmentNews.JobFullDescription) .SetParameter("JobRequest", SqlDbType.NVarChar, recruitmentNews.JobRequest) .SetParameter("JobBenefit", SqlDbType.NVarChar, recruitmentNews.JobBenefit) .SetParameter("JobInfomation", SqlDbType.NVarChar, recruitmentNews.JobInfomation) .SetParameter("company_name", SqlDbType.NVarChar, recruitmentNews.company_name) .SetParameter("company_info", SqlDbType.NVarChar, recruitmentNews.company_info) .SetParameter("company_logo", SqlDbType.NVarChar, recruitmentNews.company_logo) .SetParameter("company_size", SqlDbType.NVarChar, recruitmentNews.company_size) .SetParameter("JobType", SqlDbType.TinyInt, recruitmentNews.JobType) .SetParameter("Gender", SqlDbType.TinyInt, recruitmentNews.Gender) .SetParameter("AgeFrom", SqlDbType.TinyInt, recruitmentNews.AgeFrom) .SetParameter("AgeTo", SqlDbType.TinyInt, recruitmentNews.AgeTo) .SetParameter("ExamType", SqlDbType.TinyInt, recruitmentNews.ExamType) .SetParameter("StartDate", SqlDbType.DateTime, recruitmentNews.StartDate.ToString()) .SetParameter("EndDate", SqlDbType.DateTime, recruitmentNews.EndDate.ToString()) .SetParameter("Hot", SqlDbType.TinyInt, recruitmentNews.Hot) .SetParameter("ProcessStatus", SqlDbType.TinyInt, recruitmentNews.ProcessStatus) .SetParameter("CreatedUser", SqlDbType.NVarChar, recruitmentNews.CreatedUser) //.SetParameter("CreatedDate", SqlDbType.DateTime, recruitmentNews.CreatedDate) .SetParameter("YearExpMax", SqlDbType.SmallInt, recruitmentNews.YearExpMax) .SetParameter("YearExpMin", SqlDbType.SmallInt, recruitmentNews.YearExpMin) .SetParameter("FK_VacancyId", SqlDbType.Int, recruitmentNews.FK_VacancyId) //.SetParameter("FullTitle", SqlDbType.NVarChar, recruitmentNews.FullTitle) .SetParameter("BranchAddressId", SqlDbType.Int, recruitmentNews.BranchAddressId) .SetParameter("SkillId", SqlDbType.Int, recruitmentNews.SkillId) .SetParameter("JobCategoryId", SqlDbType.Int, recruitmentNews.JobCategoryId) .SetParameter("OUT_NewId", SqlDbType.Int, DBNull.Value, ParameterDirection.Output) .SetParameter("OUT_ErrorCode", SqlDbType.NVarChar, DBNull.Value, 255, ParameterDirection.Output) .SetParameter("OUT_ReturnMessage", SqlDbType.NVarChar, DBNull.Value, 255, ParameterDirection.Output) // Xử lý thủ tục và kết quả trả về từ DB .ExcuteNonQuery() .Complete(); db.GetOutValue("OUT_ErrorCode", out outCode) .GetOutValue("OUT_ReturnMessage", out outMessage); // Xử lý Logs if (outCode.ToString() == "0") { result.ErrorCode = "0"; result.ErrorMessage = ""; } else { result.Failed(outCode, outMessage); } } catch (Exception ex) { result.Failed("-1", ex.Message); } return(result); }
/// <summary> /// cập nhật cơ quan /// </summary> /// <param name="coQuan"></param> /// <returns></returns> public ReturnResult <CoQuan> UpdateCoQuan(CoQuan coQuan) { ReturnResult <CoQuan> result = new ReturnResult <CoQuan>();; DbProvider db; try { db = new DbProvider(); db.SetQuery("Organ_EDIT", CommandType.StoredProcedure); db.SetParameter("CoQuanID", SqlDbType.Int, coQuan.CoQuanID); db.SetParameter("OrganCode", SqlDbType.NVarChar, coQuan.OrganCode); db.SetParameter("DiaChiID", SqlDbType.Int, coQuan.DiaChiID); db.SetParameter("TenCoQuan", SqlDbType.NVarChar, coQuan.TenCoQuan, 500); db.SetParameter("LoaiCoQuan", SqlDbType.Int, coQuan.LoaiCoQuanID); db.SetParameter("AddressDetail", SqlDbType.NVarChar, coQuan.AddressDetail, 500); db.SetParameter("TinhID", SqlDbType.Int, coQuan.TinhID); db.SetParameter("HuyenID", SqlDbType.Int, coQuan.HuyenID); db.SetParameter("XaPhuongID", SqlDbType.Int, coQuan.XaPhuongID); db.SetParameter("UpdatedBy", SqlDbType.NVarChar, coQuan.UpdatedBy, 50); db.SetParameter("Description", SqlDbType.NVarChar, coQuan.Description, 1000); db.SetParameter("Notes", SqlDbType.NVarChar, coQuan.Notes, 1000); db.SetParameter("ErrorCode", SqlDbType.Int, DBNull.Value, ParameterDirection.Output); db.SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output); db.ExcuteNonQuery(); db.Complete(); db.GetOutValue("ErrorCode", out string errorCode); db.GetOutValue("ErrorMessage", out string errorMessage); if (errorCode.ToString() == "0") { result.ErrorCode = "0"; result.ErrorMessage = ""; } else { result.Failed(errorCode, errorMessage); } } catch (Exception ex) { result.Failed("-1", ex.Message); } return(result); }