public static bool GaDeleteData(DateTime from, DateTime to, int profileid)
{
try
{
InitConnection();
ga_dataTableAdapter adapter = new ga_dataTableAdapter();
if (adapter.Connection != null)
adapter.Connection.Close();
adapter.Connection = sqlCon;
adapter.sp_GaDeleteData(from, to, profileid);
return true;
}
catch (Exception exObj)
{
lastErrorString = exObj.Message;
string path = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase);
System.IO.File.AppendAllText(path.Replace("file:\\", "") + "\\dblog.txt", "[GaAddData - " + DateTime.Now.ToString() + "]" + exObj.Message + "\r\n");
}
return false;
}
public static bool GaAddData(string name, DateTime dt, int visitors, int newvisits, float percentnewvisits, int visits, int bounces, float visitbouncerate, float timeonsite, float avgtimeonsite, float entrancebouncerate, int datagroup, int dimension, int profileid, int projectid)
{
try
{
InitConnection();
ga_dataTableAdapter adapter = new ga_dataTableAdapter();
if (adapter.Connection != null)
adapter.Connection.Close();
adapter.Connection = sqlCon;
adapter.sp_GaAddData(name, dt, visitors, newvisits, percentnewvisits, visits, bounces, visitbouncerate, timeonsite, avgtimeonsite, entrancebouncerate, datagroup, dimension, profileid, projectid);
return true;
}
catch (Exception exObj)
{
lastErrorString = exObj.Message;
string path = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase);
System.IO.File.AppendAllText(path.Replace("file:\\", "") + "\\dblog.txt", "[GaAddData - " + DateTime.Now.ToString() + "]" + exObj.Message + "\r\n");
}
return false;
}
