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> GetAllBranchContact() { ReturnResult <BranchContact> result = new ReturnResult <BranchContact>(); DbProvider db = new DbProvider(); var lstBranchContact = new List <BranchContact>(); try { db.SetQuery("BranchContact_GetAll", System.Data.CommandType.StoredProcedure) .GetList <BranchContact>(out lstBranchContact) .Complete(); if (lstBranchContact.Count > 0) { result.ItemList = lstBranchContact; result.ErrorMessage = ""; result.ErrorCode = "0"; } } catch (Exception ex) { result.Failed("-1", ex.Message); } return(result); }
public ReturnResult <Skills> GetAllSkills() { ReturnResult <Skills> result = new ReturnResult <Skills>(); DbProvider db = new DbProvider(); var lstSkills = new List <Skills>(); try { db.SetQuery("Skills_GetAll", System.Data.CommandType.StoredProcedure) .GetList <Skills>(out lstSkills) .Complete(); if (lstSkills.Count > 0) { result.ItemList = lstSkills; result.ErrorMessage = ""; result.ErrorCode = "0"; } } catch (Exception ex) { result.Failed("-1", ex.Message); } return(result); }
public ReturnResult <RecruitmentNewsModel> GetRecruitmentNewPaging(BaseCondition <RecruitmentNewsModel> condition) { DbProvider provider = new DbProvider(); List <RecruitmentNewsModel> list = new List <RecruitmentNewsModel>(); string outCode = String.Empty; string outMessage = String.Empty; string totalCount = String.Empty; var result = new ReturnResult <RecruitmentNewsModel>(); try { provider.SetQuery("Inside_RecruitmentNews_GetAllPaging", System.Data.CommandType.StoredProcedure) //.SetParameter("Contain", condition.Contain, SqlDbType.NVarChar) .SetParameter("InWhere", SqlDbType.NVarChar, condition.IN_WHERE ?? String.Empty) .SetParameter("InSort", SqlDbType.NVarChar, condition.IN_SORT ?? String.Empty) .SetParameter("PageIndex", SqlDbType.Int, condition.PageIndex) .SetParameter("PageSize", SqlDbType.Int, condition.PageSize) .SetParameter("TotalCount", SqlDbType.Int, DBNull.Value, ParameterDirection.Output) .SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output) .SetParameter("ReturnMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output).GetList <RecruitmentNewsModel>(out list).Complete(); if (list.Count > 0) { result.ItemList = list; } provider.GetOutValue("ErrorCode", out outCode) .GetOutValue("ReturnMessage", out outMessage) .GetOutValue("TotalCount", out string totalRows); if (outCode != "0") { result.ErrorCode = outCode; result.ErrorMessage = outMessage; } else { result.ErrorCode = ""; result.ErrorMessage = ""; result.TotalRows = int.Parse(totalRows); } } catch (Exception ex) { result.Failed("-1", ex.Message); } return(result); }
public ReturnResult <JobPosition> GetAllJobPositionWithSearchPaging(BaseCondition <JobPosition> condition) { DbProvider provider = new DbProvider(); List <JobPosition> list = new List <JobPosition>(); string outCode = String.Empty; string outMessage = String.Empty; string totalRecords = String.Empty; var result = new ReturnResult <JobPosition>(); try { provider.SetQuery("JobPosition_GetAllWithSearchPaging", System.Data.CommandType.StoredProcedure) .SetParameter("InWhere", SqlDbType.NVarChar, condition.IN_WHERE ?? String.Empty) .SetParameter("InSort", SqlDbType.NVarChar, condition.IN_SORT ?? String.Empty) .SetParameter("StartRow", SqlDbType.Int, condition.PageIndex) .SetParameter("PageSize", SqlDbType.Int, condition.PageSize) .SetParameter("TotalRecords", SqlDbType.Int, DBNull.Value, ParameterDirection.Output) .SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output) .SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output).GetList <JobPosition>(out list).Complete(); if (list.Count > 0) { result.ItemList = list; } provider.GetOutValue("ErrorCode", out outCode) .GetOutValue("ErrorMessage", out outMessage) .GetOutValue("TotalRecords", out string totalRows); if (outCode != "0") { result.ErrorCode = outCode; result.ErrorMessage = outMessage; } else { result.ErrorCode = ""; result.ErrorMessage = ""; result.TotalRows = int.Parse(totalRows); } } catch (Exception ex) { result.Failed("-1", ex.Message); } return(result); }
public ReturnResult <CoQuan> InsertCoQuan(CoQuan coQuan) { DbProvider provider = new DbProvider(); var result = new ReturnResult <CoQuan>(); string outCode = String.Empty; string outMessage = String.Empty; string totalRecords = String.Empty; try { provider.SetQuery("[Organ_INSERT]", CommandType.StoredProcedure) .SetParameter("OrganCode", SqlDbType.NVarChar, coQuan.OrganCode) .SetParameter("TenCoQuan", SqlDbType.NVarChar, coQuan.TenCoQuan) .SetParameter("TinhID", SqlDbType.Int, coQuan.TinhID, ParameterDirection.Input) .SetParameter("HuyenID", SqlDbType.Int, coQuan.HuyenID, ParameterDirection.Input) .SetParameter("XaPhuongID", SqlDbType.Int, coQuan.XaPhuongID, ParameterDirection.Input) .SetParameter("LoaiCoQuan", SqlDbType.Int, coQuan.LoaiCoQuanID, ParameterDirection.Input) .SetParameter("CreateBy", SqlDbType.VarChar, coQuan.CreateBy, 50) .SetParameter("Description", SqlDbType.NVarChar, coQuan.Description, 1000) .SetParameter("Notes", SqlDbType.NVarChar, coQuan.Notes, 1000) .SetParameter("AddressDetail", SqlDbType.NVarChar, coQuan.AddressDetail, 500) .SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output) .SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output) .ExcuteNonQuery() .Complete(); provider.GetOutValue("ErrorCode", out outCode) .GetOutValue("ErrorMessage", out outMessage); if (outCode != "0" || outCode == "") { result.Failed(outCode, outMessage); } else { result.Item = coQuan; result.ErrorCode = "0"; result.ErrorMessage = ""; } } catch (Exception ex) { result.Failed("-1", ex.Message); } return(result); }
public ReturnResult <BranchContact> AddNewBranchContact(BranchContact BranchContact) { var result = new ReturnResult <BranchContact>(); DbProvider db = new DbProvider(); string outCode = String.Empty; string outMessage = String.Empty; string totalRecords = String.Empty; try { // Set tên stored procedure db.SetQuery("BranchContact_AddNew", CommandType.StoredProcedure) .SetParameter("BranchContactCode", SqlDbType.NVarChar, BranchContact.BranchContactCode) .SetParameter("BranchContactName", SqlDbType.NVarChar, BranchContact.BranchContactName) .SetParameter("ContactName", SqlDbType.NVarChar, BranchContact.ContactName) .SetParameter("Email", SqlDbType.NVarChar, BranchContact.Email) .SetParameter("Hotline", SqlDbType.NVarChar, BranchContact.Hotline) .SetParameter("IPPhone", SqlDbType.NVarChar, BranchContact.IPPhone) .SetParameter("OperateStatus", SqlDbType.Int, BranchContact.OperateStatus) .SetParameter("InsertedId", SqlDbType.Int, 1) .SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output) .SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output) .ExcuteNonQuery() .Complete(); db.GetOutValue("ErrorCode", out outCode) .GetOutValue("ErrorMessage", out outMessage); if (outCode != "0" || outCode == "") { result.Failed(outCode, outMessage); } else { result.Item = BranchContact; result.ErrorCode = "0"; result.ErrorMessage = ""; } } 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); }
public ReturnResult <JobPosition> AddNewJobPosition(JobPosition JobPosition) { var result = new ReturnResult <JobPosition>(); DbProvider db = new DbProvider(); string outCode = String.Empty; string outMessage = String.Empty; string totalRecords = String.Empty; try { // Set tên stored procedure db.SetQuery("JobPosition_AddNew", CommandType.StoredProcedure) .SetParameter("PositionName", SqlDbType.NVarChar, JobPosition.PositionName) .SetParameter("Description", SqlDbType.NVarChar, JobPosition.Description) .SetParameter("CreatedUser", SqlDbType.NVarChar, JobPosition.CreatedUser) .SetParameter("Manager", SqlDbType.TinyInt, JobPosition.Manager) .SetParameter("ModeifiedUser", SqlDbType.NVarChar, JobPosition.ModifiedUser) .SetParameter("Status", SqlDbType.TinyInt, JobPosition.Status) .SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output) .SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output) .ExcuteNonQuery() .Complete(); db.GetOutValue("ErrorCode", out outCode) .GetOutValue("ErrorMessage", out outMessage); if (outCode != "0" || outCode == "") { result.Failed(outCode, outMessage); } else { result.Item = JobPosition; result.ErrorCode = "0"; result.ErrorMessage = ""; } } catch (Exception ex) { result.Failed("-1", ex.Message); } return(result); }
public ReturnResult <Vacancy> AddNewVacancy(Vacancy Vacancy) { var result = new ReturnResult <Vacancy>(); DbProvider db = new DbProvider(); string outCode = String.Empty; string outMessage = String.Empty; string totalRecords = String.Empty; try { // Set tên stored procedure db.SetQuery("Vacancy_AddNew", CommandType.StoredProcedure) .SetParameter("VacancyName", SqlDbType.NVarChar, Vacancy.VacancyName) .SetParameter("IsActivated", SqlDbType.Int, Vacancy.IsActivated) .SetParameter("VacancyCode", SqlDbType.NVarChar, Vacancy.VacancyCode) .SetParameter("DescriptionVN", SqlDbType.NVarChar, Vacancy.DescriptionVN) .SetParameter("CreatedBy", SqlDbType.NVarChar, Vacancy.CreatedBy) .SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output) .SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output) .ExcuteNonQuery() .Complete(); db.GetOutValue("ErrorCode", out outCode) .GetOutValue("ErrorMessage", out outMessage); if (outCode != "0" || outCode == "") { result.Failed(outCode, outMessage); } else { result.Item = Vacancy; result.ErrorCode = "0"; result.ErrorMessage = ""; } } catch (Exception ex) { result.Failed("-1", ex.Message); } return(result); }
public ReturnResult <Skills> GetSkillsById(int id) { DbProvider provider = new DbProvider(); var result = new ReturnResult <Skills>(); string outCode = String.Empty; string outMessage = String.Empty; string totalRecords = String.Empty; Skills item = new Skills(); try { provider.SetQuery("Skills_GetById", CommandType.StoredProcedure) .SetParameter("SkillId", SqlDbType.Int, id, ParameterDirection.Input) .SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output) .SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output) .GetSingle <Skills>(out item).Complete(); provider.GetOutValue("ErrorCode", out outCode) .GetOutValue("ErrorMessage", out outMessage); if (outCode != "0" || outCode == "") { result.ErrorCode = outCode; result.ErrorMessage = outMessage; } else { result.Item = item; result.ErrorCode = outCode; result.ErrorMessage = outMessage; } } 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 <JobCategory> GetAllJobCategory() { List <JobCategory> jobCategories = new List <JobCategory>(); DbProvider dbProvider = new DbProvider(); var result = new ReturnResult <JobCategory>(); try { string outCode = String.Empty; string outMessage = String.Empty; dbProvider.SetQuery("JobCategory_GetAllData", CommandType.StoredProcedure) .GetList <JobCategory>(out jobCategories) .Complete(); result.ItemList = jobCategories; } catch (Exception ex) { result.Failed("-1", ex.Message); } return(result); }
public ReturnResult <Vacancy> DeleteVacancy(int id) { DbProvider provider = new DbProvider(); var result = new ReturnResult <Vacancy>(); string outCode = String.Empty; string outMessage = String.Empty; string totalRecords = String.Empty; Vacancy item = new Vacancy(); try { provider.SetQuery("Vacancy_Delete", CommandType.StoredProcedure) .SetParameter("Id", SqlDbType.Int, id, System.Data.ParameterDirection.Input) .SetParameter("DeletedBy ", SqlDbType.NVarChar, "", System.Data.ParameterDirection.Input) .SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, System.Data.ParameterDirection.Output) .SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, System.Data.ParameterDirection.Output) .ExcuteNonQuery().Complete(); provider.GetOutValue("ErrorCode", out outCode) .GetOutValue("ErrorMessage", out outMessage); if (outCode != "0") { result.Failed(outCode, outMessage); } else { result.ErrorCode = "0"; result.ErrorMessage = ""; } } catch (Exception ex) { throw ex; } 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 <CoQuan> GetAllCoQuan() { var result = new ReturnResult <CoQuan>(); DbProvider db; List <CoQuan> lst; try { result = new ReturnResult <CoQuan>(); db = new DbProvider(); lst = new List <CoQuan>(); db.SetQuery("Organ_GET_ALL", CommandType.StoredProcedure) .SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 400, ParameterDirection.Output) .SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output) .GetList <CoQuan>(out lst) .Complete(); db.GetOutValue("ErrorCode", out string outCode) .GetOutValue("ErrorMessage", out string outMessage); // get out value if (outCode.ToString() != "0") { result.Failed(outCode, outMessage); return(result); } else { result.ItemList = lst; result.ErrorCode = "0"; result.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> InsertRecruitmentNews(RecruitmentNewsModel recruitmentNews) { var result = new ReturnResult <RecruitmentNewsModel>(); DbProvider db = new DbProvider(); string outCode = String.Empty; string outMessage = String.Empty; string totalRecords = String.Empty; int outNewId = 0; try { // Set tên stored procedure db.SetQuery("Inside_RecruitmentNews_Insert", CommandType.StoredProcedure) .SetParameter("BranchId", SqlDbType.Int, recruitmentNews.BranchId) .SetParameter("JobCode", SqlDbType.NVarChar, recruitmentNews.JobCode) .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) // Output parameter .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(); // Xử lý Logs db.GetOutValue("OUT_ErrorCode", out outCode) .GetOutValue("OUT_ReturnMessage", out outMessage) .GetOutValue("OUT_NewId", out outNewId); if (outCode != "0" || outCode == "") { result.Failed(outCode, outMessage); } else { recruitmentNews.RecruitmentId = outNewId; result.Item = recruitmentNews; } return(result); } catch (Exception ex) { result.Failed("-1", ex.Message); } return(result); }