public List <MyOrdersDetailsResponseDto> GetAllUserOrderDetails(string OrderNumber)
{
List <MyOrdersDetailsResponseDto> lstMyOrdersDetailsResponseDto = new List <MyOrdersDetailsResponseDto>();
SqlCommand cmd = new SqlCommand("GetAllUserOrderDetails", connectionRepository.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OrderNo", OrderNumber);
connectionRepository.con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
MyOrdersDetailsResponseDto myOrdersDetailsResponseDto = new MyOrdersDetailsResponseDto();
myOrdersDetailsResponseDto.GroupId = Convert.ToInt32(dr["GroupId"]);
myOrdersDetailsResponseDto.GroupName = Convert.ToString(dr["GroupName"]);
myOrdersDetailsResponseDto.CategoryId = Convert.ToInt32(dr["CategoryId"]);
myOrdersDetailsResponseDto.CategoryName = Convert.ToString(dr["CategoryName"]);
myOrdersDetailsResponseDto.ItemId = Convert.ToInt32(dr["ItemId"]);
myOrdersDetailsResponseDto.ItemName = Convert.ToString(dr["ItemName"]);
myOrdersDetailsResponseDto.ItemImage = Convert.ToString(dr["ItemImage"]);
myOrdersDetailsResponseDto.Mrp = Convert.ToDecimal(dr["Mrp"]);
myOrdersDetailsResponseDto.Discount = Convert.ToDecimal(dr["Discount"]);
myOrdersDetailsResponseDto.Price = Convert.ToDecimal(dr["Price"]);
myOrdersDetailsResponseDto.Width = Convert.ToInt32(dr["Width"]);
myOrdersDetailsResponseDto.WidthType = Convert.ToString(dr["WidthType"]);
myOrdersDetailsResponseDto.Height = Convert.ToInt32(dr["Height"]);
myOrdersDetailsResponseDto.HeightType = Convert.ToString(dr["HeightType"]);
myOrdersDetailsResponseDto.CurrencyType = Convert.ToString(dr["CurrencyType"]);
myOrdersDetailsResponseDto.Quantity = Convert.ToInt32(dr["Quantity"]);
myOrdersDetailsResponseDto.Status = Convert.ToInt32(dr["Status"]);
myOrdersDetailsResponseDto.OrderId = Convert.ToInt32(dr["OrderId"]);
myOrdersDetailsResponseDto.OrderNumber = Convert.ToString(dr["OrderNumber"]);
myOrdersDetailsResponseDto.OrderDate = Convert.ToString(dr["OrderDate"]);
myOrdersDetailsResponseDto.PaymentDate = Convert.ToString(dr["PaymentDate"]);
myOrdersDetailsResponseDto.PaymentType = Convert.ToString(dr["PaymentType"]);
myOrdersDetailsResponseDto.UserId = Convert.ToInt32(dr["UserId"]);
myOrdersDetailsResponseDto.Name = Convert.ToString(dr["Name"]);
myOrdersDetailsResponseDto.EmailId = Convert.ToString(dr["EmailId"]);
myOrdersDetailsResponseDto.MobileNo = Convert.ToString(dr["MobileNo"]);
myOrdersDetailsResponseDto.AddressId = Convert.ToInt32(dr["AddressId"]);
lstMyOrdersDetailsResponseDto.Add(myOrdersDetailsResponseDto);
}
connectionRepository.con.Close();
return(lstMyOrdersDetailsResponseDto);
}
public List <MyOrdersDetailsResponseDto> GetOrderHistoryByUserId(int UserId)
{
List <MyOrdersDetailsResponseDto> lstMyOrdersDetailsResponseDto = new List <MyOrdersDetailsResponseDto>();
SqlCommand cmd = new SqlCommand("GetOrderHistoryByUserId", connectionRepository.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", UserId);
connectionRepository.con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
MyOrdersDetailsResponseDto myOrdersDetailsResponseDto = new MyOrdersDetailsResponseDto();
myOrdersDetailsResponseDto.OrderNumber = Convert.ToString(dr["OrderNumber"]);
lstMyOrdersDetailsResponseDto.Add(myOrdersDetailsResponseDto);
}
connectionRepository.con.Close();
return(lstMyOrdersDetailsResponseDto);
}
