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