protected void Button1_Click(object sender, EventArgs e)
{
if (ddl.SelectedIndex >= 0)
{
localhost.Service serviceObj = new localhost.Service();
//localhost.Table tableObj = listOfTables[ddl.SelectedValue];
localhost.Field[] array = serviceObj.ReadField((int)Session["orgID"], Convert.ToInt32(ddl.SelectedValue));
List<localhost.Field> values = new List<localhost.Field>(array);
for (int i = 0; i < values.Count; i++)
{
TableRow row = new TableRow();
TableCell cell1 = new TableCell();
cell1.Text = values[i].FieldNameProperty.ToString();
TableCell cell2 = new TableCell();
cell2.Text = values[i].FieldDataType.ToString();
row.Cells.Add(cell1);
row.Cells.Add(cell2);
Table1.Rows.Add(row);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
localhost.Service serviceObj = new localhost.Service();
int orgID = (int)Session["orgID"];
int objID = (int)Session["objID"];
localhost.Field[] array = serviceObj.ReadField(orgID, objID);
FieldList = new List<localhost.Field>(array);
DropDownList1.DataSource = FieldList;
DropDownList1.DataTextField = "FieldNameProperty";
DropDownList1.DataValueField = "FieldIDProperty";
DropDownList1.DataBind();
Label4.Visible = false;
Label3.Visible = false;
}
protected void ShwField_Click(object sender, EventArgs e)
{
listOfTables = (List<localhost.Table>)ViewState["listOfTables"];
localhost.Table tableObj = listOfTables[ddl.SelectedIndex];
localhost.Service serviceObj = new localhost.Service();
localhost.Field[] array = serviceObj.ReadField((int)Session["orgID"], tableObj.ObjIDProperty);
values = new List<localhost.Field>(array);
DropDownList1.DataSource = values;
DropDownList1.DataTextField = "FieldNameProperty";
DropDownList1.DataValueField = "FieldIDProperty";
DropDownList1.DataBind();
ViewState["listOfValues"] = values;
}
void ddl_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddl.SelectedIndex > 0)
{
localhost.Table tableObj = listOfTables[ddl.SelectedIndex];
localhost.Service serviceObj = new localhost.Service();
localhost.Field[] array = serviceObj.ReadField((int)Session["orgID"], tableObj.ObjIDProperty);
values = new List<localhost.Field>(array);
DropDownList1.DataSource = values;
DropDownList1.DataTextField = "FieldNameProperty";
DropDownList1.DataValueField = "FieldIDProperty";
DropDownList1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
PreRender += new EventHandler(_Default_PreRender);
if (!Page.IsPostBack)
{
int OrgID = (int)Session["orgID"];
Label1.Visible = false;
Label2.Visible = false;
textboxes = new List<TextBox>();
labels = new List<Label>();
localhost.Service serviceObj = new localhost.Service();
localhost.Table[] array = serviceObj.GetTables(OrgID);
listOfTables = new List<localhost.Table>(array);
ddl.DataSource = listOfTables;
ddl.DataTextField = "TNameProperty";
ddl.DataValueField = "ObjIDProperty";
ddl.DataBind();
List<localhost.Field> fieldlist = new List<localhost.Field>();
if (ddl.SelectedIndex >= 0)
{
localhost.Table tableObj = listOfTables[ddl.SelectedIndex];
localhost.Field[] fields = serviceObj.ReadField((int)Session["orgID"], tableObj.ObjIDProperty);
fieldlist = new List<localhost.Field>(fields);
int count = fieldlist.Count;
Table methodtable = new Table();
methodtable.Width = 500;
methodtable.BorderStyle = BorderStyle.Solid;
methodtable.BorderWidth = 5;
methodtable.Caption = "Object Fields";
methodtable.HorizontalAlign = HorizontalAlign.Center;
for (int i = 0; i < count; i++)
{
TableRow tr = new TableRow();
TableCell tc = new TableCell();
Label lb = new Label();
lb.ID = "lb" + i;
lb.EnableViewState = true;
lb.Text = fieldlist[i].FieldNameProperty + "::";
labels.Add(lb);
tc.Controls.Add(lb);
TableCell tc2 = new TableCell();
TextBox tb = new TextBox();
tb.ID = "tb" + i;
tb.EnableViewState = true;
tb.Text = Request.Form[tb.ClientID];
textboxes.Add(tb);
tc2.Controls.Add(tb);
tr.Controls.Add(tc);
tr.Controls.Add(tc2);
methodtable.Controls.Add(tr);
}
Panel1.Controls.Add(methodtable);
Session["fieldlist"] = fieldlist;
}
}
}
private int CreateServices(string wsdl_text)
{
Type service;
try
{
//Try Database Connection
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SAASDB"].ToString());
try
{
conn.Open();
}
catch (Exception e)
{
//Return Error
return -1;
}
localhost.Service serviceObj = new localhost.Service();
//Insert into Data Table the services
int count = 0;
List<string> fieldnames = new List<string>();
List<localhost.Field> fieldlist = new List<localhost.Field>();
localhost.Field[] fields = serviceObj.ReadField(11, 30);
fieldlist = new List<localhost.Field>(fields);
foreach (localhost.Field item in fieldlist)
{
fieldnames.Add(count.ToString());
count++;
}
Uri uri = new Uri(wsdl_text);
WebRequest webRequest = WebRequest.Create(uri);
System.IO.Stream requestStream = webRequest.GetResponse().GetResponseStream();
// Get a WSDL file describing a service
ServiceDescription sd = ServiceDescription.Read(requestStream);
string sdName = sd.Services[0].Name;
// Initialize a service description servImport
ServiceDescriptionImporter servImport = new ServiceDescriptionImporter();
servImport.AddServiceDescription(sd, String.Empty, String.Empty);
servImport.ProtocolName = "Soap";
servImport.CodeGenerationOptions = CodeGenerationOptions.GenerateProperties;
CodeNamespace nameSpace = new CodeNamespace();
CodeCompileUnit codeCompileUnit = new CodeCompileUnit();
codeCompileUnit.Namespaces.Add(nameSpace);
// Set Warnings
ServiceDescriptionImportWarnings warnings = servImport.Import(nameSpace, codeCompileUnit);
if (warnings == 0)
{
StringWriter stringWriter = new StringWriter(System.Globalization.CultureInfo.CurrentCulture);
Microsoft.CSharp.CSharpCodeProvider prov = new Microsoft.CSharp.CSharpCodeProvider();
prov.GenerateCodeFromNamespace(nameSpace, stringWriter, new CodeGeneratorOptions());
// Compile the assembly with the appropriate references
string[] assemblyReferences = new string[2] { "System.Web.Services.dll", "System.Xml.dll" };
CompilerParameters param = new CompilerParameters(assemblyReferences);
param.GenerateExecutable = false;
param.GenerateInMemory = true;
param.TreatWarningsAsErrors = false;
param.WarningLevel = 4;
CompilerResults results = new CompilerResults(new TempFileCollection());
results = prov.CompileAssemblyFromDom(param, codeCompileUnit);
Assembly assembly = results.CompiledAssembly;
service = assembly.GetType(sdName);
string input_params = "";
string return_type = "";
MethodInfo[] methodInfo = service.GetMethods();
foreach (MethodInfo t in methodInfo)
{
List<string> valueNames = new List<string>();
if (t.Name == "Discover")
break;
input_params = "";
return_type = "";
foreach (ParameterInfo parameter in t.GetParameters())
{
//paramname.Text = "(" + temp.ParameterType.Name + " " + temp.Name + ")";
input_params = input_params + parameter.Name + ":" + parameter.ParameterType.Name + " ";
}
//Get The Return type of the Service(Method)
return_type = t.ReturnType.ToString();
//Insert into Service Object(Methods Table)
valueNames.Add(Session["OrgID"].ToString());
valueNames.Add(wsdl_text);
valueNames.Add(t.Name);
valueNames.Add(input_params);
valueNames.Add(return_type);
bool success = serviceObj.InsertData(11, 30, "WSDL-Instance", fieldnames.ToArray(), valueNames.ToArray());
if (success == false)
{
return -1;
}
}
return 1;
}
else
{
return -1;
}
}
catch (Exception ex)
{
return -1;
}
}