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