public List<Maticsoft.Email.Model.MailConfig> DataTableToList(DataTable dt)
{
List<Maticsoft.Email.Model.MailConfig> list = new List<Maticsoft.Email.Model.MailConfig>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Maticsoft.Email.Model.MailConfig item = new Maticsoft.Email.Model.MailConfig();
if (dt.Rows[i]["ID"].ToString() != "")
{
item.ID = int.Parse(dt.Rows[i]["ID"].ToString());
}
if (dt.Rows[i]["UserID"].ToString() != "")
{
item.UserID = int.Parse(dt.Rows[i]["UserID"].ToString());
}
item.Mailaddress = dt.Rows[i]["Mailaddress"].ToString();
item.Username = dt.Rows[i]["Username"].ToString();
item.Password = dt.Rows[i]["Password"].ToString();
item.SMTPServer = dt.Rows[i]["SMTPServer"].ToString();
if (dt.Rows[i]["SMTPPort"].ToString() != "")
{
item.SMTPPort = int.Parse(dt.Rows[i]["SMTPPort"].ToString());
}
if (dt.Rows[i]["SMTPSSL"].ToString() != "")
{
item.SMTPSSL = dt.Rows[i]["SMTPSSL"].ToString() == "1";
}
item.POPServer = dt.Rows[i]["POPServer"].ToString();
if (dt.Rows[i]["POPPort"].ToString() != "")
{
item.POPPort = int.Parse(dt.Rows[i]["POPPort"].ToString());
}
if (dt.Rows[i]["POPSSL"].ToString() != "")
{
item.POPSSL = dt.Rows[i]["POPSSL"].ToString() == "1";
}
list.Add(item);
}
}
return list;
}
public Maticsoft.Email.Model.MailConfig GetModel()
{
StringBuilder builder = new StringBuilder();
builder.Append("select ID,UserID,Mailaddress,Username,Password,SMTPServer,SMTPPort,SMTPSSL,POPServer,POPPort,POPSSL from Accounts_MailConfig LIMIT 1");
Maticsoft.Email.Model.MailConfig config = new Maticsoft.Email.Model.MailConfig();
DataSet set = DbHelperMySQL.Query(builder.ToString());
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
if (set.Tables[0].Rows[0]["ID"].ToString() != "")
{
config.ID = int.Parse(set.Tables[0].Rows[0]["ID"].ToString());
}
if (set.Tables[0].Rows[0]["UserID"].ToString() != "")
{
config.UserID = int.Parse(set.Tables[0].Rows[0]["UserID"].ToString());
}
config.Mailaddress = set.Tables[0].Rows[0]["Mailaddress"].ToString();
config.Username = set.Tables[0].Rows[0]["Username"].ToString();
config.Password = set.Tables[0].Rows[0]["Password"].ToString();
config.SMTPServer = set.Tables[0].Rows[0]["SMTPServer"].ToString();
if (set.Tables[0].Rows[0]["SMTPPort"].ToString() != "")
{
config.SMTPPort = int.Parse(set.Tables[0].Rows[0]["SMTPPort"].ToString());
}
if (set.Tables[0].Rows[0]["SMTPSSL"].ToString() != "")
{
config.SMTPSSL = set.Tables[0].Rows[0]["SMTPSSL"].ToString() == "1";
}
config.POPServer = set.Tables[0].Rows[0]["POPServer"].ToString();
if (set.Tables[0].Rows[0]["POPPort"].ToString() != "")
{
config.POPPort = int.Parse(set.Tables[0].Rows[0]["POPPort"].ToString());
}
if (set.Tables[0].Rows[0]["POPSSL"].ToString() != "")
{
config.POPSSL = set.Tables[0].Rows[0]["POPSSL"].ToString() == "1";
}
return config;
}
public Maticsoft.Email.Model.MailConfig GetModel(int ID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select ID,UserID,Mailaddress,Username,Password,SMTPServer,SMTPPort,SMTPSSL,POPServer,POPPort,POPSSL from Accounts_MailConfig ");
builder.Append(" where ID=?ID LIMIT 1");
MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("?ID", MySqlDbType.Int32, 4) };
cmdParms[0].Value = ID;
Maticsoft.Email.Model.MailConfig config = new Maticsoft.Email.Model.MailConfig();
DataSet set = DbHelperMySQL.Query(builder.ToString(), cmdParms);
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
if (set.Tables[0].Rows[0]["ID"].ToString() != "")
{
config.ID = int.Parse(set.Tables[0].Rows[0]["ID"].ToString());
}
if (set.Tables[0].Rows[0]["UserID"].ToString() != "")
{
config.UserID = int.Parse(set.Tables[0].Rows[0]["UserID"].ToString());
}
config.Mailaddress = set.Tables[0].Rows[0]["Mailaddress"].ToString();
config.Username = set.Tables[0].Rows[0]["Username"].ToString();
config.Password = set.Tables[0].Rows[0]["Password"].ToString();
config.SMTPServer = set.Tables[0].Rows[0]["SMTPServer"].ToString();
if (set.Tables[0].Rows[0]["SMTPPort"].ToString() != "")
{
config.SMTPPort = int.Parse(set.Tables[0].Rows[0]["SMTPPort"].ToString());
}
if (set.Tables[0].Rows[0]["SMTPSSL"].ToString() != "")
{
config.SMTPSSL = set.Tables[0].Rows[0]["SMTPSSL"].ToString() == "1";
}
config.POPServer = set.Tables[0].Rows[0]["POPServer"].ToString();
if (set.Tables[0].Rows[0]["POPPort"].ToString() != "")
{
config.POPPort = int.Parse(set.Tables[0].Rows[0]["POPPort"].ToString());
}
if (set.Tables[0].Rows[0]["POPSSL"].ToString() != "")
{
config.POPSSL = set.Tables[0].Rows[0]["POPSSL"].ToString() == "1";
}
return config;
}