public void insertSMTP(SMTPaccountDTO dt)
{
string sql = "insert into tblSMTPaccount (Email,Password,Accesskey,Secreckey,PasswordSMTP,ServerSMTP,UsernameSMTP,Limit)values(@Email,@Password,@Accesskey,@Secreckey,@PasswordSMTP,@ServerSMTP,@UsernameSMTP,@Limit)";
SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = dt.Email;
cmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = dt.Password;
cmd.Parameters.Add("@Accesskey", SqlDbType.VarChar).Value = dt.Accesskey;
cmd.Parameters.Add("@Secreckey", SqlDbType.VarChar).Value = dt.Secreckey;
cmd.Parameters.Add("@PasswordSMTP", SqlDbType.VarChar).Value = dt.PasswordSMTP;
cmd.Parameters.Add("@ServerSMTP", SqlDbType.VarChar).Value = dt.ServerSMTP;
cmd.Parameters.Add("@UsernameSMTP", SqlDbType.VarChar).Value = dt.UsernameSMTP;
cmd.Parameters.Add("@Limit", SqlDbType.VarChar).Value = dt.Limit;
cmd.ExecuteNonQuery();
}
public void update(SMTPaccountDTO dt)
{
smtpaccount.updateSMTP(dt);
}
public void insert(SMTPaccountDTO dt)
{
smtpaccount.insertSMTP(dt);
}
private SMTPaccountDTO updatesmtpaccount()
{
SMTPaccountDTO smtpaccount = new SMTPaccountDTO();
UserLoginDTO userLogin = getUserLogin();
if (userLogin != null)
{
smtpaccount.id =Convert.ToInt32(hdfId);
smtpaccount.Email = txtEmailConfig.Text;
smtpaccount.Password = txtpassword.Text;
smtpaccount.Accesskey = txtaccesskey.Text;
smtpaccount.Secreckey = txtsecrectkey.Text;
smtpaccount.PasswordSMTP = txtpasssmtp.Text;
smtpaccount.ServerSMTP = txtserversmtp.Text;
smtpaccount.UsernameSMTP = txtusername.Text;
smtpaccount.Limit = txtlimit.Text;
}
return smtpaccount;
}
public void updateSMTP(SMTPaccountDTO dt)
{
string update = "UPDATE tblSMTPaccount SET " +
"email = @email, " +
"Password= @Password, " +
"Accesskey= @Accesskey, " +
"Secreckey= @Secreckey, " +
"PasswordSMTP= @PasswordSMTP, " +
"ServerSMTP= @ServerSMTP, " +
"UsernameSMTP= @UsernameSMTP, " +
"Limit= @Limit " +
" WHERE id = @id";
SqlCommand cmd = new SqlCommand(update, ConnectionData._MyConnection);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = dt.Email;
cmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = dt.Password;
cmd.Parameters.Add("@Accesskey", SqlDbType.VarChar).Value = dt.Accesskey;
cmd.Parameters.Add("@Secreckey", SqlDbType.VarChar).Value = dt.Secreckey;
cmd.Parameters.Add("@PasswordSMTP", SqlDbType.VarChar).Value = dt.PasswordSMTP;
cmd.Parameters.Add("@ServerSMTP", SqlDbType.VarChar).Value = dt.ServerSMTP;
cmd.Parameters.Add("@UsernameSMTP", SqlDbType.VarChar).Value = dt.UsernameSMTP;
cmd.Parameters.Add("@Limit", SqlDbType.VarChar).Value = dt.Limit;
cmd.ExecuteNonQuery();
}
