public UpdateInstrumentMasterQM UpdateInstrumentMaster(UpdateInstrumentMasterCM updateInstrumentMasterCM)
{
using (var connection = new DbConnectionProvider().CreateConnection())
{
connection.Open();
var command = new InstrumentMasterUpdateCommand {
Connection = connection
};
command.Execute(updateInstrumentMasterCM);
}
return(new UpdateInstrumentMasterQM());
}
public UpdateInstrumentMasterResponseDto UpdateInstrumentMaster(UpdateInstrumentMasterRequestDto updateInstrumentMasterRequestDto)
{
var cModel = new UpdateInstrumentMasterCM()
{
InstrumentName = updateInstrumentMasterRequestDto.InstrumentName,
AddedDate = updateInstrumentMasterRequestDto.AddedDate,
Make = updateInstrumentMasterRequestDto.Make,
Range = updateInstrumentMasterRequestDto.Range,
Accuracy = updateInstrumentMasterRequestDto.Accuracy,
Serial = updateInstrumentMasterRequestDto.Serial,
CalibratedDate = updateInstrumentMasterRequestDto.CalibratedDate,
Frequency = updateInstrumentMasterRequestDto.Frequency,
CalibrationDueDate = updateInstrumentMasterRequestDto.CalibrationDueDate,
VendorCode = updateInstrumentMasterRequestDto.VendorCode,
InstrumentCode = updateInstrumentMasterRequestDto.InstrumentCode
};
var response = instrumentMastersRepository.UpdateInstrumentMaster(cModel);
return(new UpdateInstrumentMasterResponseDto());
}
public void Execute(UpdateInstrumentMasterCM model)
{
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].uspUpdateInstrumentMaster";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@InstrumentName", SsDbType.VarChar, ParameterDirection.Input, model.InstrumentName));
sqlCommand.Parameters.Add(AddParameter("@AddedDate", SsDbType.DateTime, ParameterDirection.Input, model.AddedDate));
sqlCommand.Parameters.Add(AddParameter("@Make", SsDbType.VarChar, ParameterDirection.Input, model.Make));
sqlCommand.Parameters.Add(AddParameter("@Range", SsDbType.VarChar, ParameterDirection.Input, model.Range));
sqlCommand.Parameters.Add(AddParameter("@Accuracy", SsDbType.VarChar, ParameterDirection.Input, model.Accuracy));
sqlCommand.Parameters.Add(AddParameter("@Serial", SsDbType.VarChar, ParameterDirection.Input, model.Serial));
sqlCommand.Parameters.Add(AddParameter("@CalibratedDate", SsDbType.DateTime, ParameterDirection.Input, model.CalibratedDate));
sqlCommand.Parameters.Add(AddParameter("@Frequency", SsDbType.Decimal, ParameterDirection.Input, model.Frequency));
sqlCommand.Parameters.Add(AddParameter("@CalibratedDueDate", SsDbType.DateTime, ParameterDirection.Input, model.CalibrationDueDate));
sqlCommand.Parameters.Add(AddParameter("@VendorCode", SsDbType.VarChar, ParameterDirection.Input, model.VendorCode));
sqlCommand.Parameters.Add(AddParameter("@InstrumentCode", SsDbType.Decimal, ParameterDirection.Input, model.InstrumentCode));
sqlCommand.Parameters.Add(AddParameter("@UpdatedBy", SsDbType.UniqueIdentifier, ParameterDirection.Input, new Guid()));
sqlCommand.Parameters.Add(AddParameter("@UpdatedDateTime", SsDbType.DateTime, ParameterDirection.Input, DateTime.UtcNow));
sqlCommand.ExecuteNonQuery();
}
}