public void SaveToDB(ExcelWorksheet ws)
{
DataTable dt = WorksheetHelper.WorksheetToDT(ws, colsRequired, firstRow, lastRow, firstCol, lastCol);
DataTable manipulatedDt = ManipulatedDT(dt);
using (SqlConnection conn = new SqlConnection(_config))
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = conn;
command.CommandText = "SP_BulkInsertBrandChannel";
command.Parameters.Add("@brandchannel", SqlDbType.Structured);
command.Parameters["@brandchannel"].TypeName = "UDT_BrandChannels";
command.CommandType = CommandType.StoredProcedure;
command.Parameters["@brandchannel"].Value = manipulatedDt;
conn.Open();
command.ExecuteNonQuery();
conn.Close();
}
}
}