protected void FooterOtoVeri() { Label lblisim = (Label)GridView1.FooterRow.FindControl("ft_lblkadi"); Label lblulke = (Label)GridView1.FooterRow.FindControl("ft_lblulke"); Label lbltarih = (Label)GridView1.FooterRow.FindControl("ft_lbltarih"); TextBox tbxisim = (TextBox)GridView1.FooterRow.FindControl("ft_tbxkadi"); TextBox tbxulke = (TextBox)GridView1.FooterRow.FindControl("ft_tbxulke"); EO.Web.DatePicker dptarih = (EO.Web.DatePicker)GridView1.FooterRow.FindControl("ft_dptarih"); if (DropDownList1.SelectedValue == "isim") { lblisim.Text = DropDownList2.SelectedValue; lblisim.Visible = true; tbxisim.Visible = false; } else if (DropDownList1.SelectedValue == "ulke") { lblulke.Text = DropDownList2.SelectedValue; lblulke.Visible = true; tbxulke.Visible = false; } else if (DropDownList1.SelectedValue == "tarih") { lbltarih.Text = DropDownList2.SelectedValue; lbltarih.Visible = true; dptarih.Visible = false; } }
protected void ft_btnVeriEkle_Click(object sender, EventArgs e) { TextBox tbxisim = (TextBox)GridView1.FooterRow.FindControl("ft_tbxkadi"); TextBox tbxulke = (TextBox)GridView1.FooterRow.FindControl("ft_tbxulke"); EO.Web.DatePicker textdate = (EO.Web.DatePicker)GridView1.FooterRow.FindControl("ft_dptarih"); SqlCommand ft_veriekle = new SqlCommand("INSERT INTO tablo1(isim,ulke,tarih)VALUES('" + tbxisim.Text + "','" + tbxulke.Text + "','" + textdate.SelectedDate.ToLongDateString() + "')", conn); ft_veriekle.ExecuteNonQuery(); TabloVeriAl(); }
protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row1 = (GridViewRow)GridView2.Rows[e.RowIndex]; Label lblID1 = (Label)row1.FindControl("t_lblID1"); DropDownList ddlulke1 = (DropDownList)row1.FindControl("DropDownList2"); EO.Web.DatePicker textdate1 = (EO.Web.DatePicker)row1.FindControl("t_dptarih1"); GridView2.EditIndex = -1; SqlCommand cmd = new SqlCommand("update tablo1 set ulke='" + ddlulke1.SelectedValue + "',tarih='" + textdate1.SelectedDate.ToLongDateString() + "' WHERE id='" + lblID1.Text + "'", conn); cmd.ExecuteNonQuery(); TabloVeriAl(); }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex]; Label lblID = (Label)row.FindControl("t_lblID"); TextBox tbxisim = (TextBox)row.FindControl("t_tbxkadi"); TextBox tbxulke = (TextBox)row.FindControl("t_tbxulke"); EO.Web.DatePicker textdate = (EO.Web.DatePicker)row.FindControl("t_dptarih"); GridView1.EditIndex = -1; GridView1.ShowFooter = true; SqlCommand cmd = new SqlCommand("update tablo1 set isim='" + tbxisim.Text + "',ulke='" + tbxulke.Text + "',tarih='" + textdate.SelectedDate.ToLongDateString() + "' WHERE id='" + lblID.Text + "'", conn); cmd.ExecuteNonQuery(); TabloVeriAl(); }
protected void btn_proceed_Click1(object sender, EventArgs e) { Label qty_updt = (Label)DataList1.Items[0].FindControl("Label1"); Panel pnl = (Panel)DataList1.Items[0].FindControl("Panel1"); Label lbl = (Label)DataList1.Items[0].FindControl("lbl_msg"); if (qty_updt.Text == "completed") { pnl.Visible = false; lbl.Text = "No More quantity Remaining to Create JobCard"; } else { // Panel pnl = (Panel)DataList1.Items[0].FindControl("Panel1"); pnl.Visible = true; TextBox txt_jid1 = (TextBox)DataList1.Items[0].FindControl("txt_jid"); TextBox txt_qty = (TextBox)DataList1.Items[0].FindControl("txt_qty"); EO.Web.DatePicker dp = (EO.Web.DatePicker)DataList1.Items[0].FindControl("DatePicker1"); //TextBox txt_date = (TextBox)DataList1.Items[0].FindControl("txt_date"); Label lbl_poid = (Label)DataList1.Items[0].FindControl("idLabel"); con.Open(); cmd.Connection = con; cmd.CommandType = CommandType.Text; cmd.CommandText = "select count(*) from jobcard"; int n = Convert.ToInt32(cmd.ExecuteScalar()); n = n + 1; txt_jid1.Text = "J00" + n.ToString(); // txt_jid1.Text = lbl_poid.Text; con.Close(); } }
protected void btn_createjc_Click(object sender, EventArgs e) { Label lbl_poid = (Label)DataList1.Items[0].FindControl("idLabel"); TextBox txt_jid1 = (TextBox)DataList1.Items[0].FindControl("txt_jid"); TextBox txt_qty = (TextBox)DataList1.Items[0].FindControl("txt_qty"); EO.Web.DatePicker dp = (EO.Web.DatePicker)DataList1.Items[0].FindControl("DatePicker1"); con.Open(); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "insert_jobcard1"; string status_p = "Pending"; cmd.Parameters.AddWithValue("@jobid", txt_jid1.Text); cmd.Parameters.AddWithValue("@poid", lbl_poid.Text); cmd.Parameters.AddWithValue("@qty", txt_qty.Text); cmd.Parameters.AddWithValue("@date", dp.SelectedDate.ToString()); cmd.Parameters.AddWithValue("@status", status_p.ToString()); cmd.ExecuteNonQuery(); con.Close(); Label qty = (Label)DataList1.Items[0].FindControl("qtyLabel"); Label qty2 = (Label)DataList1.Items[0].FindControl("Label2"); int qty1_p = Convert.ToInt32(qty.Text); int updt_qty = Convert.ToInt32(qty2.Text); int qty2_j = Convert.ToInt32(txt_qty.Text); if (updt_qty == qty1_p) { updt_qty = qty1_p - qty2_j; } else { int qty1 = updt_qty - qty2_j; updt_qty = qty1; } if (updt_qty == 0) { string com = "completed"; con.Open(); cmd2.Connection = con; cmd2.CommandType = CommandType.StoredProcedure; cmd2.CommandText = "update_sts_remng"; cmd2.Parameters.AddWithValue("@po_id", lbl_poid.Text); cmd2.Parameters.AddWithValue("@r_qty", updt_qty.ToString()); cmd2.Parameters.AddWithValue("@sts", com.ToString()); cmd2.ExecuteNonQuery(); con.Close(); } con.Open(); cmd1.Connection = con; cmd1.CommandType = CommandType.StoredProcedure; cmd1.CommandText = "update_qnty"; cmd1.Parameters.AddWithValue("@po_id", lbl_poid.Text); cmd1.Parameters.AddWithValue("@qty", updt_qty.ToString()); cmd1.ExecuteNonQuery(); con.Close(); DataList1.DataBind(); }
protected void btn_submit_Click(object sender, EventArgs e) { TextBox txt_app = (TextBox)DataList1.Items[0].FindControl("txt_app"); TextBox txt_rej = (TextBox)DataList1.Items[0].FindControl("txt_rej"); TextBox txt_mname = (TextBox)DataList1.Items[0].FindControl("txt_mname"); Label statusLabel = (Label)DataList1.Items[0].FindControl("statusLabel"); Label jcidLabel = (Label)DataList1.Items[0].FindControl("jcidLabel"); EO.Web.DatePicker dp = (EO.Web.DatePicker)DataList1.Items[0].FindControl("DatePicker1"); cmd.Parameters.Clear(); con.Open(); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "insert_qc"; cmd.Parameters.AddWithValue("@jcid", jcidLabel.Text); cmd.Parameters.AddWithValue("@approve", txt_app.Text); cmd.Parameters.AddWithValue("@reject", txt_rej.Text); cmd.Parameters.AddWithValue("@mname", txt_mname.Text); cmd.Parameters.AddWithValue("@date", dp.SelectedDate.ToString()); statusLabel.Text = "Job Completed"; cmd.Parameters.AddWithValue("@status", statusLabel.Text); cmd.ExecuteNonQuery(); con.Close(); con.Open(); cmd1.Connection = con; cmd1.CommandType = CommandType.StoredProcedure; cmd1.CommandText = "update_jobcard"; cmd1.Parameters.AddWithValue("@id", jcidLabel.Text); cmd1.Parameters.AddWithValue("@status", statusLabel.Text); cmd1.ExecuteNonQuery(); con.Close(); DataList1.DataBind(); con.Open(); cmd2.Connection = con; cmd2.CommandType = CommandType.Text; cmd2.CommandText = "select count(jcid) from jobcard where poid='" + DropDownList1.SelectedValue + "'"; int n = Convert.ToInt32(cmd2.ExecuteScalar()); con.Close(); con.Open(); cmd3.Connection = con; String sts = "Job Completed"; cmd3.CommandText = "select count(jcid) from jobcard where Status='" + sts + "' and poid='" + DropDownList1.SelectedValue + "' "; int m = Convert.ToInt32(cmd3.ExecuteScalar()); con.Close(); con.Open(); cmd4.Connection = con; cmd4.CommandType = CommandType.Text; String sts1 = "Pending"; cmd4.CommandText = "select count(jcid) from jobcard where Status='" + sts1 + "' and poid='" + DropDownList1.SelectedValue + "' "; int s = Convert.ToInt32(cmd4.ExecuteScalar()); con.Close(); if (s == 0) { con.Open(); cmd5.Connection = con; cmd5.CommandType = CommandType.Text; string updtst = "Completed"; cmd5.CommandText = "UPDATE po SET status ='" + updtst + "' WHERE (id ='" + DropDownList1.SelectedValue + "' )"; cmd5.ExecuteNonQuery(); con.Close(); } }