public ActionResult Update(ConsumerVM model)
{
using (FromFarmerContext ctx = new FromFarmerContext())
{
var consumer = ctx.FF_CONSUMER.Where(x => x.IDENTITY_NUMBER == model.IDENTITY_NUMBER).FirstOrDefault();
if (consumer != null)
{
FF_CONSUMER tempConsumer = new FF_CONSUMER()
{
IDENTITY_NUMBER = model.IDENTITY_NUMBER,
CITY = model.CITY,
DISTRICT = model.NEİGHBORHOOD,
STREET = model.STREET,
APARTMENT = model.APARTMENT,
PHONE_NUMBER = model.PHONENUMBER
};
var userResult = _dbUnit.Repo <FF_CONSUMER>().Update(tempConsumer);
if (userResult != null)
{
return(Ok($"{model.IDENTITY_NUMBER} numaralı kullanıcı güncellendi."));
}
else
{
return(BadRequest($"{model.IDENTITY_NUMBER} numaralı kullanıcı güncellenemedi.."));
}
}
else
{
return(BadRequest($"{model.IDENTITY_NUMBER} numaralı kullanıcı bulunamadı.."));
}
}
}
public ActionResult GetUserByIdentityNumber(int identityNumber)
{
using (FromFarmerContext ctx = new FromFarmerContext())
{
var user = ctx.FF_USER.Where(x => x.IDENTITY_NUMBER == identityNumber).FirstOrDefault();
if (user != null)
{
UserVM tempUser = new UserVM()
{
IdentityNumber = user.IDENTITY_NUMBER,
Firstname = user.FIRSTNAME,
Lastname = user.LASTNAME,
Gender = user.GENDER,
DateOfBirth = user.DATE_OF_BIRTH,
MailAddress = user.MAIL_ADDRESS,
PhoneNumber = user.PHONE_NUMBER,
WorkAddress = user.WORK_ADDRESS,
IsFarmer = user.IS_FARMER
};
return(Ok(tempUser));
}
else
{
return(BadRequest("Error : \"user\" is not null!!"));
}
}
}
public ActionResult GetOrderByIdentityNumber(int id)
{
using (FromFarmerContext ctx = new FromFarmerContext())
{
var order = ctx.FF_ORDER.Where(x => x.ID == id).FirstOrDefault();
if (order != null)
{
OrderVM tempOrder = new OrderVM()
{
IDENTITY_NUMBER = order.IDENTITY_NUMBER,
STATUS = order.STATUS,
CONSUMER_ID = order.CONSUMER_ID,
DATE_TİME = order.DATE_TİME,
DELIVERY_ADDRESS = order.DELIVERY_ADDRESS,
PAYMENT_INFORMATION = order.PAYMENT_INFORMATION,
SHIPPING_FREE = order.SHIPPING_FREE,
TOTAL_PRICE = order.TOTAL_PRICE,
SHIPPING_TRACKING_NUMBER = order.SHIPPING_TRACKING_NUMBER
};
return(Ok(tempOrder));
}
else
{
return(BadRequest("Error : \"order\" is not null!!"));
}
}
}
public ActionResult GetUserByIdentityNumber(int identityNumber)
{
using (FromFarmerContext ctx = new FromFarmerContext())
{
var product = ctx.FF_PRODUCT.Where(x => x.IDENTITY_NUMBER == identityNumber).FirstOrDefault();
if (product != null)
{
ProductVM tempProduct = new ProductVM()
{
IDENTITY_NUMBER = product.IDENTITY_NUMBER,
TYPE = product.TYPE,
CATEGORY = product.CATEGORY,
TITLE = product.TITLE,
DESCRIPTION = product.DESCRIPTION,
FARMER_ID = product.FARMER_ID,
PRICE = product.PRICE,
QUANTITY = product.QUANTITY
};
return(Ok(tempProduct));
}
else
{
return(BadRequest("Error : \"product\" is not null!!"));
}
}
}
public ActionResult Update(ProductVM model)
{
using (FromFarmerContext ctx = new FromFarmerContext())
{
var product = ctx.FF_PRODUCT.Where(x => x.IDENTITY_NUMBER == model.IDENTITY_NUMBER).FirstOrDefault();
if (product != null)
{
FF_PRODUCT tempProduct = new FF_PRODUCT()
{
IDENTITY_NUMBER = model.IDENTITY_NUMBER,
TYPE = model.TYPE,
CATEGORY = model.CATEGORY,
TITLE = model.TITLE,
DESCRIPTION = model.DESCRIPTION,
FARMER_ID = model.FARMER_ID,
PRICE = model.PRICE,
QUANTITY = model.QUANTITY
};
var productResult = _dbUnit.Repo <FF_PRODUCT>().Update(tempProduct);
if (productResult != null)
{
return(Ok($"{model.IDENTITY_NUMBER} numaralı ürün güncellendi."));
}
else
{
return(BadRequest($"{model.IDENTITY_NUMBER} numaralı ürün güncellenemedi.."));
}
}
else
{
return(BadRequest($"{model.IDENTITY_NUMBER} numaralı ürün bulunamadı.."));
}
}
}
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 List <T> GetAll()
{
using (FromFarmerContext context = new FromFarmerContext())
{
DbSet <T> _dbSet = context.Set <T>();
return(_dbSet.AsNoTracking().Where(x => x.IS_DELETED == 0).ToList());
}
}
public T Get(long id)
{
using (FromFarmerContext context = new FromFarmerContext())
{
DbSet <T> _dbSet = context.Set <T>();
return(_dbSet.AsNoTracking().FirstOrDefault(x => x.IS_DELETED == 0 && x.ID == id));
}
}
public T Update(T entity)
{
using (FromFarmerContext context = new FromFarmerContext())
{
entity.MODIFIED_AT = DateTime.Now;
entity.IS_MODIFIED = 1;
context.Attach(entity);
context.Entry(entity).State = EntityState.Modified;
context.SaveChanges();
return(entity);
}
}
public ActionResult Delete(int identityNumber)
{
using (FromFarmerContext ctx = new FromFarmerContext())
{
var user = ctx.FF_USER.Where(x => x.IDENTITY_NUMBER == identityNumber).FirstOrDefault();
if (user != null)
{
_dbUnit.Repo <FF_USER>().Delete(Convert.ToInt32(user.ID));
return(Ok($"{identityNumber} numaralı kullanıcı silinmiştir."));
}
else
{
return(BadRequest($"{identityNumber} numaralı kullanıcı bulunamamıştır!!"));
}
}
}
public T Add(T entity)
{
using (FromFarmerContext context = new FromFarmerContext())
{
entity.CREATE_AT = DateTime.Now;
entity.MODIFIED_AT = DateTime.Now;
entity.IS_DELETED = 0;
entity.IS_MODIFIED = 0;
var a = context.Add(entity);
context.SaveChanges();
return(entity);
}
}
public ActionResult Delete(int identityNumber)
{
using (FromFarmerContext ctx = new FromFarmerContext())
{
var product = ctx.FF_PRODUCT.Where(x => x.IDENTITY_NUMBER == identityNumber).FirstOrDefault();
if (product != null)
{
_dbUnit.Repo <FF_PRODUCT>().Delete(Convert.ToInt32(product.ID));
return(Ok($"{identityNumber} numaralı ürün silinmiştir."));
}
else
{
return(BadRequest($"{identityNumber} numaralı ürün bulunamamıştır!!"));
}
}
}
public ActionResult Update(UserVM model)
{
using (FromFarmerContext ctx = new FromFarmerContext())
{
var user = ctx.FF_USER.Where(x => x.IDENTITY_NUMBER == model.IdentityNumber).FirstOrDefault();
if (user != null)
{
FF_USER tempUser = new FF_USER()
{
ID = user.ID,
IDENTITY_NUMBER = model.IdentityNumber,
FIRSTNAME = model.Firstname,
LASTNAME = model.Lastname,
GENDER = model.Gender,
DATE_OF_BIRTH = model.DateOfBirth,
MAIL_ADDRESS = model.MailAddress,
PHONE_NUMBER = model.PhoneNumber,
WORK_ADDRESS = model.WorkAddress,
IS_FARMER = model.IsFarmer
};
var userResult = _dbUnit.Repo <FF_USER>().Update(tempUser);
if (userResult != null)
{
return(Ok($"{model.IdentityNumber} numaralı kullanıcı güncellendi."));
}
else
{
return(BadRequest($"{model.IdentityNumber} numaralı kullanıcı güncellenemedi.."));
}
}
else
{
return(BadRequest($"{model.IdentityNumber} numaralı kullanıcı bulunamadı.."));
}
}
}
public ActionResult Update(OrderVM model)
{
using (FromFarmerContext ctx = new FromFarmerContext())
{
var order = ctx.FF_ORDER.Where(x => x.IDENTITY_NUMBER == model.IDENTITY_NUMBER).FirstOrDefault();
if (order != null)
{
FF_ORDER tempUser = new FF_ORDER()
{
IDENTITY_NUMBER = model.IDENTITY_NUMBER,
STATUS = model.STATUS,
CONSUMER_ID = model.CONSUMER_ID,
DATE_TİME = model.DATE_TİME,
DELIVERY_ADDRESS = model.DELIVERY_ADDRESS,
PAYMENT_INFORMATION = model.PAYMENT_INFORMATION,
SHIPPING_FREE = model.SHIPPING_FREE,
TOTAL_PRICE = model.TOTAL_PRICE,
SHIPPING_TRACKING_NUMBER = model.SHIPPING_TRACKING_NUMBER
};
var userResult = _dbUnit.Repo <FF_ORDER>().Update(tempUser);
if (userResult != null)
{
return(Ok($"{model.IDENTITY_NUMBER} numaralı kullanıcı güncellendi."));
}
else
{
return(BadRequest($"{model.IDENTITY_NUMBER} numaralı kullanıcı güncellenemedi.."));
}
}
else
{
return(BadRequest($"{model.IDENTITY_NUMBER} numaralı kullanıcı bulunamadı.."));
}
}
}
public Repo()
{
_ctx = new FromFarmerContext();
}
public UnitOfWork(FromFarmerContext context)
{
_dbContext = context;
}
public UnitOfWork()
{
_dbContext = new FromFarmerContext();
}
