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(); }