public int DeleteCropList(CropDetailsModel model)
{
int id = 0;
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_DeleteCropList";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CropListId", model.Id);
cmd.Parameters.AddWithValue("@UserId", model.ModifiedBy);
cmd.ExecuteNonQuery();
id = 1;
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(id);
}
public CropDetailsModel GetInventoryCropDetails(CropDetailsModel request)
{
ICropDetailsDataAccess _repository = new CropDetailsDataAccess();
CropDetailsModel response = new CropDetailsModel();
response = _repository.GetInventoryCropDetails(request.Id);
return(response);
}
private void PopulateSupplierNames(CropDetailsModel cropDetailsModel)
{
IQueryable <Supplier_Details> supplierDetails = CropDetailsManager.GetSupplierDetails();
cropDetailsModel.SupplierDetailsList =
supplierDetails.Select(i => new SelectListItem()
{
Text = i.SupplierName, Value = i.SupplierId.ToString()
}).OrderBy(i => i.Text).ToList();
}
public ActionResult SaveCropShedule(CropDetailsModel cropDetailsModel)
{
CropDetailsManager.SavePendingCropDtailsForProduction();
return(RedirectToAction("PendingCropDetails", new LeaveDashboardModel
{
IsRedirectedAfterSave = true,
OpperationMessage = "The changes were successfully saved."
}));
}
public IList <CropDetailsModel> GetCropDetails(CropDetailsModel request)
{
IList <CropDetailsModel> Crops = new List <CropDetailsModel>();
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_GetCropListDetails";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", request.CreatedBy);
cmd.Parameters.AddWithValue("@CropId", request.CropId);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
CropDetailsModel model = new CropDetailsModel();
model.Id = Convert.ToInt32(reader["Id"]);
model.CropId = Convert.ToInt32(reader["CropId"]);
model.Variety = Convert.ToString(reader["Variety"]);
model.Grade = Convert.ToString(reader["Grade"]);
model.UoM = Convert.ToString(reader["UoM"]);
model.Quantity = Convert.ToInt32(reader["Quantity"]);
model.SellType = Convert.ToInt32(reader["SellType"]);
model.FarmerId = Convert.ToInt32(reader["FarmerId"]);
model.Price = Convert.ToString(reader["Price"]);
model.PickupLocation = Convert.ToString(reader["PickupLocation"]);
model.Latitude = Convert.ToString(reader["Latitude"]);
model.Longitude = Convert.ToString(reader["Longitude"]);
model.Location = Convert.ToString(reader["Location"]);
Crops.Add(model);
}
}
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(Crops);
}
private void CalculateRequiredMachineCount(CropDetailsModel cropDetailsModel, double totalProductionWeight)
{
if (totalProductionWeight != 0.0)
{
cropDetailsModel.requiredTroughMachineCount = Convert.ToInt32(Math.Ceiling(totalProductionWeight / 2500));
cropDetailsModel.requiredRollerMachineCount = Convert.ToInt32(Math.Ceiling(totalProductionWeight / 140));
cropDetailsModel.requiredRollBreakerMachineCount = Convert.ToInt32(Math.Ceiling(totalProductionWeight / 175));
cropDetailsModel.requiredDryerMachineCount = 1;
cropDetailsModel.requiredSifterMachineCount = Convert.ToInt32(Math.Ceiling(totalProductionWeight / 355));
cropDetailsModel.requiredColorSorterMachineCount = Convert.ToInt32(Math.Ceiling(totalProductionWeight / 200));
if (cropDetailsModel.requiredTroughMachineCount > 6)
{
cropDetailsModel.requiredTroughMachineCount = 6;
}
if (cropDetailsModel.requiredRollerMachineCount > 7)
{
cropDetailsModel.requiredRollerMachineCount = 7;
}
if (cropDetailsModel.requiredRollBreakerMachineCount > 5)
{
cropDetailsModel.requiredRollBreakerMachineCount = 5;
}
if (cropDetailsModel.requiredSifterMachineCount > 10)
{
cropDetailsModel.requiredSifterMachineCount = 10;
}
if (cropDetailsModel.requiredColorSorterMachineCount > 2)
{
cropDetailsModel.requiredColorSorterMachineCount = 2;
}
}
else
{
cropDetailsModel.requiredTroughMachineCount = 0;
cropDetailsModel.requiredRollerMachineCount = 0;
cropDetailsModel.requiredRollBreakerMachineCount = 0;
cropDetailsModel.requiredDryerMachineCount = 0;
cropDetailsModel.requiredSifterMachineCount = 0;
cropDetailsModel.requiredColorSorterMachineCount = 0;
}
}
public int AddCropDetails(CropDetailsModel model)
{
int id = 0;
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_AddCropListDetails";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CropId", model.CropId);
cmd.Parameters.AddWithValue("@Variety", model.Variety);
cmd.Parameters.AddWithValue("@Grade", model.Grade);
cmd.Parameters.AddWithValue("@UoM", model.UoM);
cmd.Parameters.AddWithValue("@Quantity", model.Quantity);
cmd.Parameters.AddWithValue("@SellType", model.SellType);
cmd.Parameters.AddWithValue("@Price", model.Price);
cmd.Parameters.AddWithValue("@CreatedBy", model.CreatedBy);
cmd.Parameters.AddWithValue("@PickupLocation", model.PickupLocation);
cmd.Parameters.AddWithValue("@Location", model.Location);
cmd.Parameters.AddWithValue("@Latitude", model.Latitude);
cmd.Parameters.AddWithValue("@Longitude", model.Longitude);
cmd.Parameters.AddWithValue("@StateId", model.StateId);
cmd.Parameters.AddWithValue("@DistID", model.DistId);
cmd.Parameters.AddWithValue("@TalukID", model.TalukId);
cmd.Parameters.AddWithValue("@HobliID", model.HobliId);
cmd.Parameters.AddWithValue("@VillageID", model.VillageId);
cmd.Parameters.AddWithValue("@AddressId", model.AddressId);
cmd.ExecuteNonQuery();
id = 1;
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(id);
}
public ActionResult SaveCropDetails(CropDetailsModel cropDetailsModel)
{
int supplierId = int.Parse(cropDetailsModel.SupplierId);
CropDetailsManager.SaveCropDetails(
cropDetailsModel.SheduleDate,
cropDetailsModel.EstateLeafWeight,
supplierId,
cropDetailsModel.BoughtLeafWeight,
cropDetailsModel.TotalProductionWeight,
cropDetailsModel.TotalWestageWeight);
return(RedirectToAction("AddCropDetails", new LeaveDashboardModel
{
IsRedirectedAfterSave = true,
OpperationMessage = "The changes were successfully saved."
}));
}
public ActionResult PendingCropDetails(CropDetailsModel cropDetailsModel)
{
List <Crop_Details> cropDetails = CropDetailsManager.SelectCropDtailsPendingProduction();
double totalProductionWeight = cropDetails.Sum(i => i.ProducedWeight);
CalculateRequiredMachineCount(cropDetailsModel, totalProductionWeight);
CalculateRequiredEmployeeCount(cropDetailsModel, totalProductionWeight);
cropDetailsModel.CropDetailsList = cropDetails.Select(i => new CropDetailsList
{
CropId = i.CropId,
EstateLeafWeight = i.EstateLeafWeight,
BoughtLeafWeight = i.BoughtLeafWeight,
SupplierName = i.Supplier_Details.SupplierName,
ProductionWeight = i.ProducedWeight,
WastageWeight = i.WastageWeight,
EnteredDate = i.Date.ToShortDateString()
}).OrderByDescending(i => i.EnteredDate).ToList();
return(View(cropDetailsModel));
}
public CropDetailsModel GetInventoryCropDetails(int Id)
{
CropDetailsModel model = new CropDetailsModel();
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_CorpListFarmerDetails";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CropId", Id);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
model.Id = Convert.ToInt32(reader["Id"]);
model.CropId = Convert.ToInt32(reader["CropId"]);
model.Variety = Convert.ToString(reader["Variety"]);
model.Grade = Convert.ToString(reader["Grade"]);
model.UoM = Convert.ToString(reader["UoM"]);
model.Quantity = Convert.ToInt32(reader["Quantity"]);
model.SellType = Convert.ToInt32(reader["SellType"]);
model.Price = Convert.ToString(reader["Price"]);
model.IsActive = Convert.ToBoolean(reader["IsActive"]);
model.CreatedBy = Convert.ToInt32(reader["CreatedBy"]);
model.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]);
model.PickupLocation = Convert.ToString(reader["PickupLocation"]);
model.Latitude = Convert.ToString(reader["Latitude"]);
model.Longitude = Convert.ToString(reader["Longitude"]);
model.Location = Convert.ToString(reader["Location"]);
model.FarmerId = Convert.ToInt32(reader["FarmerId"]);
model.StateId = Convert.ToInt32(reader["StateId"]);
model.DistId = Convert.ToInt32(reader["DistID"]);
model.TalukId = Convert.ToInt32(reader["TalukID"]);
model.HobliId = Convert.ToInt32(reader["HobliID"]);
model.VillageId = Convert.ToInt32(reader["VillageID"]);
model.UserAdrress = new UserAddress();
model.UserAdrress.Id = Convert.ToInt32(reader["AddressId"]);
model.UserAdrress.Name = Convert.ToString(reader["Name"]);
model.UserAdrress.MobileNo = Convert.ToString(reader["mobileNo"]);
model.UserAdrress.StreeAddress = Convert.ToString(reader["StreetAdress"]);
model.UserAdrress.StreeAddress1 = Convert.ToString(reader["StreetAddress1"]);
model.UserAdrress.City = Convert.ToString(reader["City"]);
model.UserAdrress.LandMark = Convert.ToString(reader["LandMark"]);
model.UserAdrress.State = Convert.ToString(reader["State"]);
model.UserAdrress.District = Convert.ToString(reader["District"]);
model.UserAdrress.Taluk = Convert.ToString(reader["Taluk"]);
model.UserAdrress.Hoblie = Convert.ToString(reader["Hobli"]);
model.UserAdrress.Pincode = Convert.ToString(reader["Pincode"]);
model.UserAdrress.PickUpFrom = Convert.ToString(reader["addPickUpLocation"]);
model.CropIcon = Convert.ToString(reader["CropIcon"]);
model.CropName = Convert.ToString(reader["CropName"]);
model.CategoryId = Convert.ToInt32(reader["CategoryId"]);
model.Category = Convert.ToString(reader["Catagory"]);
model.CategoryIcon = Convert.ToString(reader["CatagoryIcon"]);
}
}
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(model);
}
public IList <CropDetailsModel> GetCropList(CropDetailsModel obj)
{
IList <CropDetailsModel> Crops = new List <CropDetailsModel>();
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_GetMyListings";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", obj.CreatedBy);
cmd.Parameters.AddWithValue("@PickUpFrom", obj.PickupLocation);
cmd.Parameters.AddWithValue("@FromDate", (obj.FromDate == null || obj.FromDate == new DateTime()) ? SqlDateTime.MinValue.Value : obj.FromDate);
cmd.Parameters.AddWithValue("@ToDate", (obj.ToDate == null || obj.ToDate == new DateTime()) ? SqlDateTime.MaxValue.Value.AddDays(-1) : obj.ToDate);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
CropDetailsModel model = new CropDetailsModel();
model.Id = Convert.ToInt32(reader["Id"]);
model.CropId = Convert.ToInt32(reader["CropId"]);
model.Variety = Convert.ToString(reader["Variety"]);
model.Grade = Convert.ToString(reader["Grade"]);
model.UoM = Convert.ToString(reader["UoM"]);
model.Quantity = Convert.ToInt32(reader["Quantity"]);
model.SellType = Convert.ToInt32(reader["SellType"]);
model.Price = Convert.ToString(reader["Price"]);
model.CropName = Convert.ToString(reader["CropName"]);
model.CropIcon = Convert.ToString(reader["CropIcon"]);
model.Category = Convert.ToString(reader["Catagory"]);
model.CategoryIcon = Convert.ToString(reader["CatagoryIcon"]);
model.IsActive = Convert.ToBoolean(reader["IsActive"]);
model.CreatedBy = Convert.ToInt32(reader["CreatedBy"]);
model.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]);
model.PickupLocation = Convert.ToString(reader["PickupLocation"]);
model.Latitude = Convert.ToString(reader["Latitude"]);
model.Longitude = Convert.ToString(reader["Longitude"]);
model.Location = Convert.ToString(reader["Location"]);
model.FarmerId = Convert.ToInt32(reader["FarmerId"]);
model.StateId = Convert.ToInt32(reader["StateId"]);
model.DistId = Convert.ToInt32(reader["DistID"]);
model.TalukId = Convert.ToInt32(reader["TalukID"]);
model.HobliId = Convert.ToInt32(reader["HobliID"]);
model.VillageId = Convert.ToInt32(reader["VillageID"]);
model.AddressId = Convert.ToInt32(reader["AddressId"]);
model.UserAdrress = new UserAddress();
model.UserAdrress.Id = Convert.ToInt32(reader["AddressId"]);
model.UserAdrress.Name = Convert.ToString(reader["Name"]);
model.UserAdrress.MobileNo = Convert.ToString(reader["mobileNo"]);
model.UserAdrress.StreeAddress = Convert.ToString(reader["StreetAdress"]);
model.UserAdrress.StreeAddress1 = Convert.ToString(reader["StreetAddress1"]);
model.UserAdrress.City = Convert.ToString(reader["City"]);
model.UserAdrress.LandMark = Convert.ToString(reader["LandMark"]);
model.UserAdrress.State = Convert.ToString(reader["State"]);
model.UserAdrress.District = Convert.ToString(reader["District"]);
model.UserAdrress.Taluk = Convert.ToString(reader["Taluk"]);
model.UserAdrress.Hoblie = Convert.ToString(reader["Hobli"]);
model.UserAdrress.Pincode = Convert.ToString(reader["Pincode"]);
model.UserAdrress.PickUpFrom = Convert.ToString(reader["PickUpLocation"]);
Crops.Add(model);
}
}
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(Crops);
}
public ActionResult AddCropDetails(CropDetailsModel cropDetailsModel)
{
PopulateSupplierNames(cropDetailsModel);
return(View(cropDetailsModel));
}
private void CalculateRequiredEmployeeCount(CropDetailsModel cropDetailsModel, double totalProductionWeight)
{
if (totalProductionWeight != 0.0)
{
if (totalProductionWeight <= 5000)
{
cropDetailsModel.Transportation = 2;
cropDetailsModel.Spreading = 2;
cropDetailsModel.Withering = 2;
cropDetailsModel.Rolling = 3;
cropDetailsModel.RollBrakes = 3;
cropDetailsModel.Fermentation = 2;
cropDetailsModel.Drying = 2;
cropDetailsModel.Sifter = 5;
cropDetailsModel.ColorSorter = 2;
cropDetailsModel.Packing = 2;
}
else if (totalProductionWeight <= 7500)
{
cropDetailsModel.Transportation = 3;
cropDetailsModel.Spreading = 3;
cropDetailsModel.Withering = 2;
cropDetailsModel.Rolling = 4;
cropDetailsModel.RollBrakes = 4;
cropDetailsModel.Fermentation = 2;
cropDetailsModel.Drying = 2;
cropDetailsModel.Sifter = 6;
cropDetailsModel.ColorSorter = 2;
cropDetailsModel.Packing = 2;
}
else if (totalProductionWeight <= 10000)
{
cropDetailsModel.Transportation = 4;
cropDetailsModel.Spreading = 4;
cropDetailsModel.Withering = 3;
cropDetailsModel.Rolling = 5;
cropDetailsModel.RollBrakes = 4;
cropDetailsModel.Fermentation = 3;
cropDetailsModel.Drying = 2;
cropDetailsModel.Sifter = 7;
cropDetailsModel.ColorSorter = 2;
cropDetailsModel.Packing = 2;
}
else if (totalProductionWeight <= 12500)
{
cropDetailsModel.Transportation = 5;
cropDetailsModel.Spreading = 5;
cropDetailsModel.Withering = 3;
cropDetailsModel.Rolling = 5;
cropDetailsModel.RollBrakes = 4;
cropDetailsModel.Fermentation = 3;
cropDetailsModel.Drying = 2;
cropDetailsModel.Sifter = 8;
cropDetailsModel.ColorSorter = 2;
cropDetailsModel.Packing = 2;
}
else
{
cropDetailsModel.Transportation = 5;
cropDetailsModel.Spreading = 5;
cropDetailsModel.Withering = 3;
cropDetailsModel.Rolling = 6;
cropDetailsModel.RollBrakes = 5;
cropDetailsModel.Fermentation = 3;
cropDetailsModel.Drying = 2;
cropDetailsModel.Sifter = 9;
cropDetailsModel.ColorSorter = 2;
cropDetailsModel.Packing = 2;
}
}
else
{
cropDetailsModel.Transportation = 0;
cropDetailsModel.Spreading = 0;
cropDetailsModel.Withering = 0;
cropDetailsModel.Rolling = 0;
cropDetailsModel.RollBrakes = 0;
cropDetailsModel.Fermentation = 0;
cropDetailsModel.Drying = 0;
cropDetailsModel.Sifter = 0;
cropDetailsModel.ColorSorter = 0;
cropDetailsModel.Packing = 0;
}
}
