public AddSubcontractProcessMasterResponseDto AddSubcontractProcessMaster(AddSubcontractProcessMasterRequestDto addSubcontractProcessMasterRequestDto)
{
var cModel = new AddSubcontractProcessMasterCM
{
ProcessDescription = addSubcontractProcessMasterRequestDto.ProcessDescription,
CreatedBy = new Guid("783F190B-9B66-42AC-920B-E938732C1C01"), //Later needs to be remove
CreatedDateTime = System.DateTime.UtcNow
};
var response = subcontractProcessMasterRepository.AddSubcontractProcessMaster(cModel);
return(new AddSubcontractProcessMasterResponseDto());
}
public AddSubcontractProcessMasterQM AddSubcontractProcessMaster(AddSubcontractProcessMasterCM addSubcontractProcessMasterCM)
{
using (var connection = new DbConnectionProvider().CreateConnection())
{
connection.Open();
var command = new SubcontractProcessMasterInsertCommand {
Connection = connection
};
command.Execute(addSubcontractProcessMasterCM);
}
return(new AddSubcontractProcessMasterQM());
}
public int Execute(AddSubcontractProcessMasterCM model)
{
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspAddSubContractProcessMaster]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@ProcessDescription", SsDbType.VarChar, ParameterDirection.Input, model.ProcessDescription));
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("@ProcessCode", SsDbType.Decimal, ParameterDirection.Output, default(int)));
sqlCommand.ExecuteNonQuery();
return(Convert.ToInt32(sqlCommand.Parameters["@ProcessCode"].Value));
}
}
