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