// KAYIT KONTROL var SablonAra = (from x in db.VY_Sablonlar where x.unvan == drpUnvan.SelectedItem.Text && x.bolum == drpBolum.SelectedItem.Text select x); if(SablonAra.Count() > 0){ Response.Redirect("PersonelTalep02.aspx?id=" + son_id); } else { Response.Redirect("Error.aspx?id=15&data="+ drpUnvan.SelectedItem.Text + "&bolum=" + drpBolum.SelectedItem.Text+"&err="); } /// Personel detay int cPID = Convert.ToInt32( Request.Cookies["pid"].Value ); var getPerson = (from p in db.Personel where p.pid == cPID select new { p.adi_soyadi } ).FirstOrDefault(); // Guncelleme PersonelTalepAday query = (from d in db.PersonelTalepAday where d.pt_id == get_talep && d.aday_id == get_id select d).FirstOrDefault(); query.plan_gorusme = Convert.ToDateTime(txtPlanGorusme.Text).ToLocalTime(); db.SaveChanges(); // Ekleme PersonelTalepleriLog rec_log = new PersonelTalepleriLog(); rec_log.pt_id = getPT; rec_log.karakter = "DEMIRBAS"; rec_log.detay = query.model + " envanteri " + getPerson.adi_soyadi + " tarafından verildi."; rec_log.otarih = DateTime.Now.ToLocalTime(); rec_log.ouser = Request.Cookies["kadi"].Value; db.PersonelTalepleriLog.Add(rec_log); db.SaveChanges(); // SQL SqlConnection baglanti = new SqlConnection(ConfigurationManager.ConnectionStrings["connBaglanti"].ToString()); string sql = @"SELECT * FROM PersonelSAP6031"; string connString = ConfigurationManager.ConnectionStrings["connBaglanti"].ConnectionString; SqlConnection conn = new SqlConnection(connString); SqlCommand comm = new SqlCommand(sql, conn); SqlDataReader reader; conn.Open(); reader = comm.ExecuteReader(); Repeater1.DataSource = reader; Repeater1.DataBind(); // <%#Eval(String.Format("{0:#,###}", "fiyat"))%> // uzak sitesden veri çekemk uzakadres = "http://tirsan.yalinfikir.com/getOnaylaGetir.asp?ptid=" + _talep.pt_id.ToString(); WebRequest gelenIstek = HttpWebRequest.Create(uzakadres); WebResponse gelenCevap = gelenIstek.GetResponse(); StreamReader sr = new StreamReader(gelenCevap.GetResponseStream()); string gelenBilgi = sr.ReadToEnd(); // seçilileri aktif etme DropDownList1.ClearSelection(); DropDownList1.Items.FindByValue(Convert.ToString(_id)).Selected = true; // Mesaj Yonlendirmesi Response.Redirect("Message.aspx?baslik=İşlem Tamam!&mesaj=Bilgiler Güncellendi&url=PRTP_PrototipAtolye02.aspx?do=lZ2QCAw9kFhgCAQ8WAh4JaW5uZXJo&id=" + get_id + "&tip=success"); Response.Redirect("Message.aspx?baslik=İşlem Tamam!&mesaj=İş Kapatıldı&url=PersonelCikis_PYO.aspx&tip=success"); // Get s public int GetPID() { try { return Convert.ToInt32(Request.Cookies["pid"].Value); } catch { return 0; } } public string GetKadi() { try { return Request.Cookies["pid"].Value; } catch { return "YOK"; } } //Update command int noOfRowUpdated = ctx.Database.ExecuteSqlCommand("Update student set studentname ='changed student by command' where studentid=1"); //Insert command int noOfRowInserted = ctx.Database.ExecuteSqlCommand("insert into student(studentname) values('New Student')"); //Delete command int noOfRowDeleted = ctx.Database.ExecuteSqlCommand("delete from student where studentid=1"); txtYasAraligi.Text == null ? "Farketmez" : txtYasAraligi.Text; Fonksiyonlar f = new Fonksiyonlar(); int sonuc = f.PersonelTalepMailKS(get_id); if (sonuc == 1) { div_hatamesaji.Visible = true; div_hatamesaji.InnerHtml = "ok"; } else { div_hatamesaji.Visible = true; div_hatamesaji.InnerHtml = "HATA:DKO01"; } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertMsg", "<script language='javascript'>alert('" + ex.Message + "' );</script>", false); Eval("soDateTo", "{0:dd/MM/yyyy}") , "{0:dd MMMM yyyy dddd}" // Connection String oluşturuyoruz. string sqlConn = "server=localhost; database=Veritabani; trusted_connection=true;"; SqlConnection conn = new SqlConnection(sqlConn); string cmdText = "select * from tabloadi where koşul order by Alanadi"; SqlCommand cmd = new SqlCommand(cmdText, conn); conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ListBox1.Items.Add(dr.GetString(0)); } dr.Close(); conn.Close(); DateTime oTalepTar = Convert.ToDateTime(getPerson.talep_tarihi.ToString()); hTitle.InnerHtml = "İMHA TUTANAĞI / " + oTalepTar.ToString("dd MMMM yyyy dddd", CultureInfo.CreateSpecificCulture("tr-TR")); <%#(Eval("Data") == null ? "0" : Eval("Data"))%> <%# String.Format( new System.Globalization.CultureInfo("tr-TR"), "{0:d MMMM yyyy dddd}", Eval("departman_onay_tar")) %> <script type="text/javascript"> document.getElementById("mn7").className = "treeview active"; document.getElementById("mn_ul7").className = "treeview-menu menu-open"; document.getElementById("mn_ul7").style["display"] = "block;"; document.getElementById("mna39").className = "active"; </script> try { } catch(Exception ex) { log.Error(ex.Message); log.Info("Belge durumu yuklenemedi"); } // kayit sayisi bulma var btonay = (from a in db.VY_EnvanterTalep where a.bt_onay == "NG" select a).Count(); CounterBTONAY.InnerHtml = btonay.ToString(); Logger logger = LogManager.GetCurrentClassLogger(); string filter_mail = getPerson.email.ToLower(new CultureInfo("en-US", false)); if (!Page.IsPostBack) { } document.getElementById('dvm_proje').style.display = 'block'; string cPernr = Request.Cookies["pernr"].Value; var getOnaylayan = (from i in db.TirsanPersonel where i.pernr == cPernr select i).FirstOrDefault(); // grid export protected void btnExport_Click(object sender, EventArgs e) { try { ASPxGridViewExporter1.DataBind(); ASPxGridViewExporter1.WriteXlsxToResponse(); } catch (Exception e1) { // } } <%# (Container.ItemIndex+1) % 4 == 0 ? "</div><div class='row'>" : "" %> // drp seçili drpDoviz6.DataSource = (from db_varlik in db.VY_Combo where db_varlik.tanim == "DOVIZ_KURU" select db_varlik).ToList(); drpDoviz6.DataTextField = "deger"; drpDoviz6.DataValueField = "deger"; drpDoviz6.DataBind(); drpDoviz6.ClearSelection(); drpDoviz6.Items.FindByValue(Convert.ToString(_ikinciel)).Selected = true; <td><%# String.Format( new System.Globalization.CultureInfo("tr-TR"), "{0:d MMMM yyyy dddd}", Eval("talep_tarihi")) %></td> Dun.ToString("dd MMMM yyyy dddd", CultureInfo.CreateSpecificCulture("tr-TR")) onkeyup= "javascript:this.value=this.value.toUpperCase()" ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertMsg", "<script language='javascript'>window.opener.location.reload();window.close();</script>", false); fn.NotEkle("envanter_talep", oID, cPernr, not_mesaj, 0); fn.TimeLine("fa fa-trash bg-maroon", cPernr, oID + "/" +oKalemId + " kalem numaralı talebi çıkarttı"); <div class="row"> <div class="col-md-6"> </div> <div class="col-md-6"> </div> </div> (Dns.GetHostEntry(Request.ServerVariables["remote_addr"]).HostName); $("button").click(function(){ $.post("demo_test_post.asp", { name: "Donald Duck", city: "Duckburg" }, function(data, status){ alert("Data: " + data + "\nStatus: " + status); }); }); var searchTerm = ".NET"; var blogs = context.Blogs .FromSql($"SELECT * FROM dbo.SearchBlogs({searchTerm})") .Where(b => b.Rating > 3) .OrderByDescending(b => b.Rating) .ToList(); Repeater2.DataSource = db.isci_sicil.SqlQuery("select * from isci_sicil where aktif_pasif='AKTIF' and sicil_no not in (select sicil_no from isci_tahak where tah_yil="+ tYil.ToString() + " and tah_ay="+ tAy.ToString() + ")").ToList(); Repeater2.DataBind();
No comment