public ApiResponse <PlantMasterModel> GetPlantDetail(int plantId) { var response = new ApiResponse <PlantMasterModel>(); List <PlantMasterModel> planMasterModelList = new List <PlantMasterModel>(); PlantMasterModel planMasterModel = new PlantMasterModel(); planMasterModelList.Add(planMasterModel); try { var plantIdParam = new SqlParameter { ParameterName = "PlantId", DbType = DbType.Int32, Value = (object)plantId ?? (object)DBNull.Value }; var result = _repository.ExecuteSQL <PlantMasterModel>("usp_GetPlantFromPlantMaster", plantIdParam).ToList(); if (plantId == 0) { response.Data = planMasterModelList; } else { response.Data = result; } response.Success = true; } catch (Exception ex) { _logger.Error(ex); response.Message.Add(ex.Message); } return(response); }
public BaseApiResponse SavePlant(PlantMasterModel plantObj) { return(this._iPlantService.SavePlant(plantObj)); }
public BaseApiResponse SavePlant(PlantMasterModel plantObj) { var response = new BaseApiResponse(); try { var plantIdParam = new SqlParameter { ParameterName = "PlantID", DbType = DbType.Int32, Value = plantObj.PlantID }; var plantNameParam = new SqlParameter { ParameterName = "PlantName", DbType = DbType.String, Value = plantObj.PlantName }; var specificationPlantNameParam = new SqlParameter { ParameterName = "PlantName_PressSpecification", DbType = DbType.String, Value = plantObj.PlantName_PressSpecification }; var qadPlantNameParam = new SqlParameter { ParameterName = "PlantName_QAD", DbType = DbType.String, Value = (object)plantObj.PlantName_QAD ?? DBNull.Value }; var regionIdParam = new SqlParameter { ParameterName = "RegionID", DbType = DbType.Int32, Value = plantObj.RegionID }; var countryIdParam = new SqlParameter { ParameterName = "CountryID", DbType = DbType.Int32, Value = plantObj.CountryID }; var userIdParam = new SqlParameter { ParameterName = "UserId", DbType = DbType.Int32, Value = plantObj.LoggedInUserId }; var unitSystemIdParam = new SqlParameter { ParameterName = "UnitSystemId", DbType = DbType.Int32, Value = plantObj.UnitSystemId }; var lengthUnitParam = new SqlParameter { ParameterName = "LengthUnit", DbType = DbType.Int32, Value = plantObj.LengthUnit }; var pressureUnitParam = new SqlParameter { ParameterName = "PressureUnit", DbType = DbType.Int32, Value = plantObj.PressureUnit }; var headCountParam = new SqlParameter { ParameterName = "HeadCount", DbType = DbType.Decimal, Value = (object)plantObj.HeadCount ?? DBNull.Value }; var fringeWageRateParam = new SqlParameter { ParameterName = "FringeWageRate", DbType = DbType.Double, Value = (object)plantObj.FringeWageRate ?? DBNull.Value }; var hourlyWageRateParam = new SqlParameter { ParameterName = "HourlyWageRate", DbType = DbType.Double, Value = (object)plantObj.HourlyWageRate ?? DBNull.Value }; var stdPerfomanceGoalParam = new SqlParameter { ParameterName = "StdPerfomanceGoal", DbType = DbType.Double, Value = plantObj.StdPerfomanceGoal }; var allPerformanceGoalParam = new SqlParameter { ParameterName = "AllPerformanceGoal", DbType = DbType.Double, Value = plantObj.AllPerformanceGoal }; var locationParam = new SqlParameter { ParameterName = "Location", DbType = DbType.String, Value = plantObj.Location }; var moldingManningParam = new SqlParameter { ParameterName = "MoldingManning", DbType = DbType.Double, Value = (object)plantObj.MoldingManning ?? DBNull.Value }; var defaultUTLZPercentageParam = new SqlParameter { ParameterName = "DefaultUTLZPercentage", DbType = DbType.Double, Value = (object)plantObj.DefaultUTLZPercentage ?? DBNull.Value }; var isActiveParam = new SqlParameter { ParameterName = "IsActive", DbType = DbType.Boolean, Value = plantObj.IsActive }; var injectionMoldingIdParam = new SqlParameter { ParameterName = "InjectionMoldingAreaId ", DbType = DbType.String, Value = (object)plantObj.InjectionMoldingAreaId ?? DBNull.Value }; var plantcolorParam = new SqlParameter { ParameterName = "PlantColor", DbType = DbType.String, Value = (object)plantObj.PlantColor ?? DBNull.Value }; var stdReliefDivisorParam = new SqlParameter { ParameterName = "StdReliefDivisor", DbType = DbType.Double, Value = (object)plantObj.StdReliefDivisor ?? DBNull.Value }; var stdQuotedWeekParam = new SqlParameter { ParameterName = "StdQuotedWeek", DbType = DbType.Double, Value = (object)plantObj.StdQuotedWeek ?? DBNull.Value }; var saasIdParam = new SqlParameter { ParameterName = "SaasId", DbType = DbType.Int32, Value = (object)plantObj.SaasId ?? DBNull.Value }; var result = _repository.ExecuteSQL <int>("usp_PlantMaster_SavePlantMaster", plantIdParam, plantNameParam, specificationPlantNameParam, qadPlantNameParam, regionIdParam, countryIdParam, locationParam, unitSystemIdParam, lengthUnitParam, pressureUnitParam, headCountParam, fringeWageRateParam, hourlyWageRateParam, stdPerfomanceGoalParam, allPerformanceGoalParam, moldingManningParam, defaultUTLZPercentageParam, stdReliefDivisorParam, stdQuotedWeekParam, userIdParam, isActiveParam, injectionMoldingIdParam, plantcolorParam, saasIdParam).FirstOrDefault(); response.Success = result > 0; response.InsertedId = result; } catch (Exception ex) { _logger.Error(ex); response.Message.Add(ex.Message); } return(response); }