public IHttpActionResult GetSendforUserId(Guid userid) { string str = "SELECT UserId,(select CoinName from tbl_Coin_Master where Id=CoinTypeId) as Coin_Name,BitCoinsFrom,DestinationtoBitCoins,Amount_In_USD,Amount_In_Coins,DescriptionAddress,FeeTYpe,Insert_Date,Updated_Date FROM tbl_Coin_Send where UserId='" + userid + "'"; // SqlDataAdapter da = new SqlDataAdapter(str, con); SqlCommand cmd = new SqlCommand(str, con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); List <SendBitcoinViewModel> ls = new List <SendBitcoinViewModel>(); while (dr.Read()) { SendBitcoinViewModel ob = new SendBitcoinViewModel(); ob.UserId = dr[0].ToString(); ob.CoinName = (string)dr[1]; ob.FromBitCoin = (string)dr[2]; ob.ToBitCoin = (string)dr[3]; ob.AmtInUSD = (decimal)dr[4]; ob.AmtInCoins = (decimal)dr[5]; ob.DesAddress = (string)dr[6]; ob.FeeType = (string)dr[7]; ob.InsertDate = (DateTime)dr[8]; if (dr[9] == DBNull.Value) { ob.UpdateDate = null; } else { ob.UpdateDate = (DateTime)dr[9]; } ls.Add(ob); } dr.Close(); con.Close(); //return ls; // return Ok(ls); //DataSet ds = new DataSet(); //da.Fill(ds); //DataTable dt = new DataTable(); //dt = ds.Tables[0]; //con.Close(); //string jsonstring = JsonConvert.SerializeObject(dt); //return Ok(jsonstring); if (ls.Count == 0 || ls == null) { return(NotFound()); } return(Ok(ls)); }
public ActionResult SendBitCoin(SendBitcoinViewModel obj) { if (!ModelState.IsValid) { ViewBag.Coinlist = Session["a"]; ViewBag.FeeType = Session["FeeType"]; // var data = CoinsMarketValueController.GetMarkupWithCoinId(); foreach (var r in d) { switch (r.Key) { case 101: mark101 = r.Value; break; case 102: mark102 = r.Value; break; case 103: mark103 = r.Value; break; case 104: mark104 = r.Value; break; case 105: mark105 = r.Value; break; case 106: mark106 = r.Value; break; } } try { ViewBag.BTC = "$" + Math.Round((Convert.ToDecimal(objCoin.BTCCurrentPrice()) + Convert.ToDecimal(mark101)), 2); } catch (Exception ex) { ViewBag.BTC = ex.Message; } try { ViewBag.ETH = "$" + Math.Round((Convert.ToDecimal(objCoin.ETHCurrentPrice()) + Convert.ToDecimal(mark106)), 2); } catch (Exception ex) { ViewBag.ETH = ex.Message; } try { ViewBag.DASH = "$" + Math.Round((Convert.ToDecimal(objCoin.DASHCurrentPrice()) + Convert.ToDecimal(mark102)), 2); } catch (Exception ex) { ViewBag.DASH = ex.Message; } try { ViewBag.LTC = "$" + Math.Round((Convert.ToDecimal(objCoin.LTCCurrentPrice()) + Convert.ToDecimal(mark103)), 2); } catch (Exception ex) { ViewBag.LTC = ex.Message; } try { ViewBag.ETC = "$" + Math.Round((Convert.ToDecimal(objCoin.ETCCurrentPrice()) + Convert.ToDecimal(mark105)), 2); } catch (Exception ex) { ViewBag.ETC = ex.Message; } try { ViewBag.MBC = "$" + Math.Round((Convert.ToDecimal(objCoin.GetMBC_USDCoin()) + Convert.ToDecimal(mark104)), 2); } catch (Exception ex) { ViewBag.MBC = ex.Message; } return(View(obj)); } string token = SessionToken; var userId = User.Identity.GetUserId(); obj.UserId = userId; using (var client = new HttpClient()) { client.BaseAddress = new Uri(url + "Transaction/SendPost"); //HTTP POST var postTask = client.PostAsJsonAsync(url + "Transaction/SendPost?sessiontoken=" + token, obj); postTask.Wait(); var result = postTask.Result; if (result.IsSuccessStatusCode) { //return RedirectToAction("Index"); EmailNotification en = Session["Notification"] as EmailNotification; if (en.send == true) { string uname = Session["UserName"] as string; string Email = Session["Email"] as string; string res = "Hi," + uname + " you Send coin. "; //SendMail a = new Blockchaninaccounts.App_Start.SendMail(); SendMail.Mail(Email, res); } ModelState.Clear(); ViewBag.msg = "All Details Saved Successfully"; ViewBag.Coinlist = Session["a"]; ViewBag.FeeType = Session["FeeType"]; // var d = CoinsMarketValueController.GetMarkupWithCoinId(); foreach (var r in d) { switch (r.Key) { case 101: mark101 = r.Value; break; case 102: mark102 = r.Value; break; case 103: mark103 = r.Value; break; case 104: mark104 = r.Value; break; case 105: mark105 = r.Value; break; case 106: mark106 = r.Value; break; } } try { ViewBag.BTC = "$" + Math.Round((Convert.ToDecimal(objCoin.BTCCurrentPrice()) + Convert.ToDecimal(mark101)), 2); } catch (Exception ex) { ViewBag.BTC = ex.Message; } try { ViewBag.ETH = "$" + Math.Round((Convert.ToDecimal(objCoin.ETHCurrentPrice()) + Convert.ToDecimal(mark106)), 2); } catch (Exception ex) { ViewBag.ETH = ex.Message; } try { ViewBag.DASH = "$" + Math.Round((Convert.ToDecimal(objCoin.DASHCurrentPrice()) + Convert.ToDecimal(mark102)), 2); } catch (Exception ex) { ViewBag.DASH = ex.Message; } try { ViewBag.LTC = "$" + Math.Round((Convert.ToDecimal(objCoin.LTCCurrentPrice()) + Convert.ToDecimal(mark103)), 2); } catch (Exception ex) { ViewBag.LTC = ex.Message; } try { ViewBag.ETC = "$" + Math.Round((Convert.ToDecimal(objCoin.ETCCurrentPrice()) + Convert.ToDecimal(mark105)), 2); } catch (Exception ex) { ViewBag.ETC = ex.Message; } try { ViewBag.MBC = "$" + Math.Round((Convert.ToDecimal(objCoin.GetMBC_USDCoin()) + Convert.ToDecimal(mark104)), 2); } catch (Exception ex) { ViewBag.MBC = ex.Message; } ViewBag.value = 1; ModelState.Clear(); return(View()); //return View("DashboardSuccess"); } //else //{ // ModelState.Clear(); // ModelState.AddModelError(string.Empty, "Server Error. Please contact administrator."); //} } ModelState.Clear(); ModelState.AddModelError(string.Empty, "Server Error. Please contact administrator."); ViewBag.FeeType = Session["FeeType"]; ViewBag.Coinlist = Session["a"]; // var data = CoinsMarketValueController.GetMarkupWithCoinId(); foreach (var r in d) { switch (r.Key) { case 101: mark101 = r.Value; break; case 102: mark102 = r.Value; break; case 103: mark103 = r.Value; break; case 104: mark104 = r.Value; break; case 105: mark105 = r.Value; break; case 106: mark106 = r.Value; break; } } try { ViewBag.BTC = "$" + Math.Round((Convert.ToDecimal(objCoin.BTCCurrentPrice()) + Convert.ToDecimal(mark101)), 2); } catch (Exception ex) { ViewBag.BTC = ex.Message; } try { ViewBag.ETH = "$" + Math.Round((Convert.ToDecimal(objCoin.ETHCurrentPrice()) + Convert.ToDecimal(mark106)), 2); } catch (Exception ex) { ViewBag.ETH = ex.Message; } try { ViewBag.DASH = "$" + Math.Round((Convert.ToDecimal(objCoin.DASHCurrentPrice()) + Convert.ToDecimal(mark102)), 2); } catch (Exception ex) { ViewBag.DASH = ex.Message; } try { ViewBag.LTC = "$" + Math.Round((Convert.ToDecimal(objCoin.LTCCurrentPrice()) + Convert.ToDecimal(mark103)), 2); } catch (Exception ex) { ViewBag.LTC = ex.Message; } try { ViewBag.ETC = "$" + Math.Round((Convert.ToDecimal(objCoin.ETCCurrentPrice()) + Convert.ToDecimal(mark105)), 2); } catch (Exception ex) { ViewBag.ETC = ex.Message; } try { ViewBag.MBC = "$" + Math.Round((Convert.ToDecimal(objCoin.GetMBC_USDCoin()) + Convert.ToDecimal(mark104)), 2); } catch (Exception ex) { ViewBag.MBC = ex.Message; } return(View()); }
public IHttpActionResult PostSaveSend(string sessiontoken, SendBitcoinViewModel obj) { int Result; //obj.UserId = User.Identity.GetUserId(); if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } if (con.State == ConnectionState.Open) { con.Close(); } // var res = Token.IsTokenValid(sessiontoken); //if(res==false) //{ // Redirect("~/Error.cshtml"); //} con.Open(); SqlCommand cmd1 = new SqlCommand("SP_SaveSend", con); cmd1.CommandType = CommandType.StoredProcedure; //cmd1.Parameters.AddWithValue("@UserId", UserId); //cmd1.Parameters.AddWithValue("@CoinTypeId", CoinTypeId); //cmd1.Parameters.AddWithValue("@BitCoinsFrom", BitCoinsFrom); //cmd1.Parameters.AddWithValue("@DestinationtoBitCoins", DestinationtoBitCoins); //cmd1.Parameters.AddWithValue("@Amount_In_USD", Amount_In_USD); //cmd1.Parameters.AddWithValue("@Amount_In_Coins", Amount_In_Coins); //cmd1.Parameters.AddWithValue("@DescriptionAddress", DescriptionAddress); //cmd1.Parameters.AddWithValue("@FeeTYpe", FeeTYpe); //cmd1.Parameters.AddWithValue("@Insert_Date", Insertdate); obj.ToBitCoin = "aaaa"; obj.FromBitCoin = "Null"; cmd1.Parameters.AddWithValue("@UserId", obj.UserId); cmd1.Parameters.AddWithValue("@CoinTypeId", obj.CoinTypeId); cmd1.Parameters.AddWithValue("@BitCoinsFrom", obj.FromBitCoin); cmd1.Parameters.AddWithValue("@DestinationtoBitCoins", obj.ToBitCoin); cmd1.Parameters.AddWithValue("@Amount_In_USD", obj.AmtInUSD); cmd1.Parameters.AddWithValue("@Amount_In_Coins", obj.AmtInCoins); cmd1.Parameters.AddWithValue("@DescriptionAddress", obj.DesAddress); cmd1.Parameters.AddWithValue("@FeeTYpe", obj.FeeType); cmd1.Parameters.AddWithValue("@Insert_Date", System.DateTime.Now); try { Result = cmd1.ExecuteNonQuery(); } catch (Exception e) { throw e; } con.Close(); if (Result != 0) { return(Ok("Send Amount Saved Successfully")); } else { return(BadRequest("Record not saved , Try again..")); } }