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; } }