public DataSet ExpressInterest_sendmultimails(ExpressInterestInsert ExpML, string spName) { List <Smtpemailsending> li = new List <Smtpemailsending>(); SqlConnection connection = new SqlConnection(); DataSet dtFromTo = new DataSet(); connection = SQLHelper.GetSQLConnection(); connection.Open(); try { SqlParameter[] parm = new SqlParameter[5]; parm[0] = new SqlParameter("@cust_Id", SqlDbType.Int); parm[0].Value = ExpML.FromCustID; parm[1] = new SqlParameter("@empid", SqlDbType.BigInt); parm[1].Value = ExpML.EmpID; parm[2] = new SqlParameter("@TblDetails", SqlDbType.Structured); parm[2].Value = ExpML.dtExpInt; parm[3] = new SqlParameter("@emailaddress", SqlDbType.VarChar); parm[3].Value = ExpML.emailaddress; parm[4] = new SqlParameter("@Status", SqlDbType.Int); parm[4].Direction = ParameterDirection.Output; // reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm); dtFromTo = SQLHelper.ExecuteDataset(connection, CommandType.StoredProcedure, spName, parm); Commonclass.ExpressInterestSMS(ExpML.dtExpInt, " "); } catch (Exception ex) { throw ex; } finally { connection.Close(); } return(dtFromTo); }
public Tuple <List <Smtpemailsending>, int?> ExpressInterest(ExpressInterestInsert ExpML, string spName) { int?status = null; SqlDataReader reader; List <Smtpemailsending> li = new List <Smtpemailsending>(); SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); try { SqlParameter[] parm = new SqlParameter[5]; parm[0] = new SqlParameter("@cust_Id", SqlDbType.Int); parm[0].Value = ExpML.FromCustID; parm[1] = new SqlParameter("@empid", SqlDbType.BigInt); parm[1].Value = ExpML.EmpID; parm[2] = new SqlParameter("@TblDetails", SqlDbType.Structured); parm[2].Value = ExpML.dtExpInt; parm[3] = new SqlParameter("@emailaddress", SqlDbType.VarChar); parm[3].Value = ExpML.emailaddress; parm[4] = new SqlParameter("@Status", SqlDbType.Int); parm[4].Direction = ParameterDirection.Output; reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm); if (reader.HasRows) { while (reader.Read()) { li.Clear(); Smtpemailsending smtp = new Smtpemailsending(); { smtp.profile_name = (reader["profile_name"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("profile_name")) : string.Empty; smtp.recipients = (reader["recipients"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("recipients")) : string.Empty; smtp.body = (reader["body"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body")) : string.Empty; smtp.subject = (reader["subject"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("subject")) : string.Empty; smtp.body_format = (reader["body_format"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body_format")) : string.Empty; smtp.Status = (reader["Status"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Status")) : status; } li.Add(smtp); Commonclass.SendMailSmtpMethod(li, "exp"); } } Commonclass.ExpressInterestSMS(ExpML.dtExpInt, " "); reader.Close(); } catch (Exception ex) { throw ex; } finally { connection.Close(); } return(new Tuple <List <Smtpemailsending>, int?>(li, status)); }