public async Task <List <UserPlanModelResponse> > GetUSerPlanList(UserPlanModel userPlanModel)
{
var query = this.CreateQuery(userPlanModel);
this.ExecutionQuery(query);
await Task.Delay(1000);
return(LstUserPlan);
}
public bool addPlan(AddPlanModel user)
{
if (!isValidateApiUser(user.token))
{
return(false);
}
using (db)
{
try
{
PlanModel p = db.Plans.Find(user.id);
if (p == null)
{
return(false);
}
UserPlanModel up = new UserPlanModel();
int max = 0;
foreach (UserPlanModel t in db.UserPlans.Where(u => u.username == user.username))
{
if (t != null && t.priority > max)
{
max = t.priority;
}
}
up.id = user.id;
up.username = user.username;
up.expiryTime = DateTime.Now.AddDays(p.validity);
up.storageRemaining = p.storageBenefit;
up.subTime = DateTime.Now;
up.priority = max + 1;
db.UserPlans.Add(up);
db.SaveChanges();
return(true);
}catch (Exception e)
{
Console.WriteLine(e.Message);
return(false);
}
}
}
public StringBuilder CreateQuery(UserPlanModel userPlanModel)
{
StringBuilder sql = new StringBuilder();
StringBuilder end = new StringBuilder();
StringBuilder middle = new StringBuilder();
sql.Append(" SELECT Users.Name, Plans.PlanName, Users.RegisterDate ");
sql.Append(" FROM Users ");
middle.Append(" INNER JOIN Plans on Plans.IdUser = Users.ID ");
end.Append(" WHERE ");
var counter = 0;
if (userPlanModel.Name != null && userPlanModel.Name != "")
{
end.Append(" Users.Name = '" + userPlanModel.Name.ToString() + "' ");
counter = ++counter;
}
if (userPlanModel.RegisterDate != null && userPlanModel.RegisterDate != "")
{
if (counter > 0)
{
end.Append(" AND Users.RegisterDate = '" + userPlanModel.RegisterDate.ToString() + "' ");
}
else
{
end.Append(" Users.RegisterDate = '" + userPlanModel.RegisterDate.ToString() + "' ");
}
counter = ++counter;
}
if (userPlanModel.CNPJ != null && userPlanModel.CNPJ != "")
{
if (counter > 0)
{
end.Append(" AND Users.CNPJ = '" + userPlanModel.CNPJ.ToString() + "' ");
}
else
{
end.Append(" Users.CNPJ = '" + userPlanModel.CNPJ.ToString() + "' ");
}
counter = ++counter;
}
if (userPlanModel.CPF != null && userPlanModel.CPF != "")
{
if (counter > 0)
{
end.Append(" AND Users.CPF = '" + userPlanModel.CPF.ToString() + "' ");
}
else
{
end.Append(" Users.CPF = '" + userPlanModel.CPF.ToString() + "' ");
}
counter = ++counter;
}
sql.Append(middle);
if (counter > 0)
{
sql.Append(end);
}
return(sql);
}
public async Task <List <UserPlanModelResponse> > GetUSerPlanList(UserPlanModel userPlanModel)
{
var response = await this.getListUserPlanRepository.GetUSerPlanList(userPlanModel);
return(response);
}
public async Task <ActionResult <List <UserPlanModelResponse> > > GetListUserPlan([FromBody] UserPlanModel userPlanModel)
{
DatabaseHelperClass databaseHelperClass = new DatabaseHelperClass("YOUR_CONNECTIONSTRING");
try
{
if (!ModelState.IsValid)
{
throw new Exception("Model is Invalid");
}
GetListUserPlanRepository getListUserPlanRepository = new GetListUserPlanRepository(databaseHelperClass);
DbGetListUserPlan dbGetListUserPlan = new DbGetListUserPlan(getListUserPlanRepository);
var response = await dbGetListUserPlan.GetUSerPlanList(userPlanModel);
return(Ok(response));
}
catch (Exception ex)
{
databaseHelperClass.connection.Close();
return(StatusCode(500, "Internal Server Error"));
}
}
public async Task <ActionResult <List <UserPlanModelResponse> > > GetListUserPlan(UserPlanModel userPlanModel)
{
DatabaseHelperClass databaseHelperClass = new DatabaseHelperClass("Password=123456789;Persist Security Info=True;User ID=sqlserver;Initial Catalog=epharma;Data Source=34.95.222.223");
try
{
if (!ModelState.IsValid)
{
throw new Exception("Model is Invalid");
}
GetListUserPlanRepository getListUserPlanRepository = new GetListUserPlanRepository(databaseHelperClass);
DbGetListUserPlan dbGetListUserPlan = new DbGetListUserPlan(getListUserPlanRepository);
var response = await dbGetListUserPlan.GetUSerPlanList(userPlanModel);
return(Ok(response));
}
catch (Exception ex)
{
databaseHelperClass.connection.Close();
return(StatusCode(500, "Internal Server Error"));
}
}