public void commandProcess(string command, string fakulte_ID) { int deleteFakulteId = Convert.ToInt32(fakulte_ID); SyllabusDbEntities db; using (db = new SyllabusDbEntities()) { Fakulte hocam = db.Fakultes.FirstOrDefault(f => f.fakulte_ID == deleteFakulteId); db.DeleteObject(hocam); db.SaveChanges(); } AddStore(); }
protected void btn_Save_Click(object sender, DirectEventArgs e) { int fakId = Convert.ToInt32(cmbx_fakulte.Value); int subeSayisi = Convert.ToInt32(txt_subeSayisi.Text); SyllabusDbEntities db; using (db = new SyllabusDbEntities()) { Bolum bolum = new Bolum(); bolum.fakulte_ID = fakId; bolum.bolum_Kodu = txt_bolumKodu.Text; bolum.bolum_Adi = txt_bolumAdi.Text; bolum.bolum_Baskani_Kodu = txt_baskanKod.Text; bolum.sube_Sayisi = subeSayisi; db.AddToBolums(bolum); db.SaveChanges(); } AddStore(); ClearText(); }
protected void btn_Save_Click(object sender, DirectEventArgs e) { int dekanKod = Convert.ToInt32(txt_dekanKod.Text); int dekanYardKod = 123; int dekanYard2Kod = 123; SyllabusDbEntities db; using (db = new SyllabusDbEntities()) { Fakulte fakulte = new Fakulte(); fakulte.fakulte_Kodu = txt_kod.Text; fakulte.fakulte_Adi = txt_fakulteAdi.Text; fakulte.fakulte_Kisa_Adi = txt_kisaAdi.Text; fakulte.fakulte_Dekani_ID = dekanKod; fakulte.fakulte_Dekan_Yard_ID = dekanYardKod; fakulte.fakulte_Dekan_Yard2_ID = dekanYard2Kod; db.AddToFakultes(fakulte); db.SaveChanges(); } AddStore(); ClearText(); }
protected void btnLogin_Click(object sender, DirectEventArgs e) { string userName = this.txtUserName.Text; string password = this.txtPassword.Text; Regex aNumericRgx = new Regex("^[a-zA-Z0-9]*$"); if (aNumericRgx.IsMatch(userName) == true && aNumericRgx.IsMatch(password) == true) { string loginResponse = userLoginControl.doLogin(userName, password); if (loginResponse == "1") { Guid sessionId = Guid.NewGuid(); Session["dp_user"] = txtUserName.Text; Session["dp_sessionid"] = sessionId.ToString(); //db ye session id yi kaydet SyllabusDbEntities db; using (db = new SyllabusDbEntities()) { var user = (from kullanici in db.Kullanicis where kullanici.KULLANICI_ID == userName select kullanici).FirstOrDefault(); user.KULLANICI_OTURUM_ID = sessionId.ToString(); db.SaveChanges(); } Response.Redirect("Default.aspx"); } else { lblResponse.Text = loginResponse; } } else { lblResponse.Text = "Kullanıcı adı veya parolada özel karakter kullanılamaz"; } }