public ActionResult GetUserByIdentityNumber(int identityNumber)
{
using (FromFarmerContext ctx = new FromFarmerContext())
{
var farmer = ctx.FF_FARMER.Where(x => x.ID == identityNumber).FirstOrDefault();
if (farmer != null)
{
FarmerVM tempFarmer = new FarmerVM()
{
CITY = farmer.CITY,
DISTRICT = farmer.DISTRICT,
TOWN_OR_VILLAGE = farmer.TOWN_OR_VILLAGE,
NEIGHBORHOOD = farmer.NEIGHBORHOOD,
STREET = farmer.STREET,
APARTMENT = farmer.APARTMENT,
FARMER_CERTIFICATE = farmer.FARMER_CERTIFICATE
};
return(Ok(tempFarmer));
}
else
{
return(BadRequest("Error : \"farmer\" is not null!!"));
}
}
}
public ActionResult Update(FarmerVM model)
{
using (FromFarmerContext ctx = new FromFarmerContext())
{
var farmer = ctx.FF_FARMER.Where(x => x.IDENTITY_NUMBER == model.IDENTITY_NUMBER).FirstOrDefault();
if (farmer != null)
{
FF_FARMER tempFarmer = new FF_FARMER()
{
IDENTITY_NUMBER = model.IDENTITY_NUMBER,
CITY = model.CITY,
DISTRICT = model.DISTRICT,
TOWN_OR_VILLAGE = model.TOWN_OR_VILLAGE,
NEIGHBORHOOD = model.NEIGHBORHOOD,
STREET = model.STREET,
APARTMENT = model.APARTMENT,
FARMER_CERTIFICATE = model.FARMER_CERTIFICATE
};
var farmerResult = _dbUnit.Repo <FF_FARMER>().Update(tempFarmer);
if (farmerResult != null)
{
return(Ok($"{model.IDENTITY_NUMBER} numaralı farmer güncellendi."));
}
else
{
return(BadRequest($"{model.IDENTITY_NUMBER} numaralı farmer güncellenemedi.."));
}
}
else
{
return(BadRequest($"{model.IDENTITY_NUMBER} numaralı farmer bulunamadı.."));
}
}
}
public ActionResult GetAll()
{
List <FarmerVM> farmerList = new List <FarmerVM>();
var farmer = _dbUnit.Repo <FF_FARMER>().GetAll();
if (farmer != null)
{
foreach (var item in farmer)
{
FarmerVM tempModel = new FarmerVM()
{
CITY = item.CITY,
DISTRICT = item.DISTRICT,
TOWN_OR_VILLAGE = item.TOWN_OR_VILLAGE,
NEIGHBORHOOD = item.NEIGHBORHOOD,
STREET = item.STREET,
APARTMENT = item.APARTMENT,
FARMER_CERTIFICATE = item.FARMER_CERTIFICATE
};
farmerList.Add(tempModel);
}
return(Ok(farmerList));
}
else
{
return(BadRequest("Error : \"farmerList\" is not null!!"));
}
}
public ActionResult PostFarmer([Bind(Include = "ID,FarmerName,FarmerAddress,FarmerEmail,FarmerRole,FarmerLiecnse,FarmerNID,FarmerSID")] FarmerVM objVM)
{
//Farmer _Farmer = new Farmer()
//{
// FarmerName = objVM.FarmerName,
// FarmerEmail = objVM.FarmerEmail,
// FarmerAddress = objVM.FarmerAddress,
// FarmerLiecnse = objVM.FarmerLiecnse,
// FarmerNID = objVM.FarmerNID,
// FarmerRole = objVM.FarmerRole,
// FarmerSID = objVM.FarmerSID
//};
//_dbContext.Farmers.Add(_Farmer);
//_dbContext.SaveChanges();
return(View("Index"));
}
public ActionResult Add(FarmerVM model)
{
FF_FARMER tempUser = new FF_FARMER()
{
CITY = model.CITY,
DISTRICT = model.DISTRICT,
TOWN_OR_VILLAGE = model.TOWN_OR_VILLAGE,
NEIGHBORHOOD = model.NEIGHBORHOOD,
STREET = model.STREET,
APARTMENT = model.APARTMENT,
FARMER_CERTIFICATE = model.FARMER_CERTIFICATE
};
var user = _dbUnit.Repo <FF_FARMER>().Add(tempUser);
if (user != null)
{
return(Ok($"{tempUser.ID} numaralı Farmer eklendi."));
}
else
{
return(BadRequest($"{tempUser.ID} numaralı Farmer eklenemedi.."));
}
}
