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