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"));
}
