protected override void BuildParameters()
{
base.BuildParameters();
SQLParam sqlparam = new SQLParam();
sqlparam.Name = "@UserID";
sqlparam.Type = System.Data.SqlDbType.Int;
sqlparam.Value = UserId.ToString();
sqlparam.IntValue = UserId;
sqlparam.ColumnName = "UserID";
m_sql.parameters.Add(sqlparam);
sqlparam = new SQLParam();
sqlparam.Name = "@SignInDate";
sqlparam.Type = SqlDbType.Date;
sqlparam.Value = SignInDate.ToString("yyyy-mm-dd");
sqlparam.dtValue = SignInDate;
sqlparam.ColumnName = "SignInDate";
sqlparam.IncludeInModDT = true;
m_sql.parameters.Add(sqlparam);
sqlparam = new SQLParam();
sqlparam.Name = "@SignedIn";
sqlparam.Type = SqlDbType.Bit;
sqlparam.Value = SignedIn.ToString();
if (SignedIn)
{
sqlparam.IntValue = 1;
}
else
{
sqlparam.IntValue = 0;
}
sqlparam.ColumnName = "SignedIn";
sqlparam.IncludeInModDT = false;
m_sql.parameters.Add(sqlparam);
sqlparam = new SQLParam();
sqlparam.Name = "@InTime";
sqlparam.Type = SqlDbType.DateTime;
sqlparam.Value = InTime.ToString();
sqlparam.dtValue = InTime;
sqlparam.ColumnName = "InTime";
sqlparam.IncludeInModDT = false;
m_sql.parameters.Add(sqlparam);
sqlparam = new SQLParam();
sqlparam.Name = "@OutTime";
sqlparam.Type = SqlDbType.DateTime;
sqlparam.Value = OutTime.ToString();
sqlparam.dtValue = OutTime;
sqlparam.ColumnName = "OutTime";
sqlparam.IncludeInModDT = false;
m_sql.parameters.Add(sqlparam);
if (m_IncludeIDInParameters)
{
sqlparam = new SQLParam();
sqlparam.Name = "@ID";
sqlparam.Type = SqlDbType.Int;
sqlparam.Value = Convert.ToString(ID);
sqlparam.IntValue = ID;
sqlparam.ColumnName = m_primarykey;
sqlparam.IsPrimaryKey = true;
sqlparam.IncludeInModDT = true;
m_sql.parameters.Add(sqlparam);
}
}
public string GetRawKey()
{
return(SignInDate.StorageString());
}
