public IHttpActionResult GetUserByUsernameAndPassword(String username, String password)
{
_context = new FarmEntities();
try
{
var user = _context.GetUserByUsernameAndPassword(username, password).FirstOrDefault();
return(Ok(user));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public IHttpActionResult DeletePlantation(int plantationID)
{
_context = new FarmEntities();
try
{
_context.DeletePlantation(plantationID);
return(Ok("Deleted"));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public IHttpActionResult DeleteUser(string username)
{
_context = new FarmEntities();
try
{
_context.DeleteUser(username);
return(Ok("Deleted"));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public IHttpActionResult GetAllUsers()
{
_context = new FarmEntities();
try
{
dynamic users = _context.GetAllUsers().ToList();
return(Ok(users));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public IHttpActionResult GetPlantationByUser(string username)
{
_context = new FarmEntities();
try
{
var plantation = _context.GetPlantationByUser(username).FirstOrDefault();
return(Ok(plantation));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public IHttpActionResult GetQuantitiesByPlantation(string username)
{
_context = new FarmEntities();
try
{
var quantity = _context.GetQuantitiesByPlantation(username);
return(Ok(quantity));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public IHttpActionResult GetQuantitiesByWorker(string workername)
{
_context = new FarmEntities();
try
{
var quantities = _context.GetQuantitiesByWorker(workername);
return(Ok(quantities));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public IHttpActionResult AddWorker([FromBody] dynamic client)
{
_context = new FarmEntities();
try
{
String workername = client["WorkerName"];
_context.AddWorker(workername);
return(Ok("Worker added successfully!"));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public IHttpActionResult AddPlantation([FromBody] dynamic client)
{
_context = new FarmEntities();
try
{
String harvest = client["Harvest"];
_context.AddPlantation(harvest, 0);
return(Ok("Plantation added successfully!"));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public FarmEntities AddFarmEntities(FarmEntities entity)
{
var r = StaticFunctions.Request(
"Farms/FarmEntities/",
JsonConvert.SerializeObject(entity),
HttpMethod.Post,
User.FindFirst(claim => claim.Type == "Token")?.Value
);
if (r != null)
{
var _r = JsonConvert.DeserializeObject <FarmEntities>(r);
return(_r);
}
return(null);
}
public IHttpActionResult AddHarvestedQuantityByWorker([FromBody] dynamic client)
{
_context = new FarmEntities();
try
{
String username = client["Username"];
String workername = client["WorkerName"];
double quantity = client["Quantity"];
_context.AddHarvestedQuantityByWorker(quantity, username, workername);
return(Ok("Harvested quantity by worker added successfully!"));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public IHttpActionResult AddUser([FromBody] dynamic client)
{
_context = new FarmEntities();
try
{
String username = client["Username"];
String password = client["Password"];
String name = client["Name"];
String address = client["Address"];
String cnp = client["CNP"];
String email = client["Email"];
String plantation = client["Plantation"];
_context.AddUser(username, password, name, cnp, address, email, plantation, 0);
return(Ok("User added successfully!"));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
