/// <summary> /// Edit contractType info /// </summary> /// <param name="data">ContractType info</param> /// <param name="contractTypePhaseList">Contract type phase list</param> /// <param name="contractTypeCategoryList">Contract type category list</param> /// <param name="contractTypeID">ContractType ID output</param> /// <returns>Action result</returns> public bool EditContractTypeInfo(ContractTypePlus data, IList <ContractTypePhasePlus> contractTypePhaseList, IList <ContractTypeCategoryPlus> contractTypeCategoryList, out int contractTypeID) { var res = false; using (var transaction = new TransactionScope()) { res = this._repository.EditContractTypeInfo(data, contractTypePhaseList, contractTypeCategoryList, out contractTypeID); if (res) { transaction.Complete(); } } return(res); }
/// <summary> /// Edit contractType info /// </summary> /// <param name="data">ContractType info</param> /// <param name="contractTypePhaseList">Contract type phase list</param> /// <param name="contractTypeCategoryList">Contract type category list</param> /// <param name="contractTypeID">ContractType ID output</param> /// <returns>Action result</returns> public bool EditContractTypeInfo(ContractTypePlus data, IList <ContractTypePhasePlus> contractTypePhaseList, IList <ContractTypeCategoryPlus> contractTypeCategoryList, out int contractTypeID) { int result = 0; contractTypeID = data.contract_type_id; if (data.contract_type_id == 0) { var sqlInsert = new Sql(@" INSERT INTO m_contract_type (company_code, contract_type, charge_of_sales_flg, exceptional_calculate_flg, budget_setting_flg, check_plan_flg, check_progress_flg, check_period_flg, check_sales_flg, remarks, display_order, ins_date, ins_id, upd_date, upd_id, del_flg) VALUES (@company_code, @contract_type, @charge_of_sales_flg, @exceptional_calculate_flg, @budget_setting_flg, @check_plan_flg, @check_progress_flg, @check_period_flg, @check_sales_flg, @remarks, @display_order, @ins_date, @ins_id, @upd_date, @upd_id, @del_flg); SELECT SCOPE_IDENTITY();", new { company_code = data.company_code, contract_type = data.contract_type.Trim(), charge_of_sales_flg = data.charge_of_sales_flg, exceptional_calculate_flg = data.exceptional_calculate_flg, budget_setting_flg = data.budget_setting_flg, check_plan_flg = data.check_plan_flg, check_progress_flg = data.check_progress_flg, check_period_flg = data.check_period_flg, check_sales_flg = data.check_sales_flg, remarks = data.remarks, display_order = data.display_order, ins_date = data.upd_date, ins_id = data.upd_id, upd_date = data.upd_date, upd_id = data.upd_id, del_flg = Constant.DeleteFlag.NON_DELETE }); contractTypeID = this._database.ExecuteScalar <int>(sqlInsert); if (contractTypeID > 0) { result = EditContractTypePhase(data.company_code, contractTypeID, data.upd_date.Value, data.upd_id, contractTypePhaseList); } if (result > 0) { result = EditContractTypeCategory(data.company_code, contractTypeID, data.upd_date.Value, data.upd_id, contractTypeCategoryList); } } else { var sqlUpdate = new Sql(@" UPDATE m_contract_type SET contract_type = @contract_type, charge_of_sales_flg = @charge_of_sales_flg, exceptional_calculate_flg = @exceptional_calculate_flg, budget_setting_flg = @budget_setting_flg, check_plan_flg = @check_plan_flg, check_progress_flg = @check_progress_flg, check_period_flg = @check_period_flg, check_sales_flg = @check_sales_flg, remarks = @remarks, display_order = @display_order, upd_date = @upd_date, upd_id = @upd_id, del_flg = @del_flg WHERE contract_type_id = @contract_type_id AND company_code = @company_code;", new { contract_type = data.contract_type.Trim(), charge_of_sales_flg = data.charge_of_sales_flg, exceptional_calculate_flg = data.exceptional_calculate_flg, budget_setting_flg = data.budget_setting_flg, check_plan_flg = data.check_plan_flg, check_progress_flg = data.check_progress_flg, check_period_flg = data.check_period_flg, check_sales_flg = data.check_sales_flg, remarks = data.remarks, display_order = data.display_order, upd_date = data.upd_date, upd_id = data.upd_id, del_flg = data.del_flg, contract_type_id = data.contract_type_id, company_code = data.company_code }); result = this._database.Execute(sqlUpdate); if (result > 0) { result = EditContractTypePhase(data.company_code, data.contract_type_id, data.upd_date.Value, data.upd_id, contractTypePhaseList); } if (result > 0) { result = EditContractTypeCategory(data.company_code, data.contract_type_id, data.upd_date.Value, data.upd_id, contractTypeCategoryList); } } return(result >= 0); }
public PMS03001EditViewModel() { ContractTypeInfo = new ContractTypePlus(); }