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