public List<smtpservers> smtpserversGetAll() { List<smtpservers> lstsmtpservers = new List<smtpservers>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "smtpserversGetAll").Tables[0]; if (dt.Rows.Count > 0) { int colSmtpServerId = dt.Columns["SmtpServerId"].Ordinal; int colSmtpServerHostname = dt.Columns["SmtpServerHostname"].Ordinal; int colSmtpServerPort = dt.Columns["SmtpServerPort"].Ordinal; int colSmtpServerAccount = dt.Columns["SmtpServerAccount"].Ordinal; int colSmtpServerPassword = dt.Columns["SmtpServerPassword"].Ordinal; int colStmpServerEnabled = dt.Columns["StmpServerEnabled"].Ordinal; for (int i = 0; dt.Rows.Count > i; i++) { smtpservers NewEnt = new smtpservers(); NewEnt.SmtpServerId = Int32.Parse(dt.Rows[i].ItemArray[colSmtpServerId].ToString()); NewEnt.SmtpServerHostname = dt.Rows[i].ItemArray[colSmtpServerHostname].ToString(); NewEnt.SmtpServerPort = dt.Rows[i].ItemArray[colSmtpServerPort].ToString(); NewEnt.SmtpServerAccount = dt.Rows[i].ItemArray[colSmtpServerAccount].ToString(); NewEnt.SmtpServerPassword = dt.Rows[i].ItemArray[colSmtpServerPassword].ToString(); NewEnt.StmpServerEnabled = sbyte.Parse(dt.Rows[i].ItemArray[colStmpServerEnabled].ToString()); lstsmtpservers.Add(NewEnt); } } return lstsmtpservers; } catch(Exception ex) { throw ex; } }
public int smtpserversAdd( smtpservers smtpservers) { try { return (int)SqlHelper.ExecuteScalar(SqlImplHelper.getConnectionString(), "smtpserversAdd", smtpservers.SmtpServerHostname, smtpservers.SmtpServerPort, smtpservers.SmtpServerAccount, smtpservers.SmtpServerPassword, smtpservers.StmpServerEnabled); } catch(Exception ex) { throw ex; } }
public bool smtpserversUpdate(smtpservers smtpservers) { smtpserversImpl osmtpserversImpl = new smtpserversImpl(); return osmtpserversImpl.smtpserversUpdate( smtpservers); }
public int smtpserversAdd(smtpservers smtpservers) { smtpserversImpl osmtpserversImpl = new smtpserversImpl(); return osmtpserversImpl.smtpserversAdd( smtpservers); }
public smtpservers smtpserversGetById(int SmtpServerId) { try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "smtpserversGetById", SmtpServerId).Tables[0]; smtpservers NewEnt = new smtpservers(); if(dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; NewEnt.SmtpServerId = Int32.Parse(dr["SmtpServerId"].ToString()); NewEnt.SmtpServerHostname = dr["SmtpServerHostname"].ToString(); NewEnt.SmtpServerPort = dr["SmtpServerPort"].ToString(); NewEnt.SmtpServerAccount = dr["SmtpServerAccount"].ToString(); NewEnt.SmtpServerPassword = dr["SmtpServerPassword"].ToString(); NewEnt.StmpServerEnabled = sbyte.Parse(dr["StmpServerEnabled"].ToString()); } return NewEnt; } catch(Exception ex) { throw ex; } }
public bool smtpserversUpdate( smtpservers smtpservers) { try { int update = SqlHelper.ExecuteNonQuery(SqlImplHelper.getConnectionString(), "smtpserversUpdate", smtpservers.SmtpServerId, smtpservers.SmtpServerHostname, smtpservers.SmtpServerPort, smtpservers.SmtpServerAccount, smtpservers.SmtpServerPassword, smtpservers.StmpServerEnabled); if (update > 0) { return true; } else { return false; } } catch(Exception ex) { throw ex; } }