foreach (var items in roomtype)
{
ClearTripRoomType obj = new ClearTripRoomType();
obj.key = items["k"];
obj.value = items["v"];
obj.innerroomtype = GetRoomType(hotelid, obj.key, obj.innerroomtype);
list.Add(obj);
try
{
con = new SqlConnection(ConnString);
con.Open();
using (cmd = new SqlCommand(InsertSql, con))
{
cmd.Parameters.Add("@keys", SqlDbType.Int).Value = obj.key;
cmd.Parameters.Add("@values", SqlDbType.VarChar).Value = obj.value;
cmd.ExecuteNonQuery();
}
}
catch(Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}