public OrderDTO PackOrder(int Order_id)
{
int Value = 0;
AddDTO orderitem = new AddDTO();
ItemDTO item = new ItemDTO();
OrderDTO order = new OrderDTO();
ItemDAL dal = new ItemDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);
OrderDAL dal1 = new OrderDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);
using (SqlConnection conn = new SqlConnection(this.connectionString))
using (SqlCommand comm = conn.CreateCommand())
{
comm.CommandText = "select * from [Add] where Id_or_order=@Id_or_order";
comm.Parameters.AddWithValue("@Id_or_order", Order_id);
conn.Open();
SqlDataReader reader = comm.ExecuteReader();
List <AddDTO> orderitems = new List <AddDTO>();
while (reader.Read())
{
orderitems.Add(new AddDTO
{
Id_or_order = Convert.ToInt32(reader["Id_or_order"]),
Id_of_item = Convert.ToInt32(reader["Id_of_item"]),
Quantity = Convert.ToInt32(reader["Quantity"]),
});
}
}
OrderDAL dal2 = new OrderDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString);
order = new OrderDTO
{
Order_id = Order_id,
Value = Value
};
using (SqlConnection conn1 = new SqlConnection(this.connectionString))
using (SqlCommand comm1 = conn1.CreateCommand())
{
comm1.CommandText = "update [Order] set Value= @Value where Order_id = @Order_id";
comm1.Parameters.Clear();
comm1.Parameters.AddWithValue("@Order_id", order.Order_id);
comm1.Parameters.AddWithValue("@Value", order.Value);
conn1.Open();
order.Order_id = Convert.ToInt32(comm1.ExecuteScalar());
}
return(order);
}
//adds one order position to order
public AddDTO Createadd(AddDTO add)
{
using (SqlConnection conn = new SqlConnection(this.connectionString))
using (SqlCommand comm = conn.CreateCommand())
{
comm.CommandText = "insert into [Add] (Id_of_order, Id_of_item, Quantity) values (@Id_of_order, @Id_of_item, @Quantity)";
comm.Parameters.Clear();
comm.Parameters.AddWithValue("@Id_of_order", add.Id_or_order);
comm.Parameters.AddWithValue("@Id_of_item", add.Id_of_item);
comm.Parameters.AddWithValue("@Quantity", add.Quantity);
conn.Open();
return(add);
}
}
public HttpResponseMessage Add(int conferenceId, int id, [FromBody] AddDTO data)
{
if (!ConferenceModuleContext.Security.CanManage)
{
if (!ConferenceModuleContext.Security.IsPresenter(id))
{
return(AccessViolation("You are not allowed to add content for this session"));
}
}
var url = data.url;
url = DotNetNuke.Common.Globals.AddHTTP(url);
if (!url.IsValidUrl())
{
return(ServiceError("The specified url is invalid or the server does not respond"));
}
var contentType = Connect.Conference.Core.Common.ResourceType.Hyperlink;
var m = Regex.Match(url, "(?i)https?://(www\\.youtube\\.com|youtu\\.be)/(watch\\?v=)?([^\\?&]+)(?-i)");
if (m.Success)
{
contentType = Connect.Conference.Core.Common.ResourceType.YouTube;
url = m.Groups[3].Value;
}
m = Regex.Match(url, "(?i)https?://vimeo\\.com/(\\d+)(?-i)");
if (m.Success)
{
contentType = Connect.Conference.Core.Common.ResourceType.Vimeo;
url = m.Groups[1].Value;
}
m = Regex.Match(url, "(?i)https?://channel9\\.msdn\\.com/(.+)(?-i)");
if (m.Success)
{
contentType = Connect.Conference.Core.Common.ResourceType.Channel9;
url = m.Groups[1].Value;
}
var resource = new SessionResourceBase();
resource.SessionId = id;
resource.ResourceDescription = url;
resource.ResourceLink = url;
resource.ResourceType = (int)contentType;
resource.Visibility = 1;
SessionResourceRepository.Instance.AddSessionResource(ref resource, UserInfo.UserID);
return(Request.CreateResponse(HttpStatusCode.OK, SessionResourceRepository.Instance.GetSessionResourcesBySession(id)));
}
public AddDTO Add(AddDTO add)
{
throw new NotImplementedException();
}
