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";
}
}