public Container Get_Container_By_Id(int ID)
{
Container _Container = new Container();
DataTable dt = Container_DA.Get_Container_By_Id(ID);
foreach (DataRow row in dt.Rows)
{
_Container.ID = ID;
_Container.Name = row["Name"].ToString();
_Container.CBM = row["CBM"].ToString();
}
return _Container;
}
public string Insert(string Name, string CBM)
{
Container _Container = new Container();
_Container.Name = Name;
_Container.CBM = CBM;
_Container.CreatedBy = Session["User"].ToString();
return Container_DA.Insert(_Container);
}
public string Update(int ID, string Name, string CBM)
{
Container _Container = new Container();
_Container.ID = ID;
_Container.Name = Name;
_Container.CBM = CBM;
_Container.UpdatedBy = Session["User"].ToString();
if (_Container.UpdatedBy.ToString().ToUpper() == ("Mr. Asif").ToString().ToUpper() || _Container.UpdatedBy.ToString().ToUpper() == ("Saud Piracha").ToString().ToUpper())
{
return Container_DA.Update(_Container);
}
else
{
return "-1";
}
}
public static string Insert(Container _Container)
{
DbCommand command = Catalog_Access.CreateCommand();
//Have to wite the stored procedure
command.CommandText = "sp_insert_Container";
DbParameter param;
param = command.CreateParameter();
param.ParameterName = "@Name";
param.Value = _Container.Name;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@CBM";
param.Value = _Container.CBM;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@CreatedBy";
param.Value = _Container.CreatedBy;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Return";
param.DbType = DbType.String;
param.Size = 2;
param.Direction = ParameterDirection.Output;
command.Parameters.Add(param);
Catalog_Access.ExecuteNonQuery(command);
string Return = command.Parameters["@Return"].Value.ToString();
return Return;
}
public static string Update(Container _Container)
{
DbCommand command = Catalog_Access.CreateCommand();
command.CommandText = "sp_Update_Container";
DbParameter param;
param = command.CreateParameter();
param.ParameterName = "@ID";
param.Value = _Container.ID;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Name";
param.Value = _Container.Name;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@CBM";
param.Value = _Container.CBM;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@UpdatedBy";
param.Value = _Container.UpdatedBy;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@Return";
param.DbType = DbType.String;
param.Size = 2;
param.Direction = ParameterDirection.Output;
command.Parameters.Add(param);
Catalog_Access.ExecuteNonQuery(command);
string Return = command.Parameters["@Return"].Value.ToString();
return Return;
}
/// <summary>
/// Initializes a new instance of <see cref="TelemetryProvider"/>
/// </summary>
/// <param name="container">The IoC container</param>
public TelemetryProvider(Container container)
{
m_Container = container;
var dueTime = TimeSpan.FromMinutes(60 - DateTime.Now.Minute);
m_StorageTimer = new Timer(HandleStorageTimer, null, dueTime, TimeSpan.FromHours(2));
m_Client = container.Resolve<MqttClient>();
Task.Factory.StartNew(EstablishConnection);
}