public static object ExecuteScalarSP(string StoreProcName, SqlParameter[] param = null)
{
try
{
var args = new Hashtable();
if (param == null)
{
return(DBLibs.ExcuteStoreProcedure_Scalar(StoreProcName, args, Cnn));
}
foreach (var p in param)
{
if (p.DbType.ToString() == "DateTime")
{
var timeValue = DateTime
.ParseExact(p.Value.ToString(), "dd/MM/yyyy hh:mm:ss tt", CultureInfo.InvariantCulture)
.ToString("yyyy-MM-dd HH:mm:ss.fff");
args.Add(p.ParameterName.Replace("@", ""), timeValue);
}
else
{
args.Add(p.ParameterName.Replace("@", ""), p.Value.ToString());
}
}
return(DBLibs.ExcuteStoreProcedure_Scalar(StoreProcName, args, Cnn));
//SqlCommand cmd = new SqlCommand(StoreProcName);
//cmd.Connection = con;
//if (con.State == ConnectionState.Closed) { con.Open(); }
//cmd.CommandType = CommandType.StoredProcedure;
//if (param != null)
//{
// for (int i = 0; i < param.Length; i++)
// {
// cmd.Parameters.Add(param[i]);
// }
//}
//return cmd.ExecuteScalar();
}
catch (Exception)
{
return(null);
}
finally
{
con.Close();
}
}
public static object ExecuteScalarSP(string storeProcedure)
{
//object result;
try
{
return(DBLibs.ExcuteStoreProcedure_Scalar(storeProcedure, new Hashtable(), Cnn));
//SqlCommand cmd = new SqlCommand(storeProcedure, con);
//cmd.Connection = con;
//if (con.State == ConnectionState.Closed) { con.Open(); }
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.CommandText = storeProcedure;
//result = cmd.ExecuteScalar();
//return result;
}
catch { return(null); }
finally
{
con.Close();
}
}