public MonitoringResponse GetElectricMeter(string Date)
{
string Datetime = Convert.ToDateTime(Date).ToString("yyyy-MM-dd");
MonitoringResponse re = new MonitoringResponse();
DbParam[] dbParams = new DbParam[]
{
new DbParam("@SqlWhere", DbType.String, Datetime, ParameterDirection.Input)
};
DataTable dt = this.ExecuteDataTable("Proc_GetElectricMeter", dbParams);
re.GetElectric = dt.ConvertToEntity <tbl_wms_OrderHeader>();
return(re);
}
public MonitoringResponse GetMonitoringReport()
{
MonitoringResponse re = new MonitoringResponse();
DbParam[] dbParams = new DbParam[]
{
new DbParam("@SqlWhere", DbType.String, "", ParameterDirection.Input)
};
DataSet ds = this.ExecuteDataSet("Proc_MonitoringReport", dbParams);
re.OrderQuantity = ds.Tables[0].ConvertToEntityCollection <tbl_wms_OrderHeader>();
//re.Efficiency = ds.Tables[1].ConvertToEntityCollection<tbl_wms_OrderHeader>();
re.TimelyRate = ds.Tables[1].ConvertToEntityCollection <tbl_wms_OrderHeader>();
re.WeeksOrders = ds.Tables[2].ConvertToEntityCollection <tbl_wms_OrderHeader>();
re.CarbonEmissions = ds.Tables[3].ConvertToEntityCollection <tbl_wms_OrderHeader>();
re.GetElectric = ds.Tables[4].ConvertToEntity <tbl_wms_OrderHeader>();
return(re);
}
public bool AddElectricMeter(string Date, string Office, string NFS, string Digital, string Inline)
{
MonitoringResponse re = new MonitoringResponse();
DbParam[] dbParams = new DbParam[]
{
new DbParam("@Date", DbType.String, Date, ParameterDirection.Input),
new DbParam("@Office", DbType.Decimal, Office, ParameterDirection.Input),
new DbParam("@NFS", DbType.Decimal, NFS, ParameterDirection.Input),
new DbParam("@Digital", DbType.Decimal, Digital, ParameterDirection.Input),
new DbParam("@Inline", DbType.Decimal, Inline, ParameterDirection.Input),
};
DataTable dt = this.ExecuteDataTable("Proc_AddElectricMeter", dbParams);
if (dt.Rows.Count > 0)
{
return(true);
}
return(false);
}
protected override void Execute(CodeActivityContext context)
{
// Getting OrganizationService from Context
var workflowContext = context.GetExtension <IWorkflowContext>();
var serviceFactory = context.GetExtension <IOrganizationServiceFactory>();
var orgService = serviceFactory.CreateOrganizationService(workflowContext.UserId);
List <MonitoringResponse> responses = new List <MonitoringResponse>();
MonitoringResponse response1 = new MonitoringResponse
{
SystemDisplayName = "System 1",
SystemLatency = "10 ms",
SystemStatusCode = "200"
};
responses.Add(response1);
MonitoringResponse response2 = new MonitoringResponse
{
SystemDisplayName = "System 2",
SystemLatency = "5000 ms",
SystemStatusCode = "500"
};
responses.Add(response2);
MonitoringResponse[] responseArray = responses.ToArray();
using (MemoryStream stream = new MemoryStream())
{
DataContractJsonSerializer serializer = new DataContractJsonSerializer(responseArray.GetType());
serializer.WriteObject(stream, responseArray);
string result = Encoding.Default.GetString(stream.ToArray());
//get JSON data serialized in string format in string variable
Response.Set(context, result);
}
}
