public Boolean CreateCustomerAccount(string username, string password, string cardNumber, string streetAddress, string cityName, string zipCode, string contactNumber) { localhost.Service serviceObj = new localhost.Service(); List<String> fieldnames = new List<String>(); fieldnames.Add("0"); fieldnames.Add("1"); fieldnames.Add("2"); fieldnames.Add("3"); fieldnames.Add("4"); fieldnames.Add("5"); fieldnames.Add("6"); List<String> valueNames = new List<String>(); valueNames.Add(username); valueNames.Add(password); valueNames.Add(cardNumber); valueNames.Add(streetAddress); valueNames.Add(cityName); valueNames.Add(zipCode); valueNames.Add(contactNumber); bool success = serviceObj.InsertData(11, 32, "CustomerServiceInstance", fieldnames.ToArray(), valueNames.ToArray()); if (success) return true; else return false; }
public int bill_to_card_displayConfirmation(int OrgID,int CustomerID,int ProductID,int Quantity,double price) { try { bool success = false; Order order_obj = new Order(); int CustomerObjID = 0; int OrderObjID = 0; localhost.Service serviceObj = new localhost.Service(); localhost.Table[] Tarray = serviceObj.GetTables(OrgID); List<localhost.Table> listOfTables = new List<localhost.Table>(Tarray); for (int i = 0; i < listOfTables.Count; i++) { if (listOfTables[i].TNameProperty == "Customer") { CustomerObjID = listOfTables[i].ObjIDProperty; } if (listOfTables[i].TNameProperty == "Order") { OrderObjID = listOfTables[i].ObjIDProperty; } } if (CustomerObjID != 0) { localhost.TenantTableInfo obj = serviceObj.ReadDataWithGUID(OrgID, CustomerObjID, CustomerID); string[] arr = obj.FieldNamesProperty; List<string> array = new List<string>(arr); string[] values = obj.FieldValuesProperty; List<string> valuearr = new List<string>(values); int counter = 0; for (int j = 0; j < array.Count; j++) { if (arr[j].ToString() == "Ship_FirstName") { order_obj.Ship_FirstName = valuearr[counter].ToString(); } if (arr[j].ToString() == "Ship_LastName") { order_obj.Ship_LastName = valuearr[counter].ToString(); } if (arr[j].ToString() == "Ship_phone") { order_obj.Ship_phone = valuearr[counter].ToString(); } if (arr[j].ToString() == "Ship_postalcode") { order_obj.Ship_postalcode = valuearr[counter].ToString(); } if (arr[j].ToString() == "Ship_AddressLine1") { order_obj.Ship_AddressLine1 = valuearr[counter].ToString(); } if (arr[j].ToString() == "Ship_AddressLine2") { order_obj.Ship_AddressLine2 = valuearr[counter].ToString(); } counter++; } order_obj.ProductID = ProductID; order_obj.Quantity = Quantity; order_obj.OrderStatus = "Billed"; order_obj.OrderDate = DateTime.Now; order_obj.DateLastUpdated = DateTime.Now; List<String> fieldnames = new List<String>(); fieldnames.Add("0"); fieldnames.Add("1"); fieldnames.Add("2"); fieldnames.Add("3"); fieldnames.Add("4"); fieldnames.Add("5"); fieldnames.Add("6"); fieldnames.Add("7"); fieldnames.Add("8"); fieldnames.Add("9"); fieldnames.Add("10"); fieldnames.Add("11"); fieldnames.Add("12"); List<String> valueNames = new List<String>(); valueNames.Add(order_obj.ProductID.ToString()); valueNames.Add(order_obj.Quantity.ToString()); valueNames.Add(order_obj.OrderDate.ToString()); valueNames.Add(order_obj.DateLastUpdated.ToString()); valueNames.Add(order_obj.OrderStatus.ToString()); valueNames.Add(order_obj.Ship_FirstName.ToString()); valueNames.Add(order_obj.Ship_LastName.ToString()); valueNames.Add(order_obj.Ship_AddressLine1.ToString()); valueNames.Add(order_obj.Ship_AddressLine2.ToString()); valueNames.Add(order_obj.Ship_phone.ToString()); valueNames.Add(order_obj.Ship_postalcode.ToString()); valueNames.Add(order_obj.Price.ToString()); valueNames.Add(CustomerID.ToString()); int custorderID = 0; success = serviceObj.InsertData(OrgID, OrderObjID, "Order-Instance-" + OrgID.ToString(), fieldnames.ToArray(), valueNames.ToArray()); if (success) { obj = serviceObj.ReadData(OrgID, OrderObjID); arr = obj.FieldNamesProperty; array = new List<string>(arr); values = obj.FieldValuesProperty; valuearr = new List<string>(values); int countRow = valuearr.Count / array.Count; counter = 0; for (int i = 0; i < countRow; i++) { for (int j = 0; j < array.Count; j++) { if (arr[j].ToString() == "GUID") { custorderID = Convert.ToInt32(valuearr[counter].ToString()); } counter++; } } return custorderID; } else { return custorderID; } } else { return 0; } } catch (Exception ex) { throw; } }
protected void Button2_Click(object sender, EventArgs e) { if (ddl.SelectedIndex >= 0) { int OrgID = (int)Session["orgID"]; int index_sel = ddl.SelectedIndex; List<string> fieldnames = new List<string>(); List<string> valueNames = new List<string>(); Label1.Visible = false; Label2.Visible = false; localhost.Service serviceObj = new localhost.Service(); localhost.Table tableObj = listOfTables[index_sel]; textboxes = new List<TextBox>(); labels = new List<Label>(); fieldlist = (List<localhost.Field>)Session["fieldlist"]; 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); if (fieldlist != null) { count = 0; foreach (TextBox item in textboxes) { valueNames.Add(item.Text); } foreach (localhost.Field item in fieldlist) { fieldnames.Add(count.ToString()); count++; } bool success = serviceObj.InsertData((int)Session["orgID"], tableObj.ObjIDProperty, "", fieldnames.ToArray(), valueNames.ToArray()); if (success) Label1.Visible = true; else Label2.Visible = true; } } }
private void SaveToDB(Workflow customwrkflw) { customwrkflw.WfName = txtWorkflowName.Text; List<String> fieldnames = new List<String>(); fieldnames.Add("0"); fieldnames.Add("1"); fieldnames.Add("2"); fieldnames.Add("3"); List<String> valueNames = new List<String>(); valueNames.Add(Session["OrgID"].ToString()); valueNames.Add(customwrkflw.WfName); valueNames.Add(customwrkflw.WrkflwMethods); valueNames.Add(customwrkflw.WrkflwInputs); localhost.Service serviceObj = new localhost.Service(); bool success = serviceObj.InsertData(11, 31, "Worfkflow-Instance", fieldnames.ToArray(), valueNames.ToArray()); if (success) { Label1.Text = "Worflow added successfully"; Label1.Visible = true; } else { Label1.Text = "Operation Unsuccessfull"; Label1.Visible = true; } }
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; } }