protected void Page_Load(object sender, EventArgs e)
{
String a = "SELECT * FROM [dvs_chart] WHERE [ChartId] = " + 15;
DataTable t = DatabaseClass.ExecuteQuery(a);
drawchart(t);
}
private void loadGrid()
{
DatabaseClass d = new DatabaseClass();
try
{
d.openDb();
var s = "select * from barang";
dt = new DataTable();
dt = d.read(s);
/*
* Console.WriteLine(dt.Rows.Count.ToString());
* if (dt.Rows.Count == 0)
* {
* DataRow row = dt.NewRow();
* dt.Rows.Add(row);
* }
* */
gv.DataSource = dt;
gv.DataBind();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
d.closeDB();
}
}
protected void bt_simpan_Click(object sender, EventArgs e)
{
DatabaseClass d = new DatabaseClass();
string id = tb_id.Text.ToString();
string nama = tb_nama.Text.ToString();
string jenis = tb_jenis.Text.ToString();
string harga = tb_harga.Text.ToString();
if (nama.Length == 0 || jenis.Length == 0 || harga.Length == 0)
{
return;
}
try
{
d.openDb();
var s = "insert into barang values " +
"('" + id + "', '" + nama + "', '" + jenis + "', " + harga + ")";
d.execute(s);
loadGrid();
kosong();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
d.closeDB();
}
}
protected void onRowUpdating(object sender, GridViewUpdateEventArgs e)
{
DatabaseClass d = new DatabaseClass();
try
{
string id = (gv.Rows[e.RowIndex].FindControl("lbl_id") as Label).Text.ToString().Trim();
string nama = (gv.Rows[e.RowIndex].FindControl("tb_nama") as TextBox).Text.ToString().Trim();
string jenis = (gv.Rows[e.RowIndex].FindControl("tb_jenis") as TextBox).Text.ToString();
string harga = (gv.Rows[e.RowIndex].FindControl("tb_harga") as TextBox).Text.ToString().Trim();
d.openDb();
var s = "update barang set nama = '" + nama + "', jenis = '" + jenis + "', " +
"harga = " + harga + " where id_barang = '" + id + "'";
Console.WriteLine(s);
d.execute(s);
onRowCancelingEdit(null, null);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
d.closeDB();
}
}
public void drawchart(DataTable t)
{
String s = "SELECT " + t.Rows[0][5].ToString() + ", " + t.Rows[0][7].ToString() + " FROM [" + t.Rows[0][1].ToString() + " ];";
//DrawSaved_ChartUserControl.assingDataPoint(s);
//String connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
//SqlConnection connection = new SqlConnection(connectionstring);
//connection.Open();
//SqlCommand cmd = new SqlCommand(s, connection);
//SqlDataReader reader = cmd.ExecuteReader();
DrawSaved_ChartUserControl.READER = DatabaseClass.ExequteReaderQuery(s);
//DrawSaved_ChartUserControl.READER = reader;
//Chart1.Series["Series1"].Points.DataBindXY(reader, "xAxis", reader, "yaxis");
//Chart1.DataManipulator.Sort(PointSortOrder.Descending, "Series1");
//Chart1.DataManipulator.GroupByAxisLabel("SUM","Series1");
if (DatabaseClass.getTableDatafromTable(t.Rows[0][1].ToString()) != null)
{
DrawSaved_ChartUserControl.Visible = true;
/// DrawSaved_ChartUserControl.DATASETFORCHART = DatabaseClass.getTableDatafromTable(t.Rows[0][1].ToString());
DrawSaved_ChartUserControl.CHARTTITLE = t.Rows[0][3].ToString();
DrawSaved_ChartUserControl.CHARTTYPE = t.Rows[0][4].ToString();
DrawSaved_ChartUserControl.XVALUEMEMBER = t.Rows[0][5].ToString();
DrawSaved_ChartUserControl.YVALUEMEMBER = t.Rows[0][7].ToString();
DrawSaved_ChartUserControl.ENABLELEGEND = true;
DrawSaved_ChartUserControl.XAXISINTERVAL = 1;
DrawSaved_ChartUserControl.XAXISTITLE = t.Rows[0][6].ToString();
DrawSaved_ChartUserControl.YAXISTITLE = t.Rows[0][8].ToString();
DrawSaved_ChartUserControl.CHARTBACKGROUNDCOLOR = t.Rows[0][9].ToString();
DrawSaved_ChartUserControl.CHARTSERIESCOLOR = t.Rows[0][10].ToString();
if (t.Rows[0][11].ToString() == "1")
{
DrawSaved_ChartUserControl.ENABLE3D = true;
}
else
{
DrawSaved_ChartUserControl.ENABLE3D = false;
}
DrawSaved_ChartUserControl.SORTING = "Ascending";
DrawSaved_ChartUserControl.FORMULA = "Sum";
DrawSaved_ChartUserControl.CreateChart_UserControl();
}
DatabaseClass.closeReaderConnection();
DatabaseClass.closeConnection();
// connection.Close();
}
protected void onRowDeleting(object sender, GridViewDeleteEventArgs e)
{
DatabaseClass d = new DatabaseClass();
try
{
string id = (gv.Rows[e.RowIndex].FindControl("lbl_id") as Label).Text.ToString().Trim();
d.openDb();
var s = "delete barang where id_barang = '" + id + "'";
Console.WriteLine(s);
d.execute(s);
onRowCancelingEdit(null, null);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
d.closeDB();
}
}
