// For Room Type
public DataSet AddCCAvenue(CCAvenueBo ccavenueBo)
{
var transactionStatus = new TransactionStatus();
var ccavenue = BuiltRoomTypeDomain(ccavenueBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@Cav_Name", ccavenue.Cav_Name), //0
new SqlParameter("@Cav_Percent", ccavenue.Cav_Percent), //1
new SqlParameter("@Cav_Descr", ccavenue.Cav_Descr), //2
new SqlParameter("@Cav_Ipaddress", ccavenue.Cav_Ipaddress), //3
new SqlParameter("@Cav_Regist_On", ccavenue.Cav_Regist_On), //4
new SqlParameter("@Cav_Modified_On", ccavenue.Cav_Modified_On), //5
new SqlParameter("@Cav_Active_flag", "True"), //6
new SqlParameter("@opReturnValue", "0") //7
};
// Params[3].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddCCAvenue", Params);
ds.Locale = CultureInfo.InvariantCulture;
//string test = Params[3].Value.ToString();
return(ds);
}
public TransactionStatus EditCCAvenue(CCAvenueBo ccavenueBo)
{
var transactionStatus = new TransactionStatus();
var ccavenue = BuiltRoomTypeDomain(ccavenueBo);
CemexDb con = new CemexDb();
SqlConnection conn = con.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("dbo.proc_updateCCAvenue", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Cav_Id", Convert.ToInt32(ccavenue.Cav_Id));
cmd.Parameters.AddWithValue("@Cav_Name", ccavenue.Cav_Name);
cmd.Parameters.AddWithValue("@Cav_Percent", ccavenue.Cav_Percent);
cmd.Parameters.AddWithValue("@Cav_Ipaddress", ccavenue.Cav_Ipaddress);
cmd.Parameters.AddWithValue("@Cav_Descr", ccavenue.Cav_Descr);
cmd.Parameters.AddWithValue("@Cav_Modified_On", ccavenue.Cav_Modified_On);
cmd.Parameters.AddWithValue("@Cav_Active_flag", "true");
cmd.Parameters.AddWithValue("@opReturnValue", SqlDbType.Int);
cmd.ExecuteNonQuery();
return(transactionStatus);
}
private CCAvenue BuiltRoomTypeDomain(CCAvenueBo ccavenueBo)
{
return((CCAvenue) new CCAvenue().InjectFrom(ccavenueBo));
}
