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