Asp.NET Webform snippets

// 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

Bir cevap yazın

E-posta hesabınız yayımlanmayacak.