1-) Asp.Net - 26.07.2016 mvc json windows servis web servis mail atma proje bitti
26.07.2016 mvc json windows servis web servis mail atma proje bitti
1-)Anasayfa.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Newtonsoft.Json.Linq;
using Newtonsoft.Json;
using System.Text;
using System.IO;
using System.Data.SqlClient;
using System.Data;
//json.habersoftware.com
namespace arayuzservis
{
public partial class anasayfa : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
object kullanici = Session["k_id"];
if (!IsPostBack)//sayfa ilk yüklenmediğinde
{
//griddoldur("http://localhost:51371/json/getir?kontrol=getir");
griddoldur("http://json.habersoftware.com/json/getir?kontrol=getir");
}
if (kullanici == null)
{
//giriş yapılamadı
Response.Redirect("giris.aspx");
}
}
private void tablecalistir()
{
}
public void btn_kaydet_Click(object sender, EventArgs e)
{
//veriler("http://localhost:51371/json/ekle?per_id=1&per_isim=" + txt_ad.Text + "&per_soyisim=" + txt_soyad.Text + "&per_eposta=" + txt_eposta.Text + "&per_d_tarihi=" + txt_tarih.Text);
//griddoldur("http://json.habersoftware.com//json/getir?kontrol=getir");
veriler("http://json.habersoftware.com/json/ekle?per_id=1&per_isim=" + txt_ad.Text + "&per_soyisim=" + txt_soyad.Text + "&per_eposta=" + txt_eposta.Text + "&per_d_tarihi=" + txt_tarih.Text);
griddoldur("http://json.habersoftware.com/json/getir?kontrol=getir");
}
public void veriler(string link)
{
WebClient c = new WebClient();
string linkk = link;
string json = c.DownloadString(linkk);
if (!json.Equals("\"SQL sorgusunu yaz\""))//mvcjson da veri tabanına ekleme,gunceleme,silme de bu json döner... select yani veri alırken bu dönmez veri döner
{
d_tarihlerini_cek(json);
}
else
{
Response.Write("<script>alert('Başarılı')</script>");
}
}
public void d_tarihlerini_cek(string jsonverisi)//ay ve gun tutarsa alır veri tabanından
{
JObject j = JObject.Parse(jsonverisi);
JArray ja = (JArray)j["personel"];
Console.WriteLine("toplam kayit = " + ja.Count + "\n");
for (int i = 0; i < ja.Count; i++)
{
string pc_ay = DateTime.Now.Month.ToString();
string pc_gun = DateTime.Now.Day.ToString();
string mail = (string)ja[i]["per_eposta"];
string isim = (string)ja[i]["per_isim"];
string soyisim = (string)ja[i]["per_soyisim"];
string ay = DateTime.Parse(ja[i]["per_d_tarihi"].ToString()).Date.Month.ToString();
string gun = DateTime.Parse(ja[i]["per_d_tarihi"].ToString()).Day.ToString();
if (ay.Equals(pc_ay) && gun.Equals(pc_gun))
{
txt_ad.Text = isim;
Response.Write("mail gönder isim =" + isim + "\nsoyisim=" + soyisim + "\neposta=" + mail + "\nay =" + ay + "\ngun =" + gun);
// Console.WriteLine("mail gönder isim =" + isim + "\nsoyisim=" + soyisim + "\neposta=" + mail + "\nay =" + ay + "\ngun =" + gun);
}
}
}
protected void grid_personel_SelectedIndexChanged(object sender, EventArgs e)
{
int selectedRowIndex = grid_personel.SelectedIndex;
GridViewRow row = grid_personel.Rows[selectedRowIndex];
txt_ad.Text = HttpUtility.HtmlDecode(row.Cells[1].Text);
txt_soyad.Text = HttpUtility.HtmlDecode(row.Cells[2].Text);
txt_eposta.Text = HttpUtility.HtmlDecode(row.Cells[3].Text);
txt_tarih.Text = HttpUtility.HtmlDecode(row.Cells[4].Text);
}
protected void btn_sil_Click(object sender, EventArgs e)//epostaya göre siler
{
//veriler("http://localhost:51371/json/ekle?per_id=3&per_eposta=" + txt_eposta.Text);
//griddoldur("http://localhost:51371/json/getir?kontrol=getir");
veriler("http://json.habersoftware.com/json/ekle?per_id=3&per_eposta=" + txt_eposta.Text);
griddoldur("http://json.habersoftware.com/json/getir?kontrol=getir");
}
private void griddoldur(string link)//hepsini alır
{
try
{
WebClient c = new WebClient();
c.Encoding = Encoding.UTF8;
string linkk = link;
string json = c.DownloadString(linkk);
JObject j = JObject.Parse(json);
JArray ja = (JArray)j["personel"];
Console.WriteLine("toplam kayit = " + ja.Count + "\n");
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[4] { new DataColumn("İsim"), new DataColumn("Soyisim"), new DataColumn("E-Posta"), new DataColumn("Doğum Tarihi") });
for (int i = 0; i < ja.Count; i++)
{
string pc_ay = DateTime.Now.Month.ToString();
string pc_gun = DateTime.Now.Day.ToString();
string mail = (string)ja[i]["per_eposta"];
string isim = (string)ja[i]["per_isim"];
string soyisim = (string)ja[i]["per_soyisim"];
string ay = DateTime.Parse(ja[i]["per_d_tarihi"].ToString()).Date.Month.ToString();
string gun = DateTime.Parse(ja[i]["per_d_tarihi"].ToString()).Day.ToString();
string yilll = DateTime.Parse(ja[i]["per_d_tarihi"].ToString()).Year.ToString();
string tarihhh = DateTime.Parse(ja[i]["per_d_tarihi"].ToString()).ToString();
//Response.Write("isim =" + isim + "\nsoyisim=" + soyisim + "\neposta=" + mail + "\ndoğum tarihi=" + tarihhh);
// Console.WriteLine("mail gönder isim =" + isim + "\nsoyisim=" + soyisim + "\neposta=" + mail + "\nay =" + ay + "\ngun =" + gun);
dt.Rows.Add(isim, soyisim, mail, yilll+"-"+ay+"-"+gun);
}
grid_personel.DataSource = dt;
grid_personel.DataBind();
}
catch (Exception E)
{
Response.Write(E.Message.ToString());
}
finally
{
}
}
protected void btn_guncelle_Click(object sender, EventArgs e)
{
//veriler("http://localhost:51371/json/ekle?per_id=2&per_isim=" + txt_ad.Text + "&per_soyisim=" + txt_soyad.Text + "&per_eposta=" + txt_eposta.Text + "&per_d_tarihi=" + txt_tarih.Text);
//griddoldur("http://localhost:51371/json/getir?kontrol=getir");
veriler("http://json.habersoftware.com/json/ekle?per_id=2&per_isim=" + txt_ad.Text + "&per_soyisim=" + txt_soyad.Text + "&per_eposta=" + txt_eposta.Text + "&per_d_tarihi=" + txt_tarih.Text);
griddoldur("http://json.habersoftware.com/json/getir?kontrol=getir");
}
protected void grid_personel_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
grid_personel.PageIndex = e.NewPageIndex;
//griddoldur("http://localhost:51371/json/getir?kontrol=getir");
griddoldur("http://json.habersoftware.com/json/getir?kontrol=getir");
}
protected void btn_ara_Click(object sender, EventArgs e)//hepsi boşşa tablonun hepsini getirir.
{
//griddoldur("http://localhost:51371/json/ekle?per_id=4&per_isim=" + txt_ad.Text + "&per_soyisim=" + txt_soyad.Text + "&per_eposta=" + txt_eposta.Text + "&per_d_tarihi=" + txt_tarih.Text);
griddoldur("http://json.habersoftware.com/json/ekle?per_id=4&per_isim=" + txt_ad.Text + "&per_soyisim=" + txt_soyad.Text + "&per_eposta=" + txt_eposta.Text + "&per_d_tarihi=" + txt_tarih.Text);
}
}
}
2-)masteranasayfa.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace arayuzservis
{
public partial class masteranasayfa : System.Web.UI.MasterPage
{
protected void Page_Load(object sender, EventArgs e)
{
cikisss.Style["display"] = aktif;
// girisss.Style["display"] = displayy;
Enterr.Style["display"] = displayy;
}
protected void btn_giris_Click(object sender, EventArgs e)
{
if (k_id.Text.Equals("ramazan") && k_sifre.Text.Equals("haber"))
{
masteranasayfa.displayy = "none";
masteranasayfa.aktif = "normal";
Session.Add("k_id", k_id.Text);
Response.Redirect("anasayfa.aspx");
}
}
public static string displayy = "normal", aktif = "none";
protected void cikisss_Click(object sender, EventArgs e)
{
masteranasayfa.displayy = "normal";
masteranasayfa.aktif = "none";
Session.Abandon();//degerleri yok eder
Response.Redirect("giris.aspx");
}
}
}