public AddMachineMasterResponseDto AddMachineMaster(AddMachineMasterRequestDto addMachineMasterRequestDto)
{
var cModel = new AddMachineMasterCM()
{
MachineName = addMachineMasterRequestDto.MachineName,
AddedDate = addMachineMasterRequestDto.AddedDate
};
var response = machineMastersRepository.AddMachineMaster(cModel);
return(new AddMachineMasterResponseDto());
}
public AddMachineMasterQM AddMachineMaster(AddMachineMasterCM addMachineMasterCM)
{
using (var connection = new DbConnectionProvider().CreateConnection())
{
connection.Open();
var command = new MachineMasterInsertCommand {
Connection = connection
};
command.Execute(addMachineMasterCM);
}
return(new AddMachineMasterQM());
}
public int Execute(AddMachineMasterCM model)
{
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspAddMachineMaster]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@MachineName", SsDbType.VarChar, ParameterDirection.Input, model.MachineName));
sqlCommand.Parameters.Add(AddParameter("@AddedDate", SsDbType.DateTime, ParameterDirection.Input, model.AddedDate));
sqlCommand.Parameters.Add(AddParameter("@CreatedBy", SsDbType.UniqueIdentifier, ParameterDirection.Input, new Guid()));
sqlCommand.Parameters.Add(AddParameter("@CreatedDateTime", SsDbType.DateTime, ParameterDirection.Input, DateTime.UtcNow));
sqlCommand.Parameters.Add(AddParameter("@MachineCode", SsDbType.Decimal, ParameterDirection.Output, default(int)));
sqlCommand.ExecuteNonQuery();
return(Convert.ToInt32(sqlCommand.Parameters["@MachineCode"].Value));
}
}
