protected void Button1_Click(object sender, EventArgs e) { String objrefname = Request.Form["objrefname"].ToString(); String Status = Request.Form["Status"].ToString(); String selectedproject = Request.Form["activeProject"].ToString(); String Des = Request.Form["des"].ToString(); String value = Request.Form["value"].ToString(); String Modifiable = Request.Form["Modifiable"].ToString(); String global = Request.Form["global"].ToString(); int projectid = 0; value = value.Replace("'", "''"); value = value.Replace("\r\n", string.Empty); value = value.Trim().ToString(); //lblresult.Text = ""; DataSet ds = null; int check = 0; if (objrefname != "" && value != "") { duplicatecheck = "select * from obj_repository where obj_ref_name = '{0}' and projectid= {1}"; qry = string.Format(duplicatecheck, objrefname, selectedproject); if (obj.getDs(qry, out ds, "dsdt")) { if (ds.Tables[0].Rows.Count == 0) { ispresent = true; } } qry = string.Format(insertobjectrepo, selectedproject, objrefname, value, Des, Status, global, Modifiable); if (ispresent == true) { if (obj.insert(qry, out temp)) { if (temp == 1) { // lblresult.Text = " " + txttestcase.Text.ToString() + " Testcase created sucessfully"; Response.Write("<script LANGUGE='JavaScript'> alert('" + objrefname + " Obj Repository created sucessfully ')</script>"); } else { Response.Write("<script LANGUGE='JavaScript'> alert('Error in creating new object referance name')</script>"); } } } else { Response.Write("<script LANGUGE='JavaScript'> alert('" + objrefname + " name already exists ')</script>"); } } else { Response.Write("<script LANGUGE='JavaScript'> alert('please select language and test case name')</script>"); } }
protected void Button1_Click(object sender, EventArgs e) { String actionname = Request.Form["actiontype"].ToString(); String Status = Request.Form["Status"].ToString(); String selectedproject = Request.Form["activeProject"].ToString(); String Des = Request.Form["des"].ToString(); String exitiffail = Request.Form["exit"].ToString(); String Modifiable = Request.Form["Modifiable"].ToString(); String global = Request.Form["global"].ToString(); //lblresult.Text = ""; DataSet ds = null; if (actionname != "" && selectedproject != "") { duplicatecheck = "select * from actiontype where actiontypename = '{0}' and projectid= {1}"; qry = string.Format(duplicatecheck, actionname, selectedproject); if (obj.getDs(qry, out ds, "dsdt")) { if (ds.Tables[0].Rows.Count == 0) { ispresent = true; } } qry = string.Format(inseractiontype, selectedproject, actionname, Des, global, Modifiable, exitiffail, Status); if (ispresent == true) { if (obj.insert(qry, out temp)) { if (temp == 1) { // lblresult.Text = " " + txttestcase.Text.ToString() + " Testcase created sucessfully"; Response.Write("<script LANGUGE='JavaScript'> alert('" + actionname + " Action type created sucessfully ')</script>"); } else { Response.Write("<script LANGUGE='JavaScript'> alert('Error in creating new action type name')</script>"); } } } else { Response.Write("<script LANGUGE='JavaScript'> alert('" + actionname + " name already exists ')</script>"); } } else { Response.Write("<script LANGUGE='JavaScript'> alert('please select action and project name')</script>"); } }
protected void Button1_Click(object sender, EventArgs e) { String testcasename = Request.Form["Testcasename"].ToString(); String language = Request.Form["language"].ToString(); String Des = Request.Form["des"].ToString(); String Status = Request.Form["Status"].ToString(); String Priority = Request.Form["Priority"].ToString(); //lblresult.Text = ""; DataSet ds = null; int check = 0; if (testcasename != "" && language != "") { duplicatecheck = "select * from testcases where testcasename = '{0}'"; qry = string.Format(duplicatecheck, testcasename); if (obj.getDs(qry, out ds, "dsdt")) { if (ds.Tables[0].Rows.Count == 0) { ispresent = true; } } qry = string.Format(inserttestcase, testcasename, Des, Status, language, Priority, activeprojectname); if (ispresent == true) { if (obj.insert(qry, out temp)) { if (temp == 1) { // lblresult.Text = " " + txttestcase.Text.ToString() + " Testcase created sucessfully"; Response.Write("<script LANGUGE='JavaScript'> alert('" + testcasename + " Test Case created sucessfully ')</script>"); } else { Response.Write("<script LANGUGE='JavaScript'> alert('Error in creating new testcase')</script>"); } } } else { Response.Write("<script LANGUGE='JavaScript'> alert('" + testcasename + " Test Case name already exists ')</script>"); } } else { Response.Write("<script LANGUGE='JavaScript'> alert('please select language and test case name')</script>"); } }
public Hashtable gettestagentkeyvalues(String query) { Dbmethods obj = new Dbmethods(); Hashtable hashKeyValues = new Hashtable(); DataSet ds; try { if (obj.getDs(query, out ds, "dsdt")) { foreach (DataRow dbRow in ds.Tables[0].Rows) { hashKeyValues.Add(dbRow["ID"].ToString(), dbRow["machinename"].ToString()); } } } catch (Exception exception) { Console.Write("Exception occurred while communicating with DB : ==> : " + exception.Message); Console.Write("Query : ==> : " + query); } return(hashKeyValues); }
protected void Button1_Click(object sender, EventArgs e) { string testcaseid = Session["tcnameid"].ToString(); var Browsertype = Request.Form["BrowserType"].ToString(); var ActionType = Request.Form["ActionType"].ToString(); var Status = Request.Form["Status"].ToString(); var Obj_ref_id = Request.Form["obj_ReferenceName_Value1"].ToString(); var Value = Request.Form["targetValue"].ToString(); var Comments = Request.Form["comments"].ToString(); string StepId = Request.QueryString["RequestType"].Trim(); Boolean ispresent = false; DataSet ds = null; string duplicatecheck = "", qry = ""; int currentstepid = 0; Value = Value.Replace("'", "''"); Value = Value.Replace("\r\n", string.Empty); Value = Value.Trim().ToString(); if (testcaseid != "" && StepId != "") { duplicatecheck = "select * from test_case_design_steps where id={0}"; qry = string.Format(duplicatecheck, StepId); if (obj.getDs(qry, out ds, "dsdt")) { if (ds.Tables[0].Rows.Count == 0) { ispresent = true; } else { ispresent = true; } } if (ispresent == true) { //Npgsql.NpgsqlConnection con = obj.getSQLConnection(); //Npgsql.NpgsqlDataReader reader = null; //reader = obj.executeQueryResults(qry); //while (reader.Read()) //{ // currentstepid = Convert.ToInt32(reader["stepid"]); // currentstepid++; //} qry = string.Format(updatestep, ActionType, Obj_ref_id, Browsertype, Status, Value, Comments, StepId); if (obj.Update(qry, out temp)) { if (temp == 1) { // lblresult.Text = " " + txttestcase.Text.ToString() + " Testcase created sucessfully"; Response.Write("<script LANGUGE='JavaScript'> alert('Step Created sucessfully ')</script>"); Session["ActiveTestcase"] = testcaseid; Response.Redirect("Default2.aspx"); } else { Response.Write("<script LANGUGE='JavaScript'> alert('Error in creating new step')</script>"); } } } else { //Response.Write("<script LANGUGE='JavaScript'> alert('" + actionname + " name already exists ')</script>"); } } }