public static float GetLatestCoef(int projectid, DateTime dt, APIServiceProviderTypes ptype)
{
try
{
InitConnection();
coefsTableAdapter adapter = new coefsTableAdapter();
if (adapter.Connection != null)
adapter.Connection.Close();
adapter.Connection = sqlCon;
return (float)adapter.sp_GetLatestCoef(projectid, dt, (int)ptype);
}
catch (Exception exObj)
{
lastErrorString = exObj.Message;
string path = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase);
System.IO.File.AppendAllText(path.Replace("file:\\", "") + "\\dblog.txt", "[GetLatestCoef - " + DateTime.Now.ToString() + "]" + exObj.Message + "\r\n");
}
return 0;
}
public static int AddCompaign(string name, string cid, int projectid, string provider, string client, APIServiceProviderTypes ptype, decimal balance, decimal maxtransfer)
{
try
{
InitConnection();
campaignsTableAdapter adapter = new campaignsTableAdapter();
if (adapter.Connection != null)
adapter.Connection.Close();
adapter.Connection = sqlCon;
return Convert.ToInt32(adapter.sp_AddCampaign(name, cid, projectid, provider, client, (int)ptype, balance, maxtransfer));
}
catch (Exception exObj)
{
lastErrorString = exObj.Message;
string path = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase);
System.IO.File.AppendAllText(path.Replace("file:\\", "") + "\\dblog.txt", "[AddCampaign - " + DateTime.Now.ToString() + "]" + exObj.Message + "\r\n");
}
return 0;
}
