public DataSet AddParam(ParamBo paramBo)
{
var transactionStatus = new TransactionStatus();
var param = BuiltParamDomain(paramBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@vend_Id", 4), //0
new SqlParameter("@prop_Id", 1), //1
new SqlParameter("@room_Id", 1), //2
new SqlParameter("@lmk_Id", 1), //3
new SqlParameter("@user_Id", 1), //4
new SqlParameter("@Vparam_Code", param.Vparam_Code), //5
new SqlParameter("@Vparam_Descr", param.Vparam_Descr), //6
new SqlParameter("@Vparm_Type", param.Vparm_Type), //7
new SqlParameter("@Vparam_Val", param.Vparam_Val), //8
new SqlParameter("@Vparam_Active_Flag", "True"), //9
// new SqlParameter("@opReturnValue", SqlDbType.Int)//10
};
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddParam", Params);
ds.Locale = CultureInfo.InvariantCulture;
return(ds);
}
public TransactionStatus UpdateParam(ParamBo paramBo)
{
var transactionStatus = new TransactionStatus();
var param = BuiltParamDomain(paramBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@param_Id", param.Id), //0
new SqlParameter("@vend_Id", 4), //1
new SqlParameter("@Vparam_Code", param.Vparam_Code), //2
new SqlParameter("@Vparam_Descr", param.Vparam_Descr), //2
new SqlParameter("@Vparm_Type", param.Vparm_Type), //3
new SqlParameter("@Vparam_Val", param.Vparam_Val), //4
new SqlParameter("@opReturnValue", SqlDbType.Int) //5
};
Params[6].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_UpdateParam", Params);
ds.Locale = CultureInfo.InvariantCulture;
return(transactionStatus);
}
private Param BuiltParamDomain(ParamBo paramBo)
{
return((Param) new Param().InjectFrom(paramBo));
}
