public IQueryable <PL_CUSTOMER_CLUSTER2> GetPopulation()
{
PL_CUSTOMER_CLUSTERRepository rep = new PL_CUSTOMER_CLUSTERRepository(connectionString);
List <PL_CUSTOMER_CLUSTER2> list = rep.GetPopulation();
return(list.AsQueryable());
}
public IQueryable <PL_CUSTOMER_CLUSTER> GetCentroid3()
{
PL_CUSTOMER_CLUSTERRepository rep = new PL_CUSTOMER_CLUSTERRepository(connectionString);
List <PL_CUSTOMER_CLUSTER> list = rep.GetCentroid3();
return(list.AsQueryable());
}
public IQueryable <PL_CUSTOMER_CLUSTER4> GetDataPelanggan2()
{
PL_CUSTOMER_CLUSTERRepository rep = new PL_CUSTOMER_CLUSTERRepository(connectionString);
List <PL_CUSTOMER_CLUSTER4> list = rep.GetDataPelanggan2();
return(list.AsQueryable());
}
public IQueryable <PL_CUSTOMER_CLUSTER> GetCustomerData(int id, string MONTH, int YEAR)
{
PL_CUSTOMER_CLUSTERRepository rep = new PL_CUSTOMER_CLUSTERRepository(connectionString);
List <PL_CUSTOMER_CLUSTER> list = rep.GetCustomerData(id, MONTH, YEAR);
return(list.AsQueryable());
}
public IQueryable <PL_CUSTOMER_CLUSTER> GetClusterByID(int id)
{
PL_CUSTOMER_CLUSTERRepository rep = new PL_CUSTOMER_CLUSTERRepository(connectionString);
List <PL_CUSTOMER_CLUSTER> list = rep.GetClusterByID(id);
return(list.AsQueryable());
}
public IQueryable <PL_CUSTOMER_CLUSTER> GetDateByID(DateTime DATE)
{
DATE = Convert.ToDateTime(DATE);
PL_CUSTOMER_CLUSTERRepository rep = new PL_CUSTOMER_CLUSTERRepository(connectionString);
List <PL_CUSTOMER_CLUSTER> list = rep.GetDateByID(DATE);
return(list.AsQueryable());
}
public IQueryable <PL_CUSTOMER_CLUSTER3> GetGMSL()
{
PL_CUSTOMER_CLUSTERRepository rep = new PL_CUSTOMER_CLUSTERRepository(connectionString);
List <PL_CUSTOMER_CLUSTER3> list = rep.GetGMSL();
foreach (var data in list)
{
for (var i = 0; i < list.Count; i++)
{
var a = String.Format("{0:yyyy/mm/dd}", data.DATE_TIME);
var b = a;
var c = @Convert.ToString(string.Format("{0:dd/MM/yyyy}", data.DATE_TIME));
var d = c;
}
}
return(list.AsQueryable());
}
public void Delete(PL_CUSTOMER_CLUSTER pl_customer_cluster)
{
PL_CUSTOMER_CLUSTERRepository rep = new PL_CUSTOMER_CLUSTERRepository(connectionString);
rep.Remove(pl_customer_cluster);
}
public void Put(PL_CUSTOMER_CLUSTER pl_customer_cluster)
{
PL_CUSTOMER_CLUSTERRepository rep = new PL_CUSTOMER_CLUSTERRepository(connectionString);
rep.Update(pl_customer_cluster);
}
