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();
}
}
