/// <summary> /// Save the CIR details. /// </summary> /// <param name="oCirModel">object</param> /// <param name="loginUserId">string</param> /// <returns>object</returns> public CIRResult SaveCIRDetails(CIRModel oCirModel, string loginUserId) { CIRResult oCIRResult = new CIRResult(); try { using (var connection = Connection()) { var result = connection.QueryMultiple("CFS_CIR", new { CIRId = oCirModel.CIRId, CIRNumber = oCirModel.CIRNumber, WONumber = oCirModel.WONumber, TbnId = oCirModel.TbnId, DOF = oCirModel.DateOfFailure, AlarmCode = oCirModel.AlarmCode == null ? "0" : oCirModel.AlarmCode, EmpId = oCirModel.EmpId, SwVersion = oCirModel.SwVersion == null ? "0" : oCirModel.SwVersion, HwVersion = oCirModel.HwVersion == null ? "0" : oCirModel.HwVersion, WTGStatus = oCirModel.WTGStatus == null ? "0" : oCirModel.WTGStatus, WTGStartTime = oCirModel.WTGStartTime, WTGStopTime = oCirModel.WTGStopTime, Production = oCirModel.Production, RunHrs = oCirModel.RunHrs == null ? "0" : oCirModel.RunHrs, FnSystem = oCirModel.FuncSystem == null ? "0" : oCirModel.FuncSystem, CompGroup = oCirModel.ComponentGroup == null ? "0" : oCirModel.ComponentGroup, ComponentMake = oCirModel.ComponentMake, FailureDuring = oCirModel.FailureDuring == null ? "0" : oCirModel.FailureDuring, SerialNumber = oCirModel.SerialNumber, FOM = oCirModel.FOM == null ? "0" : oCirModel.FOM, AlarmDesc = oCirModel.AlarmDesc, UId = loginUserId, Partcode = oCirModel.PartCode }, commandType: CommandType.StoredProcedure); oCIRResult.MessageInfo = result.Read <Message>().FirstOrDefault(); if (oCIRResult.MessageInfo.Clear == "True") { oCIRResult.CIRData = result.Read <CIRModel>().FirstOrDefault(); } } } catch (Exception ex) { //SaveErrorMessageInFile(oErrorMessage = new ErrorMessage { UserId = loginUserId, ModuleName = "CIR", MethodName = "SaveCIRDetails", Exception = ex.Message }); Logger.Error(ex.Message); } return(oCIRResult); }
/// <summary> /// Save the CIM details. /// </summary> /// <param name="oCirModel">object</param> /// <param name="loginUserId">string</param> /// <returns>object</returns> public CIRResult SaveCIRDetails(CIRModel oCirModel, string loginUserId) { CIRResult oCIRResult = new CIRResult(); try { using (var conn = Connection()) { var result = conn.QueryMultiple("CFS_CIM", new { CIMId = oCirModel.CIMId == null ? "0" : oCirModel.CIMId, CIMNumber = oCirModel.CIMNumber == null ? "" : oCirModel.CIMNumber, TbnId = oCirModel.TbnId == null ? "0" : oCirModel.TbnId, DOF = oCirModel.DateOfFailure, AlarmCode = oCirModel.AlarmCode, EmpId = oCirModel.EmpId, SwVersion = oCirModel.SwVersion, HwVersion = oCirModel.HwVersion, WTGStatus = oCirModel.WTGStatus == null ? "0" : oCirModel.WTGStatus, WTGStartTime = oCirModel.WTGStartTime, WTGStopTime = oCirModel.WTGStopTime, Production = oCirModel.Production == null ? "0" : oCirModel.Production, RunHrs = oCirModel.RunHrs == null ? "0" : oCirModel.RunHrs, FnSytem = oCirModel.FuncSystem == null ? "0" : oCirModel.FuncSystem, CompGroup = oCirModel.ComponentGroup == null ? "0" : oCirModel.ComponentGroup, ComponentMake = oCirModel.ComponentMake, FailureDuring = oCirModel.FailureDuring == null ? "0" : oCirModel.FailureDuring, SerialNumber = oCirModel.SerialNumber, FOM = oCirModel.FOM == null ? "0" : oCirModel.FOM, UId = loginUserId, Partcode = oCirModel.PartCode == null ? "" : oCirModel.PartCode, WONumber = oCirModel.WONumber == null ? "" : oCirModel.WONumber, TSite = oCirModel.TSite == null ? "0" : oCirModel.TSite, DOC = oCirModel.DOC == null ? "" : oCirModel.DOC, Turbine = oCirModel.TTurbine == null ? "" : oCirModel.TTurbine, Customer = oCirModel.Customer == null ? "" : oCirModel.Customer, Temp = oCirModel.TempName == null ? "" : oCirModel.TempName, Dust = oCirModel.Dust == null ? "" : oCirModel.Dust, Corrosion = oCirModel.Corrosion == null ? "" : oCirModel.Corrosion, THeight = oCirModel.THeightName == null ? "" : oCirModel.THeightName, Blade = oCirModel.Blade == null ? "" : oCirModel.Blade, Generator = oCirModel.Generator == null ? "" : oCirModel.Generator, GearBox = oCirModel.GearBox == null ? "" : oCirModel.GearBox, CmrId = oCirModel.CmrId == null ? "0" : oCirModel.CmrId, TempID = oCirModel.TempId == null ? "0" : oCirModel.TempId, DustID = oCirModel.DustId == null ? "0" : oCirModel.DustId, CorrosionId = oCirModel.CorrosionId == null ? "0" : oCirModel.CorrosionId, THeightid = oCirModel.THeightId == null ? "0" : oCirModel.THeightId, BladeId = oCirModel.BladeId == null ? "0" : oCirModel.BladeId, GRiD = oCirModel.GRId == null ? "0" : oCirModel.GRId, GBId = oCirModel.GBId == null ? "0" : oCirModel.GBId, AlarmDesc = oCirModel.AlarmDesc == null ? "" : oCirModel.AlarmDesc, WTGType = oCirModel.WTGType == null ? "" : oCirModel.WTGType, WTGTypeId = oCirModel.WTGTypeID == null ? "0" : oCirModel.WTGTypeID }, commandType: CommandType.StoredProcedure); oCIRResult.MessageInfo = result.Read <Message>().FirstOrDefault(); if (oCIRResult.MessageInfo.Clear == "True") { oCIRResult.CIRData = result.Read <CIRModel>().FirstOrDefault(); } } } catch (Exception ex) { //SaveErrorMessageInFile(oErrorMessage = new ErrorMessage { UserId = loginUserId, ModuleName = "CIM", MethodName = "SaveCIRDetails", Exception = ex.Message }); Logger.Error(ex.Message); } return(oCIRResult); }