SqlOrmEntity.TrimConnect 1.1.8

// Class Created For TrimSql // Solid Task | Access DataBase | // Created On | 04/08/2016 11:27:34 AM // Latest Build | For Visual Studio 2017 // Aut Token | b7kkildsd52-88720-4wfe-8871-oljjk43455 // Version Update | V2.4.17 public class Keys : SqlOrmEntity.TrimConnectsql

{ public string MachineName; public Guid InstallationID; public string InstanceName; public int Client; public byte PublicKey; public byte SymmetricKey;

/// <summary>
/// Initializes a new instance of the <see cref="Keys"/> class.
/// </summary>
/// <param name="PrevID">The previous identifier.</param>
public Keys(int PrevID = 0) : base(PrevID)
{
}
/// <summary>
/// Procses the initilise.
/// pass 1 , optional param for encryption
/// </summary>
protected override void _ProcsInitilise()
{
    ConnectionString = FetchConnectionString("jDB");
    _InsertProceduer = "Insert_Keys";
    _UpdateProceduer = "Update_Keys";
    _deleteProceduer = "Delete_Keys";
    _GetProceduer = "GetAll_Keys_ByID";
}

/// <summary>
/// Creates the schema parameters.
/// </summary>
/// <returns>IDataParameter[].</returns>
protected override IDataParameter[] CreateSchemaParams()
{
    SqlParameter[] Sys_sp_Prms = {
    new SqlParameter ("@MachineName",SqlDbType.NVarChar,512),
    new SqlParameter ("@InstallationID",SqlDbType.UniqueIdentifier),
    new SqlParameter ("@InstanceName",SqlDbType.NVarChar,64),
    new SqlParameter ("@Client",SqlDbType.Int),
    new SqlParameter ("@PublicKey",SqlDbType.Image,2147483647),
    new SqlParameter ("@SymmetricKey",SqlDbType.Image,2147483647)};
    Sys_sp_Prms[0].Value = MachineName;
    Sys_sp_Prms[1].Value = InstallationID;
    Sys_sp_Prms[2].Value = InstanceName;
    Sys_sp_Prms[3].Value = Client;
    Sys_sp_Prms[4].Value = PublicKey;
    Sys_sp_Prms[5].Value = SymmetricKey;

    return Sys_sp_Prms;

}
/// <summary>
/// Reads the data from Sql and push to DataLayer.
/// </summary>
protected override void _ReadData()
{
    if (_PrevID == 0) return;
    DataTable dt = RetrieveRowData(_PrevID);
    if (dt.Rows.Count == 1)
    {
        MachineName = (string)dt.Rows[0]["MachineName"];
        InstallationID = (Guid)dt.Rows[0]["InstallationID"];
        InstanceName = (string)dt.Rows[0]["InstanceName"];
        Client = (int)dt.Rows[0]["Client"];
        PublicKey = (byte)dt.Rows[0]["PublicKey"];
        SymmetricKey = (byte)dt.Rows[0]["SymmetricKey"];
    }
    else
    {
        _PrevID = 0;
    }
}

}