private String Sinhmatudong() { DataSet1TableAdapters.QueriesTableAdapter q = new DataSet1TableAdapters.QueriesTableAdapter(); String somabn = "00" + q.getSOMABN().ToString(); somabn = somabn.Substring(somabn.Length - 3, 3); return("BN" + somabn); }
public FormKPiR() { DataBase = new DBContact(); InitializeComponent(); textBoxPiROd.Text = DateTime.Today.AddDays(1 - DateTime.Today.Day).ToShortDateString(); textBoxPiRDo.Text = DateTime.Today.ToShortDateString(); queries = new DataSet1TableAdapters.QueriesTableAdapter(); filtrAkcje = new List <string>(); filtrKonta = new List <string>(); filtrKoord = new List <string>(); val = -1; }
public Almacenaje() { //Se instancian los elementos necesarios del dataset DataSetLocal = new DataSet1(); adaptadorUsuarios = new DataSet1TableAdapters.UsuarioTableAdapter(); adaptadorReceta = new DataSet1TableAdapters.RecetaTableAdapter(); adaptadorRecetaConfirmada = new DataSet1TableAdapters.Receta_Confirmada1TableAdapter(); adaptadorModerador = new DataSet1TableAdapters.ModeradorTableAdapter(); adaptadorAdministrador = new DataSet1TableAdapters.AdministradorTableAdapter(); adaptadorEspecialista = new DataSet1TableAdapters.EspecialistaTableAdapter(); adaptadorRestaurante = new DataSet1TableAdapters.RestauranteTableAdapter(); adaptadorRecetaAModificar = new DataSet1TableAdapters.Receta_A_ModificarTableAdapter(); adaptadorForo = new DataSet1TableAdapters.MensajeForoTableAdapter(); adaptadorMensajePrivado = new DataSet1TableAdapters.MensajePrivadoTableAdapter(); adaptadorConsultas = new DataSet1TableAdapters.QueriesTableAdapter(); adaptadorProductos = new DataSet1TableAdapters.ProductoTableAdapter(); adaptadorPedidos = new DataSet1TableAdapters.PedidoTableAdapter(); adaptadorComentario = new DataSet1TableAdapters.ComentarioTableAdapter(); }
protected void ASPxButton1_Click(object sender, EventArgs e) { if (ASPxTextBox1.Text != "" || ASPxTextBox2.Text != "" || ASPxTextBox3.Text != "" || ASPxTextBox4.Text != "") { DataSet1TableAdapters.TBLMUSTERITableAdapter dt = new DataSet1TableAdapters.TBLMUSTERITableAdapter(); dt.MusteriEkle(ASPxTextBox1.Text, ASPxTextBox2.Text, ASPxTextBox3.Text, ASPxDateEdit1.Text, ASPxRadioButtonList1.SelectedItem.Text, ASPxTextBox4.Text); String odano; DataSet1TableAdapters.QueriesTableAdapter dto = new DataSet1TableAdapters.QueriesTableAdapter(); odano = Convert.ToString(dto.odano()); ASPxLabel6.Text = "Kayıt Başarılı. Oda Numaranız : " + odano; ASPxTextBox1.Text = ""; ASPxTextBox2.Text = ""; ASPxTextBox3.Text = ""; ASPxTextBox4.Text = ""; DataSet1TableAdapters.TBLODATableAdapter dton = new DataSet1TableAdapters.TBLODATableAdapter(); dton.Odadurum(odano); } else { ASPxLabel6.Text = "Lütfen * ile belirtilen kısımları doldurunuz."; } }
protected void Button1_Click(object sender, EventArgs e) { if (ASPxCaptcha1.IsValid) { int oda = 0; if (Convert.ToInt32(ASPxSpinEdit1.Text) == 1) { DataSet1TableAdapters.QueriesTableAdapter dtq = new DataSet1TableAdapters.QueriesTableAdapter(); oda = Convert.ToInt32(dtq.Tekodalar()); if (oda == 0) { ASPxLabel9.Text = "Aradığınız türde bir oda bulunmamaktadır."; } else { dt.UlkeSayac(Cmb1.SelectedItem.Text); DataSet1TableAdapters.TBLISLEMTableAdapter dtb = new DataSet1TableAdapters.TBLISLEMTableAdapter(); dtb.ISLEMEKLE(oda, ASPxDateEdit1.Text, ASPxDateEdit2.Text, ASPxSpinEdit1.Text); Response.Redirect("/Kayit.aspx"); } } if (Convert.ToInt32(ASPxSpinEdit1.Text) == 2) { DataSet1TableAdapters.QueriesTableAdapter dtq = new DataSet1TableAdapters.QueriesTableAdapter(); oda = Convert.ToInt32(dtq.İkiliodalar()); if (oda == 0) { ASPxLabel9.Text = "Aradığınız türde bir oda bulunmamaktadır."; } else { dt.UlkeSayac(Cmb1.SelectedItem.Text); DataSet1TableAdapters.TBLISLEMTableAdapter dtb = new DataSet1TableAdapters.TBLISLEMTableAdapter(); dtb.ISLEMEKLE(oda, ASPxDateEdit1.Text, ASPxDateEdit2.Text, ASPxSpinEdit1.Text); Response.Redirect("/Kayit.aspx"); } } if (Convert.ToInt32(ASPxSpinEdit1.Text) == 3) { DataSet1TableAdapters.QueriesTableAdapter dtq = new DataSet1TableAdapters.QueriesTableAdapter(); oda = Convert.ToInt32(dtq.Ucluodalar()); if (oda == 0) { ASPxLabel9.Text = "Aradığınız türde bir oda bulunmamaktadır."; } else { dt.UlkeSayac(Cmb1.SelectedItem.Text); DataSet1TableAdapters.TBLISLEMTableAdapter dtb = new DataSet1TableAdapters.TBLISLEMTableAdapter(); dtb.ISLEMEKLE(oda, ASPxDateEdit1.Text, ASPxDateEdit2.Text, ASPxSpinEdit1.Text); Response.Redirect("/Kayit.aspx"); } } if (Convert.ToInt32(ASPxSpinEdit1.Text) == 4) { DataSet1TableAdapters.QueriesTableAdapter dtq = new DataSet1TableAdapters.QueriesTableAdapter(); oda = Convert.ToInt32(dtq.Dortluodalar()); if (oda == 0) { ASPxLabel9.Text = "Aradığınız türde bir oda bulunmamaktadır."; } else { dt.UlkeSayac(Cmb1.SelectedItem.Text); DataSet1TableAdapters.TBLISLEMTableAdapter dtb = new DataSet1TableAdapters.TBLISLEMTableAdapter(); dtb.ISLEMEKLE(oda, ASPxDateEdit1.Text, ASPxDateEdit2.Text, ASPxSpinEdit1.Text); Response.Redirect("/Kayit.aspx"); } } } else { ASPxLabel5.Text = "Valla billa robot değilim"; } }