public static bool AddCampaignStatisticsRecord(int campaignid, DateTime datetime, int shows, int clicks, decimal price, int projectid) { try { InitConnection(); campaignstatsTableAdapter adapter = new campaignstatsTableAdapter(); if (adapter.Connection != null) adapter.Connection.Close(); adapter.Connection = sqlCon; adapter.sp_AddCampaignStatisticsRecord(campaignid, datetime, shows, clicks, price, 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", "[AddCampaignStatisticsRecord - " + DateTime.Now.ToString() + "]" + exObj.Message + "\r\n"); } return false; }
public static bool DeleteCampaignStatisticsRecords(int projectid, DateTime dt, string cid, string provider) { try { InitConnection(); campaignstatsTableAdapter adapter = new campaignstatsTableAdapter(); if (adapter.Connection != null) adapter.Connection.Close(); adapter.Connection = sqlCon; adapter.sp_DeleteCampaignStatisticsRecords(projectid, dt, cid, provider); return true; } catch (Exception exObj) { lastErrorString = exObj.Message; string path = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase); System.IO.File.AppendAllText(path.Replace("file:\\", "") + "\\dblog.txt", "[DeleteCampaignStatisticsRecord - " + DateTime.Now.ToString() + "]" + exObj.Message + "\r\n"); } return false; }