private int CalculateDateColumns(SqlConnection conn, DimDateParam paramObj)
{
var dic = new Dictionary <string, string>();
dic.Add("FromDate", string.Format("{0:yyyy-MM-dd}", paramObj.FromDate.Date));
dic.Add("ToDate", string.Format("{0:yyyy-MM-dd}", paramObj.ToDate.Date));
string commandText = Smart.Format(
@"DECLARE @FromDate datetime = '{FromDate}';
DECLARE @ToDate datetime = '{ToDate}';
EXEC sp_CalculateDateColumns @FromDate, @ToDate;", dic);
using (var cmd = new SqlCommand(commandText, conn))
{
return(cmd.ExecuteNonQuery());
}
}
private int DeleteExistingDates(SqlConnection conn, DimDateParam paramObj)
{
var dic = new Dictionary <string, string>();
dic.Add("FromDate", string.Format("{0:yyyy-MM-dd}", paramObj.FromDate.Date));
dic.Add("ToDate", string.Format("{0:yyyy-MM-dd}", paramObj.ToDate.Date));
string commandText = Smart.Format(
@"DECLARE @FromDate datetime = '{FromDate}';
DECLARE @ToDate datetime = '{ToDate}';
DELETE FROM DimDate WHERE FullDate BETWEEN @FromDate AND @ToDate;",
dic);
using (var cmd = new SqlCommand(commandText, conn))
{
return(cmd.ExecuteNonQuery());
}
}
