public List<Maticsoft.Model.Members.SiteMessageLog> DataTableToList(DataTable dt)
{
List<Maticsoft.Model.Members.SiteMessageLog> list = new List<Maticsoft.Model.Members.SiteMessageLog>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Maticsoft.Model.Members.SiteMessageLog item = new Maticsoft.Model.Members.SiteMessageLog();
if ((dt.Rows[i]["ID"] != null) && (dt.Rows[i]["ID"].ToString() != ""))
{
item.ID = int.Parse(dt.Rows[i]["ID"].ToString());
}
if ((dt.Rows[i]["MessageID"] != null) && (dt.Rows[i]["MessageID"].ToString() != ""))
{
item.MessageID = new int?(int.Parse(dt.Rows[i]["MessageID"].ToString()));
}
if ((dt.Rows[i]["MessageType"] != null) && (dt.Rows[i]["MessageType"].ToString() != ""))
{
item.MessageType = dt.Rows[i]["MessageType"].ToString();
}
if ((dt.Rows[i]["MessageState"] != null) && (dt.Rows[i]["MessageState"].ToString() != ""))
{
item.MessageState = dt.Rows[i]["MessageState"].ToString();
}
if ((dt.Rows[i]["ReceiverID"] != null) && (dt.Rows[i]["ReceiverID"].ToString() != ""))
{
item.ReceiverID = new int?(int.Parse(dt.Rows[i]["ReceiverID"].ToString()));
}
if ((dt.Rows[i]["Ext1"] != null) && (dt.Rows[i]["Ext1"].ToString() != ""))
{
item.Ext1 = dt.Rows[i]["Ext1"].ToString();
}
if ((dt.Rows[i]["Ext2"] != null) && (dt.Rows[i]["Ext2"].ToString() != ""))
{
item.Ext2 = dt.Rows[i]["Ext2"].ToString();
}
if ((dt.Rows[i]["ReceiverUserName"] != null) && (dt.Rows[i]["ReceiverUserName"].ToString() != ""))
{
item.ReceiverUserName = dt.Rows[i]["ReceiverUserName"].ToString();
}
list.Add(item);
}
}
return list;
}
public Maticsoft.Model.Members.SiteMessageLog GetModel(int ID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select top 1 ID,MessageID,MessageType,MessageState,ReceiverID,Ext1,Ext2,ReceiverUserName from SA_SiteMessageLog ");
builder.Append(" where ID=@ID");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.Int, 4) };
cmdParms[0].Value = ID;
Maticsoft.Model.Members.SiteMessageLog log = new Maticsoft.Model.Members.SiteMessageLog();
DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms);
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
if ((set.Tables[0].Rows[0]["ID"] != null) && (set.Tables[0].Rows[0]["ID"].ToString() != ""))
{
log.ID = int.Parse(set.Tables[0].Rows[0]["ID"].ToString());
}
if ((set.Tables[0].Rows[0]["MessageID"] != null) && (set.Tables[0].Rows[0]["MessageID"].ToString() != ""))
{
log.MessageID = new int?(int.Parse(set.Tables[0].Rows[0]["MessageID"].ToString()));
}
if ((set.Tables[0].Rows[0]["MessageType"] != null) && (set.Tables[0].Rows[0]["MessageType"].ToString() != ""))
{
log.MessageType = set.Tables[0].Rows[0]["MessageType"].ToString();
}
if ((set.Tables[0].Rows[0]["MessageState"] != null) && (set.Tables[0].Rows[0]["MessageState"].ToString() != ""))
{
log.MessageState = set.Tables[0].Rows[0]["MessageState"].ToString();
}
if ((set.Tables[0].Rows[0]["ReceiverID"] != null) && (set.Tables[0].Rows[0]["ReceiverID"].ToString() != ""))
{
log.ReceiverID = new int?(int.Parse(set.Tables[0].Rows[0]["ReceiverID"].ToString()));
}
if ((set.Tables[0].Rows[0]["Ext1"] != null) && (set.Tables[0].Rows[0]["Ext1"].ToString() != ""))
{
log.Ext1 = set.Tables[0].Rows[0]["Ext1"].ToString();
}
if ((set.Tables[0].Rows[0]["Ext2"] != null) && (set.Tables[0].Rows[0]["Ext2"].ToString() != ""))
{
log.Ext2 = set.Tables[0].Rows[0]["Ext2"].ToString();
}
if ((set.Tables[0].Rows[0]["ReceiverUserName"] != null) && (set.Tables[0].Rows[0]["ReceiverUserName"].ToString() != ""))
{
log.ReceiverUserName = set.Tables[0].Rows[0]["ReceiverUserName"].ToString();
}
return log;
}