public dynamic GetEmployeeDetails(int pageLength, String AccountName, String AccountEmail, int pageIndex, string sConstring) { DataSet ds = new DataSet(); ODAl.AdminAccess rptObj = new ODAl.AdminAccess(sConstring); UD.TablePreferences EmployeeTablePreferences = new UD.TablePreferences("", "", true, false); Dictionary <string, UD.TablePreferences> EmployeeDictionary = new Dictionary <string, UD.TablePreferences>(); EmployeeDictionary.Add("Employees", EmployeeTablePreferences); ds = rptObj.GetEmployeeDetails(pageLength, AccountName, AccountEmail, pageIndex); if (ds == null) { responseObj.Add(new JProperty("Success", "false")); responseObj.Add(new JProperty("Message", "Data Base Error")); } else { helper.ParseDataSet(ds, EmployeeDictionary); responseObj = helper.GetDataSetJobj; } return(responseObj); }
public JObject GetProfileDetails(int id, string conString) { DataSet ds = new DataSet(); ODAl.AdminAccess rptObj = new ODAl.AdminAccess(conString); UD.TablePreferences EmployeeTablePreferences = new UD.TablePreferences("", "", true, false); Dictionary <string, UD.TablePreferences> EmployeeDictionary = new Dictionary <string, UD.TablePreferences>(); EmployeeDictionary.Add("Employees", EmployeeTablePreferences); ds = rptObj.GetProfileDetails(id); if (ds == null) { responseObj.Add(new JProperty("Success", "false")); responseObj.Add(new JProperty("Message", "Data Base Error")); } else { helper.ParseDataSet(ds, EmployeeDictionary); responseObj = helper.GetDataSetJobj; } return(responseObj); }
/// <summary> /// Converts the data set to JSon/Xml object. /// </summary> /// <param name="ds">The DataSet.</param> /// <returns></returns> public void ParseDataSet(DataSet ds, Dictionary <string, TablePreferences> tablePreferences = null) { if (ds == null) { return; } try { TablePreferences currentTablePreferences = null; string childXmlElementNameForRows = ""; bool columnValuesAsXmlAttributes = true; bool singleRowAsSingleEntity = true; string currentTableRootName = string.Empty; foreach (DataTable table in ds.Tables) { currentTablePreferences = null; currentTableRootName = string.Empty; childXmlElementNameForRows = ""; columnValuesAsXmlAttributes = true; singleRowAsSingleEntity = true; if (tablePreferences != null && tablePreferences.ContainsKey(table.TableName)) { tablePreferences.TryGetValue(table.TableName, out currentTablePreferences); if (currentTablePreferences != null) { currentTableRootName = currentTablePreferences.RootName == null ? string.Empty : currentTablePreferences.RootName; childXmlElementNameForRows = currentTablePreferences.ChildElementNameForRows == null ? string.Empty : currentTablePreferences.ChildElementNameForRows; columnValuesAsXmlAttributes = currentTablePreferences.ColumnValuesAsXmlAttributes; singleRowAsSingleEntity = currentTablePreferences.SingleRowAsSingleEntity; } } if (table.TableName.Equals(Label.OUTPUT_PARAMETERS)) { foreach (DataColumn column in table.Columns) { this.CreateProperty(column.ColumnName, table.Rows[0][column.ColumnName], true); } } else { this._jArr = new JArray(); JObject rowJObj = new JObject(); XmlElement tableRootElement = null; XmlElement tableRowElement = null; XmlElement columnElement = null; string columnValue = ""; if (this._isOutputXmlFormat) { tableRootElement = xmlDoc.CreateElement(currentTableRootName.Length > 0 ? currentTableRootName : table.TableName); } if (singleRowAsSingleEntity && table.Rows.Count == 1) { if (this._isOutputXmlFormat) { tableRootElement = xmlDoc.CreateElement(childXmlElementNameForRows.Length > 0 ? childXmlElementNameForRows : currentTableRootName.Length > 0 ? currentTableRootName : table.TableName); } rowJObj = new JObject(); if (table.Rows.Count > 0) { foreach (DataColumn column in table.Columns) { if (table.Rows[0][column.ColumnName] is DBNull || table.Rows[0][column.ColumnName] == null) { columnValue = ""; } else { columnValue = table.Rows[0][column.ColumnName].ToString(); } if (this._isOutputXmlFormat) { if (columnValuesAsXmlAttributes) { tableRootElement.SetAttribute(column.ColumnName, columnValue); } else { columnElement = xmlDoc.CreateElement(column.ColumnName); columnElement.InnerText = columnValue; tableRootElement.AppendChild(columnElement); } } else { bool boolResult = false; int intResult = 0; float floatResult = 0; if (column.ColumnName.Equals(Label.SUCCESS, StringComparison.CurrentCultureIgnoreCase) || bool.TryParse(columnValue, out boolResult)) { rowJObj.Add(new JProperty(column.ColumnName, boolResult)); } else if (int.TryParse(columnValue, out intResult)) { rowJObj.Add(new JProperty(column.ColumnName, intResult)); } else if (float.TryParse(columnValue, out floatResult)) { rowJObj.Add(new JProperty(column.ColumnName, columnValue)); } else { rowJObj.Add(new JProperty(column.ColumnName, columnValue)); } } } } if (this._isOutputXmlFormat) { rootElement.AppendChild(tableRootElement); } else { this._jObj.Add(new JProperty(childXmlElementNameForRows.Length > 0 ? childXmlElementNameForRows : currentTableRootName.Length > 0 ? currentTableRootName : table.TableName, rowJObj)); } } else { foreach (DataRow row in table.Rows) { rowJObj = new JObject(); if (tableRootElement != null && childXmlElementNameForRows.Length > 0) { tableRowElement = xmlDoc.CreateElement(childXmlElementNameForRows); } else if (tableRootElement != null) { tableRowElement = xmlDoc.CreateElement(currentTableRootName.Length > 0 ? currentTableRootName : table.TableName); } foreach (DataColumn column in table.Columns) { if (row[column.ColumnName] is DBNull || row[column.ColumnName] == null) { columnValue = ""; } else { columnValue = row[column.ColumnName].ToString(); } if (this._isOutputXmlFormat) { if (columnValuesAsXmlAttributes) { tableRowElement.SetAttribute(column.ColumnName, columnValue); } else { columnElement = xmlDoc.CreateElement(column.ColumnName); columnElement.InnerText = columnValue; tableRowElement.AppendChild(columnElement); } } else { bool boolResult = false; int intResult = 0; float floatResult = 0; if (column.ColumnName.Equals(Label.SUCCESS, StringComparison.CurrentCultureIgnoreCase) || bool.TryParse(columnValue, out boolResult)) { rowJObj.Add(new JProperty(column.ColumnName, boolResult)); } else if (int.TryParse(columnValue, out intResult)) { rowJObj.Add(new JProperty(column.ColumnName, intResult)); } else if (float.TryParse(columnValue, out floatResult)) { rowJObj.Add(new JProperty(column.ColumnName, floatResult)); } else { rowJObj.Add(new JProperty(column.ColumnName, columnValue)); } } } if (this._isOutputXmlFormat) { tableRootElement.AppendChild(tableRowElement); } else { this._jArr.Add(rowJObj); } } if (this._isOutputXmlFormat) { rootElement.AppendChild(tableRootElement); } else { this._jObj.Add(new JProperty(currentTableRootName.Length > 0 ? currentTableRootName : table.TableName, this._jArr)); } } } } } catch (Exception ex) { //Utilities.Logger.Error(ex.ToString()); } finally { } }