protected void Button1_Click(object sender, EventArgs e)
{
if (ddl.SelectedIndex >= 0)
{
localhost.Service serviceObj = new localhost.Service();
localhost.Table tableObj = listOfTables[ddl.SelectedIndex];
localhost.TenantTableInfo obj = serviceObj.ReadData((int)Session["orgID"],tableObj.ObjIDProperty);
string[] arr = obj.FieldNamesProperty;
List<string> array = new List<string>(arr);
string[] values = obj.FieldValuesProperty;
List<string> valuearr = new List<string>(values);
int countRow = valuearr.Count / array.Count;
int counter = 0;
for (int i = 0; i < countRow; i++)
{
TableRow row = new TableRow();
for (int j = 0; j < array.Count; j++)
{
TableCell cell = new TableCell();
cell.Text = valuearr[counter++].ToString();
row.Cells.Add(cell);
}
Table1.Rows.Add(row);
}
}
}
public Boolean authenticateUserNamePassword(string username, string password)
{
string uname = null, pword = null;
localhost.Service serviceObj = new localhost.Service();
localhost.TenantTableInfo obj = serviceObj.ReadData(11, 32);
string[] arr = obj.FieldNamesProperty;
List<string> array = new List<string>(arr);
string[] values = obj.FieldValuesProperty;
List<string> valuearr = new List<string>(values);
int countRow = valuearr.Count / array.Count;
int counter = 0;
for (int i = 0; i < countRow; i++)
{
for (int j = 0; j < array.Count; j++)
{
if (arr[j].ToString() == "password")
{
pword = valuearr[counter].ToString();
if (username == uname && pword == password)
{
return true;
}
else
{
return false;
}
}
if (arr[j].ToString() == "username")
{
uname = valuearr[counter].ToString();
}
counter++;
}
}
return false;
}
protected void Page_Load(object sender, EventArgs e)
{
localhost.Service serviceObj = new localhost.Service();
localhost.TenantTableInfo obj = serviceObj.ReadData(11, 31);
string[] arr = obj.FieldNamesProperty;
List<string> array = new List<string>(arr);
string[] values = obj.FieldValuesProperty;
List<string> valuearr = new List<string>(values);
int countRow = valuearr.Count / array.Count;
int counter = 0;
TableRow row = new TableHeaderRow();
var cell1 = new TableCell();
row.TableSection = TableRowSection.TableHeader;
cell1.Text = "Global ID";
row.Cells.Add(cell1);
WfTable.Rows.Add(row);
row.TableSection = TableRowSection.TableHeader;
cell1 = new TableCell();
cell1.Text = "Workflow Name";
row.Cells.Add(cell1);
WfTable.Rows.Add(row);
row.TableSection = TableRowSection.TableHeader;
cell1 = new TableCell();
cell1.Text = "Selection";
row.Cells.Add(cell1);
WfTable.Rows.Add(row);
int addrow = 0;
for (int i = 0; i < countRow; i++)
{
addrow = 0;
row = new TableRow();
RadioButton rbnew = new RadioButton();
if (i == 0)
{
rbnew.Checked = true;
}
for (int j = 0; j < array.Count; j++)
{
TableCell cell = new TableCell();
if (arr[j].ToString() == "GUID")
{
cell.Text = valuearr[counter].ToString();
rbnew.ID = valuearr[counter].ToString();
rbnew.EnableViewState = true;
rbnew.CheckedChanged += new EventHandler(Changed);
rbnew.AutoPostBack = true;
rbnew.GroupName = "Check";
row.Cells.Add(cell);
}
if (arr[j].ToString() == "wfname")
{
cell.Text = valuearr[counter].ToString();
row.Cells.Add(cell);
}
if (arr[j].ToString() == "ownerid")
{
if (Convert.ToInt32(valuearr[counter]) == 11 || Convert.ToInt32(valuearr[counter]) == Convert.ToInt32(Session["OrgId"]))
{
addrow = 1;
}
}
counter++;
}
if (addrow == 1)
{
TableCell cellcheck = null;
row.Cells.Add(cellcheck = new TableCell());
((IParserAccessor)cellcheck).AddParsedSubObject(rbnew);
WfTable.Rows.Add(row);
}
}
}
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 Page_Load(object sender, EventArgs e)
{
PreRender += new EventHandler(CustomizeWorkflow_PreRender);
lstipTextBoxes = new List<TextBox>();
lstMethodNames = new List<TextBox>();
if (!Page.IsPostBack)
{
ShowServices();
}
string Methods;
string Inputs;
string[] MethodIDs = null;
string[] Input = null;
#region DataSourceBinding
//Get methods for the workflow ID
localhost.Service serviceObj = new localhost.Service();
localhost.TenantTableInfo obj = serviceObj.ReadDataWithGUID(11, 31, Convert.ToInt32(Session["WfID"]));
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;
defaultwrkflw.WfID = Convert.ToInt32(Session["WfID"]);
for (int j = 0; j < array.Count; j++)
{
if (arr[j].ToString() == "wfname")
{
defaultwrkflw.WfName = valuearr[counter].ToString();
}
if (arr[j].ToString() == "wfmethods")
{
Methods = valuearr[counter].ToString();
MethodIDs = Methods.Split(',');
}
if (arr[j].ToString() == "wfinputs")
{
Inputs = valuearr[counter].ToString();
Input = Inputs.Split(',');
defaultwrkflw.Inputs = Input;
}
counter++;
}
foreach (var item in MethodIDs)
{
defaultwrkflw.Methods.Add(Convert.ToInt32(item));
obj = serviceObj.ReadDataWithGUID(11, 30, Int32.Parse(item));
arr = obj.FieldNamesProperty;
array = new List<string>(arr);
values = obj.FieldValuesProperty;
valuearr = new List<string>(values);
counter = 0;
for (int j = 0; j < array.Count; j++)
{
if (arr[j].ToString() == "minput")
{
defaultwrkflw.InputParam.Add(valuearr[counter].ToString());
}
if (arr[j].ToString() == "mname")
{
defaultwrkflw.MethodName.Add(valuearr[counter].ToString());
}
if (arr[j].ToString() == "moutput")
{
defaultwrkflw.OutputParam.Add(valuearr[counter].ToString());
}
counter++;
}
}
obj = serviceObj.ReadData(11, 30);
arr = obj.FieldNamesProperty;
array = new List<string>(arr);
values = obj.FieldValuesProperty;
valuearr = new List<string>(values);
int countRow = valuearr.Count / array.Count;
counter = 0;
int addrow = 0;
for (int i = 0; i < countRow; i++)
{
AvailableServices serv = new AvailableServices();
addrow = 0;
for (int j = 0; j < array.Count; j++)
{
if (arr[j].ToString() == "GUID")
{
serv.MethodId = Convert.ToInt32(valuearr[counter].ToString());
}
if (arr[j].ToString() == "mname")
{
serv.MethodName = valuearr[counter].ToString();
}
if (arr[j].ToString() == "minput")
{
serv.InputParam = valuearr[counter].ToString();
}
if (arr[j].ToString() == "moutput")
{
serv.OutputParam = valuearr[counter].ToString();
}
if (arr[j].ToString() == "ownerid")
{
if (Convert.ToInt32(valuearr[counter]) == 11 || Convert.ToInt32(valuearr[counter]) == Convert.ToInt32(Session["OrgId"]))
{
addrow = 1;
}
}
counter++;
}
if (addrow > 0)
{
availservice.Add(serv);
}
}
#endregion
#region AddControls
int methodcounter = 0;
Panel2.Controls.Add(new LiteralControl("<br />"));
Label work_label = new Label();
work_label.Text = defaultwrkflw.WfName + " Workflow Steps";
work_label.Font.Bold = true;
work_label.Font.Size = 20;
Panel2.Controls.Add(work_label);
Panel2.Controls.Add(new LiteralControl("<br />"));
Table methodtable = new Table();
methodtable.BorderStyle = BorderStyle.Solid;
methodtable.BorderWidth = 5;
methodtable.Font.Bold = true;
methodtable.Font.Size = 10;
methodtable.Attributes.Add("runat", "Server");
methodtable.ID = defaultwrkflw.Methods[methodcounter].ToString();
TableRow row = new TableHeaderRow();
var cell1 = new TableCell();
cell1.Text = "Service Name";
row.Cells.Add(cell1);
cell1 = new TableCell();
cell1.Text = "Ouput Mapping";
row.Cells.Add(cell1);
methodtable.Rows.Add(row);
counter = 0;
foreach (string item in defaultwrkflw.MethodName)
{
if (!item.Equals(""))
{
TableRow tr = new TableRow();
TableCell tc = new TableCell();
TableCell tc2 = new TableCell();
TextBox txtMethodName = new TextBox();
txtMethodName.Width = 350;
txtMethodName.Text = item;
TextBox txtInputParam = new TextBox();
txtInputParam.Text = defaultwrkflw.Inputs[counter++];
txtInputParam.Width = 50;
lstipTextBoxes.Add(txtInputParam);
lstMethodNames.Add(txtMethodName);
tc.Controls.Add(txtMethodName);
tc2.Controls.Add(txtInputParam);
methodtable.Controls.Add(tr);
tr.Controls.Add(tc);
tr.Controls.Add(tc2);
}
}
int methodcount = 10 - defaultwrkflw.MethodName.Count;
while (methodcount > 0 )
{
TableRow tr = new TableRow();
TableCell tc = new TableCell();
TableCell tc2 = new TableCell();
TextBox txtMethodName = new TextBox();
txtMethodName.Width = 350;
txtMethodName.Text = "";
TextBox txtInputParam = new TextBox();
txtInputParam.Text = "";
txtInputParam.Width = 50;
lstipTextBoxes.Add(txtInputParam);
lstMethodNames.Add(txtMethodName);
tc.Controls.Add(txtMethodName);
tc2.Controls.Add(txtInputParam);
methodtable.Controls.Add(tr);
tr.Controls.Add(tc);
tr.Controls.Add(tc2);
methodcount--;
}
Panel2.Controls.Add(methodtable);
#endregion
}
void ShowServices()
{
localhost.Service serviceObj = new localhost.Service();
localhost.TenantTableInfo obj = serviceObj.ReadData(11, 30);
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;
int addrow = 0;
int countRow = valuearr.Count / array.Count;
DataColumn col1 = new DataColumn("Service Name");
DataColumn col2 = new DataColumn("Input params");
DataColumn col3 = new DataColumn("Output params");
col1.DataType = System.Type.GetType("System.String");
col2.DataType = System.Type.GetType("System.String");
col3.DataType = System.Type.GetType("System.String");
dt.Columns.Add(col1);
dt.Columns.Add(col2);
dt.Columns.Add(col3);
for (int i = 0; i < countRow; i++)
{
addrow = 0;
DataRow row = dt.NewRow();
for (int j = 0; j < array.Count; j++)
{
if (arr[j].ToString() == "mname")
{
row[col1] = valuearr[counter].ToString();
}
if (arr[j].ToString() == "minput")
{
row[col2] = valuearr[counter].ToString();
}
if (arr[j].ToString() == "moutput")
{
row[col3] = valuearr[counter].ToString();
}
if (arr[j].ToString() == "ownerid")
{
if (Convert.ToInt32(valuearr[counter]) == 11 || Convert.ToInt32(valuearr[counter]) == Convert.ToInt32(Session["OrgId"]))
{
addrow = 1;
}
}
counter++;
}
if (addrow > 0)
{
dt.Rows.Add(row);
}
}
GridView1.DataSource = dt;
GridView1.DataBind();
}