/// <summary> /// Edit phase info /// </summary> /// <param name="data">Phase info</param> /// <param name="phaseID">Phase ID output</param> /// <returns>Action result</returns> public bool EditPhaseInfo(PhasePlus data, out int phaseID) { var res = false; using (var transaction = new TransactionScope()) { res = this._repository.EditPhaseInfo(data, out phaseID); if (res) { transaction.Complete(); } } return(res); }
/// <summary> /// Edit phase info /// </summary> /// <param name="data">Phase info</param> /// <param name="phaseID">Phase ID output</param> /// <returns>Action result</returns> public bool EditPhaseInfo(PhasePlus data, out int phaseID) { int result = 0; phaseID = data.phase_id; if (data.phase_id == 0) { var sqlInsert = new Sql(@" INSERT INTO m_phase (company_code, phase_name, display_name, remarks, estimate_target_flg, ins_date, ins_id, upd_date, upd_id, del_flg) VALUES (@company_code, @phase_name, @display_name, @remarks,@estimate_target_flg, @ins_date, @ins_id, @upd_date, @upd_id, @del_flg); SELECT SCOPE_IDENTITY();", new { company_code = data.company_code, phase_name = data.phase_name.Trim(), display_name = data.display_name.Trim(), remarks = data.remarks, estimate_target_flg = data.estimate_target_flg, 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 }); phaseID = this._database.ExecuteScalar <int>(sqlInsert); if (phaseID > 0) { result = phaseID; } } else { var sqlUpdate = new Sql(@" UPDATE m_phase SET phase_name = @phase_name, display_name = @display_name, remarks = @remarks, estimate_target_flg = @estimate_target_flg, upd_date = @upd_date, upd_id = @upd_id, del_flg = @del_flg WHERE phase_id = @phase_id AND company_code = @company_code;", new { phase_name = data.phase_name.Trim(), display_name = data.display_name.Trim(), remarks = data.remarks, estimate_target_flg = data.estimate_target_flg, upd_date = data.upd_date, upd_id = data.upd_id, del_flg = data.del_flg, phase_id = data.phase_id, company_code = data.company_code }); result = this._database.Execute(sqlUpdate); } return(result > 0); }
public PMS04001EditViewModel() { PhaseInfo = new PhasePlus(); }