public Element get_Element(int id_url, string id_elt)
{
using (ElementDBEntities db = new ElementDBEntities())
{
return(db.Elements.Where(p => p.id_url == id_url && p.id_element == id_elt).SingleOrDefault());
}
}
public List <Element> get_ListElement(int id_url)
{
using (ElementDBEntities db = new ElementDBEntities())
{
return(db.Elements.Where(p => p.id_url == id_url).ToList());
}
}
public Form_elements get_Form_ByIdForm(string idForm, int idUrl)
{
using (ElementDBEntities db = new ElementDBEntities())
{
return(db.Form_elements.Where(p => p.id_form == idForm && p.id_url == idUrl).SingleOrDefault());
}
}
public Url getURL(int id)
{
using (ElementDBEntities db = new ElementDBEntities())
{
return(db.Urls.Where(p => p.id_url == id).SingleOrDefault());
}
}
public Url getURL(string url)
{
using (ElementDBEntities db = new ElementDBEntities())
{
return(db.Urls.Where(p => p.url1 == url).SingleOrDefault());
}
}
public List <Element> get_List_Button_Not_Type_Submit(int id_url)
{
using (ElementDBEntities db = new ElementDBEntities())
{
return(db.Elements.Where(p => p.id_url == id_url && p.type != "submit").ToList());
}
}
public List <Element> get_List_Elt_Type_Submit(int id_url, string id_form)
{
using (ElementDBEntities db = new ElementDBEntities())
{
return(db.Elements.Where(p => p.id_url == id_url && p.type == "submit" && p.id_form == id_form).ToList());
}
}
public bool update_RedirectUrl(string id_testcase, int id_url, string redirect)
{
try
{
using (ElementDBEntities db = new ElementDBEntities())
{
var oldRedirect_Url = get_RedirectUrlTest(id_testcase, id_url);
if (oldRedirect_Url == null)
{
oldRedirect_Url = new Redirect_url()
{
id_testcase = id_testcase, id_url = id_url, redirect_url_test = "", current_url = redirect
};
db.Redirect_url.Add(oldRedirect_Url);
}
else
{
oldRedirect_Url.current_url = redirect;
db.Redirect_url.Attach(oldRedirect_Url);
db.Entry(oldRedirect_Url).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
return(true);
}
}
catch { }
return(false);
}
public List <Element> get_List_Element_Tag_Type(int id_url, string tag, string type)
{
using (ElementDBEntities db = new ElementDBEntities())
{
return(db.Elements.Where(p => p.id_url == id_url && p.tag_name == tag && p.type == type).ToList());
}
}
public List <Element> get_List_Input_Tag_Type(int id_url, string type, string id_form)
{
using (ElementDBEntities db = new ElementDBEntities())
{
return(db.Elements.Where(p => p.id_url == id_url && p.type == type && p.id_form == id_form).ToList());
}
}
public Redirect_url get_RedirectUrlTest(string id_testcase, int id_url)
{
try
{
using (ElementDBEntities db = new ElementDBEntities())
{
return(db.Redirect_url.Where(p => p.id_testcase == id_testcase && p.id_url == id_url).SingleOrDefault());
}
}
catch { }
return(null);
}
public List <Input_testcase> get_InputTestcase_ByIdTestcase(string id_testcase, int id_url)
{
try
{
using (ElementDBEntities db = new ElementDBEntities())
{
return(db.Input_testcase.Where(p => p.id_testcase == id_testcase && p.id_url == id_url).OrderBy(p => p.test_step).ToList());
}
}
catch { }
return(null);
}
public List <Element_test> get_ElementTest_ByIdTestcase(string id_testcase, int id_url)
{
try
{
using (ElementDBEntities db = new ElementDBEntities())
{
return(db.Element_test.Where(p => p.id_testcase == id_testcase && p.id_url == id_url).ToList());
}
}
catch { }
return(null);
}
public List <Test_case> get_ListTestcase(int id_url)
{
try
{
using (ElementDBEntities db = new ElementDBEntities())
{
return(db.Test_case.Where(p => p.id_url == id_url).ToList());
}
}
catch
{
}
return(null);
}
public bool insert_ListInputTestcase(List <Input_testcase> newListInput)
{
try
{
using (ElementDBEntities db = new ElementDBEntities())
{
db.Input_testcase.AddRange(newListInput);
db.SaveChanges();
return(true);
}
}
catch { }
return(false);
}
public bool insert_TestElement(Element_test newElement)
{
try
{
using (ElementDBEntities db = new ElementDBEntities())
{
db.Element_test.Add(newElement);
db.SaveChanges();
return(true);
}
}
catch { }
return(false);
}
public bool insert_Testcase(Test_case newTestcase)
{
try
{
using (ElementDBEntities db = new ElementDBEntities())
{
db.Test_case.Add(newTestcase);
db.SaveChanges();
return(true);
}
}
catch { }
return(false);
}
public string get_ResultTestcase(int id_url, string id_testcase)
{
try
{
using (ElementDBEntities db = new ElementDBEntities())
{
return(db.Test_case.Where(p => p.id_url == id_url && p.id_testcase == id_testcase).SingleOrDefault().result.ToString());
}
}
catch
{
}
return("");
}
public List <Form_elements> get_ListForm_ByIdUrl(int id_Url)
{
try
{
using (ElementDBEntities db = new ElementDBEntities())
{
return(db.Form_elements.Where(p => p.id_url == id_Url).ToList());
}
}
catch
{
}
return(null);
}
public bool insert_RedirectUrlTest(Redirect_url newRedirect_Url)
{
try
{
using (ElementDBEntities db = new ElementDBEntities())
{
db.Redirect_url.Add(newRedirect_Url);
db.SaveChanges();
return(true);
}
}
catch { }
return(false);
}
public bool update_RedirectUrlTest(Redirect_url oldRedirect_Url)
{
try
{
using (ElementDBEntities db = new ElementDBEntities())
{
db.Redirect_url.Attach(oldRedirect_Url);
db.Entry(oldRedirect_Url).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch { }
return(false);
}
public bool Delete_TestElement(Element_test oldElement)
{
try
{
using (ElementDBEntities db = new ElementDBEntities())
{
db.Element_test.Attach(oldElement);
db.Element_test.Remove(oldElement);
db.SaveChanges();
return(true);
}
}
catch { }
return(false);
}
public bool Update_TestElement(Element_test newElement)
{
try
{
using (ElementDBEntities db = new ElementDBEntities())
{
db.Element_test.Attach(newElement);
db.Entry(newElement).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch { }
return(false);
}
public bool update_InputTestElement(Input_testcase oldElement)
{
try
{
using (ElementDBEntities db = new ElementDBEntities())
{
db.Input_testcase.Attach(oldElement);
db.Entry(oldElement).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch { }
return(false);
}
public int insertURL(Url newurl)
{
using (ElementDBEntities db = new ElementDBEntities())
{
try
{
db.Urls.Add(newurl);
db.SaveChanges();
return(newurl.id_url);
}
catch
{
return(-1);
}
}
}
public bool delete_InputTestElement(string id_testcase, int id_url)
{
try
{
using (ElementDBEntities db = new ElementDBEntities())
{
var inputElement = get_InputTestcase_ByIdTestcase(id_testcase, id_url).SingleOrDefault();
db.Input_testcase.Attach(inputElement);
db.Input_testcase.Remove(inputElement);
db.SaveChanges();
return(true);
}
}
catch { }
return(false);
}
public int insert_Element(Element newElement)
{
using (ElementDBEntities db = new ElementDBEntities())
{
try
{
db.Elements.Add(newElement);
db.SaveChanges();
return(1);
}
catch
{
return(-1);
}
}
}
public bool update_RedirectUrlTest(string id_testcase, int id_url, string redirect)
{
try
{
using (ElementDBEntities db = new ElementDBEntities())
{
var oldRedirect_Url = get_RedirectUrlTest(id_testcase, id_url);
oldRedirect_Url.redirect_url_test = redirect;
db.Redirect_url.Attach(oldRedirect_Url);
db.Entry(oldRedirect_Url).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch { }
return(false);
}
public bool update_ValueResult_Testcase(int id_url, string id_testcase, string valueresult)
{
try
{
using (ElementDBEntities db = new ElementDBEntities())
{
var testcase = db.Element_test.Where(p => p.id_url == id_url && p.id_testcase == id_testcase).SingleOrDefault();
testcase.value_return = valueresult;
db.Element_test.Attach(testcase);
db.Entry(testcase).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch
{
}
return(false);
}
public int insertURL(string url, string name)
{
using (ElementDBEntities db = new ElementDBEntities())
{
try
{
Url newurl = new Url();
newurl.name = name;
newurl.url1 = url;
db.Urls.Add(newurl);
db.SaveChanges();
return(newurl.id_url);
}
catch
{
return(-1);
}
}
}
