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