using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.IO;
using System.Web.UI.WebControls;
using System.Web.UI;
using System.Configuration;
using System.Net.Mail;
using System.Data.SqlClient;
using System.Collections;
/// <summary>
/// Summary description for CommonClass
/// </summary>
public class CommonClass
{
public const string SELECTED_CUSTOMERS_INDEX =
"SelectedCustomersIndex";
string ConnectionString=string.Empty;
static SqlConnection con;
public CommonClass()
{
ConnectionString =
ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
con = new
SqlConnection(ConnectionString);
}
public void SetConnection()
{
if (ConnectionString == string.Empty)
{
ConnectionString =
ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
}
con = new
SqlConnection(ConnectionString);
}
public DataSet ExecuteProcudere(string procName,
Hashtable parms)
{
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new
SqlDataAdapter();
cmd.CommandText = procName;
cmd.CommandType = CommandType.StoredProcedure;
if (con == null)
{
SetConnection();
}
cmd.Connection = con;
if (parms.Count > 0)
{
foreach (DictionaryEntry
de in parms)
{
cmd.Parameters.AddWithValue(de.Key.ToString(), de.Value);
}
}
da.SelectCommand = cmd;
da.Fill(ds);
return ds;
}
public int ExecuteQuery(string procName, Hashtable
parms)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType =
CommandType.StoredProcedure;
cmd.CommandText = procName;
if (parms.Count > 0)
{
foreach (DictionaryEntry
de in parms)
{
cmd.Parameters.AddWithValue(de.Key.ToString(), de.Value);
}
}
if (con == null)
{
SetConnection();
}
cmd.Connection = con;
if (con.State ==
ConnectionState.Closed)
con.Open();
int result=cmd.ExecuteNonQuery();
return result;
}
public int ExecuteQuerywithOutputparams(SqlCommand
cmd)
{
if (con == null)
{
SetConnection();
}
cmd.Connection = con;
if (con.State ==
ConnectionState.Closed)
con.Open();
int result = cmd.ExecuteNonQuery();
return result;
}
public int ExecuteQueryWithOutParam(string procName,
Hashtable parms)
{
SqlCommand cmd = new SqlCommand();
SqlParameter sqlparam = new
SqlParameter();
cmd.CommandType =
CommandType.StoredProcedure;
cmd.CommandText = procName;
if (parms.Count > 0)
{
foreach (DictionaryEntry
de in parms)
{
if
(de.Key.ToString().Contains("_out"))
{
sqlparam = new SqlParameter(de.Key.ToString(),de.Value);
sqlparam.DbType = DbType.Int32;
sqlparam.Direction = ParameterDirection.Output;
cmd.Parameters.Add(sqlparam);
}
else
{
cmd.Parameters.AddWithValue(de.Key.ToString(), de.Value);
}
}
}
if (con == null)
{
SetConnection();
}
cmd.Connection = con;
if (con.State ==
ConnectionState.Closed)
con.Open();
int result = cmd.ExecuteNonQuery();
if (sqlparam != null)
result =
Convert.ToInt32(sqlparam.SqlValue.ToString());
return result;
}
// mail sending
public void mailsend(string mailId, string subject,
string body)
{
try
{
string smtpServer =
ConfigurationManager.AppSettings["SmtpServer"].ToString();
int smtpserverport =
Convert.ToInt32(ConfigurationManager.AppSettings["smtpserverport"]);
MailMessage mailMsg =
new MailMessage();
mailMsg.From = new
System.Net.Mail.MailAddress(ConfigurationManager.AppSettings["FromId"],
"HIHL-1056", System.Text.Encoding.UTF8);
mailMsg.To.Add(mailId);
mailMsg.Subject =
subject;
mailMsg.Body = body;
mailMsg.BodyEncoding =
System.Text.Encoding.UTF8;
mailMsg.IsBodyHtml =
true;
mailMsg.Priority =
System.Net.Mail.MailPriority.High;
//The SMTP requires
Authentication so the credentials has to be sent
System.Net.NetworkCredential mailAuthentication = new
System.Net.NetworkCredential("harish.kumar@envilenz.com",
"Hareesh28");
System.Net.Mail.SmtpClient client = new System.Net.Mail.SmtpClient();
client.Port =
smtpserverport;
client.Host =
smtpServer;
client.EnableSsl = true;
client.UseDefaultCredentials = false;
client.Credentials =
mailAuthentication;
object userState =
mailMsg;
client.Send(mailMsg);
}
catch (Exception ex)
{
}
}
public int ExecuteNonQuery(string p, Hashtable ht)
{
throw new NotImplementedException();
}
public DataSet ExecuteProcudere(char p, Hashtable
ht)
{
throw new NotImplementedException();
}
}
