public int Update(AbsentVM dataVM, int id) { using (SqlConnection connection = new SqlConnection(_configuration.GetConnectionString("myConnection"))) { var procName = "SP_Update_Absent"; parameters.Add("id", id); parameters.Add("updDate", dataVM.UpdDate); var Edit = connection.Execute(procName, parameters, commandType: CommandType.StoredProcedure); return(Edit); } }
public int Create(AbsentVM dataVM) { using (SqlConnection connection = new SqlConnection(_configuration.GetConnectionString("myConnection"))) { var procName = "SP_Create_Absent"; parameters.Add("userId", dataVM.UserId); parameters.Add("insDate", dataVM.InsDate); var insert = connection.Execute(procName, parameters, commandType: CommandType.StoredProcedure); return(insert); } }
public IActionResult Update(int id, GetAbsentVM dataVM) { if (ModelState.IsValid) { var data = new AbsentVM { UpdDate = dataVM.UpdAt }; var update = _repo.Update(data, id); if (update > 0) { return(Ok("Successfully Created")); } return(BadRequest("Not Successfully")); } return(BadRequest("Not Successfully")); }
public IActionResult Create(GetAbsentVM dataVM) { if (ModelState.IsValid) { var data = new AbsentVM { UserId = dataVM.UserId, InsDate = dataVM.InsAt }; var create = _repo.Create(data); if (create > 0) { return(Ok("Successfully Created")); } return(BadRequest("Not Successfully")); } return(BadRequest("Not Successfully")); }