public static ArtGalleryDS.GalleryDataTable GetById(int id)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
data.EnforceConstraints = false;
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("Gallery_GetById", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@id", id);
SqlDataAdapter da = new SqlDataAdapter(selectCommand);
da.Fill(data, "Gallery");
}
catch { }
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(data.Gallery);
}
public static int UpdateArtist(
string email,
string ArtistImagePath,
string ArtistPageText,
string contact
)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("Site_UpdateArtist", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@email", email);
selectCommand.Parameters.AddWithValue("@ArtistImagePath", ArtistImagePath);
selectCommand.Parameters.AddWithValue("@ArtistPageText", ArtistPageText);
selectCommand.Parameters.AddWithValue("@contact", contact);
int retval = selectCommand.ExecuteNonQuery();
return(retval);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
public static int UpdateLogoPath(
string LogoPath
)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("Site_UpdateLogoPath", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@LogoPath", LogoPath);
return(selectCommand.ExecuteNonQuery());
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
/// <summary>
/// Find all the metatags in all the picture metatags, not used anymore
/// </summary>
/// <returns></returns>
public static string GetList()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
StringBuilder str = new StringBuilder();
SqlDataReader reader = null;
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("SearchWord_GetList", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
reader = selectCommand.ExecuteReader();
while (reader.Read())
{
str.Append(reader.GetString(0));
str.Append(",");
}
}
catch { }
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(str.ToString().Substring(0, str.Length - 1));
}
public static int Delete(int original_id, DateTime original_lastupdated)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("Reproduction_Delete", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@original_id", original_id);
selectCommand.Parameters.AddWithValue("@original_lastupdated", original_lastupdated);
return(selectCommand.ExecuteNonQuery());
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
public static int PreviousPublic(int id)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("Picture_PreviousPublic", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@id", id);
return((int)selectCommand.ExecuteScalar());
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
public static int Update(
string WatermarkText,
string WatermarkFontFamily,
string WatermarkFontColor,
string WatermarkFontSize,
DateTime original_lastupdated
)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("WaterMark_Update", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@WatermarkText", WatermarkText);
selectCommand.Parameters.AddWithValue("@WatermarkFontFamily", WatermarkFontFamily);
selectCommand.Parameters.AddWithValue("@WatermarkFontColor", WatermarkFontColor);
selectCommand.Parameters.AddWithValue("@WatermarkFontSize", WatermarkFontSize);
selectCommand.Parameters.AddWithValue("@original_lastupdated", original_lastupdated);
return(selectCommand.ExecuteNonQuery());
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
public static ArtGalleryDS.ReproductionDataTable GetById(int id)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("Reproduction_GetById", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@id", id);
SqlDataAdapter da = new SqlDataAdapter(selectCommand);
da.Fill(data, "Reproduction");
}
catch (Exception ex)
{
string mess = ex.Message;
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(data.Reproduction);
}
public static ArtGalleryDS.WaterMarkDataTable Get()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("WaterMark_Get", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(selectCommand);
data.EnforceConstraints = false;
da.Fill(data, "WaterMark");
}
catch (Exception ex)
{
string mess = ex.Message;
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(data.WaterMark);
}
/// <summary>
/// Get one record from PayPal Table, the one that is active
/// </summary>
/// <returns>PayPal typed dataset</returns>
public static ArtGalleryDS.PayPalRow GetAcive()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
data.EnforceConstraints = false;
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("PayPal_GetActive", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(selectCommand);
da.Fill(data, "PayPal");
}
catch (Exception ex)
{
string mess = ex.Message;
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
if (data.PayPal.Rows.Count == 1)
{
return(data.PayPal[0]);
}
return(null);
}
public static ArtGalleryDS.PayPalDataTable GetByMode(string mode)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
data.EnforceConstraints = false;
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("PayPal_GetByMode", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@mode", mode);
SqlDataAdapter da = new SqlDataAdapter(selectCommand);
da.Fill(data, "PayPal");
}
catch (Exception ex)
{
string mess = ex.Message;
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(data.PayPal);
}
public static ArtGalleryDS.PictureDataTable Get(string searchString)
{
Regex rex = new Regex("[A-Za-z0-9]+");
MatchCollection mc = rex.Matches(searchString);
if (mc.Count == 0)
{
return(new ArtGalleryDS.PictureDataTable());
}
StringBuilder query = new StringBuilder();
query.Append("select distinct pictureid as id, title, picturepath ");
query.Append("from PictureSearchWord ");
query.Append("inner join SearchWord on SearchWord.id = PictureSearchWord.searchwordid ");
query.Append("inner join Picture on picture.id = PictureSearchWord.pictureid where ");
for (int i = 0; i < mc.Count; i++)
{
if (i == mc.Count - 1)
{
query.AppendFormat("Contains(searchterm, '{0}')", mc[i].Value);
}
else
{
query.AppendFormat("Contains(searchterm, '{0}') or ", mc[i].Value);
}
}
string commandtext = query.ToString();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand(commandtext, conn);
selectCommand.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(selectCommand);
da.Fill(data, "Picture");
}
catch (Exception ex)
{
string message = ex.Message;
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(data.Picture);
}
public static int Update(
string buynowurl,
string BusinessEmailOrMerchantID,
bool active,
string PDTAuthenticationToken,
string CertificateId,
string PKCS12CertFile,
string PKCS12Password,
string PayPalCertPath,
DateTime original_lastupdated,
string original_mode
)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("PayPal_Update", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@buynowurl", buynowurl);
selectCommand.Parameters.AddWithValue("@BusinessEmailOrMerchantID", BusinessEmailOrMerchantID);
selectCommand.Parameters.AddWithValue("@Active", active);
selectCommand.Parameters.AddWithValue("@PDTAuthenticationToken", PDTAuthenticationToken);
selectCommand.Parameters.AddWithValue("@CertificateId", CertificateId);
selectCommand.Parameters.AddWithValue("@PKCS12CertFile", PKCS12CertFile);
selectCommand.Parameters.AddWithValue("@PKCS12Password", PKCS12Password);
selectCommand.Parameters.AddWithValue("@PayPalCertPath", PayPalCertPath);
selectCommand.Parameters.AddWithValue("@original_lastupdated", original_lastupdated);
selectCommand.Parameters.AddWithValue("@original_mode", original_mode);
return(selectCommand.ExecuteNonQuery());
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
public static int Update(
string email,
string LogoPath,
string ArtistImagePath,
string HomePageText,
string ArtistPageText,
string Metatags,
string contact,
string copyrightholder
)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("Site_Update", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@email", email);
selectCommand.Parameters.AddWithValue("@LogoPath", LogoPath);
selectCommand.Parameters.AddWithValue("@ArtistImagePath", ArtistImagePath);
selectCommand.Parameters.AddWithValue("@HomePageText", HomePageText);
selectCommand.Parameters.AddWithValue("@ArtistPageText", ArtistPageText);
selectCommand.Parameters.AddWithValue("@Metatags", Metatags);
selectCommand.Parameters.AddWithValue("@contact", contact);
selectCommand.Parameters.AddWithValue("@copyrightholder", copyrightholder);
int retval = selectCommand.ExecuteNonQuery();
HttpContext.Current.Application["metatags"] = Metatags;
HttpContext.Current.Application["logo"] = LogoPath;
return(retval);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
public static int Insert(Exception ex)
{
if (ex == null)
{
return(0);
}
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
StringBuilder str = new StringBuilder();
while (ex != null)
{
str.AppendLine(ex.Message);
str.AppendLine(ex.StackTrace);
str.AppendLine("------------------------------------");
ex = ex.InnerException;
}
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("ErrorLog_Insert", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@errormessage", str.ToString());
SqlParameter id = selectCommand.Parameters.Add("@id", SqlDbType.Int, 4);
id.Direction = ParameterDirection.Output;
selectCommand.ExecuteNonQuery();
return((int)id.Value);
}
catch (Exception ex1)
{
string message = ex1.Message;
throw ex;
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(0);
}
public static int Update(
bool EnableSSL,
int Port,
string Host,
string emailaddress,
string password,
string EmailName,
DateTime original_lastupdated
)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("SendMail_Update", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@EnableSSL", EnableSSL);
selectCommand.Parameters.AddWithValue("@Port", Port);
selectCommand.Parameters.AddWithValue("@Host", Host);
selectCommand.Parameters.AddWithValue("@emailaddress", emailaddress);
selectCommand.Parameters.AddWithValue("@EmailName", EmailName);
selectCommand.Parameters.AddWithValue("@password", password);
selectCommand.Parameters.AddWithValue("@original_lastupdated", original_lastupdated);
return(selectCommand.ExecuteNonQuery());
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
public static int Update(
string description,
decimal price,
decimal weight,
decimal width,
decimal height,
int original_id,
DateTime original_lastupdated
)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("Reproduction_Update", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@description", description);
selectCommand.Parameters.AddWithValue("@price", price);
selectCommand.Parameters.AddWithValue("@width", width);
selectCommand.Parameters.AddWithValue("@height", height);
selectCommand.Parameters.AddWithValue("@weight", weight);
selectCommand.Parameters.AddWithValue("@original_id", original_id);
selectCommand.Parameters.AddWithValue("@original_lastupdated", original_lastupdated);
return(selectCommand.ExecuteNonQuery());
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
public static int Insert(
string menutext,
string gallerytitle,
bool active)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("Gallery_Insert", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@menutext", menutext);
selectCommand.Parameters.AddWithValue("@gallerytitle", gallerytitle);
selectCommand.Parameters.AddWithValue("@active", active);
SqlParameter id = selectCommand.Parameters.Add("@id", SqlDbType.Int, 4);
id.Direction = ParameterDirection.Output;
int retval = selectCommand.ExecuteNonQuery();
if (retval != 1)
{
throw new Exception("No record inserted");
}
return((int)id.Value);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
public static ArtGalleryDS.GalleryDataTable GetPublic()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("Gallery_GetPublic", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(selectCommand);
da.Fill(data, "Gallery");
}
catch { }
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(data.Gallery);
}
/// <summary>
/// looks up a list of ids to make sure that match Picture.id values
/// </summary>
/// <param name="searchString">a list of numbers separated by commas</param>
/// <returns>a table of id found in picture table</returns>
public static ArtGalleryDS.PictureDataTable GetByList(string searchString)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("Picture_GetByList", conn);
selectCommand.Parameters.AddWithValue("@list", searchString);
selectCommand.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(selectCommand);
da.Fill(data, "Picture");
}
catch { }
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(data.Picture);
}
public static ArtGalleryDS.SiteDataTable GetArtist()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
data.EnforceConstraints = false;
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("Site_GetArtist", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(selectCommand);
da.Fill(data, "Site");
}
catch { }
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(data.Site);
}
public static int Update(
string Title,
string Frame,
float Width,
float Height,
short Date,
string MetaTags,
string Notes,
string Media,
int GalleryId,
string PicturePath,
string surface,
double price,
decimal weight,
string description,
bool Available,
int original_id,
string original_metatags,
DateTime original_lastupdated
)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("Picture_Update", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@Title", Title);
selectCommand.Parameters.AddWithValue("@Frame", Frame);
selectCommand.Parameters.AddWithValue("@Width", Width);
selectCommand.Parameters.AddWithValue("@Height", Height);
selectCommand.Parameters.AddWithValue("@Date", Date);
selectCommand.Parameters.AddWithValue("@MetaTags", MetaTags);
selectCommand.Parameters.AddWithValue("@Notes", CheckNull(Notes));
selectCommand.Parameters.AddWithValue("@Media", Media);
selectCommand.Parameters.AddWithValue("@GalleryId", GalleryId);
selectCommand.Parameters.AddWithValue("@PicturePath", PicturePath);
selectCommand.Parameters.AddWithValue("@surface", CheckNull(surface));
selectCommand.Parameters.AddWithValue("@price", price);
selectCommand.Parameters.AddWithValue("@weight", weight);
selectCommand.Parameters.AddWithValue("@description", description);
selectCommand.Parameters.AddWithValue("@Available", Available);
selectCommand.Parameters.AddWithValue("@original_id", original_id);
selectCommand.Parameters.AddWithValue("@original_metatags", original_metatags);
selectCommand.Parameters.AddWithValue("@original_lastupdated", original_lastupdated);
return(selectCommand.ExecuteNonQuery());
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
public static int Insert(
string Title,
string Frame,
float Width,
float Height,
short Date,
string MetaTags,
string Notes,
string Media,
int GalleryId,
string PicturePath,
string surface,
double price,
decimal weight,
string description,
bool Available
)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GalleryConnectionString"].ConnectionString);
ArtGalleryDS data = new ArtGalleryDS();
try
{
conn.Open();
SqlCommand selectCommand = new SqlCommand("Picture_Insert", conn);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@Title", Title);
selectCommand.Parameters.AddWithValue("@Frame", Frame);
selectCommand.Parameters.AddWithValue("@Width", Width);
selectCommand.Parameters.AddWithValue("@Height", Height);
selectCommand.Parameters.AddWithValue("@Date", Date);
selectCommand.Parameters.AddWithValue("@MetaTags", CheckNull(MetaTags));
selectCommand.Parameters.AddWithValue("@Notes", CheckNull(Notes));
selectCommand.Parameters.AddWithValue("@Media", Media);
selectCommand.Parameters.AddWithValue("@GalleryId", GalleryId);
selectCommand.Parameters.AddWithValue("@PicturePath", PicturePath);
selectCommand.Parameters.AddWithValue("@surface", CheckNull(surface));
selectCommand.Parameters.AddWithValue("@price", price);
selectCommand.Parameters.AddWithValue("@weight", weight);
selectCommand.Parameters.AddWithValue("@description", CheckNull(description));
selectCommand.Parameters.AddWithValue("@Available", Available);
SqlParameter id = selectCommand.Parameters.Add("@id", SqlDbType.Int);
id.Direction = ParameterDirection.Output;
int rowcount = selectCommand.ExecuteNonQuery();
if (rowcount > 0)
{
return((int)selectCommand.Parameters["@id"].Value);
}
return(0);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
