public JsonResult CheckedTodoList(int Id, ToDoListVM toDoListVM)
{
client.DefaultRequestHeaders.Add("Authorization", HttpContext.Session.GetString("JWToken"));
var getEmail = HttpContext.Session.GetString("id");
var myContent = JsonConvert.SerializeObject(toDoListVM);
var buffer = System.Text.Encoding.UTF8.GetBytes(myContent);
var byteContent = new ByteArrayContent(buffer);
byteContent.Headers.ContentType = new MediaTypeHeaderValue("application/json");
var result = client.PutAsync("todolists/Checkedlist/" + Id, byteContent).Result;
if (result.IsSuccessStatusCode)
{
//MailMessage mm = new MailMessage("*****@*****.**", userVM.Email);
//mm.Subject = "[Password] " + DateTime.Now.ToString("ddMMyyyyhhmmss");
//mm.Body = "Hi " + userVM.Username + "\nThis Is Your New Password : "******"smtp.gmail.com";
//smtp.Port = 587;
//smtp.EnableSsl = true;
//NetworkCredential nc = new NetworkCredential("*****@*****.**", "085376886737");
//smtp.UseDefaultCredentials = false;
//smtp.Credentials = nc;
//smtp.Send(mm);
//ViewBag.Message = "Password Has Been Sent.Check your email to login";
return(Json(result));
}
else
{
return(Json(""));
}
}
public JsonResult InsertOrUpdate(ToDoListVM toDoListVM)
{
var client = new HttpClient
{
BaseAddress = new Uri("https://localhost:44377/api/")
};
client.DefaultRequestHeaders.Add("Authorization", HttpContext.Session.GetString("JWToken"));
toDoListVM.UserId = Convert.ToInt32(HttpContext.Session.GetString("id"));
var myContent = JsonConvert.SerializeObject(toDoListVM);
var buffer = System.Text.Encoding.UTF8.GetBytes(myContent);
var byteContent = new ByteArrayContent(buffer);
byteContent.Headers.ContentType = new MediaTypeHeaderValue("application/json");
if (toDoListVM.Id == 0)
{
var result = client.PostAsync("todolists", byteContent).Result;
return(Json(result));
}
else
{
var result = client.PutAsync("todolists/" + toDoListVM.Id, byteContent).Result;
return(Json(result));
}
}
public void Update(ToDoListVM toDoListVM)
{
this.Name = toDoListVM.Name;
this.Status = toDoListVM.Status;
this.UpdateDate = DateTimeOffset.Now;
}
public ActionResult Report(ToDoListVM toDoListVM)
{
ToDoListReport _toDoListReport = new ToDoListReport();
byte[] abytes = _toDoListReport.PrepareReport(GetToDoList());
return(File(abytes, "application/pdf"));
}
// GET: activities/Edit/5
public async Task <JsonResult> Update(ToDoListVM toDoListVM)
{
client.DefaultRequestHeaders.Add("Authorization", HttpContext.Session.GetString("Token"));
TokenVM tokenVM = new TokenVM();
tokenVM.Username = HttpContext.Session.GetString("Username");
tokenVM.ExpireToken = Convert.ToInt64(HttpContext.Session.GetString("ExpToken"));
tokenVM.RefreshToken = HttpContext.Session.GetString("RefreshToken");
tokenVM.ExpireRefreshToken = Convert.ToInt64(HttpContext.Session.GetString("ExpRefreshToken"));
if (tokenVM.ExpireToken < DateTime.UtcNow.Ticks && tokenVM.ExpireRefreshToken > DateTime.UtcNow.Ticks)
{
await RefreshToken(tokenVM);
}
else if (tokenVM.ExpireRefreshToken < DateTime.UtcNow.Ticks)
{
return(null);
}
var myContent = JsonConvert.SerializeObject(toDoListVM);
var buffer = System.Text.Encoding.UTF8.GetBytes(myContent);
var byteContent = new ByteArrayContent(buffer);
byteContent.Headers.ContentType = new MediaTypeHeaderValue("application/json");
var result = client.PutAsync("activities/" + toDoListVM, byteContent).Result;
return(Json(result));
}
// IEnumerable<ToDoListVM> Paging(string userId, int param1, string keyword, int pageNumber, int pageSize)
public async Task <ToDoListVM> Paging(string userId, int param1, string keyword, int pageNumber, int pageSize)
{
using (var conn = new SqlConnection(_connectionString.Value))
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@paramUserName", userId);
parameters.Add("@pageSize", pageSize);
parameters.Add("@pageNumber", pageNumber);
parameters.Add("@param1", param1);
parameters.Add("@paramKeyword", keyword);
parameters.Add("@length", dbType: DbType.Int32, direction: ParameterDirection.Output);
parameters.Add("@filterLength", dbType: DbType.Int32, direction: ParameterDirection.Output);
var result = new ToDoListVM();
result.data = await conn.QueryAsync <ToDoListVM>("SP_FilterData", parameters, commandType : CommandType.StoredProcedure);
int filterlength = parameters.Get <int>("@filterLength");
result.filterLength = filterlength;
int length = parameters.Get <int>("@length");
result.length = length;
return(result);
//var result = conn.Query<ToDoListVM>("SP_FilterData", parameters, commandType: CommandType.StoredProcedure);
//return result;
}
}
public ToDoList(ToDoListVM toDoListVM)
{
this.Id = toDoListVM.Id;
this.Name = toDoListVM.Name;
this.Status = toDoListVM.Status;
this.CreateDate = DateTimeOffset.Now;
this.isDelete = false;
}
public async Task <IActionResult> Report(ToDoListVM toDoListVM)
{
ActivitiesReport activities = new ActivitiesReport();
var readTask = await GetActivities();
byte[] abytes = activities.PrepareReport(readTask);
return(File(abytes, "application/pdf", $"ReportActivities{DateTime.Now.ToString("MMddyyyy")}.pdf"));
}
public IActionResult Put(ToDoListVM toDoListVM)
{
var data = _toDoListService.Update(toDoListVM);
if (data > 0)
{
return(Ok(data));
}
return(BadRequest("Failed"));
}
public IActionResult Put(int id, ToDoListVM todolistVM)
{
var put = _todolistService.Update(id, todolistVM);
if (put > 0)
{
return(Ok(put));
}
return(BadRequest("Update Failed!"));
}
public IActionResult Post(ToDoListVM todolistVM)
{
var push = _todolistService.Create(todolistVM);
if (push > 0)
{
return(Ok(push));
}
return(BadRequest("Added Row Failed!"));
}
public int Create(ToDoListVM toDoListVM)
{
parameters.Add("@Name", toDoListVM.Name);
parameters.Add("@Email", toDoListVM.Email);
using (var connection = new SqlConnection(connectionString.Value))
{
var data = connection.Execute("SP_InsertToDoList",
parameters, commandType: CommandType.StoredProcedure);
return(data);
}
}
public int Update(ToDoListVM toDoListVM)
{
if (string.IsNullOrWhiteSpace(toDoListVM.Name))
{
return(result);
}
else
{
return(_toDoListRepository.Update(toDoListVM));
}
}
public int Create(ToDoListVM toDoListVM)
{
using (var conn = new SqlConnection(_connectionString.Value))
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@paramName", toDoListVM.Name);
parameters.Add("@paramUserId", toDoListVM.userId);
var result = conn.Execute("SP_InsertDataToDoLists", parameters, commandType: CommandType.StoredProcedure);
return(result);
}
}
public JsonResult Update(int id, ToDoListVM grade)
{
Client.DefaultRequestHeaders.Add("Authorization", HttpContext.Session.GetString("Token"));
var myContent = JsonConvert.SerializeObject(grade);
var buffer = System.Text.Encoding.UTF8.GetBytes(myContent);
var byteContent = new ByteArrayContent(buffer);
byteContent.Headers.ContentType = new MediaTypeHeaderValue("application/json");
var result = Client.PutAsync("todolists/" + id, byteContent).Result;
return(Json(result));
}
public int Create(ToDoListVM toDoListVM)
{
using (SqlConnection connection = new SqlConnection(_connectionStrings.Value))
{
var procName = "SP_InsertToDoList"; //callsp
parameters.Add("@Name", toDoListVM.Name); //retrieve username
parameters.Add("@UserId", toDoListVM.UserId); //retrieve password
var todolist = connection.Execute(procName, parameters, commandType: CommandType.StoredProcedure); //toiinputdatausingdapper
return(todolist);
}
//throw new NotImplementedException();
}
public JsonResult Insert(ToDoListVM todolistVM)
{
Client.DefaultRequestHeaders.Add("Authorization", HttpContext.Session.GetString("Token"));
todolistVM.userId = Convert.ToInt32(HttpContext.Session.GetString("Id"));
var myContent = JsonConvert.SerializeObject(todolistVM);
var buffer = System.Text.Encoding.UTF8.GetBytes(myContent);
var byteContent = new ByteArrayContent(buffer);
byteContent.Headers.ContentType = new MediaTypeHeaderValue("application/json");
var result = Client.PostAsync("todolists", byteContent).Result;
return(Json(result));
}
public int Update(int Id, ToDoListVM toDoListVM)
{
using (SqlConnection connection = new SqlConnection(_connectionStrings.Value))
{
var procName = "SP_UpdateToDoList";
parameters.Add("@ID", Id);
parameters.Add("@Name", toDoListVM.Name);
parameters.Add("@Status", toDoListVM.Status);
parameters.Add("@UserId", toDoListVM.UserId);
var todolist = connection.Execute(procName, parameters, commandType: CommandType.StoredProcedure); //toiinputdatausingdapper
return(todolist);
}
//throw new NotImplementedException();
}
public List <ToDoListVM> GetToDoList()
{
List <ToDoListVM> todolistVMs = new List <ToDoListVM>();
ToDoListVM toDoListVM = new ToDoListVM();
//for (int i = 0; i < todolistVMs.Count; i++)
for (int i = 0; i < 10; i++)
{
toDoListVM = new ToDoListVM();
toDoListVM.Id = i;
toDoListVM.Name = "Name";
todolistVMs.Add(toDoListVM);
}
return(todolistVMs);
}
public async Task <IActionResult> AddToDoList(ToDoListVM model)
{
var toDoList = new Project.Models.Entities.ToDoList
{
Name__c = model.Name,
Duedate__c = model.DueDate,
IsCompleted__c = model.IsCompleted
};
var response = await _toDoListRepo.Insert(toDoList);
if (response.Success)
{
return(RedirectToAction("Index", "Home"));
}
else
{
return(View());
}
}
public int Update(ToDoListVM toDoListVM)
{
parameters.Add("@Id", toDoListVM.Id);
parameters.Add("@Name", toDoListVM.Name);
//if (toDoListVM.Status == false)
//{
// parameters.Add("@Status", 0);
//}
//else if (toDoListVM.Status == true)
//{
// parameters.Add("@Status", 1);
//}
//parameters.Add("@Status", toDoListVM.Status);
using (var connection = new SqlConnection(connectionString.Value))
{
var data = connection.Execute("SP_UpdateToDoList",
parameters, commandType: CommandType.StoredProcedure);
return(data);
}
}
public async Task <IActionResult> UpdateToDoList(ToDoListVM model)
{
var toDoList = new Project.Models.Entities.ToDoList
{
Id = model.Id,
Name__c = model.Name,
Duedate__c = model.DueDate,
IsCompleted__c = model.IsCompleted
};
var response = await _toDoListRepo.Update(toDoList);
if (response.Success)
{
return(RedirectToAction("GetToDoList", new { parentId = model.Id }));
}
else
{
return(View());
}
}
//public async Task<IEnumerable<ToDoListVM>> Search(int Id, int status, string keyword)
//{
// using (SqlConnection connection = new SqlConnection(_connectionStrings.Value))
// {
// var procName = "SP_Search";
// parameters.Add("@ID", Id);
// parameters.Add("@status", status);
// parameters.Add("@SearchKey", keyword);
// var todolist = await connection.QueryAsync<ToDoListVM>(procName, parameters, commandType: CommandType.StoredProcedure); //await ada jeda. bermanfaat untuk banyak data
// return todolist;
// }
//}
//public async Task<IEnumerable<ToDoListVM>> Paging(int Id, int status, string keyword, int pageSize, int pageNumber)
//{
// using (SqlConnection connection = new SqlConnection(_connectionStrings.Value))
// {
// var procName = "SP_Paging";
// parameters.Add("@ID", Id);
// parameters.Add("@status", status);
// parameters.Add("@SearchKey", keyword);
// parameters.Add("@pageSize", pageSize);
// parameters.Add("@pageNumber", pageNumber);
// var todolist = await connection.QueryAsync<ToDoListVM>(procName, parameters, commandType: CommandType.StoredProcedure); //await ada jeda. bermanfaat untuk banyak data
// return todolist;
// }
//}
public async Task <ToDoListVM> PageSearch(string Id, int status, string keyword, int pageSize, int pageNumber)
{
using (SqlConnection connection = new SqlConnection(_connectionStrings.Value))
{
var procName = "SP_PageSearch";
parameters.Add("@email", Id);
parameters.Add("@status", status);
parameters.Add("@SearchKey", keyword);
parameters.Add("@pageSize", pageSize);
parameters.Add("@pageNumber", pageNumber);
parameters.Add("@length", dbType: DbType.Int32, direction: ParameterDirection.Output);
parameters.Add("@filterlength", dbType: DbType.Int32, direction: ParameterDirection.Output);
var result = new ToDoListVM();
result.data = await connection.QueryAsync <ToDoListVM>(procName, parameters, commandType : CommandType.StoredProcedure); //await ada jeda. bermanfaat untuk banyak data
int filterlength = parameters.Get <int>("@filterlength");
result.filterlength = filterlength;
int length = parameters.Get <int>("@length");
result.length = length;
return(result);
}
}
public ActionResult Put(int Id, ToDoListVM toDoListVM)
{
return(Ok(_toDoListServices.Update(Id, toDoListVM)));
}
public ActionResult Post(ToDoListVM toDoListVM)
{
return(Ok(_toDoListServices.Create(toDoListVM)));
}
public int Create(ToDoListVM toDoListVM)
{
return(_toDoListRepository.Create(toDoListVM));
}
public void Delete(ToDoListVM toDoListVM)
{
this.IsDelete = true;
this.DeleteDate = DateTimeOffset.Now;
}
public int Update(int id, ToDoListVM toDoListVM)
{
return(_toDoListRepository.Update(id, toDoListVM));
}
public int Update(int Id, ToDoListVM toDoListVM)
{
return(_todolistRepository.Update(Id, toDoListVM));
//throw new NotImplementedException();
}
public int Create(ToDoListVM toDoListVM)
{
return(_todolistRepository.Create(toDoListVM));
//throw new NotImplementedException();
}
