public static string DateDisplay(Int32 teamid)
{
DateTime datestart, dateend;
SystemObjects.TableF _tablef = new SystemObjects.TableF();
_tablef.TeamID = teamid;
DataSet ds = new DataSet();
try
{
DataTable dt = new DataTable();
dt = _tablef.displayRatingsDate();
DataTable dtdate = new DataTable();
dtdate.Columns.Add("Dates");
dtdate.Rows.Add("Please select Month - Year...");
datestart = Convert.ToDateTime(dt.Rows[0]["RateDateMin"].ToString());
dateend = Convert.ToDateTime(dt.Rows[0]["RateDateMax"].ToString());
while (datestart <= dateend)
{
DateTime datestart_ = Convert.ToDateTime(datestart.Month.ToString() + "/01/" + datestart.Year.ToString());
dtdate.Rows.Add(String.Format("{0:MMMM - yyyy}", datestart_));
datestart = datestart.AddMonths(1);
}
ds.Tables.Add(dtdate);
}
catch (Exception ex)
{
}
return ds.GetXml();
}
public static string MetricDisplay(Int32 teamid)
{
DataTable dummy = new DataTable();
dummy.Columns.Add("TeamMetricID", typeof(Int32));
//dummy.Columns.Add("ExhibitID", typeof(Int32));
dummy.Columns.Add("Metrics");
dummy.Columns.Add("TeamTarget");
//dummy.Rows.Add();
SystemObjects.TableF _tablef = new SystemObjects.TableF();
TableF.MyMetric _mymetric = new TableF.MyMetric();
_tablef.TeamID = teamid;
DataSet ds = new DataSet();
try
{
//dummy.Merge(_tablef.displayTeamMetrics());
ds.Tables.Add((DataTable)_mymetric.Session["MyMetrics1"]);
}
catch (Exception ex)
{
}
return(ds.GetXml());
}
public static string DateDisplay(Int32 teamid)
{
DateTime datestart, dateend;
SystemObjects.TableF _tablef = new SystemObjects.TableF();
_tablef.TeamID = teamid;
DataSet ds = new DataSet();
try
{
DataTable dt = new DataTable();
dt = _tablef.displayRatingsDate();
DataTable dtdate = new DataTable();
dtdate.Columns.Add("Dates");
dtdate.Rows.Add("Please select Month - Year...");
datestart = Convert.ToDateTime(dt.Rows[0]["RateDateMin"].ToString());
dateend = Convert.ToDateTime(dt.Rows[0]["RateDateMax"].ToString());
while (datestart <= dateend)
{
DateTime datestart_ = Convert.ToDateTime(datestart.Month.ToString() + "/01/" + datestart.Year.ToString());
dtdate.Rows.Add(String.Format("{0:MMMM - yyyy}", datestart_));
datestart = datestart.AddMonths(1);
}
ds.Tables.Add(dtdate);
}
catch (Exception ex)
{
}
return(ds.GetXml());
}
public static string MetricDisplay(Int32 keyid, Int32 teamid)
{
DataTable dummy = new DataTable();
dummy.Columns.Add("MetricsID", typeof(Int32));
dummy.Columns.Add("Metrics");
dummy.Columns.Add("MetricsDesc");
dummy.Columns.Add("ItemName");
//dummy.Rows.Add();
SystemObjects.TableF _tablef = new SystemObjects.TableF();
_tablef.KeyID = keyid;
_tablef.TeamID = teamid;
DataSet ds = new DataSet();
try
{
dummy.Merge(_tablef.displayKeyMetrics());
ds.Tables.Add(dummy);
}
catch (Exception ex)
{
}
return(ds.GetXml());
}
public static string InsertTeamRating(List <string> _arr)
{
SystemObjects.TableF _tablef = new SystemObjects.TableF();
_tablef.TeamMetricID = Convert.ToInt32(_arr[0].ToString());
_tablef.RateDate = Convert.ToDateTime(_arr[1].ToString());
_tablef.Rating = Convert.ToDecimal(_arr[2].ToString());
_tablef.Remarks = _arr[3].ToString();
_tablef.WorkdayID = Convert.ToInt32(_arr[4].ToString());
return(_tablef.InsertTeamRating());
}
public static string saveTableFTeamMetric(List <string> _arr)
{
SystemObjects.TableF _tablef = new SystemObjects.TableF();
_tablef.TeamID = Convert.ToInt32(_arr[0].ToString());
_tablef.MetricID = Convert.ToInt32(_arr[1].ToString());
_tablef.TargetDirect = _arr[2].ToString();
_tablef.Target = Convert.ToDecimal(_arr[3].ToString());
_tablef.TargetDescript = _arr[4].ToString();
_tablef.WorkdayID = Convert.ToInt32(_arr[5].ToString());
_tablef.SourceName = _arr[6].ToString();
return(_tablef.InsertTeamMetric());
}
public static string saveMetric(List<string> _arr)
{
SystemObjects.TableF _tablef = new SystemObjects.TableF();
_tablef.KeyID = Convert.ToInt32(_arr[0].ToString());
_tablef.ItemID = Convert.ToInt32(_arr[1].ToString());
_tablef.Metrics = _arr[2].ToString();
_tablef.MetricDesc = _arr[3].ToString();
_tablef.Calculations = _arr[4].ToString();
_tablef.Considerations = _arr[5].ToString();
_tablef.BestPractice = _arr[6].ToString();
_tablef.Frequency = _arr[7].ToString();
_tablef.TeamID = Convert.ToInt32(_arr[8].ToString());
_tablef.WorkdayID = Convert.ToInt32(_arr[9].ToString());
return _tablef.InsertMetric();
}
public static string MetricSpecificDisplay(Int32 metricid)
{
SystemObjects.TableF _tablef = new SystemObjects.TableF();
_tablef.MetricID = metricid;
DataSet ds = new DataSet();
try
{
ds.Tables.Add(_tablef.displayMetricSpecific());
}
catch (Exception ex)
{
}
return ds.GetXml();
}
public static string saveMetric(List <string> _arr)
{
SystemObjects.TableF _tablef = new SystemObjects.TableF();
_tablef.KeyID = Convert.ToInt32(_arr[0].ToString());
_tablef.ItemID = Convert.ToInt32(_arr[1].ToString());
_tablef.Metrics = _arr[2].ToString();
_tablef.MetricDesc = _arr[3].ToString();
_tablef.Calculations = _arr[4].ToString();
_tablef.Considerations = _arr[5].ToString();
_tablef.BestPractice = _arr[6].ToString();
_tablef.Frequency = _arr[7].ToString();
_tablef.TeamID = Convert.ToInt32(_arr[8].ToString());
_tablef.WorkdayID = Convert.ToInt32(_arr[9].ToString());
return(_tablef.InsertMetric());
}
public static string PTDisplay()
{
SystemObjects.TableF _tablef = new SystemObjects.TableF();
TableF.MyMetric _mymetric = new TableF.MyMetric();
DataSet ds = new DataSet();
try
{
ds.Tables.Add(_tablef.displayTeamMetrics());
}
catch (Exception ex)
{
}
return(ds.GetXml());
}
public static string MetricSpecificDisplay(Int32 metricid)
{
SystemObjects.TableF _tablef = new SystemObjects.TableF();
_tablef.MetricID = metricid;
DataSet ds = new DataSet();
try
{
ds.Tables.Add(_tablef.displayMetricSpecific());
}
catch (Exception ex)
{
}
return(ds.GetXml());
}
public static string RatingDisplay(List <string> _arr)
{
SystemObjects.TableF _tablef = new SystemObjects.TableF();
_tablef.TeamMetricID = Convert.ToInt32(_arr[0].ToString());
_tablef.RateDate = Convert.ToDateTime(_arr[1].ToString());
DataSet ds = new DataSet();
try
{
ds.Tables.Add(_tablef.displayRatings());
}
catch (Exception ex)
{
}
return(ds.GetXml());
}
public static string ManualDisplay(List <string> _arr)
{
SystemObjects.TableF _tablef = new SystemObjects.TableF();
TableF.MyMetric _mymetric = new TableF.MyMetric();
_tablef.TeamID = Convert.ToInt32(_arr[0].ToString());
DataSet ds = new DataSet();
try
{
ds.Tables.Add(_tablef.displayTeamMetrics());
}
catch (Exception ex)
{
}
return(ds.GetXml());
}
public static string TargetDisplay(Int32 metricid, Int32 teamid)
{
SystemObjects.TableF _tablef = new SystemObjects.TableF();
_tablef.MetricID = metricid;
_tablef.TeamID = teamid;
DataSet ds = new DataSet();
try
{
ds.Tables.Add(_tablef.displayTarget());
}
catch (Exception ex)
{
}
return(ds.GetXml());
}
public static string SummaryDisplay(List<string> _arr)
{
SystemObjects.TableF _tablef = new SystemObjects.TableF();
_tablef.TeamID = Convert.ToInt32(_arr[0].ToString());
_tablef.RateDate = Convert.ToDateTime(_arr[1].ToString());
DataSet ds = new DataSet();
try
{
ds = _tablef.displayRatingsTeam();
}
catch (Exception ex)
{
}
return ds.GetXml();
}
public static string ATODisplay(List<string> _arr)
{
SystemObjects.TableF _tablef = new SystemObjects.TableF();
TableF.MyMetric _mymetric = new TableF.MyMetric();
_tablef.TeamID = Convert.ToInt32(_arr[0].ToString());
_tablef.RateDate = Convert.ToDateTime(_arr[1].ToString());
DataSet ds = new DataSet();
try
{
ds.Tables.Add(_tablef.displayATOMetrics());
ds.Tables.Add(_tablef.displayTeamMetrics());
}
catch (Exception ex)
{
}
return ds.GetXml();
}
public static string test1(Int32 exid)
{
DataTable dummy = new DataTable();
dummy.Columns.Add("KeyID", typeof(Int32));
dummy.Columns.Add("KeyName");
//dummy.Rows.Add();
SystemObjects.TableF _tablef = new SystemObjects.TableF();
_tablef.ExhibitID = exid;
DataSet ds = new DataSet();
try
{
dummy.Merge(_tablef.displayExKeys());
ds.Tables.Add(dummy);
}
catch (Exception ex)
{
}
return(ds.GetXml());
}
public static string MetricDisplay(Int32 keyid, Int32 teamid)
{
DataTable dummy = new DataTable();
dummy.Columns.Add("MetricsID", typeof(Int32));
dummy.Columns.Add("Metrics");
dummy.Columns.Add("MetricsDesc");
dummy.Columns.Add("ItemName");
//dummy.Rows.Add();
SystemObjects.TableF _tablef = new SystemObjects.TableF();
_tablef.KeyID = keyid;
_tablef.TeamID = teamid;
DataSet ds = new DataSet();
try
{
dummy.Merge(_tablef.displayKeyMetrics());
ds.Tables.Add(dummy);
}
catch (Exception ex)
{
}
return ds.GetXml();
}
public static string TargetDisplay(Int32 metricid, Int32 teamid)
{
SystemObjects.TableF _tablef = new SystemObjects.TableF();
_tablef.MetricID = metricid;
_tablef.TeamID = teamid;
DataSet ds = new DataSet();
try
{
ds.Tables.Add(_tablef.displayTarget());
}
catch (Exception ex)
{
}
return ds.GetXml();
}
public static string InsertTeamRating(List<string> _arr)
{
SystemObjects.TableF _tablef = new SystemObjects.TableF();
_tablef.TeamMetricID = Convert.ToInt32(_arr[0].ToString());
_tablef.RateDate = Convert.ToDateTime(_arr[1].ToString());
_tablef.Rating = Convert.ToDecimal(_arr[2].ToString());
_tablef.Remarks = _arr[3].ToString();
_tablef.WorkdayID = Convert.ToInt32(_arr[4].ToString());
return _tablef.InsertTeamRating();
}
public static string PTDisplay()
{
SystemObjects.TableF _tablef = new SystemObjects.TableF();
TableF.MyMetric _mymetric = new TableF.MyMetric();
DataSet ds = new DataSet();
try
{
ds.Tables.Add(_tablef.displayTeamMetrics());
}
catch (Exception ex)
{
}
return ds.GetXml();
}
public static string MetricDisplay(Int32 teamid)
{
DataTable dummy = new DataTable();
dummy.Columns.Add("TeamMetricID", typeof(Int32));
//dummy.Columns.Add("ExhibitID", typeof(Int32));
dummy.Columns.Add("Metrics");
dummy.Columns.Add("TeamTarget");
//dummy.Rows.Add();
SystemObjects.TableF _tablef = new SystemObjects.TableF();
TableF.MyMetric _mymetric = new TableF.MyMetric();
_tablef.TeamID = teamid;
DataSet ds = new DataSet();
try
{
//dummy.Merge(_tablef.displayTeamMetrics());
ds.Tables.Add((DataTable)_mymetric.Session["MyMetrics1"]);
}
catch (Exception ex)
{
}
return ds.GetXml();
}
public static string test1(Int32 exid)
{
DataTable dummy = new DataTable();
dummy.Columns.Add("KeyID", typeof(Int32));
dummy.Columns.Add("KeyName");
//dummy.Rows.Add();
SystemObjects.TableF _tablef = new SystemObjects.TableF();
_tablef.ExhibitID = exid;
DataSet ds = new DataSet();
try
{
dummy.Merge(_tablef.displayExKeys());
ds.Tables.Add(dummy);
}
catch (Exception ex)
{
}
return ds.GetXml();
}
public static string saveTableFTeamMetric(List<string> _arr)
{
SystemObjects.TableF _tablef = new SystemObjects.TableF();
_tablef.TeamID = Convert.ToInt32(_arr[0].ToString());
_tablef.MetricID = Convert.ToInt32(_arr[1].ToString());
_tablef.TargetDirect = _arr[2].ToString();
_tablef.Target = Convert.ToDecimal(_arr[3].ToString());
_tablef.TargetDescript = _arr[4].ToString();
_tablef.WorkdayID = Convert.ToInt32(_arr[5].ToString());
_tablef.SourceName = _arr[6].ToString();
return _tablef.InsertTeamMetric();
}
