private void frmPaymentList_Load(object sender, EventArgs e)
{
SqlClass sqlCon = new SqlClass();
sqlCon.ListData(dtgridPaymentList, DateTime.Now, DateTime.Now);
dtgridPaymentList.Columns[0].HeaderText = "Numarası";
dtgridPaymentList.Columns[1].HeaderText = "Ödeme Şekli";
dtgridPaymentList.Columns[2].HeaderText = "Ödeme Tipi";
dtgridPaymentList.Columns[3].HeaderText = "TL";
dtgridPaymentList.Columns[3].DefaultCellStyle.Format = "N";
dtgridPaymentList.Columns[4].HeaderText = "Euro";
dtgridPaymentList.Columns[4].DefaultCellStyle.Format = "N";
dtgridPaymentList.Columns[5].HeaderText = "Dolar";
dtgridPaymentList.Columns[5].DefaultCellStyle.Format = "N";
dtgridPaymentList.Columns[6].HeaderText = "Müşteri_id";
dtgridPaymentList.Columns[7].HeaderText = "Müşteri";
dtgridPaymentList.Columns[8].HeaderText = "Tarih";
dtgridPaymentList.Columns[0].Visible = false;
dtgridPaymentList.Columns[6].Visible = false;
}
private void frmKisiListesi_Load(object sender, EventArgs e)
{
SqlClass sqlCon = new SqlClass();
String bag;
// MySqlConnectionStringBuilder build = new MySqlConnectionStringBuilder();
DataSet dSet = new DataSet();
//build.Server = "localhost";
//build.UserID = "root";
//build.Password = "******";
//build.Database = "case_follow";
//build.Port = 3306;
//
DataGridView stock_list = new DataGridView();
stock_list.Name = "stock_list";
//SqlClass sqlCon = new SqlClass();
SqlClass connect = new SqlClass();
connect.ConnectSql();
String sql2 = "SELECT ID, NAME, SURNAME FROM customer_list ";
//if (DataGridList.Name == "dtgridSalesList")
// sql = sql + " ORDER BY SALE_CODE";
DataTable dtable2 = new DataTable();
MySqlDataAdapter adapter2 = new MySqlDataAdapter();
MySqlCommand command2 = new MySqlCommand();
bag = build.ToString();
baglanti = new MySqlConnection(bag);
command2.CommandText = sql2;
command2.Connection = baglanti;
adapter2.SelectCommand = command2;
baglanti.Open();
adapter2.Fill(dtable2);
adapter2.Fill(dSet);
stock_list.DataSource = dtable2;
dtgrdList.DataSource = dtable2;
baglanti.Close();
// sqlCon.ListData(dtgrdStockList, DateTime.Now, DateTime.Now);
dtgrdList.Columns[0].HeaderText = "ID";
dtgrdList.Columns[1].HeaderText = "Adı";
dtgrdList.Columns[2].HeaderText = "Soyadı";
dtgrdList.Columns[0].Visible = false;
}
private void frmStockList_Load(object sender, EventArgs e)
{
SqlClass sqlCon = new SqlClass();
sqlCon.ListData(dtgrdStockList, DateTime.Now, DateTime.Now);
dtgrdStockList.Columns[0].HeaderText = "Numarası";
dtgrdStockList.Columns[1].HeaderText = "Stok Adı";
dtgrdStockList.Columns[2].HeaderText = "Stok Kodu";
dtgrdStockList.Columns[3].HeaderText = "Kayıt Tarihi";
/// dtgrdStockList.Columns[4].HeaderText = "Alan Firma/Kişi";
// dtgrdStockList.Columns[5].HeaderText = "Fiyatı";
// dtgrdStockList.Columns[6].HeaderText = "Ödeme Cinsi";
// dtgrdStockList.Columns[7].HeaderText = "Kayıt Tarihi";
dtgrdStockList.Columns[0].Visible = false;
}
private void button2_Click(object sender, EventArgs e)
{
if (((tbName.Text.Trim() == "") || (tbSurname.Text.Trim() == "")) && (tbfirmname.Text.Trim() == ""))
{
MessageBox.Show("Tam ad giriniz ve ya Firma adını giriniz", "Bilgilendirme Mesajı");
}
else
{
SqlClass sqlConn = new SqlClass();
sqlConn.AddPerson(tbName.Text, tbSurname.Text, tbfirmname.Text, tbTelNum.Text, tbadres.Text);
tbName.Text = " ";
tbSurname.Text = " ";
tbfirmname.Text = " ";
tbTelNum.Text = " ";
tbadres.Text = " ";
label2.Visible = true;
}
}
private void dtgrdStockList_CellEnter(object sender, DataGridViewCellEventArgs e)
{
String lvSL_CODE;
try
{
lvSL_CODE = dtgrdStockList.CurrentRow.Cells["CODE"].Value.ToString();
}
catch
{
lvSL_CODE = "0";
}
SqlClass sqlCon = new SqlClass();
String bag;
DataSet dSet = new DataSet();
SqlClass connect = new SqlClass();
connect.ConnectSql();
String sql2 = "SELECT SLC.KISI_ADI, SLC.ODEMETIPI, SLC.* FROM stock_list_case SLC WHERE SLC.CODE = " + "'" + lvSL_CODE + "'";
DataTable dtable2 = new DataTable();
MySqlDataAdapter adapter2 = new MySqlDataAdapter();
MySqlCommand command2 = new MySqlCommand();
bag = build.ToString();
baglanti = new MySqlConnection(bag);
command2.CommandText = sql2;
command2.Connection = baglanti;
adapter2.SelectCommand = command2;
baglanti.Open();
adapter2.Fill(dtable2);
adapter2.Fill(dSet);
dtgrdDetail.DataSource = dtable2;
baglanti.Close();
// sqlCon.ListData(dtgrdStockList, DateTime.Now, DateTime.Now);
dtgrdDetail.Columns[0].HeaderText = "Kişi/Firma Adı";
dtgrdDetail.Columns[1].HeaderText = "Ödeme Tipi";
dtgrdDetail.Columns[2].HeaderText = "detayId";
dtgrdDetail.Columns[3].HeaderText = "CL_ID";
dtgrdDetail.Columns[4].HeaderText = "TL";
dtgrdDetail.Columns[4].DefaultCellStyle.Format = "N";
dtgrdDetail.Columns[5].HeaderText = "Dolar";
dtgrdDetail.Columns[5].DefaultCellStyle.Format = "N";
dtgrdDetail.Columns[6].HeaderText = "Euro";
dtgrdDetail.Columns[6].DefaultCellStyle.Format = "N";
dtgrdDetail.Columns[7].HeaderText = "Ödeme Tipi";
dtgrdDetail.Columns[8].HeaderText = "Kaç Adet?";
dtgrdDetail.Columns[9].HeaderText = "Kişi/Firma Adı";
dtgrdDetail.Columns[10].HeaderText = "Stok Kodu";
dtgrdDetail.Columns[11].HeaderText = "Tarih";
dtgrdDetail.Columns[12].HeaderText = "SL_ID";
dtgrdDetail.Columns[1].Visible = false;
dtgrdDetail.Columns[2].Visible = false;
dtgrdDetail.Columns[3].Visible = false;
dtgrdDetail.Columns[10].Visible = false;
dtgrdDetail.Columns[9].Visible = false;
dtgrdDetail.Columns[12].Visible = false;
dtgrdDetail.AllowUserToAddRows = false;
}
private void frmCusumerCase_Load(object sender, EventArgs e)
{
string yr3, m3, d3;
string yr, m, d, yr2, m2, d2;
yr = dateTimePicker1.Value.Year.ToString();
m = dateTimePicker1.Value.Month.ToString();
d = dateTimePicker1.Value.Day.ToString();
yr2 = dateTimePicker2.Value.Year.ToString();
m2 = dateTimePicker2.Value.Month.ToString();
d2 = dateTimePicker2.Value.Day.ToString();
yr3 = DateTime.Now.Year.ToString();
m3 = DateTime.Now.Month.ToString();
d3 = DateTime.Now.Day.ToString();
int d4 = Convert.ToInt32(d3) + 1;
SqlClass sqlCon = new SqlClass();
//sqlCon.ListData(customer_list, DateTime.Now, DateTime.Now);
sqlCon.ConnectSql();
String sql = "SELECT CL.*, CL.ID AS CL_ID FROM customer_list CL Where CL.DATE BETWEEN '" + yr + "-" + m + "-" + d + "' AND " + "'" + yr2 + "-" + m2 + "-" + d2 + "'";
//" SELECT CL.*, CC.*,cl.DATE FROM customer_case cc INNER JOIN customer_list cl ON cl.ID = cc.CL_ID";
//if (DataGridList.Name == "dtgridSalesList")
// sql = sql + " ORDER BY SALE_CODE";
DataTable dt = new DataTable();
adapter = new MySqlDataAdapter();//MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand();
command.CommandText = sql;
command.Connection = baglanti;
adapter.SelectCommand = command;
//baglanti.Open();
adapter.Fill(dt);
customer_list.DataSource = dt;
baglanti.Close();
customer_list.Columns[0].HeaderText = "ID";
customer_list.Columns[1].HeaderText = "Adı";
customer_list.Columns[2].HeaderText = "Soyadı";
customer_list.Columns[3].HeaderText = "Adres";
customer_list.Columns[4].HeaderText = "Telefon Numarası";
customer_list.Columns[5].HeaderText = "Firma Adı";
customer_list.Columns[6].HeaderText = "Kayıt Tarihi";
customer_list.Columns[7].HeaderText = "IDW";
customer_list.Columns[0].Visible = false;
customer_list.Columns[7].Visible = false;
customer_list.AllowUserToAddRows = false;
// SqlClass sqlCon = new SqlClass();
//sqlCon.ListData(customer_list, DateTime.Now, DateTime.Now);
//sqlCon.ConnectSql();
String sqlTotal2 = "SELECT CC.ODEMETIPI,SUM(CC.TL) AS TL, SUM(CC.EURO) AS EURO, SUM(CC.DOLAR) AS DOLAR FROM customer_case cc WHERE DATE BETWEEN '"
+ yr3 + "-" + m3 + "-" + d3 + "' AND " + "'" + yr3 + "-" + m3 + "-" + d4 + "'" + " GROUP BY CC.ODEMETIPI";
//if (DataGridList.Name == "dtgridSalesList")
// sql = sql + " ORDER BY SALE_CODE";
DataTable dtTotal2 = new DataTable();
MySqlDataAdapter adapterTotal2 = new MySqlDataAdapter();
MySqlCommand commandTotal2 = new MySqlCommand();
commandTotal2.CommandText = sqlTotal2;
commandTotal2.Connection = baglanti;
adapterTotal2.SelectCommand = commandTotal2;
//baglanti.Open();
adapterTotal2.Fill(dtTotal2);
grdCase_Total.DataSource = dtTotal2;
baglanti.Close();
grdCase_Total.Columns[0].HeaderText = "Ödeme Tipi";
grdCase_Total.Columns[1].HeaderText = "TL";
grdCase_Total.Columns[1].DefaultCellStyle.Format = "N";
grdCase_Total.Columns[2].HeaderText = "€";
grdCase_Total.Columns[2].DefaultCellStyle.Format = "N";
grdCase_Total.Columns[3].HeaderText = "$";
grdCase_Total.Columns[3].DefaultCellStyle.Format = "N";
// customer_list.Columns[0].Visible = false;
String id;
int lvD = 0; int lvT = 0; int lvE = 0;
}
private void btnQueryStock_Click_1(object sender, EventArgs e)
{
string yr, m, d, yr2, m2, d2;
yr = dateTimePicker1.Value.Year.ToString();
m = dateTimePicker1.Value.Month.ToString();
d = dateTimePicker1.Value.Day.ToString();
yr2 = dateTimePicker2.Value.Year.ToString();
m2 = dateTimePicker2.Value.Month.ToString();
d2 = dateTimePicker2.Value.Day.ToString();
SqlClass sqlCon = new SqlClass();
sqlCon.ConnectSql();
String sql = "SELECT cl.*,cl.ID AS CL_ID FROM customer_list CL Where CL.DATE BETWEEN '" + yr + "-" + m + "-" + d + "' AND " + "'" + yr2 + "-" + m2 + "-" + d2 + "'";
DataTable dt = new DataTable();
adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand();
command.CommandText = sql;
command.Connection = baglanti;
adapter.SelectCommand = command;
//baglanti.Open();
adapter.Fill(dt);
customer_list.DataSource = dt;
baglanti.Close();
customer_list.Columns[0].HeaderText = "ID";
customer_list.Columns[1].HeaderText = "Adı";
customer_list.Columns[2].HeaderText = "Soyadı";
customer_list.Columns[3].HeaderText = "Firma Adı";
customer_list.Columns[4].HeaderText = "Telefon Numarası";
customer_list.Columns[5].HeaderText = "Adres";
customer_list.Columns[6].HeaderText = "Kayıt Tarihi";
customer_list.Columns[7].HeaderText = "IDW";
customer_list.Columns[0].Visible = false;
customer_list.Columns[7].Visible = false;
customer_list.AllowUserToAddRows = false;
String lvCL_ID;
//dataSet = null;
try
{
lvCL_ID = customer_list.CurrentRow.Cells["ID"].Value.ToString();
}
catch
{
lvCL_ID = "0";
}
String sqlTotal3 = "SELECT * FROM customer_case CC where CC.CL_ID = " + "'" + lvCL_ID + "'";
DataTable dtTotal3 = new DataTable();
dataSet = new DataSet();
adapter = new MySqlDataAdapter();
MySqlCommand commandTotal3 = new MySqlCommand();
commandTotal3.CommandText = sqlTotal3;
commandTotal3.Connection = baglanti;
adapter.SelectCommand = commandTotal3;
if (baglanti.State == ConnectionState.Closed)
{
baglanti.Open();
}
adapter.Fill(dtTotal3);
adapter.Fill(dataSet, "customer_case");
grdCusCasDetail.DataSource = dataSet.Tables[0];//dtTotal3;
baglanti.Close();
grdCusCasDetail.Columns[0].HeaderText = "CL_ID";
grdCusCasDetail.Columns[1].HeaderText = "TL";
grdCusCasDetail.Columns[1].DefaultCellStyle.Format = "N";
grdCusCasDetail.Columns[2].HeaderText = "€";
grdCusCasDetail.Columns[2].DefaultCellStyle.Format = "N";
grdCusCasDetail.Columns[3].HeaderText = "$";
grdCusCasDetail.Columns[3].DefaultCellStyle.Format = "N";
grdCusCasDetail.Columns[4].HeaderText = "Ödeme Tipi";
grdCusCasDetail.Columns[5].HeaderText = "ID";
grdCusCasDetail.Columns[0].Visible = false;
grdCusCasDetail.Columns[5].Visible = false;
}
