/// <summary>
/// Function creates an instance of the Static class
/// for the first time. But for the subsequent times
/// existing instance is returned.
/// </summary>
/// <returns>DatabaseServiceHandler</returns>
public static DataBaseServiceHandler createinstance()
{
if (Obj == null)
{
Obj = new DataBaseServiceHandler();
}
return(Obj);
}
public static void InsertExportHistory(string Reference, string Type)
{
SqlConnection SqlConn = null;
try
{
SqlConn = new SqlConnection(ExchangeConfigRegistryEntities.ExchangeConnectionString);
SqlConn.Open();
var userCount = SqlHelper.ExecuteNonQuery(SqlConn, CommandType.StoredProcedure, "usp_Export_History",
DataBaseServiceHandler.AddParameter <string>("@Reference1", DbType.String, Reference),
DataBaseServiceHandler.AddParameter <string>("@Reference2", DbType.String, ""),
DataBaseServiceHandler.AddParameter <string>("@Type", DbType.String, Type),
DataBaseServiceHandler.AddParameter <string>("@Status", DbType.String, ""));
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
}
finally
{
SqlConn.Close();
}
}