public FarmerViewModel GetFarmerByFsc(string FscId, int Mode = 0)
{
DataSet ds = _Apdal.GetFarmerByFsc(FscId, Mode);
FarmerViewModel a = new FarmerViewModel();
if (ds != null && ds.Tables[0] != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
List <FarmerModel> p = new List <FarmerModel>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
FarmerModel Reason = new FarmerModel();
Reason.FarmerId = ds.Tables[0].Rows[i]["FarmerId"].ToString();
Reason.FarmerName = ds.Tables[0].Rows[i]["FarmerName"].ToString();
Reason.MobileNo = ds.Tables[0].Rows[i]["MobileNo"].ToString();
Reason.District = ds.Tables[0].Rows[i]["DistrictName"].ToString();
Reason.DistrictId = ds.Tables[0].Rows[i]["DistrictID"].ToString();
Reason.StateId = ds.Tables[0].Rows[i]["StateID"].ToString();
Reason.StatusID = Convert.ToInt32(ds.Tables[0].Rows[i]["BlackListStatus"].ToString());
Reason.CallStatus = ds.Tables[0].Rows[i]["AgentStatus"].ToString();
p.Add(Reason);
}
a.FarmerList = p;
}
}
return(a);
}
public async Task <IActionResult> Profile()
{
try
{
var username = User.Identity.Name;
var farmer = await _farmerRepository.FindByNameAsync(username);
var farmerModel = new FarmerViewModel
{
Id = farmer.Id,
FirstName = farmer.FirstName,
LastName = farmer.LastName,
DateCreated = farmer.DateCreated,
Email = farmer.Email,
Address = farmer.Address,
Phone = farmer.Phone,
TotalAnimals = await _animalRepository.TotalAnimals(username)
};
return(Ok(new FarmerProfileRequestModel {
Status = "success", Message = "farmer profile successfully retrieved", Profile = farmerModel
}));
}
catch (Exception ex)
{
var response = new ErrorModel
{
Status = "error",
Message = $"{ex.Message}",
};
return(BadRequest(response));
}
}
public ActionResult AddFarmer(FarmerViewModel model)
{
Farmers farmersEntity = new Farmers
{
UserName = model.UserName,
Email = model.Email,
Password = model.Password,
AddedDate = DateTime.UtcNow,
ModifiedDate = DateTime.UtcNow,
FarmerProfile = new FarmerProfile
{
FirstName = model.FirstName,
LastName = model.LastName,
Address = model.Address,
AddedDate = DateTime.UtcNow,
ModifiedDate = DateTime.UtcNow,
}
};
farmerService.InsertFarmer(farmersEntity);
if (farmersEntity.Id > 0)
{
return(RedirectToAction("index"));
}
return(View(model));
}
// The action method EditFarmer helps to return a view to edit a farmers details in the system
public ActionResult EditFarmer(int?id)
{
FarmerViewModel model = new FarmerViewModel();
if (id.HasValue && id != 0)
{
Farmers farmerEntity = farmerService.GetFarmer(id.Value);
FarmerProfile farmerProfileEntity = farmerProfileService.GetFarmerProfile(id.Value);
model.FirstName = farmerProfileEntity.FirstName;
model.LastName = farmerProfileEntity.LastName;
model.Address = farmerProfileEntity.Address;
model.Email = farmerEntity.Email;
}
return(PartialView("_EditFarmer", model));
}
public async Task <IActionResult> SelectFarmer([FromBody] FarmerViewModel farmerViewModel)
{
try
{
var _serviceEndPoint = new ServicesEndPoint(_unitOfWork, _emailService);
var farmer = _Mapper.Map <Farmer>(farmerViewModel);
var result = await _serviceEndPoint.SelectFarmer(farmer);
if (result == null)
{
return(NotFound(farmerViewModel));
}
return(Ok(new { message = "Succesfully Selected!", result = result }));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public async Task <IActionResult> GetFarmerById(int farmerId)
{
try
{
var _serviceEndPoint = new ServicesEndPoint(_unitOfWork, _emailService);
Farmer res = await _serviceEndPoint.GetFarmerById(farmerId);
FarmerViewModel results = _Mapper.Map <FarmerViewModel>(res);
if (results == null)
{
return(NotFound(results));
}
return(Ok(results));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IActionResult Index()
{
List <FarmerViewModel> model = new List <FarmerViewModel>();
farmerService.GetFarmers().ToList().ForEach(u =>
{
FarmerProfile farmerProfile = farmerProfileService.GetFarmerProfile(u.Id);
FarmerViewModel farmer = new FarmerViewModel
{
Id = u.Id,
Name = $"{farmerProfile.FirstName} {farmerProfile.LastName}",
Email = u.Email,
Address = farmerProfile.Address
};
model.Add(farmer);
});
return(View(model));
}
public ActionResult EditFarmer(FarmerViewModel model)
{
Farmers farmerEntity = farmerService.GetFarmer(model.Id);
farmerEntity.Email = model.Email;
farmerEntity.ModifiedDate = DateTime.UtcNow;
FarmerProfile farmerProfileEntity = farmerProfileService.GetFarmerProfile(model.Id);
farmerProfileEntity.FirstName = model.FirstName;
farmerProfileEntity.LastName = model.LastName;
farmerProfileEntity.Address = model.Address;
farmerProfileEntity.ModifiedDate = DateTime.UtcNow;
farmerEntity.FarmerProfile = farmerProfileEntity;
farmerService.UpdateFarmer(farmerEntity);
if (farmerEntity.Id > 0)
{
return(RedirectToAction("index"));
}
return(View(model));
}
public Farmer GetFarmerByFsc(string apiKey, string FscId, int Mode = 0)
{
Farmer fr = new Farmer();
if (apiKey == ConfigurationManager.AppSettings["reasonkey"])
{
try
{
FarmerViewModel a = _agentbal.GetFarmerByFsc(FscId, Mode);
var f = new List <FarmerModel>();
fr.Farmers = a;
}
catch (Exception ex)
{
LogBal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, int.Parse(FscId));
}
}
return(fr);
}
public async Task <FarmerViewModel> GetByUser(int userId)
{
FarmerViewModel result = null;
string cmd = $@"SELECT * FROM `farmer` f
LEFT JOIN `address` a ON a.id = f.address_id AND a.is_used = 1 AND a.is_deleted = 0
LEFT JOIN `contact` c ON c.id = f.contact_id AND c.is_used = 1 AND c.is_deleted = 0
WHERE f.user_account_id = {userId} and f.is_deleted = 0";
if (DbConnection != null)
{
var rd = await DbConnection.QueryMultipleAsync(cmd, transaction : DbTransaction);
rd.Read <Farmer, Address, Contact, FarmerViewModel>(
(fRs, aRs, cRs) =>
{
if (result == null)
{
result = CommonHelper.Mapper <Farmer, FarmerViewModel>(fRs);
}
if (result.Address == null)
{
result.Address = aRs;
}
if (result.Contact == null)
{
result.Contact = cRs;
}
return(result);
}
);
return(result);
}
else
{
using (var conn = DALHelper.GetConnection())
{
var rd = await conn.QueryMultipleAsync(cmd);
rd.Read <Farmer, Address, Contact, FarmerViewModel>(
(fRs, aRs, cRs) =>
{
if (result == null)
{
result = CommonHelper.Mapper <Farmer, FarmerViewModel>(fRs);
}
if (result.Address == null)
{
result.Address = aRs;
}
if (result.Contact == null)
{
result.Contact = cRs;
}
return(result);
}
);
return(result);
}
}
}
public UpdateCommand(FarmerViewModel farmer)
{
Farmer = farmer;
}
public ActionResult AddFarmer()
{
FarmerViewModel model = new FarmerViewModel();
return(PartialView("_AddFarmer", model));
}
public AddCommand(FarmerViewModel farmer)
{
Farmer = farmer;
}
