public static DataSet GetAllCampaignsDS(Campaign_StatusEnum status)
{
DBAccess db = new DBAccess();
db.AddInt("status", Convert.ToInt32(status));
DataSet ds = db.ExecuteDataSet(_SQLSelectByStatus);
return(ds);
}
public static DataSet GetCampaignsDS(int SupplierID, Campaign_StatusEnum Status)
{
DBAccess db = new DBAccess();
db.AddInt("SupplierID", SupplierID);
db.AddInt("Status", Convert.ToInt32(Status));
DataSet ds = db.ExecuteDataSet(_SQLSelectByStatusSupplier);
return(ds);
}
public static int SetStatus(int ID, Campaign_StatusEnum Status)
{
DBAccess db = new DBAccess();
Campaign rec = new Campaign(ID);
db.AddInt("ID", ID);
db.AddInt("Status", Convert.ToInt32(Status));
AddParmsStandard(db, rec);
int retval = db.ExecuteNonQuery(_SQLSetStatus);
AddLog(Status: "Campaign", Logtext: string.Format("SetStatus Campaign: ID:{0} Status:{1}", rec.ID, rec.StatusText), Metode: "SetStatus");
return(retval);
}
//EXEC @return_value = [vicjos1_sysadm].[Co2Db_Campaign_Search]
// @SupplierID = -1,
// @CampaignID = -1,
// @Status = -1,
// @StartDate = NULL,
// @EndDate = NULL
public static DataSet GetCampaignsSupplierDS(int SupplierID, Campaign_StatusEnum Status, int CampaignID, string StartDate, string EndDate)
{
DBAccess db = new DBAccess();
db.AddInt("SupplierID", SupplierID);
db.AddInt("CampaignID", CampaignID);
db.AddInt("Status", Convert.ToInt32(Status));
if (Information.IsDate(StartDate))
{
db.AddDateTime("StartDate", (DateTime?)((object)StartDate));
}
if (Information.IsDate(EndDate))
{
db.AddDateTime("EndDate", (DateTime?)((object)EndDate));
}
DataSet ds = db.ExecuteDataSet(_SQLSelectBySupplierSearch);
return(ds);
}
public static DataSet GetCampaignSupplierStatus(int SupplierID, Campaign_StatusEnum type)
{
return(Search_Campaign((System.Convert.ToInt32(type)).ToString(), SupplierID));
}
public static DataSet GetRekvireret_Campaign(Campaign_StatusEnum type)
{
return(Search_Campaign((System.Convert.ToInt32(type)).ToString()));
}
public static System.Collections.Generic.List <Campaign> GetCampaignsList(int SupplierID, Campaign_StatusEnum Status)
{
System.Collections.Generic.List <Campaign> result = new System.Collections.Generic.List <Campaign>();
DBAccess db = new DBAccess();
Campaign rec = default(Campaign);
db.AddInt("SupplierID", SupplierID);
db.AddInt("Status", Convert.ToInt32(Status));
SqlDataReader dr = default(SqlDataReader);
//Try
dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectByStatusSupplier)); //_SQLSelectAll 'CType(db.ExecuteReader(_SQLSelectAllID), SqlDataReader)
if (dr.HasRows)
{
while (dr.Read())
{
rec = new Campaign();
Populate(dr, rec);
result.Add(rec); //(Campaign.GetCampaign(dr.DBtoInt("ID")))
}
}
dr.Close();
//Catch ex As Exception
//Throw ex
//End Try
return(result);
}
